TANF-ACF-IM-2011-02 (File Layouts and Edits for the Report on Engagement in Additional Work Activities)

Publication Date: February 25, 2011
Current as of:

TO:

State Agencies Administering the Temporary Assistance for Needy Families (TANF) Program and Other Interested Parties

SUBJECT:

File Layouts and Edits for the Report on Engagement in Additional Work Activities

REFERENCE:

Section 411of the Social Security Act and section 812 of the Claims Resolution Act of 2010.

BACKGROUND:

Section 812 of the Claims Resolution Act of 2010 modifies section 411of the Social Security Act by requiring that each State agency, the District of Columbia, and the Territories submit a Report on Engagement in Additional Work Activities. The new report must be submitted for two reporting periods. The first reporting period is from March 1 through March 31, 2011 and this report is due no later than May 31, 2011. The second reporting period is from April 1 through June 30, 2011 and the report for this period is due no later than August 31, 2011. The report form and instructions were transmitted via TANF-ACF-PI-2011- 03, Form ACF-812, the Report on Engagement in Additional Work Activities for Families Receiving Assistance under the TANF and SSP-MOE Programs.

CONTENT:

This memorandum transmits the transmission file layouts and edits for the Report on Engagement in Additional Work Activities.

ATTACHMENT:

RoE– Header Trailer Layout, RoE – Family Record Layout, RoE – Person Record Layout, and RoE – Edits

INQUIRIES:

Inquiries should be directed to the TANF Program Manager in your Region.

 

/s/
Earl S. Johnson
Director
Office of Family Assistance

 

TANF-ACF-IM-2011-02, RoE– Header Trailer Layout, RoE – Family Record Layout, RoE – Person Record Layout, and RoE – Edits

 

TANF - SSPMOE
Report on Engagement
Revised 2/18/2011

TRANSMISSION FILE HEADER RECORD
 

DESCRIPTION

LENGTH

FROM

TO

COMMENT

Title

6

1

6

Value = HEADER

Calendar Quarter

5

7

11

Value = YYYYQ
Q=1 (Mar)
Q=2 (Apr-Jun)

State FIPS code

2

12

13

2 digit state code

Encryption Indicator

1

14

14

E=SSN is encrypted
Blank = SSN is not encrypted

Update Indicator

1

15

15

N = New data
D = Delete existing data

The Header Record precedes all data records. Data records are sorted by report month, case number and record type.

 

TRANSMISSION FILE TRAILER RECORD
 

DESCRIPTION

LENGTH

FROM

TO

COMMENT

Title

7

1

7

Value = TRAILER

Number of Records transmitted

7

8

14

Right Adjusted

Blank

9

15

23

Value = spaces
The Trailer Record follows all data records. Header and trailer records are not counted.

back to top

2/18/2011

All data is Right Adjusted
File Names;
ADS.E2J.NDMn.ESxx (C:D or CFI)
ADS.E2J.FTPn.ESxx (FTP)


TANF - SSPMOE
REPORT ON ENGAGEMENT
FAMILY DATA
 
ITEM #    DESCRIPTION  LENGTH  FROM TO COMMENTS
  RECORD TYPE 2 1 2 "E1"
2 REPORTING MONTH 6 3 8 Numeric
4 CASE NUMBER 11 9 19 Alphanumeric
3 STRATUM 2 20 21 Numeric
5 FAMILY RECEIVING ASSISTANCE 1 22 22 Numeric
6 NO OF FAMILIES ON THE MONTHLY SAMPLE FRAME        
       6A  TANF 6 23 28 Numeric
       6B  SSPMOE 6 29 34 Numeric
  BLANK 221 35 255 Spaces

back to top

2/18/2011

All data is Right Adjusted

 

TANF - SSPMOE
REPORT ON ENGAGEMENT
PERSON DATA
 
ITEM #    DESCRIPTION  LENGTH   FROM  TO COMMENTS
  RECORD TYPE
2
1
2
"E2"   UP TO 4 PERSON RECORDS
2 REPORTING MONTH
6
3
8
Numeric
4 CASE NUMBER
11
9
19
Alphanumeric
7 SOCIAL SECURITY NUMBER
9
20
28
Alphanumeric
8 PARTICIPATE IN COUNTABLE ACTIVITIES FOR SUFFICIENT HOURS
1
29
29
Alphanumeric
9 PARTICIPATE IN COUNTABLE ACTIVITIES - STATE NOT TO REPORT
 
 
 
 
       9A  SUFFICIENT FOR PARTICIPATION RATE
