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