1 TANF Data Report Part 265

Temporary Assistance for Needy Families (TANF) Data Reporting for Work Participation

TANF&SSP_Data_Report_layouts_FR2.xlsx

OMB: 0970-0338

Document [xlsx]
Download: xlsx | pdf

Overview

INDEX
TANF_SECT1_FAMILY
TANF_SECT1_ADULT
TANF_SECT1_CHILD
TANF_SECT2_FAMILY
TANF_SECT2_PERSON
TANF_SECT3
TANF_SECT4
SSP_SECT1_FAMILY
SSP_SECT1_ADULT
SSP_SECT1_CHILD
SSP_SECT2_FAMILY
SSP_SECT2_PERSON
SSP_SECT3
SSP_SECT4


Sheet 1: INDEX

PAPERWORK REDUCTION ACT OF 1995 (Pub. L. 104-13) STATEMENT OF PUBLIC BURDEN: Through this information collection, ACF is gathering information to assess and evaluate whether a State TANF program meets statutorily required participation rates. Public reporting burden for this collection of information is estimated to average 8,804 hours per grantee per year, including the time for reviewing instructions, gathering and maintaining the data needed, and reviewing the collection of information. This is a mandatory collection of information (42 U.S.C. § 611). An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information subject to the requirements of the Paperwork Reduction Act of 1995, unless it displays a currently valid OMB control number. The OMB # is 0970-0338 and the expiration date is XX/XX/XXXX. If you have any comments on this collection of information, please contact the Office of Family Assistance by email at TANFdata@acf.hhs.gov.




TANF & SSP DATA REPORT LAYOUTS

1. TANF SECTION 1 FAMILY
2. TANF SECTION 1 ADULT
3. TANF SECTION 1 CHILD
4. TANF SECTION 2 FAMILY
5. TANF SECTION 2 PERSON
6. TANF SECTION 3 AGGREGATED
7. TANF SECTION 4 STRATIFIED

8. SSP SECTION 1 FAMILY
9. SSP SECTION 1 ADULT
10. SSP SECTION 1 CHILD
11. SSP SECTION 2 FAMILY
12. SSP SECTION 2 PERSON
13. SSP SECTION 3 AGGREGATED
14. SSP SECTION 4 STRATIFIED



File Names;
ADS.E2J.NDMn.TSxx (C:D)
ADS.E2J.FTPn.TSxx (FTP)
n - section, xx-fips code

General Instructions: Each item (i.e. data element) needs to hold a certain number of spaces in the flat file. If your system does not automatically hold the spaces, this file layout describes the number of spaces (length) that need to be held. All items should be right-adjusted (e.g. case number = 00000012345). If an item is not applicable or no longer in use, enter the number of digits (zeros or blanks) according to the file format. For example: Tribal Code is 3 digits but is not applicable to states and territories. Therefore, you would need to enter 000 to hold the correct number of spaces. Throughout the instructions you will see the direction “Enter 000.” This indicates that you must enter zeros to fill the correct amount of spaces as referenced in this workbook.

Sheet 2: TANF_SECT1_FAMILY

TANF
LAYOUT FOR SECTION 1 DISAGGREGATED
FAMILY LEVEL DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 "T1" - SECTION 1 T 1








4 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




6 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
2 COUNTY FIPS CODE 3 20 22 Numeric 1 2 3







5 STRATUM 2 23 24 Numeric 1 2








7 ZIP CODE 5 25 29 Alphanumeric 1 2 3 4 5





8 FUNDING STREAM 1 30 30 Numeric 1









9 DISPOSITION 1 31 31 Numeric 1









10 NEW APPLICANT 1 32 32 Numeric 1









11 # FAMILY MEMBERS 2 33 34 Numeric 1 2








12 TYPE OF FAMILY FOR WORK PARTICIPATION 1 35 35 Numeric 1









13 RECEIVES SUBSIDIZED HOUSING 1 36 36 Numeric 1









14 RECEIVES MEDICAL ASSISTANCE 1 37 37 Numeric 1









15 RECEIVES SNAP - NO LONGER IN USE 1 38 38 Numeric 0









16 AMOUNT OF SNAP 4 39 42 Numeric 1 2 3 4






17 RECEIVES SUBSIDIZED CHILD CARE - NO LONGER IN USE 1 43 43 Numeric 0









18 AMOUNT OF SUBSIDIZED CHILD CARE 4 44 47 Numeric 1 2 3 4






19 AMOUNT OF CHIILD SUPPORT 4 48 51 Numeric 1 2 3 4






20 AMOUNT OF FAMILY'S CASH RESOURCES 4 52 55 Numeric 1 2 3 4






21 CASH & CASH EQUIVALENTS














ITEM21A_AMOUNT 4 56 59 Numeric 1 2 3 4






ITEM21B_NBR_MONTH 3 60 62 Numeric 1 2 3







22 TANF CHILD CARE














ITEM22A_AMOUNT 4 63 66 Numeric 1 2 3 4






ITEM22B_CHILDREN_COVERED 2 67 68 Numeric 1 2








ITEM22C_NBR_MONTHS 3 69 71 Numeric 1 2 3







23 TRANSPORTATION AND OTHER SUPPORTIVE SERVICE














ITEM23A_AMOUNT 4 72 75 Numeric 1 2 3 4






ITEM23B_NBR_MONTHS 3 76 78 Numeric 1 2 3







24 TRANSITIONAL SERVICES - NO LONGER IN USE











ITEM24A_AMOUNT 4 79 82 Numeric 0 0 0 0






ITEM24B_NBR_MONTHS 3 83 85 Numeric 0 0 0







25 OTHER - NO LONGER IN USE














ITEM25A_AMOUNT 4 86 89 Numeric 0 0 0 0






ITEM25B_NBR_MONTHS 3 90 92 Numeric 0 0 0







26 REASON FOR & AMOUNT OF ASSISTANCE REDUCTION














ITEM26A_I_SANCTIONS REDUCTION_AMOUNT 4 93 96 Numeric 1 2 3 4






ITEM26A_II_WORK REQUIREMENTS SANCTION 1 97 97 Alphanumeric 1










ITEM26A_III - NO LONGER IN USE 1 98 98 Alphanumeric 0










ITEM26A_IV_SANCTION FOR TEEN PARENT NOT ATTENDING SCHOOL 1 99 99 Alphanumeric 1










ITEM26A_V_NON-COOPERATION WITH CHILD SUPPORT 1 100 100 Alphanumeric 1










ITEM26A_VI_FAILURE TO COMPLY WITH INDIVIDUAL RESPONSIBILITY PLAN 1 101 101 Alphanumeric 1










ITEM26A_VII_OTHER SANCTION 1 102 102 Alphanumeric 1










ITEM26B_RECOUPMENT OF PRIOR OVERPAYMENT 4 103 106 Alphanumeric 1 2 3 4







ITEM26C_I_OTHER TOTAL REDUCTION AMOUNT 4 107 110 Alphanumeric 1 2 3 4







ITEM26C_II_FAMILY CAP 1 111 111 Alphanumeric 1










ITEM26C_III_REDUCTION BASED ON LENGTH OF RECEIPT OF ASSISTANCE 1 112 112 Alphanumeric 1










ITEM26C_IV_OTHER, NON-SANCTION 1 113 113 Alphanumeric 1









