Skip to Main Content

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 First Name Char Required At least one character, no special characters.
Employee Middle Initial Char Optional
Employee Last Name Char Required At least one character, no special characters except hyphen.
Employee Address Line 1 Char Required At least two characters, left justify.
Employee Address Line 2 Char Optional
Employee City Char Required At least two characters, no special characters except hyphen.
Employee State Char Required Valid 2 letter FIPS abbr. (e.g. TN)
Employee Zip Numeric Required All zeros will be rejected
Employee Zip+4 Numeric Optional
Employee Social Security Number or ITIN Numeric Required No hyphens
Employer Name Char Required At least two characters, left justify.
Employer Address Line 1 Char Required At least two characters, left justify.
Employer Address Line 2 Char Optional
Employer City Char Required At least two characters, left justify.
Employer State Char Required Valid 2 letter FIPS abbr. (e.g. TN)
Employer Zip Numeric Required All zeros will be rejected
Employer Zip+4 Char Optional
Employer FEIN Numeric Required Federal Employer Identification Number (no hyphens). Use the same FEIN for which listed employee(s) quarterly wages will be reported under. If you have questions, please contact our center.
Employer Payroll Address Line 1 Char Optional Address where employee’s check is processed
Employer Payroll Address Line 2 Char Optional
Employer Payroll City Char Optional
Employer Payroll State Char Optional
Employer Payroll Zip Numeric Optional
Employee Date of Hire Numeric Required Format - CCYYMMDD
Left Your Employment During Period Char Optional Y=Yes, N=No
Employee Date of Birth Numeric Optional Format - CCYYMMDD
Employee Gender Char Optional
Employee Work State Char Optional Valid 2 letter FIPS abbr. (e.g. TN)
Earned Income Tax Credit Indicator Char Optional Y=Yes, N=No
Is Medical Insurance Available to Employee? Char Optional Y=Yes, N=No
Outlet or Store Number Char Optional

Contact Information

Tennessee New Hire Reporting Program
P.O. Box 438
Norwell, MA 02061
Phone: (888) 715-2280
Fax: (877) 505-4761