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

Publication Date: February 25, 2011

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

    Current as of: