Delimited File Format Instructions
Files can be submitted in either Tab or Comma Delimited format. Tab or Comma Delimited files must include all of the following fields, in the order listed.
Each field may be enclosed by double-quotes. Each record line of the file should represent one record and all fields Left Justified.
You can download our CSV Template or Tab-Delimited Template to assist you in creating your files.
| Field | Type | Status | Comments |
|---|---|---|---|
| Employee First Name | Alpha | Required | At Least 1 Char, No Special Chars. |
| Employee Middle Name | Alpha | Optional | If Non-Blank, at least 1 Char, No Special Chars |
| Employee Last Name | Alpha | Required | At Least 1 Char, No Special Chars. |
| Employee Suffix | Alphanumeric | Optional | |
| Employee SSN # | Numeric | Required | As Reported by Employee, Must Be 9 Digits |
| Employee Address 1 | Alphanumeric | Required | |
| Employee Address 2 | Alphanumeric | Optional | |
| Employee Address 3 | Alphanumeric | Optional | |
| Employee Address City | Alpha | Required | At Least 2 Char, No Special Chars. |
| Employee Address State | Alpha | Required | Valid State or Territory Abbreviation |
| Employee Address Zip 1 | Numeric | Required | Required if Domestic Address. Spaces If International Address |
| Employee Address Zip Ext | Alphanumeric | Optional | |
| Employee Country Code | Alphanumeric | Optional | Required If Foreign Address, Refer to U.S. Department of Commerce FIPS Code Manual, National Institute of Standards and Technology, FIPS Pub 10-4 (April 1995) |
| Employee Country Name | Alphanumeric | Optional | If Present, at least 2 Chars. |
| Employee Country Zip | Alphanumeric | Optional | |
| Employee Marital Status | Alpha | Optional | M=Married, S=Single |
| Employee Hire Date | Numeric | Required | |
| Employer Name | Alphanumeric | Required | At Least Two Characters |
| Employer Address 1 | Alphanumeric | Required | Employer Address From W-4 |
| Employer Address 2 | Alphanumeric | Optional | |
| Employer Address 3 | Alphanumeric | Optional | |
| Employer Address City | Alpha | Required | At Least 2 Char, No Special Chars. |
| Employer Address State | Alpha | Required | Valid State or Territory Abbreviation |
| Employer Address Zip 1 | Numeric | Required | Must Be Numeric |
| Employer Address Zip Ext | Numeric | Optional | |
| Employer Foreign Country Code | Alphanumeric | Optional | Required If Foreign Address, Refer to U.S. Department of Commerce FIPS Code Manual, National Institute of Standards and Technology, FIPS Pub 10-4 (April 1995) |
| Employer Country Name | Alphanumeric | Optional | If Present At Least 2 Chars |
| Employer Country Zip | Alphanumeric | Optional | |
| Federal Ein | Numeric | Required | Federal Employer Identification Number |
| State Ein | Numeric | Optional | State Ein and Left Justify |
| Employee Occupation | Alphanumeric | Optional | Job Title, No Special Characters |
| Employee Salary | Numeric | Optional | Gross Amount Paid Per Employee Salary Frequency, Last 2 Positions Are Decimal Places, Zeroes Are Allowed. |
| Employee Salary Frequency | Alpha | Optional | AN=Annual. BI=Biweekly. BM=Bimonthly. OT=One Time. QT=Quarterly, SA=Semi-Annual. SM=Semi-Monthly. WK=Weekly |
| Employee Hire State | Alpha | Optional | Valid State or Territory Abbreviation in Which Employee is hired to Work |
| Employee Birth Date | Numeric | Optional | If Not Present Zero Fill. |
| Employee Insurance | Alpha | Optional | Y=Yes, the Employee and/or Family Has Purchased Insurance Through Employer. N=No, the Employee and/or Family Has Not Purchased Insurance Through Employer |
| Employer Service Address 1 | Alphanumeric | Optional | This is the Employer Address to which the Income Assignment should be sent, if different from the Employer Address 1 field. |
| Service Address 2 | Alphanumeric | Optional | |
| Service Address 3 | Alphanumeric | Optional | |
| Service Address City | Alpha | Optional | At Least 2 Char, No Special Chars. |
| Service Address State | Alpha | Optional | Valid State or Territory Abbreviation |
| Service Address Zip 1 | Numeric | Optional | Must Be Numeric |
| Service Address Zip Ext | Numeric | Optional | |
| Service Foreign Country Code | Alphanumeric | Optional | Required If Foreign Address, Refer to U.S. Department of Commerce FIPS Code Manual, National Institute of Standards and Technology, FIPS Pub 10-4 (April 1995) |
| Service Country Name | Alpha | Optional | If Present At Least 2 Chars |
| Service Country Zip | Numeric | Optional | |
| Employer Contact First Name | Alpha | Optional | Name of Contact who will administer income assignment. |
| Employer Contact Last Name | Alpha | Optional | Name Of Contact Who Will Administer Income Assignment. |
| Employer Contact Phone Num | Numeric | Optional | Include Area Code, No Hyphens, Phone Number of Employer Contact. |
| Filler | Alphanumeric | Required | Spaces To Be Used for Future Versions. |