27 WAIVER_EVALUATION_CONTROL_GRPS - NO LONGER IN USE 1 114 114 Alphanumeric 0









28 TANF FAMILY EXEMPT FROM TIME_LIMITS 2 115 116 Numeric 1 2








29 TANF FAMILY NEW CHILD ONLY FAMILY - NO LONGER IN USE 1 117 117 Numeric 0










BLANK 39 118 156 Spaces 39 SPACES










Sheet 3: TANF_SECT1_ADULT

TANF
LAYOUT FOR SECTION 1 DISAGGREGATED
ADULT CHARACTERISTIC DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 UP TO 10 RECORD TYPES 3 "T2" UP TO 6 ADULT RECORDS T 2








4 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




6 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
30 FAMILY AFFILIATION 1 20 20 Numeric 1









31 NONCUSTODIAL PARENT 1 21 21 Numeric 1









32 DATE OF BIRTH 8 22 29 Numeric Y Y Y Y M M D D


33 SOCIAL SECURITY NUMBER 9 30 38 Alphanumeric 1 2 3 4 5 6 7 8 9

34 RACE/ETHNICITY










ITEM34A_HISPANIC OR LATINO 1 39 39 Alphanumeric 1









ITEM34B_AMERICAN INDIAN OR ALASKA NATIVE 1 40 40 Alphanumeric 1










ITEM34C_ASIAN 1 41 41 Alphanumeric 1










ITEM34D_BLACK OR AFRICAN AMERICAN 1 42 42 Alphanumeric 1










ITEM34E_NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 1 43 43 Alphanumeric 1










ITEM34F_WHITE 1 44 44 Alphanumeric 1









35 GENDER 1 45 45 Numeric 1









36 RECEIVES FEDERAL DISABILITY BENEFITS











ITEM36A_RECEIVES FEDERAL DISABILITY INSURANCE OASDI PROGRAM 1 46 46 Alphanumeric 1









ITEM36B_RECEIVES BENEFITS BASED ON FEDERAL DISABILITY STATUS 1 47 47 Alphanumeric 1










ITEM36C_RECEIVES AID TO THE PERMANENTLY AND TOTALLY DISABLED UNDER TITLE XIV-APDT 1 48 48 Alphanumeric 1










ITEM36D - NO LONGER IN USE 1 49 49 Alphanumeric 0










ITEM36E_RECEIVES SUPPLEMENTAL SECURITY INCOME UNDER TITLE
XVI-SSI
1 50 50 Alphanumeric 1









37 MARITAL STATUS 1 51 51 Alphanumeric 1









38 RELATIONSHIP TO HEAD OF HOUSEHOLD 2 52 53 Numeric 1 2








39 PARENT WITH MINOR CHILD 1 54 54 Alphanumeric 1









40 NEEDS OF A PREGNANT WOMAN - NO LONGER IN USE 1 55 55 Alphanumeric 0









41 EDUCATION LEVEL 2 56 57 Alphanumeric 1 2








42 CITIZENSHIP STATUS 1 58 58 Alphanumeric 1









43 COOPERATION WITH CHILD SUPPORT 1 59 59 Alphanumeric 1









44 NUMBER OF COUNTABLE MONTHS TOWARD FEDERAL TIME-LIMIT 3 60 62 Alphanumeric 1 2 3







45 REMAINING UNDER STATE TIME LIMIT -NO LONGER IN USE 2 63 64 Alphanumeric 0 0








46 EXEMPT FROM STATE TIME LIMIT -NO LONGER IN USE 1 65 65 Alphanumeric 0









47 EMPLOYMENT STATUS 1 66 66 Alphanumeric 1









48 WORK ELIGIBLE INDIVIDUAL INDICATOR 2 67 68 Alphanumeric 1 2








49 WORK PARTICIPATION STATUS 2 69 70 Alphanumeric 1 2








50 UNSUBSIDIZED EMPLOYMENT HOURS 2 71 72 Alphanumeric 1 2








51 SUBSIDIZED PRIVATE EMPLOYMENT HOURS 2 73 74 Alphanumeric 1 2








52 SUBSIDIZED PUBLIC EMPLOYMENT HOURS 2 75 76 Alphanumeric 1 2








53 WORK EXPERIENCE HOURS OF















ITEM53A_PARTICIPATION 2 77 78 Alphanumeric 1 2









ITEM53B_EXCUSED ABSENCES 2 79 80 Alphanumeric 1 2









ITEM53C_HOLIDAYS 2 81 82 Alphanumeric 1 2








54 ON THE JOB TRAINING HOURS 2 83 84 Alphanumeric 1 2








55 JOB SEARCH & JOB READINESS HOURS OF















ITEM55A_PARTICIPATION 2 85 86 Alphanumeric 1 2









ITEM55B_EXCUSED ABSENCES 2 87 88 Alphanumeric 1 2









ITEM55C_HOLIDAYS 2 89 90 Alphanumeric 1 2








56 COMMUNITY SVS PROG. HOURS OF















ITEM56A_PARTICIPATION 2 91 92 Alphanumeric 1 2









ITEM56B_EXCUSED ABSENCES 2 93 94 Alphanumeric 1 2









ITEM56C_HOLIDAYS 2 95 96 Alphanumeric 1 2








57 VOCATIONAL EDUCATION TRAINING HOURS OF















ITEM57A_PARTICIPATION 2 97 98 Alphanumeric 1 2









ITEM57B_EXCUSED ABSENCES 2 99 100 Alphanumeric 1 2









ITEM57C_HOLIDAYS 2 101 102 Alphanumeric 1 2








58 JOB SKILLS TRAINING RELATED EMPLOYMENT HOURS OF















ITEM58A_PARTICIPATION 2 103 104 Alphanumeric 1 2









ITEM58B_EXCUSED ABSENCES 2 105 106 Alphanumeric 1 2









ITEM58C_HOLIDAYS 2 107 108 Alphanumeric 1 2








59 ED. RELATED TO EMPLOYMENT W/O HS DIPLOMA HOURS OF















ITEM59A_PARTICIPATION 2 109 110 Alphanumeric 1 2









ITEM59B_EXCUSED ABSENCES 2 111 112 Alphanumeric 1 2









ITEM59C_HOLIDAYS 2 113 114 Alphanumeric 1 2








60 SATISFACTORY SCHOOL ATTENDENCE HOURS OF















ITEM59A_PARTICIPATION 2 115 116 Alphanumeric 1 2









ITEM59B_EXCUSED ABSENCES 2 117 118 Alphanumeric 1 2









ITEM59C_HOLIDAYS 2 119 120 Alphanumeric 1 2








61 PROVIDING CHILD CARE HOURS OF















ITEM59A_PARTICIPATION 2 121 122 Alphanumeric 1 2









ITEM59B_EXCUSED ABSENCES 2 123 124 Alphanumeric 1 2









ITEM59C_HOLIDAYS 2 125 126 Alphanumeric 1 2








62 OTHER WORK ACTIVITIES 2 127 128 Alphanumeric 1 2








63 NUMBER OF DEEMED CORE HOURS FOR OVERALL RATE 2 129 130 Alphanumeric 0 0








64 NUMBER OF DEEMED CORE HOURS FOR THE TWO-PARENT RATE 2 131 132 Alphanumeric 0 0








65 AMOUNT OF EARNED INCOME 4 133 136 Alphanumeric 1 2 3 4






66 AMOUNT OF UNEARNED INCOME














