Form 1 Input Record

Federal Tax Offset, Administrative Offset, and Passport Denial Programs

PRA - Input Record Spec 10-14-09

Input Record

OMB: 0970-0161

Document [doc]
Download: doc | pdf
  1. Input Record Specifications

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:

  1. Name

  2. Location

  3. Length

  4. Type (A = alphabetic, N = numeric, or A/N = alphanumeric)

  5. 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.

  1. All alphabetic data must be in upper case.

  2. All alphabetic and alphanumeric data must be left justified and space filled.

  3. All numeric data must be right justified and zero-filled.

  4. 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.

  • If Transaction Type equals ‘B’, ‘C’, ‘L’, ‘M’, ‘R’, ‘S’, ‘T’, ‘Z’ or ‘D’, all key fields (Submitting State Code, SSN, Case Type Indicator) must match key fields on the OCSE Case Master File in order for the transaction to be processed. If there is no match, the transaction will be rejected.

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.

  • If Transaction Type equals ‘A’ (Add/Recertify Case), the local code that is submitted is compared against the OCSE State/Local Contact Phone and Address File. If the local code contains spaces or is not found, the local code for the case will be set to zeros on the OCSE Case Master File, and a local code of zeros will be submitted for the case to FMS.

  • If Transaction Type equals ‘L’, and the local code that is submitted contains spaces, the local code for the case will be set to zeros on the OCSE Case Master File, and a local code of zeros will be submitted for the case to FMS. Otherwise, the local code that is submitted is compared against the OCSE State/Local Contact Phone and Address File. If the local code is not found, the transaction will be rejected.

  • If Transaction Type equals ‘B’, ‘C’, ‘M’, ‘S’, ‘R’, ‘D’, ‘Z’ or ‘T’, the local code, if present, will not be updated at OCSE or 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.

  • If Transaction Type equals ‘A’ (Add/Recertify Case), the SSN is verified using an SSA-defined range check that automatically validates the area portion of the SSN (the first three positions of the SSN) against the current high digit being used for area. In addition, the group portion of the SSN (the fourth and fifth positions of the SSN) is compared against the area to ensure that the group number was issued with the particular area number. To verify the current high digits for area and group issued by SSA, refer to Chart D-3, “Online Resources”, “IRS Web Sites”.

  • If Transaction Type equals ‘B’, ‘C’, ‘L’, ‘M’, ‘R’, ‘S’, ‘T’, ‘Z’ or ‘D’, all key fields (Submitting State Code, SSN, and Case Type Indicator) must match key fields on the OCSE Case Master File in order for the transaction to be processed. If there is no match, the transaction will be rejected.

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 ‘A’ (Add/Recertify Case), if present, OCSE will store the field on the Case Master File without performing any edits. This field is not sent to FMS or DoS.

  • If Transaction Type equals ‘C’ (Change Case ID), this field is required. The new Case ID will overwrite the existing Case ID without performing any edits.

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.

  • If Transaction Type equals ‘A’, if the last name does not match the OCSE Case Master File for the obligor, the name is processed as a name change.

  • If Transaction Type equals ‘B’ (Name Change), the first four positions must contain at least one alphabetic character.

  • If Transaction Type equals ‘A’ (Add Case) or ‘B’ (Name Change), the last name is stored on the OCSE Case Master File after the last name passes the edit check above.

  • If Transaction Type equals ‘C’, ‘L’, ‘M’, ‘R’, ‘S’, ‘T’, ‘Z’ or ‘D’, the first 4 characters that are submitted must match the first 4 characters that are stored on the OCSE Case Master File or the first 4 characters of a Transaction Type ‘B’ (Name Change) transaction for the same case in the same process. If there is no match, the transaction will be rejected.

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.

  • If Transaction Type equals ‘A’ (Add Case) or ‘B’ (Name Change), the first name is stored on the OCSE Case Master File after the first character passes the edit check above.

  • If Transaction Type equals ‘A’, and the first name does not match the OCSE Case Master File for the obligor, the name is processed as a name change.

  • If Transaction Type equals ‘C’, ‘L’, ‘M’, ‘R’, ‘S’, ‘T’, ‘Z’ or ‘D’, the obligor first name, if present, will not be updated at OCSE or FMS.

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 ‘A’ (Add/Recertify Case), the arrearage amount is the current amount owed by the obligor. If the arrearage amount is less than $25, the Add Case transaction will be rejected.

  • If Transaction Type equals ‘A’, ‘M’ or ‘S’, this field is required. This field must contain a numeric amount in whole dollars only. Decimal points, dollar signs, commas, or plus/minus signs are not valid (e.g., $1,500.00 = 00001500).

  • If Transaction Type equals ‘D’, this field is not required. However, the existing arrearage amount will be zeroed out.

  • If Transaction Type equals ‘M’, the arrearage amount is the current amount that is owed by the obligor. If the arrearage amount is equal to zero, the case will be flagged as deleted.

  • If Transaction Type equals ‘S’, this field functions as the Accumulated Payment Amount Field and is referred to by that name. The accumulated payment amount is the accumulated State Payment Amount for the processing year.

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

  • If Transaction Type equals ‘B’, ‘C’, ‘L’, ‘M’, ‘R’, ‘S’, ‘T’, ‘Z’ or ‘D’, all key fields (Submitting State Code, SSN, and Case Type Indicator) must match key fields on the OCSE Case Master File in order for the transaction to be processed. If there is no match, the transaction will be rejected.

Transfer State Code

75-76

2

A

Conditionally Required

  • If Transaction Type equals ‘T’, this field must contain a valid, two-character, alphabetic State abbreviation code for the transfer State. Refer to Appendix H, “State and Territory Abbreviations; Country Codes”, for a list of these codes.

  • If Transaction Type equals ‘A’, ‘B’, ‘C’, ‘D’, ‘L’, ‘M’, ‘S’, ‘Z’ or ‘R’, this field, if present, will not be updated at OCSE.

Transfer Local Code

77-79

3

A/N

Optional

  • If Transaction Type equals ‘T’, this field should contain a three-position, alphanumeric local code for the transfer State. If present, this field is stored on the OCSE Case Master File.

  • If Transaction Type equals ‘A’, ‘B’, ‘C’, ‘D’, ‘L’, ‘M’, ‘S’, ‘Z’ or ‘R’, this field, if present, will not be updated at OCSE.

Process Year

80-83

4

A/N

Conditionally Required

  • If Transaction Type equals ‘S’, this field must be in CCYY format, and must contain the year that the tax refund or administrative payment was offset. The date must fall within the previous seven years of the current year.

  • If Transaction Type equals ‘A’, ‘B’, ‘C’, ‘D’, ‘L’, ‘M’, ‘R’, ‘Z’ or ‘T’, this field, if present, will not be updated at OCSE.

Obligor Address Line 1

84-113

30

A/N

Conditionally Required

  • If Transaction Type equals ‘A’ (Add Case) or ‘Z’ (Address Change), this field contains the first address line of the obligor’s mailing address. If this line is blank, the Obligor Address Line 2 Field will be checked for an address (refer to Section 2.1.5.3, “Address Processing”, for information).

  • If Transaction Type equals ‘Z’ (Address Change), Obligor Address Line 1 or Obligor Address Line 2 cannot both be all spaces.

  • If Transaction Type equals ‘A’ (Recertify Case), this field is not required. If present, the address that is currently stored at OCSE will be updated with the submitted address.

  • 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 Address Line 2

114-143

30

A/N

