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
Record Identifier	Alphanumeric	Required	This must contain the characters 'HR'.
Format Version Number	Alpha	Required	The following text: "1.00".
Employee First Name	Alpha	Required	Left justify
Employee Middle Name	Alpha	Optional	Left justify. Space if unknown
Employee Last Name	Alpha	Required	Left justify
Employee SSN #	Numeric	Required	Must be 9 digits
Employee Address Line 1	Alphanumeric	Required	Left justify
Employee Address Line 2	Alphanumeric	Optional	Left justify. Spaces if unused
Employee Address Line 3	Alphanumeric	Optional	Left justify. Spaces if unused
Employee City	Alpha	Required	Left justify
Employee State	Alpha	Required	Required if domestic address. Spaces if international address
Employee Zip Code	Numeric	Required	Required if domestic address. Spaces if international address
Employee Date of Birth	Numeric	Optional	MMDDYYYY. Must be a valid date
Employee Date of Hire	Numeric	Required	MMDDYYYY. Must be a valid date. Employee's first day of work
Employee State of Hire	Alpha	Optional	Standard postal abbreviation
Employee Independent Contractor (IC)	Alpha	Optional	"Y" if independent contractor. "N" if not a contractor.
Dependent Health Insurance Available	Alpha	Optional	"Y" if dependent health insurance available, "N" if not available
Date Employee Qualifies for Family Health Insurance	Alpha	Optional	This date must be submitted in the format of: MMDDYYYY.
Filler	Alpha	Optional	Blank fill. Reserved for future use.
Employer FEIN	Alphanumeric	Required	Federal Employer Identification Number. Must be 9 digits; include leading zeroes.
Filler	Alpha	Optional	Spaces
Employer Name	Alphanumeric	Required	Left Justify
Employer Address Line 1	Alphanumeric	Required	Employer address. Left justify
Employer Address Line 2	Alphanumeric	Optional	Left justify if present. Spaces if unused.
Employer Address Line 3	Alphanumeric	Optional	Left justify if present. Spaces if unused.
Employer City	Alpha	Required	Left justify
Employer State	Alpha	Required	Required if domestic address. Spaces if international address
Employer Zip Code	Numeric	Required	This must contain a 5-digit or 9-digit number. No dashes.
Employer Contact Name	Alpha	Optional
Phone Number of Contact Person	Numeric	Optional	Must be in a format with area code first then number. This field must have numbers only. (no hyphens or parentheses).
Filler	Char	Optional	Spaces

Delimited File Format Instructions

Quick Links