ITEM66A_EARNED INCOME TAX CREDIT - NO LONGER IN USE 4 137 140 Alphanumeric 0 0 0 0






ITEM66B_SOCIAL SECURITY 4 141 144 Alphanumeric 1 2 3 4







ITEM66C_SSI 4 145 148 Alphanumeric 1 2 3 4







ITEM66D_WORKER'S COMPENSATION 4 149 152 Alphanumeric 1 2 3 4







ITEM66E_OTHER UNEARNED INCOME 4 153 156 Alphanumeric 1 2 3 4







Sheet 4: TANF_SECT1_CHILD

TANF
LAYOUT FOR SECTION 1 DISAGGREGATED
CHILD CHARACTERISTIC DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 "T3" - UP TO 10 CHILDREN T 3








4 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




6 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
67 FAMILY AFFILIATION-1 1 20 20 Numeric,Child 1,3,5,7,9 1









68 DATE OF BIRTH 8 21 28 Numeric Y Y Y Y M M D D


69 SOCIAL SECURITY NUMBER 9 29 37 Alphanumeric 1 2 3 4 5 6 7 8 9

70 RACE/ETHNICITY














ITEM70A_HISPANIC OR LATINO 1 38 38 Alphanumeric 1









ITEM70B_AMERICAN INDIAN OR ALASKA NATIVE 1 39 39 Alphanumeric 1










ITEM70C_ASIAN 1 40 40 Alphanumeric 1










ITEM70D_BLACK OR AFRICAN AMERICAN 1 41 41 Alphanumeric 1










ITEM70E_NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 1 42 42 Alphanumeric 1










ITEM70F_WHITE 1 43 43 Alphanumeric 1









71 GENDER 1 44 44 Numeric 1









72 RECEIVES FEDERAL DISABILITY BENEFITS










ITEM72A_RECEIVES BENEFITS BASED ON FEDERAL DISABILITY STATUS UNDER NON-SSA PROGRAMS 1 45 45 Alphanumeric 1









ITEM72B_RECEIVES SSI UNDER TITLE XVI-SSI 1 46 46 Alphanumeric 1









73 RELATIONSHIP TO HEAD OF HOUSEHOLD 2 47 48 Numeric 1 2








74 PARENT WITH MINOR CHILD 1 49 49 Alphanumeric 1









75 EDUCATION LEVEL 2 50 51 Alphanumeric 1 2








76 CITIZENSHIP/ALIENAGE 1 52 52 Alphanumeric 1









77 AMOUNT OF UNEARNED INCOME











ITEM77A_SSI 4 53 56 Alphanumeric 1 2 3 4






ITEM77B_OTHER UNEARNED INCOME 4 57 60 Alphanumeric 1 2 3 4






67 FAMILY AFFILIATION-2 1 61 61 Numeric; Child 2,4,6,8,10 1









68 DATE OF BIRTH 8 62 69 Numeric Y Y Y Y M M D D


69 SOCIAL SECURITY NUMBER 9 70 78 Alphanumeric 1 2 3 4 5 6 7 8 9

70 RACE/ETHNICITY














ITEM70A_HISPANIC OR LATINO 1 79 79 Alphanumeric 1









ITEM70B_AMERICAN INDIAN OR ALASKA NATIVE 1 80 80 Alphanumeric 1










ITEM70C_ASIAN 1 81 81 Alphanumeric 1










ITEM70D_BLACK OR AFRICAN AMERICAN 1 82 82 Alphanumeric 1










ITEM70E_NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 1 83 83 Alphanumeric 1










ITEM70F_WHITE 1 84 84 Alphanumeric 1









71 GENDER 1 85 85 Numeric 1









72 RECEIVES FEDERAL DISABILITY BENEFITS










ITEM72A_RECEIVES BENEFITS BASED ON FEDERAL DISABILITY STATUS UNDER NON-SSA PROGRAMS 1 86 86 Alphanumeric 1









ITEM72B_RECEIVES SSI UNDER TITLE XVI-SSI 1 87 87 Alphanumeric 1









73 RELATIONSHIP TO HEAD OF HOUSEHOLD 2 88 89 Numeric 1 2








74 PARENT WITH MINOR CHILD 1 90 90 Alphanumeric 1









75 EDUCATION LEVEL 2 91 92 Alphanumeric 1 2








76 CITIZENSHIP/ALIENAGE 1 93 93 Alphanumeric 1









77 AMOUNT OF UNEARNED INCOME











ITEM77A_SSI 4 94 97 Alphanumeric 1 2 3 4






ITEM77B_OTHER UNEARNED INCOME 4 98 101 Alphanumeric 1 2 3 4







BLANK 55 102 156 Spaces 55 SPACES










Sheet 5: TANF_SECT2_FAMILY

TANF
LAYOUT FOR SECTION 2 DISAGGREGATED
FAMILY LEVEL DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 "T4" SECTION 2 T 4








4 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




6 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
2 COUNTY FIPS CODE 3 20 22 Numeric 1 2 3







5 STRATUM 2 23 24 Numeric 1 2








7 ZIP CODE 5 25 29 Alphanumeric 1 2 3 4 5





8 DISPOSITION 1 30 30 Numeric 1









9 REASON FOR CLOSURE 2 31 32 Numeric 1 2








10 RECEIVES SUBSIDIZED HOUSING 1 33 33 Numeric 1









11 RECEIVES MEDICAL ASSISTANCE 1 34 34 Numeric 1









12 RECEIVES FOOD STAMPS 1 35 35 Numeric 1









13 RECEIVES SUBSIDIZED CHILD CARE 1 36 36 Numeric 1










BLANKS 35 37 71 Alphanumeric 35 SPACES










Sheet 6: TANF_SECT2_PERSON

TANF
LAYOUT FOR SECTION 2 DISAGGREGATED
PERSON LEVEL DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 "T5" SECTION 2 T 5








4 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




6 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
14 FAMILY AFFILIATION 1 20 20 Numeric 1









15 DATE OF BIRTH 8 21 28 Numeric Y Y Y Y M M D D


16 SOCIAL SECURITY NUMBER 9 29 37 Alphanumeric 1 2 3 4 5 6 7 8 9

17 RACE/ETHNICITY















ITEM17A_HISPANIC OR LATINO 1 38 38 Alphanumeric 1










ITEM17B_AMERICAN INDIAN OR ALASKA NATIVE 1 39 39 Alphanumeric 1










ITEM17C_ASIAN 1 40 40 Alphanumeric 1










ITEM17D_BLACK OR AFRICAN AMERICAN 1 41 41 Alphanumeric 1










ITEM17E_NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 1 42 42 Alphanumeric 1










ITEM17F_WHITE 1 43 43 Alphanumeric 1









18 GENDER 1 44 44 Numeric 1









19 RECEIVES DISABILITY BENEFITS















ITEM19A_RECEIVED FEDERAL DISABILITY INSURANCE BENEFITS UNDER THE OASDI PROGRAM 1 45 45 Alphanumeric 1










ITEM19B_RECEIVES BENEFITS BASED ON FEDERAL DISABILITY STATUS UNDER NON-SSA PROGRAMS 1 46 46 Alphanumeric 1










ITEM19C_RECEIVED AID TO THE PERMANENTLY & TOTALLY DISABLED UNDER TITLE XIV-APDT 1 47 47 Alphanumeric 1










