Homepage
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.
You can download our CSV Template or Tab-Delimited Template to assist you in creating your files.
| Field | Type | Status | Comments |
|---|---|---|---|
| Employee SSN | Char | Required | Left justify |
| Employee Last Name | Char | Required | Left justify |
| Employee First Name | Char | Required | Left justify |
| Employee Middle Initial | Char | Optional | Space if unused |
| Employee Address Line 1 | Char | Required | Left justify |
| Employee Address Line 2 | Char | Optional | Left justify. Spaces if unused |
| Employee City | Char | Required | Left justify |
| Employee State | Char | Required | Required |
| Employee Zip Code | Numeric | Required | Required |
| Employee Zip+4 | Numeric | Optional | Must be 4-digits. Spaces if unknown |
| Employer Name | Char | Required | Left Justify |
| Employer Address Line 1 | Char | Required | Employer address. Left justify |
| Employer Address Line 2 | Char | Optional | Left justify if present. Spaces if unused. |
| Employer City | Char | Required | Left justify |
| Employer State | Char | Required | Required |
| Employer Zip Code | Numeric | Required | Required |
| Employer Zip+4 | Numeric | Optional | If present, must be 4-digits. Spaces if unknown |
| Employer FEIN | Numeric | Required | Federal Employer Identification Number. Must be 9 digits; include leading zeroes. |
| Employer State EIN | Numeric | Optional | State Employer Identification Number. Must be 7 digits; include leading zeroes. |
| Employee Date of Hire | Numeric | Required | CCYYMMDD. Must be a valid date. Employee's first day of work |
| Employee Date of Birth | Numeric | Optional | CCYYMMDD. Must be a valid date |
| Filler | Char | Optional | Spaces |