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 |
|---|---|---|---|
| Worker's First Name | Char | Required | |
| Worker's Middle Initial | Char | Optional | |
| Worker's Last Name | Char | Required | |
| Worker's Address Line 1 | Char | Required | |
| Worker's Address Line 2 | Char | Optional | |
| Worker's City | Char | Required | |
| Worker's State | Char | Required | Valid 2 letter state code (e.g. MS) |
| Worker's Zip Code | Numeric | Required | |
| Worker's Zip +4 | Numeric | Required | |
| Worker's SSN | Numeric | Required | All zeroes will be rejected |
| Worker's Date of Hire | Numeric | Required | YYYYMMDD |
| Worker's Date of Birth | Numeric | Required | YYYYMMDD, if unknown 00000000 |
| Worker's Gender | Char | Required | M/F/U |
| Worker's Work State | Char | Required | Valid 2 letter state code (default to MS) |
| Employer's Name | Char | Required | |
| Employer Payroll Address Line 1 | Char | Required | |
| Employer's Payroll Address Line 2 | Char | Optional | |
| Employer's Payroll City | Char | Required | |
| Employer's Payroll State | Char | Required | Valid 2 letter state code (default to MS) |
| Employer's Payroll Zip Code | Numeric | Required | |
| Employer's Zip +4 | Numeric | Required | |
| Employer's Payroll Country Code | Char | Optional | |
| Employer's Federal EIN | Numeric | Required | |
| Employer's State EIN | Numeric | Required | If unknown, default to 0000000000 |
| Employee Salary | Numeric | Required | No decimal, last two digits for cents |
| Payment Frequency | Char | Required | Effective December 1, 2010 Use W (weekly), B (Bi-weekly), M (Monthly) and A (annual). If unavailable, default to a space or a blank |
| Employee eligible for an insurance benefit | Char | Required | Y/N |