ITEM19D - NO LONGER IN USE 1 48 48 Alphanumeric 0










ITEM19E_RECEIVED SSI UNDER TITLE XVI-SSI 1 49 49 Alphanumeric 1









20 MARITAL STATUS 1 50 50 Alphanumeric 1









21 RELATIONSHIP TO HEAD OF HOUSEHOLD 2 51 52 Numeric 1









22 PARENT WITH MINOR CHILD IN THE FAMILY 1 53 53 Alphanumeric 1









23 NEEDS OF A PREGNANT WOMAN -NO LONGER IN USE 1 54 54 Alphanumeric 0









24 EDUCATION LEVEL 2 55 56 Alphanumeric 1 2








25 CITIZENSHIP/ALIENAGE 1 57 57 Alphanumeric 1









26 NUMBER OF COUNTABLE MONTHS TOWARD FEDERAL TIME LIMIT 3 58 60 Alphanumeric 1 2 3







27 NUMBER OF COUNTABLE MONTHS REMAINING UNDER STATE/TRIBE TIME LIMIT - NO LONGER IN USE 2 61 62 Alphanumeric 0 0








28 EMPLOYMENT STATUS 1 63 63 Alphanumeric 1









29 AMOUNT OF EARNED INCOME 4 64 67 Alphanumeric 1 2 3 4






30 AMOUNT OF UNEARNED INCOME 4 68 71 Alphanumeric 1 2 3 4







Sheet 7: TANF_SECT3

TANF
LAYOUT FOR SECTION 3 AGGREGATED DATA




































ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)











RECORD TYPE 2 1 2 "T6" ONE PER QUARTER T 6









3 CALENDAR QUARTER
















CALENDAR YEAR 4 3 6 Numeric 2 0 2 3








CALENDAR QUARTER 1 7 7 Numeric 1










4 TOTAL NUMBER OF APPLICATIONS
















ITEM_4_FIRST_MONTH 8 8 15 Numeric; First month, sum(item5+item6) 1 2 3 4 5 6 7 8




ITEM_4_SECOND_MONTH 8 16 23 Numeric; Second month, sum(item5+item 6) 1 2 3 4 5 6 7 8




ITEM_4_THIRD_MONTH 8 24 31 Numeric; Third month, sum(item5+item6) 1 2 3 4 5 6 7 8



5 TOTAL NUMBER OF APPROVED APPLICATIONS
















ITEM_5_FIRST_MONTH 8 32 39 Numeric 1 2 3 4 5 6 7 8




ITEM_5_SECOND_MONTH 8 40 47 Numeric 1 2 3 4 5 6 7 8




ITEM_5_THIRD_MONTH 8 48 55 Numeric 1 2 3 4 5 6 7 8



6 TOTAL NUMBER OF DENIED APPLICATIONS
















ITEM_6_FIRST_MONTH 8 56 63 Numeric 1 2 3 4 5 6 7 8




ITEM_6_SECOND_MONTH 8 64 71 Numeric 1 2 3 4 5 6 7 8




ITEM_6_THIRD_MONTH 8 72 79 Numeric 1 2 3 4 5 6 7 8



7 TOTAL AMOUNT OF ASSISTANCE
















ITEM_7_FIRST_MONTH 12 80 91 Numeric 1 2 3 4 5 6 7 8 9 0 1 2

ITEM_7_SECOND_MONTH 12 92 103 Numeric 1 2 3 4 5 6 7 8 9 0 1 2

ITEM_7_THIRD_MONTH 12 104 115 Numeric 1 2 3 4 5 6 7 8 9 0 1 2
8 TOTAL NUMBER OF FAMILIES
















ITEM_8_FIRST_MONTH 8 116 123 Numeric; First month sum(item9+item10+item11) 1 2 3 4 5 6 7 8




ITEM_8_SECOND_MONTH 8 124 131 Numeric; Second month, sum(item9+item10+item11) 1 2 3 4 5 6 7 8




ITEM_8_THIRD_MONTH 8 132 139 Numeric; Third month, sum(item9+item10+item11) 1 2 3 4 5 6 7 8



9 TOTAL NUMBER OF 2 PARENT FAMILES
















ITEM_9_FIRST_MONTH 8 140 147 Numeric 1 2 3 4 5 6 7 8




ITEM_9_SECOND_MONTH 8 148 155 Numeric 1 2 3 4 5 6 7 8




ITEM_9_THIRD_MONTH 8 156 163 Numeric 1 2 3 4 5 6 7 8



10 TOTAL NUMBER OF 1 PARENT FAMILIES
















ITEM_10_FIRST_MONTH 8 164 171 Numeric 1 2 3 4 5 6 7 8




ITEM_10_SECOND_MONTH 8 172 179 Numeric 1 2 3 4 5 6 7 8




ITEM_10_THIRD_MONTH 8 180 187 Numeric 1 2 3 4 5 6 7 8



11 TOTAL NUMBER OF NO PARENT FAMILIES
















ITEM_11_FIRST_MONTH 8 188 195 Numeric 1 2 3 4 5 6 7 8




ITEM_11_SECOND_MONTH 8 196 203 Numeric 1 2 3 4 5 6 7 8




ITEM_11_THIRD_MONTH 8 204 211 Numeric 1 2 3 4 5 6 7 8



12 TOTAL NUMBER OF RECIPIENTS
















ITEM_12_FIRST_MONTH 8 212 219 Numeric; First month, sum(item13+item14) 1 2 3 4 5 6 7 8




ITEM_12_SECOND_MONTH 8 220 227 Numeric; Second month, sum(item13+item14) 1 2 3 4 5 6 7 8




ITEM_12_THIRD_MONTH 8 228 235 Numeric; Third month, sum(item13+item14) 1 2 3 4 5 6 7 8



13 TOTAL NUMBER OF ADULT RECIPIENTS
















ITEM_13_FIRST_MONTH 8 236 243 Numeric 1 2 3 4 5 6 7 8




ITEM_13_SECOND_MONTH 8 244 251 Numeric 1 2 3 4 5 6 7 8




ITEM_13_THIRD_MONTH 8 252 259 Numeric 1 2 3 4 5 6 7 8



14 TOTAL NUMBER OF CHILD RECIPIENTS
















ITEM_14_FIRST_MONTH 8 260 267 Numeric 1 2 3 4 5 6 7 8




ITEM_14_SECOND_MONTH 8 268 275 Numeric 1 2 3 4 5 6 7 8




ITEM_14_THIRD_MONTH 8 276 283 Numeric 1 2 3 4 5 6 7 8



15 TOTAL NUMBER OF NONCUSTODIAL RECIPIENTS
















ITEM_15_FIRST_MONTH 8 284 291 Numeric 1 2 3 4 5 6 7 8




ITEM_15_SECOND_MONTH 8 292 299 Numeric 1 2 3 4 5 6 7 8




ITEM_15_THIRD_MONTH 8 300 307 Numeric 1 2 3 4 5 6 7 8



16 TOTAL NUMBER OF BIRTHS
















ITEM_16_FIRST_MONTH 8 308 315 Numeric 1 2 3 4 5 6 7 8




ITEM_16_SECOND_MONTH 8 316 323 Numeric 1 2 3 4 5 6 7 8




ITEM_16_THIRD_MONTH 8 324 331 Numeric 1 2 3 4 5 6 7 8