1
30
30
Alphanumeric
       9B  UNSUBSIDIZED EMPLOYMENT
3
31
33
Numeric
       9C  SUBSIDIZED PRIVATE EMPLOYMENT
3
34
36
Numeric
       9D  SUBSIDIZED PUBLIC EMPLOYMENT
3
37
39
Numeric
       9E  WORK EXPERIENCE
3
40
42
Numeric
       9F  ON THE JOB TRAINING
3
43
45
Numeric
       9G  JOB SEARCH
3
46
48
Numeric
       9H  COMMUNITY SERVICE
3
49
51
Numeric
       9I  VOCATIONAL TRAINING
3
52
54
Numeric
       9J  JOB SKILLS TRAINING
3
55
57
Numeric
       9K  EDUCATION
3
58
60
Numeric
       9L  SCHOOL ATTENDANCE
3
61
63
Numeric
       9M  PROVIDING CHILD CARE SERVICE
3
64
66
Numeric
10 PARTICIPATE IN COUNTABLE ACTIVITIES - INSUFFICIENT HOURS TO MEET WORK REQ
 
 
 
 
       10A  SUFFICIENT FOR PARTICIPATION RATE
1
67
67
Alphanumeric
       10B  UNSUBSIDIZED EMPLOYMENT
3
68
70
Numeric
       10C  SUBSIDIZED PRIVATE EMPLOYMENT
3
71
73
Numeric
       10D  SUBSIDIZED PUBLIC EMPLOYMENT
3
74
76
Numeric
       10E  WORK EXPERIENCE
3
77
79
Numeric
       10F  ON THE JOB TRAINING
3
80
82
Numeric
       10G  JOB SEARCH
3
83
85
Numeric
       10H  COMMUNITY SERVICE
3
86
88
Numeric
       10I  VOCATIONAL TRAINING
3
89
91
Numeric
       10J  JOB SKILLS TRAINING
3
92
94
Numeric
       10K  EDUCATION
3
95
97
Numeric
       10L  SCHOOL ATTENDANCE
3
98
100
Numeric
       10M  PROVIDING CHILD CARE SERVICE
3
101
103
Numeric
11 PARTICIPATE IN COUNTABLE ACTIVITIES - PARTICIPATION HOURS BEYOND STATUTORY LIMIT
 
 
 
 
       11A  BEYOND STATUTORY LIMIT
1
104
104
Alphanumeric
       11B  JOB SEARCH
3
105
107
Numeric
       11C  VOCATIONAL TRAINING
3
108
110
Numeric
12 PARTICIPATE IN COUNTABLE ACTIVITIES - FEDERAL VERIFICATION STANDARD
 
 
 
 
       12A  SUFFICIENT FOR PARTICIPATION RATE
1
111
111
Alphanumeric
       12B  UNSUBSIDIZED EMPLOYMENT
3
112
114
Numeric
       12C  SUBSIDIZED PRIVATE EMPLOYMENT
3
115
117
Numeric
       12D  SUBSIDIZED PUBLIC EMPLOYMENT
3
118
120
Numeric
       12E  WORK EXPERIENCE
3
121
123
Numeric
       12F  ON THE JOB TRAINING
3
124
126
Numeric
       12G  JOB SEARCH
3
127
129
Numeric
       12H  COMMUNITY SERVICE
3
130
132
Numeric
       12I  VOCATIONAL TRAINING
3
133
135
Numeric
       12J  JOB SKILLS TRAINING
3
136
138
Numeric
       12K  EDUCATION
3
139
141
Numeric
       12L  SCHOOL ATTENDANCE
3
142
144
Numeric
       12M  PROVIDING CHILD CARE SERVICE
3
145
147
Numeric
13 PARTICIPATE IN NON COUNTABLE ACTIVITIES UNDER SECTION 407(D) OF SOCIAL SECURITY ACT
 
 
 
 
       13A  PARTICIPATE IN ACTIVITIES
1
148
148
Alphanumeric
       13B  HIGH SCHOOL OR GED
3
149
151
Numeric
       13C  ADULT BASIC EDUCATION / ESL
3
152
154
Numeric
       13D  POST SECONDARY EDUCATION
3
155
157
Numeric
       13E  TREATMENT ACTIVITIES
3
158
160
Numeric
       13F  FAMILY LIFE SKILLS
3
161
163
Numeric
       13G  ACCESSING WORK SUPPORT ACTIVITIES
