This appendix consists of the following charts:
Chart E-1 Case Submission and Update Record Layout
Chart E-2 Case Submission and Update Control Record Layout
Chart E-3 State/Local Contact Phone and Address Record Layout
These charts show the detailed record layouts that are accepted by the FOP.
Each record layout in this appendix provides the following information:
Name
Location
Length
Type (A = alphabetic, N = numeric, or A/N = alphanumeric)
Comments
The Comments column in the charts provides edit information and indicates if the field is required for a specific transaction. Comments also provide an explanation of the field and its relationship to other fields, or records, where appropriate. Additional information regarding each field may be found in Appendix C, “Data Dictionary”.
The data transmitted to OCSE must comply with the following requirements:
All data must be in EBCDIC format.
All alphabetic data must be in upper case.
All alphabetic and alphanumeric data must be left justified and space filled.
All numeric data must be right justified and zero-filled.
All dates must be in the CCYY format.
All Filler fields must be filled with spaces.
Chart E‑1: Case Submission and Update Record Layout OMB Control No: 0970-0161 Expiration Date: XX/XX/20XX |
||||
Field Name |
Location |
Length |
A/N |
Comments |
Submitting State Code |
1-2 |
2 |
A |
Required – Key Data This field is required for all Transaction Types. This field must contain a valid, two-character, alphabetic State abbreviation code for the submitting State. Refer to Appendix H, “State and Territory Abbreviations; Country Codes”, for a list of these codes.
|
Local Code |
3-5 |
3 |
A/N |
Optional This field is used with Transaction Types ‘A’ and ‘L’. This field contains the code that will be used to associate the obligor with a local contact address when the Pre-Offset Notice is produced by OCSE or an offset notice is produced by FMS.
Refer to Section 2.1.4.3.4, “Local Code Change”, for details about keeping local code information up to date at OCSE. |
SSN |
6-14 |
9 |
N |
Required – Key Data This field is required for all Transaction Types. This field must be numeric, must be greater than zero, and must contain a valid SSN or ITIN.
|
Case ID |
15-29 |
15 |
A/N |
Conditionally Required This field is used if the Transaction Type equals ‘A’ or ‘C’. This field is for State use only; it is not sent to FMS or DoS. If this field is not used by the State, it should be filled with spaces.
If Transaction Type equals ‘B’, ‘L’, ‘M’, ‘R’, ‘S’, ‘T’, ‘Z’ or ‘D’, the Case ID, if present, will not be updated at OCSE. |
Obligor Last Name |
30-49 |
20 |
A/N |
Required This field is required for all Transaction Types. No spaces or special characters, except a hyphen, can be embedded within the first four positions.
Refer to Sections 2.1.4.3.1, “Name Change” and 2.2.5.5, “Name Processing”, for more details.
|
Obligor First Name |
50-64 |
15 |
A/N |
Conditionally Required This field is required If Transaction Type equals ‘A’ and ‘B’. The first position of this field must contain an alphabetic character.
Refer to Sections 2.1.4.3.1, “Name Change” and 2.2.5.5, “Name Processing”, for more details. |
Arrearage Amount (Accumulated Payment Amount) |
65-72 |
8 |
N |
Conditionally Required
If Transaction Type equals ‘B’, ‘C’, ‘L’, ‘R’, ‘Z’ or ‘T’, the arrearage amount, if present, will not be updated at OCSE or FMS. |
Transaction Type |
73 |
1 |
A |
Required This field must contain a valid Transaction Type code. Valid codes for this field are: A – Add/Recertify Case B – Name Change C – Case ID Change D – Delete Case L – Local Code Change M – Modify Arrearage Amount R – Replace Exclusion Indicator(s) S – State Payment T – Transfer for Administrative Review Z – Address Change |
Case Type Indicator |
74 |
1 |
A |
Required – Key Data This field is required for all Transaction Types. This field must contain one of the following valid case type codes: A – TANF N – Non‑TANF
|
Transfer State Code |
75-76 |
2 |
A |
Conditionally Required
|
Transfer Local Code |
77-79 |
3 |
A/N |
Optional
|
Process Year |
80-83 |
4 |
A/N |
Conditionally Required
|
Obligor Address Line 1 |
84-113 |
30 |
A/N |
Conditionally Required
|
Obligor Address Line 2 |
114-143 |
30 |
A/N |
Optional
If Transaction Type equals ‘B’, ‘C’, ‘D’, ‘L’, ‘M’, ‘S’, ‘R’ or ‘T’, the address, if present, will not be updated at OCSE or FMS. |
Obligor City |
144-168 |
25 |
A/N |
Conditionally Required
|
Obligor State |
169-170 |
2 |
A |
Conditionally Required
|
Obligor Zip Code |
171-179 |
9 |
N |
Conditionally Required
|
Date Issued |
180-187 |
8 |
A/N |
Conditionally Required
|
Exclusion Indicator(s) |
188-227 |
40 |
A |
Optional
ADM – Exclude all Administrative Offsets (RET, SAL, VEN) RET – Exclude Federal Retirement Offset VEN – Exclude Vendor Payment/Miscellaneous Offset SAL – Exclude Federal Salary Offset (pre-set at FMS on all cases) TAX – Exclude Tax Refund Offset PAS – Exclude Passport Denial FIN – Exclude Multistate Financial Institution Data Match DCK – Exclude Debt Check Program (for participating States) INS – Exclude Insurance Match (for participating States) Space – Remove all existing exclusion indicators
|
Filler |
228-244 |
17 |
A/N |
Space filled. |
Request Code |
245 |
1 |
A/N |
Optional
|
Chart E‑2: Case Submission and Update Control Record Layout OMB Control No: 0970-0161 Expiration Date: XX/XX/20XX |
||||
Field Name |
Location |
Length |
A/N |
Comments |
Submitting State Code |
1-2 |
2 |
A |
This field should contain a valid, two-character, alphabetic State abbreviation code for the submitting State. |
Control |
3-5 |
3 |
A |
This field must contain the value ‘CTL’ to indicate that this is the control record for the file. |
Total TANF Records |
6-14 |
9 |
N |
This field should contain the total number of TANF records on the Case Submission and Update File. |
Total Non-TANF Records |
15-23 |
9 |
N |
This field should contain the total number of Non-TANF records on the Case Submission and Update File. |
Total TANF Amount |
24-34 |
11 |
N |
This field should contain the total arrearage amount for TANF records on the Case Submission and Update File. |
Total Non-TANF Amount |
35-45 |
11 |
N |
This field should contain the total arrearage amount for Non-TANF records on the Case Submission and Update File. |
Filler |
46-245 |
200 |
A/N |
Space Filled. |
Chart E‑3: State/Local Contact Phone and Address Record Layout OMB Control No: 0970-0161 Expiration Date: XX/XX/20XX |
||||
Field Name |
Location |
Length |
A/N |
Comments |
Submitting State Code |
1-2 |
2 |
A |
Required – Key Data This field must contain a valid, two-character, alphabetic State abbreviation code for the submitting State. Refer to Appendix H, “State and Territory Abbreviations; Country Codes”, for a list of these codes. |
Local Code |
3-5 |
3 |
A/N |
Required – Key Data This field must be numeric.
|
Telephone Number 1 |
6-19 |
14 |
A/N |
Required This field must contain the State or local contact telephone number. The area code must be surrounded by parentheses, with a space after the right parenthesis. The first three digits of the telephone number are followed by a dash, and the last four digits of the telephone number fill the remainder of the field (e.g., (301) 555‑1212). |
Extension 1 |
20-23 |
4 |
N |
Optional If used, this field must be numeric, and contains the extension to Telephone Number 1. |
Telephone Number 2 |
24-37 |
14 |
A/N |
Optional This field should contain the in-state toll-free telephone number, and will be designated as such on the Pre-Offset Notice. The area code must be surrounded by parentheses with a space after the right parenthesis. The first three digits of the telephone number are followed by a dash, and the last four digits of the telephone number fill the remainder of the field (e.g., (800) 555‑1212). |
Extension 2 |
38-41 |
4 |
N |
Optional If present, this field must be numeric, and contains the extension to Telephone Number 2. |
State Agency Name |
42-76 |
35 |
A/N |
Required This field must contain the name of the contact office (e.g., Bureau of Child Support Enforcement). A reference to “Child Support” or “Family Support” must be included in this field. Do not reference the ‘IRS’, ‘FMS’, or specific names of contact persons in any of the State Agency Name or Address Fields. |
State Agency Address Line 1 |
77-111 |
35 |
A/N |
Conditionally Required This field is required if Address Lines 2 and 3 are spaces. |
State Agency Address Line 2 |
112-146 |
35 |
A/N |
Conditionally Required This field is required if Address Lines 1 and 3 are spaces. |
State Agency Address Line 3 |
147-181 |
35 |
A/N |
Conditionally Required This field is required if Address Lines 1 and 2 are spaces. |
State Agency Address Line 4 |
182-216 |
35 |
A/N |
Required This field must contain the fourth address line for the State agency name (e.g., State, city and zip code). |
Filler |
217-220 |
4 |
A/N |
Space Filled. |
Appendix E: Input Record
Specifications E-
File Type | application/msword |
Author | KDonovan |
Last Modified By | Jean Shaw |
File Modified | 2009-10-14 |
File Created | 2009-10-14 |