17 TOTAL NUMBER OF OUT OF WEDLOCK BIRTHS
















ITEM_17_FIRST_MONTH 8 332 339 Numeric 1 2 3 4 5 6 7 8




ITEM_17_SECOND_MONTH 8 340 347 Numeric 1 2 3 4 5 6 7 8




ITEM_17_THIRD_MONTH 8 348 355 Numeric 1 2 3 4 5 6 7 8



18 TOTAL NUMBER OF CLOSED CASES
















ITEM_18_FIRST_MONTH 8 356 363 Numeric 1 2 3 4 5 6 7 8




ITEM_18_SECOND_MONTH 8 364 371 Numeric 1 2 3 4 5 6 7 8




ITEM_18_THIRD_MONTH 8 372 379 Numeric 1 2 3 4 5 6 7 8




Sheet 8: TANF_SECT4

TANF
LAYOUT FOR SECTION 4 AGGREGATED STRATIFIED DATA


























ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)






RECORD TYPE 2 1 2 "T7" ONE PER QUARTER T 7




3 CALENDAR QUARTER








CALENDAR YEAR 4 3 6 Numeric 2 0 2 3



CALENDAR QUARTER 1 7 7 Numeric 1





4 TDRS SECTION INDICATOR 1 8 8 Numeric 1





5 STRATUM-1 2 9 10 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 11 17 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 18 24 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 25 31 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 32 32 Numeric 1





5 STRATUM-2 2 33 34 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 35 41 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 42 48 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 49 55 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 56 56 Numeric 1





5 STRATUM-3 2 57 58 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 59 65 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 66 72 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 73 79 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 80 80 Numeric 1





5 STRATUM-4 2 81 82 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 83 89 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 90 96 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 97 103 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 104 104 Numeric 1





5 STRATUM-5 2 105 106 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 107 113 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 114 120 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 121 127 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 128 128 Numeric 1





5 STRATUM-6 2 129 130 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 131 137 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 138 144 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 145 151 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 152 152 Numeric 1





5 STRATUM-7 2 153 154 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 155 161 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 162 168 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 169 175 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 176 176 Numeric 1





5 STRATUM-8 2 177 178 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 179 185 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 186 192 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 193 199 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 200 200 Numeric 1





5 STRATUM-9 2 201 202 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 203 209 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 210 216 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 217 223 Numeric 1 2 3 4 5 6 7
4 TDRS SECTION INDICATOR 1 224 224 Numeric 1





5 STRATUM-10 2 225 226 Numeric 1 2




6 TOTAL NUMBER OF FAMILIES











ITEM_6_FIRST_MONTH 7 227 233 Numeric 1 2 3 4 5 6 7

ITEM_6_SECOND_MONTH 7 234 240 Numeric 1 2 3 4 5 6 7

ITEM_6_THIRD_MONTH 7 241 247 Numeric 1 2 3 4 5 6 7













Defaults: zero filled and right adjusted for all valid entries











Blank fill if no data for stratum or # of families











Can have up to 10 record types T7, each with 10 stratum codes












Sheet 9: SSP_SECT1_FAMILY

SSP
LAYOUT FOR SECTION 1 DISAGGREGATED
FAMILY LEVEL DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 M1 M 1








3 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




5 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
2 COUNTY FIPS CODE 3 20 22 Numeric 1 2 3







4 STRATUM 2 23 24 Numeric 1 2








6 ZIP CODE 5 25 29 Alphanumeric 1 2 3 4 5





7 DISPOSITION 1 30 30 Numeric 1









8 # FAMILY MEMBERS 2 31 32 Numeric 1 2








9 TYPE OF FAMILY FOR WORK PARTICIPATION 1 33 33 Numeric 1









10 HAS FAMILY RECEIVED ASSISTANCE UNDER TANF WITHIN PAST 6 MONTHS 1 34 34 Numeric 1









11 RECEIVES SUBSIDIZED HOUSING 1 35 35 Numeric 1









12 RECEIVES MEDICAL ASSISTANCE 1 36 36 Numeric 1









13 RECEIVES SNAP - NO LONGER IN USE 1 37 37 Numeric 0









14 AMOUNT OF SNAP 4 38 41 Numeric 1 2 3 4






15 RECEIVES SUBSIDIZED CHILD CARE - NO LONGER IN USE 1 42 42 Numeric 0









16 AMOUNT OF SUBSIDIZED CHILD CARE 4 43 46 Numeric 1 2 3 4






17 AMOUNT OF CHILD SUPPORT 4 47 50 Numeric 1 2 3 4






18 AMT OF FAMILY'S CASE RESOURCES 4 51 54 Numeric 1 2 3 4






19 CASH & CASH EQUIVALENTS















ITEM_19A_AMOUNT 4 55 58 Numeric 1 2 3 4







ITEM_19B_MONTHS 3 59 61 Numeric 1 2 3







20 TANF CHILD CARE












ITEM_20A_AMOUNT 4 62 65 Numeric 1 2 3 4







ITEM_20B_CHILDREN-COVERED 2 66 67 Numeric 1 2









ITEM_20C_NBR_MONTHS 3 68 70 Numeric 1 2 3







21 TRANSPORTATION












ITEM_21A_AMOUNT 4 71 74 Numeric 1 2 3 4







ITEM_21B_MONTHS 3 75 77 Numeric 1 2 3







22 TRANSITIONAL SERVICES - NO LONGER IN USE












ITEM_22A_AMOUNT 4 78 81 Numeric 0 0 0 0







ITEM_22B_NBR_MONTHS 3 82 84
0 0 0







23 OTHER












ITEM_23A_AMOUNT 4 85 88 Numeric 1 2 3 4







ITEM_23B_MONTHS 3 89 91 Numeric 1 2 3







24 REASON FOR & AMOUNT OF ASSISTANCE REDUCTIONS












ITEM24A_I_SANCTIONS REDUCTION AMOUNT 4 92 95 Alphanumeric 1 2 3 4







ITEM24A_II_WORK REQUIREMENTS SANCTION 1 96 96 Alphanumeric 1










ITEM24A_III - NO LONGER IN USE 1 97 97 Alphanumeric 0










ITEM24A_IV_SANCTION FOR TEEN PARENT NOT ATTENDING SCHOOL 1 98 98 Alphanumeric 1










ITEM24A_V_NON-COOPERATION WITH CHILD SUPPORT 1 99 99 Alphanumeric 1










ITEM24A_VI_FAILURE TO COMPLY WITH INDIVIDUAL RESPONSIBILTY PLAN 1 100 100 Alphanumeric 1










ITEM24A_VII_OTHER SANCTIONS 1 101 101 Alphanumeric 1










ITEM24B_RECOUPMENT OF PRIOR OVERPAYMENT 4 102 105 Alphanumeric 1 2 3 4







ITEM24C_I_OTHER TOTAL REDUCTION AMOUNT 4 106 109 Alphanumeric 1 2 3 4







ITEM24C_II_FAMILY CAP 1 110 110 Alphanumeric 1










ITEM24C_III_REDUCTION BASED ON LENGTH OF RECEIPT OF ASSISTANCE 1 111 111 Alphanumeric 1










ITEM24C_IV_OTHER, NON-SANCTION 1 112 112 Alphanumeric 1









25 WAIVER EVALUATION/CONTROL GROUPS 1 113 113 Alphanumeric 0