3
164
166
Numeric
       13H  IN ASSESSMENT
3
167
169
Numeric
       13I  OTHER
 
 
 
 
           13Ii  HOURS OF PARTICIPATION
3
170
172
Numeric
           13Iii  SPECIFY OTHER ACTIVITY
40
173
212
Alphanumeric
14 WORK-ELIGIBLE INVIDUAL ENGAGED IN WORK ACTIVITY
 
 
 
 
       14A  ENGAGED IN ANY WORK ACTIVITY
1
213
213
Alphanumeric
       14B  REASON FOR NON PARTICIPATION
2
214
215
Alphanumeric
       14C  SPECIFY OTHER REASON
40
216
255
Alphanumeric

 

back to top

Effective date : 5/16/2011

All data is Right Adjusted


TANF-SSPMOE REPORT ON ENGAGEMENT
EDITS
 
EDIT # ITEM # DESCRIPTION EDIT VALUES EDIT TYPE
E1-001
1
 FIPS CODE ITEM 1 MUST = 01-02, 04-06, 08-13, 15-42, 44-51, 53-56, 66, 72, 78
FATAL
E1-002
2
 REPORTING YEAR ITEM 2 (YEAR) MUST = > 2011
FATAL
E1-003
2
 REPORTING MONTH ITEM 2 (MONTH) MUST >=01 AND =
FATAL
E1-004
3
 STRATUM ITEM 3 MUST = 00-99
FATAL
E1-005
4
 CASE NUMBER ITEM 4  MUST NOT BE BLANK
FATAL
E1-006
5
 FAMILY RECEIVING ASSISTANCE ITEM 5 MUST = 1 - 3
FATAL
E1-007
7
 SOCIAL SECURITY NUMBER ITEM 7 MUST NOT BE BLANK
FATAL
E1-008
7
 SOCIAL SECURITY NUMBER SSN IS NOT 9 NUMERIC DIGITS
FATAL
E1-009
8
 PARTICIPATE IN COUNTABLE ACTIVITIES FOR SUFFICIENT HOURS ITEM 8 MUST = 0 - 1
FATAL
E1-010
9
 PARTICIPATE IN COUNTABLE ACTIVITIES - STATE NOT TO REPORT ITEM 9A MUST = 0 - 1
FATAL
E1-011
9
 PARTICIPATE IN COUNTABLE ACTIVITIES - STATE NOT TO REPORT IF ITEM 8 = 1 OR ITEM 9A = 0, THEN ITEM 9B - 9M MUST BLANK
FATAL
E1-012
9
 PARTICIPATE IN COUNTABLE ACTIVITIES - STATE NOT TO REPORT IF ITEM 8 = 0 AND ITEM 9A = 1, THEN ITEM 9B - 9M MUST >= 0
FATAL
E1-013
10
 PARTICIPATE IN COUNTABLE ACTIVITIES - INSUFFICIENT HOURS TO MEET WORK REQ ITEM 10A MUST = 0 - 1
FATAL
E1-014
10
 PARTICIPATE IN COUNTABLE ACTIVITIES - INSUFFICIENT HOURS TO MEET WORK REQ IF ITEM 8 = 1 OR ITEM 10A = 0, THEN ITEM 10B - 10M MUST BLANK
FATAL
E1-015
10
 PARTICIPATE IN COUNTABLE ACTIVITIES - INSUFFICIENT HOURS TO MEET WORK REQ IF ITEM 8 = 0 AND ITEM 10A = 1, THEN ITEM 10B - 10M MUST >= 0
FATAL
E1-016
11
 PARTICIPATE IN COUNTABLE ACTIVITIES - PARTICIPATION HOURS BEYOND STATUTORY LIMIT ITEM 11A MUST = 0 - 1
FATAL
E1-017
11
 PARTICIPATE IN COUNTABLE ACTIVITIES - PARTICIPATION HOURS BEYOND STATUTORY LIMIT IF ITEM 8 = 1 OR ITEM 11A = 0, THEN ITEM 11B - 11C MUST BLANK
FATAL
E1-018
11
 PARTICIPATE IN COUNTABLE ACTIVITIES - PARTICIPATION HOURS BEYOND STATUTORY LIMIT IF ITEM 8 = 0 AND ITEM 11A = 1, THEN ITEM 11B - 11C MUST >= 0
FATAL
E1-019
12
 PARTICIPATE IN COUNTABLE ACTIVITIES - FEDERAL VERIFICATION STANDARD ITEM 12A MUST = 0 - 1
FATAL
E1-020
12
 PARTICIPATE IN COUNTABLE ACTIVITIES - FEDERAL VERIFICATION STANDARD IF ITEM 8 = 1 OR ITEM 12A = 0, THEN ITEM 12B - 12M MUST BLANK
FATAL
E1-021
12
 PARTICIPATE IN COUNTABLE ACTIVITIES - FEDERAL VERIFICATION STANDARD IF ITEM 8 = 0 AND ITEM 12A = 1, THEN ITEM 12B - 12M MUST >= 0
FATAL
E1-022
13
 PARTICIPATE IN NON COUNTABLE ACTIVITIES UNDER SECTION 407(D) OF SOCIAL SECURITY ACT ITEM 13A MUST = 0 - 1
FATAL
E1-023
13
 PARTICIPATE IN NON COUNTABLE ACTIVITIES UNDER SECTION 407(D) OF SOCIAL SECURITY ACT IF ITEM 8 = 1 OR ITEM 13A = 0, THEN ITEM 13B - 13I MUST BLANK
FATAL
E1-024
13
 PARTICIPATE IN NON COUNTABLE ACTIVITIES UNDER SECTION 407(D) OF SOCIAL SECURITY ACT IF ITEM 8 = 0 AND ITEM 13A = 1, THEN ITEM 13B - 13H MUST >= 0
FATAL
E1-025
13
 PARTICIPATE IN NON COUNTABLE ACTIVITIES UNDER SECTION 407(D) OF SOCIAL SECURITY ACT IF ITEM 13Ii IS NOT BLANK, THEN ITEM 13Iii MUST NOT BLANK
WARNING
E1-026
14
 WORK-ELIGIBLE INVIDUAL ENGAGED IN WORK ACTIVITY ITEM 14A MUST = 0 - 1
FATAL
E1-027
14
 WORK-ELIGIBLE INVIDUAL ENGAGED IN WORK ACTIVITY IF ITEM 14A = 0, THEN ITEM 14B MUST = 01 - 14, 99
FATAL
E1-028
14
 WORK-ELIGIBLE INVIDUAL ENGAGED IN WORK ACTIVITY IF ITEM 14B = 99, THEN ITEM 14C MUST NOT BLANK
WARNING
E1-029
6
 NO OF FAMILY ON THE MONTHLY SAMPLE FRAME ITEM 6 MUST BE NUMERIC
FATAL
 
 
    
 
E1-500
HEADER
 HEADER RECORD VALIDATION DATA TYPE IN HEADER RECORD DOES NOT MATCH RECORD TYPE.
FATAL
E1-501
SYSTEM
 SYSTEM VALIDATION TOO MANY DATA ERRORS; STOPPED AFTER 500 ERRORS.
FATAL
E1-502
SYSTEM
 SYSTEM VALIDATION CASE MUST HAVE AT LEAST 1 PERSON RECORD AND NO MORE THAN 4 PERSON RECORDS.
FATAL
E1-503
HEADER
 HEADER RECORD VALIDATION CALENDAR YEAR IN CALENDAR QUARTER MUST BE => 2011 AND CALENDAR QUARTER MUST = 1-2.
FATAL
E1-504
TRAILER
 TRAILER RECORD VALIDATION RECORD COUNT IN TRAILER RECORD DOES NOT MATCH COMPUTED RECORD TOTAL.
WARNING
E1-505
SYSTEM
 SYSTEM VALIDATION HEADER RECORD IS MISSING.
FATAL
E1-506
TRAILER
 TRAILER RECORD VALIDATION TRAILER RECORD IS MISSING.
WARNING
E1-507
HEADER
 HEADER RECORD VALIDATION ENCRYPTION CODE IS INVALID
WARNING
E1-508
HEADER
 HEADER RECORD VALIDATION HEADER RECORD IS NOT FOLLOWED BY DATA RECORDS
FATAL
E1-509
HEADER
 HEADER RECORD VALIDATION INVALID STATE FIPS CODE
FATAL
E1-510
HEADER
 HEADER RECORD VALIDATION REPORT MONTH DOES NOT MATCH CALENDAR YEAR & QUARTER
FATAL
E1-511
HEADER
 HEADER RECORD VALIDATION UPDATE INDICATOR IS NOT VALID (D,N)
FATAL
E1-512
SYSTEM
 SYSTEM VALIDATION CASE NUMBER IS OUT OF SEQUENCE
FATAL

 

back to top