This appendix consists of the following charts:
Chart F-1: Rejected Case Submission and Update Record Layout
Chart F-2: Rejected Case Submission and Update Control Record Layout
Chart F-3: Unaccountable Missing Address/Corrected SSN (UMACS) Record Layout
Chart F-4: Collection and Adjustment Record Layout
Chart F-5: Collection and Adjustment Control Record Layout
Chart F-6: Case Reconciliation Record Layout
Chart F-7: Case Reconciliation Control Record Layout
Each chart provides a detailed description of the output records in the files that are created by the FCE program.
Each record layout in this section provides the following information:
Field Name
Location
Length
Type (A = alphabetic, N = numeric, or A/N = alphanumeric)
Comments
The Comments column in the charts provides an explanation of each field in the record layout and its relationship to other fields or records. Additional information regarding the fields may be found in Appendix C, “Data Dictionary.”
The output files are transmitted to the states using SSA’s network and MFT protocol. Additional information regarding MFT, and the process for transmission of data, may be found in Section 6.1, “Managed File Transfer.”
PAPERWORK REDUCTION ACT OF 1995 (Pub. L. 104-13) STATEMENT OF PUBLIC BURDEN: The purpose of this statutorily required (42 U.S.C. 652(b); 42 U.S.C. 664; 26 U.S.C. 6402(c); 31 CFR 285.3; 45 CFR 302.60; 45 CFR 303.72; 31 U.S.C. 3701 et seq.; 31 U.S.C. 3716(h); 31 CFR 285.1; 42 U.S.C. 652(k); 42 U.S.C. 654(31); 22 CFR 51.60; 42 U.S.C. 654(31); 42 U.S.C. 664; 31 CFR 285.1; and 31 CFR 285.3) information collection is to collect past due child support. Public reporting estimated burden for this collection of information is 0.14 hours per respondent, including the time for reviewing instructions, gathering and maintaining the data needed, and reviewing the collection of information. As provided by the 5 U.S.C. §§552a(b) and (e), any confidential information collected for this program is protected secured, and accessed only by authorized users. A federal agency may not conduct or sponsor an information collection without a valid OMB Control Number. No individual or entity is required to respond to, nor shall an individual or entity be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act of 1995, without a current valid OMB Control Number. If you have any comments on this collection of information, please contact [email protected]
Chart F‑4: Collection and Adjustment Record Layout OMB Control No: 0970-0161 Expiration Date: xx/xx/xxxx |
||||
Field Name |
Location |
Length |
A/N |
Comments |
Submitting State Code |
1-2 |
2 |
A |
This field contains the state abbreviation that was sent to OCSE by the state and stored on the OCSE Case Master File. |
Local Code |
3-5 |
3 |
A/N |
This field contains the local code that was sent to OCSE by the state and stored on the OCSE Case Master File. |
SSN |
6-14 |
9 |
N |
This field contains the Social Security number that was sent to OCSE by the state and stored on the OCSE Case Master File. |
Case ID |
15-29 |
15 |
A/N |
This field contains the case identification that was sent to OCSE by the state and stored on the OCSE Case Master File. |
NCP Last Name |
30-49 |
20 |
A/N |
This field contains the NCP last name that was sent to OCSE by the state and stored on the OCSE Case Master File. |
NCP First Name |
50-64 |
15 |
A/N |
This field contains the NCP first name s that was sent to OCSE by the state and stored on the OCSE Case Master File. |
Certified Arrearage Amount |
65-75 |
11 |
N |
This field contains the arrearage amount that is stored on the OCSE Case Master File at the time of certification. The certified arrearage amount is a signed positive numeric amount with two decimal places assumed. |
Collection Amount |
76-86 |
11 |
N |
This field contains the amount of the offset that was sent to OCSE on the BFS Collection Record. The collection amount is a signed positive numeric amount with two decimal places assumed.
|
Adjustment Amount |
87-97 |
11 |
N |
This field contains the amount of the adjustment that was sent to OCSE on the BFS Collection Record. The adjustment amount is a signed positive numeric amount with two decimal places assumed.
|
Adjustment Year |
98-101 |
4 |
N |
This field contains the year during which the offset originated that was sent to OCSE on the BFS Collection Record. The adjustment year is in the CCYY format.
|
Offset Year |
102-105 |
4 |
N |
This field contains the current processing year when the offset occurred, in the CCYY format. |
Return Indicator |
106 |
1 |
A |
This field contains the return indicator that was sent to OCSE on the BFS Collection Record. The return indicator identifies whether or not this is a joint return. Spaces are returned in this field for an adjustment record. Y – joint return N – not a joint return |
Case Type Indicator |
107 |
1 |
A |
This field contains the Case Type indicator that was sent to OCSE by the state and stored on the OCSE Case Master File. |
Filler |
108-112 |
5 |
A/N |
Space filled. |
Payment Name |
113-147 |
35 |
A/N |
|
Payment Street Address |
148-182 |
35 |
A/N |
|
Payment City and State |
183-207 |
25 |
A/N |
|
Payment Zip Code |
208-216 |
9 |
N |
|
Offset Type |
217-219 |
3 |
A |
This field identifies the type of offset or adjustment that applied. Valid values are: MPY – Manual Payment RET – Federal Retirement TAX – Tax Refund Offset VEN – Vendor Payment/Miscellaneous |
Fee Amount |
220-224 |
5 |
N |
This field contains the service fee amount for an offset that was sent to OCSE on the BFS Collection Record. The fee amount is a numeric amount with two decimal places assumed.
|
Injured Spouse Indicator |
225 |
1 |
A |
This field contains the injured spouse indicator that was sent to OCSE on the BFS Collection Record. The injured spouse indicator identifies if an injured spouse allocation has been processed. Y – processed injured spouse allocation. N – no information is available, or no injured spouse allocation has been filed. This field is only populated for joint return offset records, that is, position 106 is a ‘Y’ and position 107 is an ‘N’.
|
Zero Balance Delete Indicator |
226 |
1 |
A |
This field contains the zero balance delete indicator that was set by OCSE to show that an offset reduced the modified arrearage amount for a case to zero. The case is deleted at OCSE but not BFS. Y – case deleted by the offset. N – all other records, including adjustments and offsets that did not reduce the modified arrearage amount to zeroes. |
TOP Trace Number |
227-236 |
10 |
A/N |
The trace number assigned to an offset collection by BFS and returned as an identifier with a collection or associated adjustment. |
BFS Offset Month Day or Reversal Reason Code |
237-240 |
4 |
A/N |
For offsets:
For reversals, this field contains one of the following codes:
|
Chart F‑5: Collection and Adjustment Control Record Layout OMB Control No: 0970-0161 Expiration Date: xx/xx/xxxx |
||||
Field Name |
Location |
Length |
A/N |
Comments |
Submitting State Code |
1-2 |
2 |
A |
This field contains the state abbreviation that was sent to OCSE and stored on the OCSE Case Master File. |
Filler |
3-5 |
3 |
A/N |
Space Filled. |
Total Control |
6-14 |
9 |
A/N |
This field is a constant field and contains ‘TOTAL’ to identify this record as the Collection and Adjustment Control Record. |
Filler |
15-34 |
20 |
A/N |
Space Filled. |
Total Adjustments |
35-49 |
15 |
N |
This field contains the total number of adjustments that were processed. |
Total Collections |
50-64 |
15 |
N |
This field contains the total number of collections that were processed. |
Total Certified Arrearage Amount |
65-75 |
11 |
N |
This field is an accumulation of the certified arrearage amounts that were processed. The total certified arrearage amount is a signed positive numeric amount with two decimal places assumed. |
Total Collection Amount |
76-86 |
11 |
N |
This field is an accumulation of the collection amounts that were processed. The total collection amount is a signed positive numeric amount with two decimal places assumed. |
Total Adjustment Amount |
87-97 |
11 |
N |
This field is an accumulation of the adjustment amounts that were processed. The total adjustment amount is a signed positive numeric amount with two decimal places assumed. |
Total Net Amount |
98-108 |
11 |
N |
This field contains the total collection amount minus the total adjusted amount. The total net amount is a signed positive numeric amount with two decimal places assumed. |
OCSE Cycle Number |
109-114 |
6 |
A/N |
This field contains the year and cycle number for this file of collections and adjustments. The format of the field is CCYYNN in which CC is century, YY is calendar year, and NN is the cycle number. |
Filler |
115-240 |
126 |
A/N |
Space Filled. |
File Type | application/vnd.openxmlformats-officedocument.wordprocessingml.document |
Author | Tutwiler, Angela (ACF) (CTR) |
File Modified | 0000-00-00 |
File Created | 2022-09-09 |