BLANK 37 114 150 Spaces 37 SPACES










Sheet 10: SSP_SECT1_ADULT

SSP
LAYOUT FOR SECTION 1 DISAGGREGATED
ADULT CHARACTERISTIC DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 VALUE = M2 (6 ADULTS) M 2








3 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




5 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
26 FAMILY AFFILIATION 1 20 20 Numeric 1









27 NONCUSTODIAL PARENT 1 21 21 Numeric 1









28 DATE OF BIRTH ADULT 8 22 29 Numeric Y Y Y Y M M D D


29 SOCIAL SECURITY NUMBER 9 30 38 Alphanumeric 1 2 3 4 5 6 7 8 9

30 RACE/ETHNICITY












ITEM30A_HISPANIC OR LATINO 1 39 39 Alphanumeric 1










ITEM30B_AMERICAN INDIAN OR ALASKA NATIVE 1 40 40 Alphanumeric 1










ITEM30C_ASIAN 1 41 41 Alphanumeric 1










ITEM30D_BLACK OR AFRICAN AMERICAN 1 42 42 Alphanumeric 1










ITEM30E_NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 1 43 43 Alphanumeric 1










ITEM30F WHITE 1 44 44 Alphanumeric 1









31 GENDER 1 45 45 Numeric 1









32 RECEIVES DISABILITY BENEFITS













ITEM32A_RECEIVES FEDERAL DISABILITY INSURANCE BENEFITS UNDER OASDI PROGRAM 1 46 46 Alphanumeric 1










ITEM32B_RECEIVES BENEFTIS BASED ON FEDERAL DISABILITY STATUS UNDER ON-SSA PROGRAMS 1 47 47 Alphanumeric 1










ITEM32C_RECEIVES AID TO THE PERMANENTLY AND TOTALLY DISABLED UNDER TITLE XIV-APDT 1 48 48 Alphanumeric 1










ITEM32D - NO LONGER IN USE 1 49 49 Alphanumeric 0










ITEM32E_RECEIVES SSI UNDER TITLE XVI-SSI 1 50 50 Alphanumeric 1









33 MARITAL STATUS 1 51 51 Alphanumeric 1









34 RELATIONSHIP TO HEAD OF HOUSEHOLD 2 52 53 Numeric 1 2








35 PARENT WITH MINOR CHILD 1 54 54 Alphanumeric 1









36 NEEDS OF A PREGNANT WOMAN - NO LONGER IN USE 1 55 55 Alphanumeric 0









37 EDUCATION LEVEL 2 56 57 Alphanumeric 1 2








38 CITIZENSHIP/ALIENAGE 1 58 58 Alphanumeric 1









39 COOPERATION WITH CHILD SUPPORT 1 59 59 Alphanumeric 1









40 EMPLOYMENT STATUS 1 60 60 Alphanumeric 1









41 WORK ELIGIBLE INDIVIDUAL INDICATOR 2 61 62 Alphanumeric 1 2








42 WORK PARTICIPATION STATUS 2 63 64 Alphanumeric 1 2








43 UNSUBSIDIZED EMPLOYMENT HOURS 2 65 66 Alphanumeric 1 2








44 SUBSIDIZED PRIVATE EMPLOYMENT HOURS 2 67 68 Alphanumeric 1 2








45 SUBSIDIZED PUBLIC EMPLOYMENT HOURS 2 69 70 Alphanumeric 1 2








46 WORK EXPERIENCE HOURS OF















ITEM46A_PARTICIPATION 2 71 72 Alphanumeric 1 2









ITEM46B_EXCUSED ABSENCES 2 73 74 Alphanumeric 1 2









ITEM46C_HOLIDAYS 2 75 76 Alphanumeric 1 2








47 ON THE JOB TRAINING HOURS 2 77 78 Alphanumeric 1 2








48 JOB SEARCH & JOB READINESS HOURS OF















ITEM48A_PARTICIPATION 2 79 80 Alphanumeric 1 2









ITEM48B_EXCUSED ABSENCES 2 81 82 Alphanumeric 1 2









ITEM48C_HOLIDAYS 2 83 84 Alphanumeric 1 2








49 COMMUNITY SERVICE PROGRAMS HOURS OF















ITEM49A_PARTICIPATION 2 85 86 Alphanumeric 1 2









ITEM49B_EXCUSED ABSENCES 2 87 88 Alphanumeric 1 2









ITEM49C_HOLIDAYS 2 89 90 Alphanumeric 1 2








50 VOCATIONAL EDUCATION TRAINING HOURS OF















ITEM50A_PARTICIPATION 2 91 92 Alphanumeric 1 2









ITEM50B_EXCUSED ABSENCES 2 93 94 Alphanumeric 1 2









ITEM50C_HOLIDAYS 2 95 96 Alphanumeric 1 2








51 JOB SKILLS TRAINING RELATED EMPLOYMENT HOURS OF













ITEM51A_PARTICIPATION 2 97 98 Alphanumeric 1 2









ITEM51B_EXCUSED ABSENCES 2 99 100 Alphanumeric 1 2









ITEM51C_HOLIDAYS 2 101 102 Alphanumeric 1 2








52 ED. RELATED TO EMPLOYMENT W/O HS DIPLOMA HOURS OF













ITEM52A_PARTICIPATION 2 103 104 Alphanumeric 1 2









ITEM52B_EXCUSED ABSENCES 2 105 106 Alphanumeric 1 2









ITEM52C_HOLIDAYS 2 107 108 Alphanumeric 1 2








53 SATISFACTORY SCHOOL ATTENDENCE HOURS OF















ITEM53A_PARTICIPATION 2 109 110 Alphanumeric 1 2









ITEM53B_EXCUSED ABSENCES 2 111 112 Alphanumeric 1 2









ITEM53C_HOLIDAYS 2 113 114 Alphanumeric 1 2








54 PROVIDING CHILD CARE HOURS OF















ITEM54A_PARTICIPATION 2 115 116 Alphanumeric 1 2









ITEM54B_EXCUSED ABSENCES 2 117 118 Alphanumeric 1 2









ITEM54C_HOLIDAYS 2 119 120 Alphanumeric 1 2








55 OTHER WORK ACTIVITIES 2 121 122 Alphanumeric 1 2








56 DEEMED CORE HOURS FOR OVERALL RATE 2 123 124 Alphanumeric 0 0








57 DEEMED CORE HOURS FOR THE TWO-PARENT RATE 2 125 126 Alphanumeric 0 0








58 AMOUNT OF EARNED INCOME 4 127 130 Alphanumeric 1 2 3 4






59 AMOUNT OF UNEARNED INCOME















ITEM59A - NO LONGER IN USE 4 131 134 Alphanumeric 0 0 0 0







ITEM59B_SOCIAL SECURITY 4 135 138 Alphanumeric 1 2 3 4







ITEM59C_SSI 4 139 142 Alphanumeric 1 2 3 4







ITEM59D_WORKER'S COMPENSATION 4 143 146 Alphanumeric 1 2 3 4







ITEM59E_OTHER UNEARNED INCOME 4 147 150 Alphanumeric 1 2 3 4







Sheet 11: SSP_SECT1_CHILD

SSP
LAYOUT FOR SECTION 1 DISAGGREGATED
CHILD CHARACTERISTIC DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 VALUE =M3 (MAX 5 PER CASE) M 3








3 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