Optional

  • If Transaction Type equals ‘A’ (Add Case) or ‘Z’ (Address Change), this field may contain the second address line for the obligor (refer to Section 2.1.5.3, “Address Processing”, for information)

  • If Transaction Type equals ‘Z’ (Address Change), Obligor Address Line 1 or Obligor Address Line 2 cannot both be all spaces.

  • If Transaction Type equals ‘A’ (Recertify Case), this field is not required. If present, the address that is currently stored at OCSE will be updated with the submitted address.

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

  • If Transaction Type equals ‘A’ (Add Case) or ‘Z’ (Address Change), this field contains the city of the obligor’s mailing address (refer to Section 2.1.5.3, “Address Processing for Notices”, for information).

  • If Transaction Type equals ‘A’ (Recertify Case), this field is not required. If present, the address that is currently stored at OCSE will be updated with the submitted address.

  • If Transaction Type equals ‘Z’ (Address Change), Obligor City is required.

  • 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 State

169-170

2

A

Conditionally Required

  • If Transaction Type equals ‘A’ (Add Case) or ‘Z’ (Address Change), this field contains a two-character, alphabetic State abbreviation code for the State of the obligor’s mailing address (refer to Section 2.1.5.3, “Address Processing”, for information regarding address processing).

  • If Transaction Type equals ‘A’ (Recertify Case), this field is not required. If present, the address that is currently stored at OCSE will be updated with the submitted address.

  • If Transaction Type equals ‘Z’ (Address Change), Obligor State is required.

  • If Transaction Type equals ‘B’, ‘C’, ‘D’, ‘L’, ‘M’, ‘S’, ‘R’ and ‘T’, the address, if present, will not be updated at OCSE or FMS.

Obligor Zip Code

171-179

9

N

Conditionally Required

  • If Transaction Type equals ‘A’ (Add Case) or ‘Z’ (Address Change), this field contains a 5 or 9 digit zip code (refer to Section 2.1.5.3, “Address Processing”, for information regarding address processing).

  • If Transaction Type equals ‘A’ (Recertify Case), this field is not required. If present, the address that is currently stored at OCSE will be updated with the submitted address.

  • If Transaction Type equals ‘Z’ (Address Change), Obligor Zip Code is required.

  • 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.

Date Issued

180-187

8

A/N

Conditionally Required

  • If Transaction Type equals ‘A’ (Add/Recertify Case), and the State issues their own Pre-Offset Notices, this field is required. The date must be in CCYYMMDD format. This field indicates the date that the Pre-Offset Notice was mailed. If OCSE issues the Pre-Offset Notices, OCSE will fill in the date.

  • If Transaction Type equals ‘B’, ‘C’, ‘D’, ‘L’, ‘M’, ‘S’, ‘R’, ‘T’ and ‘Z’, the date issued, if present, will not be updated at OCSE or FMS.

Exclusion Indicator(s)

188-227

40

A

Optional

  • If Transaction Type equals ‘A’ (Add/Recertify Case) or ‘R’, this field is optional. If setting more than one exclusion indicator, the indicators must be separated with a comma or space (e.g., RET,PAS,FIN, or RET PAS FIN). Valid exclusion indicators are:

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

  • If Transaction Type equals ‘B’, ‘C’, ‘D’, ‘L’, ‘M’, ‘S’, ‘Z’ or ‘T’, this field, if present, will not be updated at OCSE or FMS.

Filler

228-244

17

A/N

Space filled.

Request Code

245

1

A/N

Optional

  • If Transaction Type equals ‘M’, this field should contain a ‘P’, to request that a Pre-Offset Notice be generated by OCSE. If present, this field will generate a PON if all of the edits are passed to update an arrearage amount and for processing a notice.

  • If Transaction Type equals ‘A’, ‘B’, ‘C’, ‘D’, ‘L’, ‘R’, ‘S’, ‘T’ or ‘Z’, no action will be taken at OCSE or FMS if this field contains a value.



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.

  • If the local code is equal to '000', the State contact information will be updated.

  • If the local code is other than '000' and the local code is found on the OCSE State/Local Contact Phone and Address File, the local contact information will be updated.

  • If the local code is other than '000' and the local code is not found on the OCSE State/Local Contact Phone and Address File, the local contact information will be added.

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-1

File Typeapplication/msword
AuthorKDonovan
Last Modified ByJean Shaw
File Modified2009-10-14
File Created2009-10-14

© 2024 OMB.report | Privacy Policy