5 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
60 FAMILY AFFILIATION -CHILD 1 20 20 Numeric;CHILD 1,3,5,7,9 1









61 DATE OF BIRTH - CHILD 8 21 28 Numeric Y Y Y Y M M D D


62 SOCIAL SECURITY NUMBER 9 29 37 Alphanumeric 1 2 3 4 5 6 7 8 9

63 RACE/ETHNICITY















ITEM63A_HISPANIC OR LATINO 1 38 38 Alphanumeric 1










ITEM63B_AMERICAN INDIAN OR ALASKA NATIVE 1 39 39 Alphanumeric 1










ITEM63C_ASIAN 1 40 40 Alphanumeric 1










ITEM63D_BLACK OR AFRICAN AMERICAN 1 41 41 Alphanumeric 1










ITEM63E_NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 1 42 42 Alphanumeric 1










ITEM63F_WHITE 1 43 43 Alphanumeric 1









64 GENDER 1 44 44 Numeric 1









65 RECEIVES DISABILITY BENEFITS













ITEM65A_RECEIVES BENEFITS BASED ON FEDERAL DISABILITY STATUS UNDER NON-SSI PROGRAMS 1 45 45 Alphanumeric 1










ITEM65B_RECEIVES SSI UNDER TITLE XVI-SSI 1 46 46 Alphanumeric 1









66 RELATIONSHIP TO HEAD OF HOUSEHOLD 2 47 48 Numeric 1 2








67 PARENT WITH MINOR CHILD 1 49 49 Alphanumeric 1









68 EDUCATIONAL LEVEL 2 50 51 Alphanumeric 1 2








69 CITIZENSHIP/ALIENAGE 1 52 52 Alphanumeric 1









70 AMOUNT OF UNEARNED INCOME










ITEM70A_SSI 4 53 56 Alphanumeric 1 2 3 4







ITEM70B_OTHER UNEARNED INCOME 4 57 60 Alphanumeric 1 2 3 4






60 FAMILY AFFILIATION - CHILD 1 61 61 Numeric;CHILD 2,4,6,8,10 1









61 DATE OF BIRTH ADULT - CHILD 8 62 69 Numeric Y Y Y Y M M D D


62 SOCIAL SECURITY NUMBER 9 70 78 Numeric 1 2 3 4 5 6 7 8 9

63 RACE/ETHNICITY















ITEM63A_HISPANIC OR LATINO 1 79 79 Alphanumeric 1










ITEM63B_AMERICAN INDIAN OR ALASKA NATIVE 1 80 80 Alphanumeric 1










ITEM63C_ASIAN 1 81 81 Alphanumeric 1










ITEM63D_BLACK OR AFRICAN AMERICAN 1 82 82 Alphanumeric 1










ITEM63E_NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 1 83 83 Alphanumeric 1










ITEM63F_WHITE 1 84 84 Alphanumeric 1









64 GENDER 1 85 85 Numeric 1









65 RECEIVES DISABILITY BENEFITS













ITEM65A_RECEIVES BENEFITS BASED ON FEDERAL DISABILITY STATUS UNDER NON-SSI PROGRAMS 1 86 86 Alphanumeric 1










ITEM65B_RECEIVES SSI UNDER TITLE XVI-SSI 1 87 87 Alphanumeric 1









66 RELATIONSHIP TO HEAD OF HOUSEHOLD 2 88 89 Numeric 1 2








67 PARENT WITH MINOR CHILD 1 90 90 Alphanumeric 1









68 EDUCATIONAL LEVEL 2 91 92 Alphanumeric 1 2








69 CITIZENSHIP/ALIENAGE 1 93 93 Alphanumeric 1









70 AMOUNT OF UNEARNED INCOME











ITEM70A_SSI 4 94 97 Alphanumeric 1 2 3 4







ITEM70B_OTHER UNEARNED INCOME 4 98 101 Alphanumeric 1 2 3 4







BLANK 49 102 150 Spaces 49 SPACES










Sheet 12: SSP_SECT2_FAMILY

SSP
LAYOUT FOR SECTION 2 DISAGGREGATED
FAMILY LEVEL DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 VALUE = M4 M 4








3 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




5 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
2 COUNTY FIPS CODE 3 20 22 Numeric 1 2 3







4 STRATUM 2 23 24 Numeric 1 2








6 ZIP CODE 5 25 29 Alphanumeric 1 2 3 4 5





7 DISPOSITION 1 30 30 Numeric 1









8 REASON FOR CLOSURE 2 31 32 Numeric 1 2








9 RECEIVES SUBSIDIZED HOUSING 1 33 33 Numeric 1









10 RECEIVES MEDICAL ASSISTANCE 1 34 34 Numeric 1









11 RECEIVES FOOD STAMPS 1 35 35 Numeric 1









12 RECEIVES SUBSIDIZED CHILD CARE 1 36 36 Numeric 1










BLANK 30 37 66 SPACES 30 SPACES










Sheet 13: SSP_SECT2_PERSON

SSP
LAYOUT FOR SECTION 2 DISAGGREGATED
PERSON LEVEL DATA

















ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)










RECORD TYPE 2 1 2 VALUE = M5 M 5








3 REPORTING MONTH 6 3 8 Numeric Y Y Y Y M M




5 CASE NUMBER 11 9 19 Alphanumeric A B C 1 2 3 A B C 4 5
13 FAMILY AFFILIATION 1 20 20 Numeric 1









14 DATE OF BIRTH 8 21 28 Numeric Y Y Y Y M M D D


15 SOCIAL SECURITY NUMBER 9 29 37 Alphanumeric 1 2 3 4 5 6 7 8 9

16 RACE/ETHNICITY















ITEM17A_HISPANIC OR LATINO 1 38 38 Alphanumeric 1










ITEM17B_AMERICAN INDIAN OR ALASKA NATIVE 1 39 39 Alphanumeric 1










ITEM17C_ASIAN 1 40 40 Alphanumeric 1










ITEM17D_BLACK OR AFRICAN AMERICAN 1 41 41 Alphanumeric 1










ITEM17E_NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 1 42 42 Alphanumeric 1










ITEM17F_WHITE 1 43 43 Alphanumeric 1









17 GENDER 1 44 44 Numeric 1









18 RECEIVES DISABILITY BENEFITS















ITEM18A_RECEIVED FEDERAL DISABILITY INSURANCE BENEFITS UNDER OASDI PROGRAM 1 45 45 Alphanumeric 1










ITEM18B_RECEIVED BENEFITS BASED ON FEDERAL DISABILITY STATUS UNDER NON-SSA PROGRAMS 1 46 46 Alphanumeric 1










ITEM18C_RECEIVED AID TO THE PERMANENTLY AND TOTALLY DISABLED UNDER TITLE XIV-APDT 1 47 47 Alphanumeric 1










ITEM18D - NO LONGER IN USE 1 48 48 Alphanumeric 0










ITEM18E_RECEIVED SSI UNDER TITLE XVI-SSI 1 49 49 Alphanumeric 1









19 MARITAL STATUS 1 50 50 Alphanumeric 1









20 RELATIONSHIP TO HEAD OF HOUSEHOLD 2 51 52 Numeric 1









21 PARENT WITH MINOR CHILD IN THE FAMILY 1 53 53 Alphanumeric 1









22 NEEDS OF A PREGNANT WOMAN - NO LONGER IN USE 1 54 54 Alphanumeric 0









23 EDUCATION LEVEL 2 55 56 Alphanumeric 1 2








24 CITIZENSHIP/ALIENAGE 1 57 57 Alphanumeric 1









25 EMPLOYMENT STATUS 1 58 58 Alphanumeric 1









26 AMOUNT OF EARNED INCOME 4 59 62 Alphanumeric 1 2 3 4






27 AMOUNT OF UNEARNED INCOME 4 63 66 Alphanumeric 1 2 3 4






Up to 16 persons per case
















Sheet 14: SSP_SECT3

SSP
LAYOUT FOR SECTION 3 AGGREGATED DATA




































ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)











RECORD TYPE 2 1 2 "M6" ONE PER QUARTER M 6









2 CALENDAR QUARTER
















CALENDAR YEAR 4 3 6 Numeric 2 0 2 3








CALENDAR QUARTER 1 7 7 Numeric 1










3 TOTAL NUMBER OF SSP-MOE FAMILIES
















ITEM_3_FIRST_MONTH 8 8 15 Numeric; First month sum(item4+item5+item6) 1 2 3 4 5 6 7 8




ITEM_3_SECOND_MONTH 8 16 23 Numeric; Second month sum(item4+item5+item6) 1 2 3 4 5 6 7 8




ITEM_3_THIRD_MONTH 8 24 31 Numeric; Third month sum(item4+item5+item6) 1 2 3 4 5 6 7 8



4 TOTAL NUMBER OF 2 PARENT FAMILES
















ITEM_4_FIRST_MONTH 8 32 39 Numeric 1 2 3 4 5 6 7 8




ITEM_4_SECOND_MONTH 8 40 47 Numeric 1 2 3 4 5 6 7 8




ITEM_4_THIRD_MONTH 8 48 55 Numeric 1 2 3 4 5 6 7 8



5 TOTAL NUMBER OF 1 PARENT FAMILIES
















ITEM_5_FIRST_MONTH 8 56 63 Numeric 1 2 3 4 5 6 7 8




ITEM_5_SECOND_MONTH 8 64 71 Numeric 1 2 3 4 5 6 7 8




ITEM_5_THIRD_MONTH 8 72 79 Numeric 1 2 3 4 5 6 7 8



6 TOTAL NUMBER OF NO PARENT FAMILIES
















ITEM_6_FIRST_MONTH 8 80 87 Numeric 1 2 3 4 5 6 7 8




ITEM_6_SECOND_MONTH 8 88 95 Numeric 1 2 3 4 5 6 7 8




ITEM_6_THIRD_MONTH 8 96 103 Numeric 1 2 3 4 5 6 7 8



7 TOTAL NUMBER OF RECIPIENTS
















ITEM_7_FIRST_MONTH 8 104 111 Numeric; First month sum(item8+item9) 1 2 3 4 5 6 7 8




ITEM_7_SECOND_MONTH 8 112 119 Numeric; Second month sum(item8+item9) 1 2 3 4 5 6 7 8




ITEM_7_THIRD_MONTH 8 120 127 Numeric; Third month sum(item8+item9) 1 2 3 4 5 6 7 8



8 TOTAL NUMBER OF ADULT RECIPIENTS
















ITEM_8_FIRST_MONTH 8 128 135 Numeric 1 2 3 4 5 6 7 8




ITEM_8_SECOND_MONTH 8 136 143 Numeric 1 2 3 4 5 6 7 8




ITEM_8_THIRD_MONTH 8 144 151 Numeric 1 2 3 4 5 6 7 8



9 TOTAL NUMBER OF CHILD RECIPIENTS
















ITEM_9_FIRST_MONTH 8 152 159 Numeric 1 2 3 4 5 6 7 8




ITEM_9_SECOND_MONTH 8 160 167 Numeric 1 2 3 4 5 6 7 8




ITEM_9_THIRD_MONTH 8 168 175 Numeric 1 2 3 4 5 6 7 8



10 TOTAL NUMBER OF NONCUSTODIAL PARENTS IN WORK ACTIVITIES
















ITEM_10_FIRST_MONTH 8 176 183 Numeric 1 2 3 4 5 6 7 8




ITEM_10_SECOND_MONTH 8 184 191 Numeric 1 2 3 4 5 6 7 8




ITEM_10_THIRD_MONTH 8 192 199 Numeric 1 2 3 4 5 6 7 8



11 TOTAL AMOUNT OF ASSISTANCE
















ITEM_11_FIRST_MONTH 12 200 211 Numeric 1 2 3 4 5 6 7 8 9 0 1 2

ITEM_11_SECOND_MONTH 12 212 223 Numeric 1 2 3 4 5 6 7 8 9 0 1 2

ITEM_11_THIRD_MONTH 12 224 235 Numeric 1 2 3 4 5 6 7 8 9 0 1 2
12 TOTAL NUMBER OF CLOSED CASES
















ITEM_12_FIRST_MONTH 8 236 243 Numeric 1 2 3 4 5 6 7 8




ITEM_12_SECOND_MONTH 8 244 251 Numeric 1 2 3 4 5 6 7 8




ITEM_12_THIRD_MONTH 8 252 259 Numeric 1 2 3 4 5 6 7 8




Sheet 15: SSP_SECT4

SSP
LAYOUT FOR SECTION 4 AGGREGATED STRATIFIED DATA


























ITEM # DESCRIPTION LENGTH FROM TO COMMENTS (DATA TYPE) Example of Contents (If BOLD & Blue = fixed value)






RECORD TYPE 2 1 2 "M7" ONE PER QUARTER M 7




2 CALENDAR QUARTER








CALENDAR YEAR 4 3 6 Numeric 2 0 2 3



CALENDAR QUARTER 1 7 7 Numeric 1





3 TDRS SECTION INDICATOR 1 8 8 Numeric 1





4 STRATUM-1 2 9 10 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 11 17 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 18 24 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 25 31 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 32 32 Numeric 1





4 STRATUM-2 2 33 34 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 35 41 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 42 48 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 49 55 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 56 56 Numeric 1





4 STRATUM-3 2 57 58 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 59 65 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 66 72 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 73 79 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 80 80 Numeric 1





4 STRATUM-4 2 81 82 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 83 89 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 90 96 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 97 103 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 104 104 Numeric 1





4 STRATUM-5 2 105 106 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 107 113 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 114 120 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 121 127 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 128 128 Numeric 1





4 STRATUM-6 2 129 130 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 131 137 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 138 144 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 145 151 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 152 152 Numeric 1





4 STRATUM-7 2 153 154 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 155 161 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 162 168 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 169 175 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 176 176 Numeric 1





4 STRATUM-8 2 177 178 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 179 185 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 186 192 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 193 199 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 200 200 Numeric 1





4 STRATUM-9 2 201 202 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 203 209 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 210 216 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 217 223 Numeric 1 2 3 4 5 6 7
3 TDRS SECTION INDICATOR 1 224 224 Numeric 1





4 STRATUM-10 2 225 226 Numeric 1 2




5 TOTAL NUMBER OF FAMILIES











ITEM_5_FIRST_MONTH 7 227 233 Numeric 1 2 3 4 5 6 7

ITEM_5_SECOND_MONTH 7 234 240 Numeric 1 2 3 4 5 6 7

ITEM_5_THIRD_MONTH 7 241 247 Numeric 1 2 3 4 5 6 7













File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy