Home

File Submission Layout

This file layout has been created for employers who have the ability to export new hire data from their existing payroll or human resources software. If you have any questions, or need further assistance with reporting electronically after reviewing the File Transfer page, please Contact Minnesota New Hire Reporting Center.

Regardless of transmission method or media type, the following file submission layout must be used.

MN Employer File Submission Layout - Create file using FIXED-WIDTH ASCII TEXT FORMAT.

Field	Type	Length	Start Position	End Position	Status	Comments
Record Identifier	Char	17	1	17	Required	The following text: "MN Newhire Record". Case does not matter.
Format Version Number	Char	4	18	21	Required	The following text: "1.00".

Employee Information

Field	Type	Length	Start Position	End Position	Status	Comments
Employee First Name	Char	16	22	37	Required	At least one character, no special characters.
Employee Middle Name	Char	16	38	53	Optional	Blank Fill, If non-blank must be at least one character, no special characters.
Employee Last Name	Char	30	54	83	Required	At least one character, no special characters except hyphen.
Employee SSN#	Numeric	9	84	92	Required	As reported by employee.
Employee Address Line 1	Char	40	93	132	Required	At least two characters, left justify.
Employee Address Line 2	Char	40	133	172	Optional	Blank Fill, Employee address line 2.
Employee Address Line 3	Char	40	173	212	Optional	Blank Fill, Employee address line 3.
Employee City	Char	25	213	237	Required	At least two characters, no special characters except hyphen.
Employee State	Char	2	238	239	Required	Valid state or territory abbreviation. Not required for foreign address.
Employee Postal Code	Char	20	240	259	Required	If a non-foreign address then only U.S. 5 digit zip code, left justified. If foreign address then left justify.
Employee Zip+4	Numeric	4	260	263	Optional	US state and territories only. Blank fill if unknown or international address
Employee Country Code	Char	2	264	265	Optional	For foreign addresses only. Refer to U.S. Department of Commerce FIPS code manual, National Institute of Standards and Technology, FIPS PUB 10-4 (April 1995).
Employee Date of Birth	Numeric	8	266	273	Optional	If present, numeric. Format - MMDDYYYY.
Employee Date of Hire	Numeric	8	274	281	Required	Numeric. Format - MMDDYYYY.
Employee State of Hire	Char	2	282	283	Optional	Valid state or territory abbreviation. Field is required for registered Multistate employers.
Independent Contractor?	Char	1	284	284	Optional	"Y" if employee is an independent contractor. "N" if employee is not an independent contractor. Field is required for state agencies.
Filler	Char	1	285	285	Required	Blank Fill, Reserved for future use.

Employer Information

Field	Type	Length	Start Position	End Position	Status	Comments
Employer FEIN	Numeric	9	286	294	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.
Filler	Char	12	295	306	Optional	Blank Fill, Reserved for future use.
Employer Name	Char	45	307	351	Required	At least two characters, left justify.
Employer Address Line 1	Char	40	352	391	Required	At least two characters, left justify.
Employer Address Line 2	Char	40	392	431	Optional	Blank Fill, Employer address line 2.
Employer Address Line 3	Char	40	432	471	Optional	Blank Fill, Employer address line 3.
Employer City	Char	25	472	496	Required	At least two characters, left justify.
Employer State	Char	2	497	498	Required	Valid state or territory abbreviation. Not required for foreign address.
Employer Postal Code	Char	20	499	518	Required	If a non-foreign address then only U.S. 5 digit zip code, left justified. If foreign address then left justify.
Employer Zip+4	Char	4	519	522	Optional	If present, must be 4-digits. Spaces if unknown or international address.
Employer Country Code	Char	2	523	524	Optional	For foreign addresses only.
Employer Phone Number	Numeric	10	525	534	Optional	Employer contact ten-digit phone number including area code (no hyphens or parentheses).
Employer Phone Extension	Numeric	6	535	540	Optional	Employer contact extension (numeric only).
Employer Contact Name	Char	20	541	560	Optional	Name of contact for employer.
Employer Address Line 1	Char	40	561	600	Optional	Employer Address 1
Optional Employer Address Line 2	Char	40	601	640	Optional	Optional Employer Address Line 2
Optional Employer Address Line 3	Char	40	641	680	Optional	Optional Employer Address Line 3
Optional Employer City	Char	25	681	705	Optional	Employer Alternate City
Optional Employer State	Char	2	706	707	Optional	Employer Alternate State
Optional Employer Postal Code	Char	20	708	727	Optional	Employer Alternate Zip Code
Optional Employer Zip+4	Char	4	728	731	Optional	Employer Alternate Zip+4
Optional Employer Country Code	Char	2	732	733	Optional	For foreign addresses only.
Optional Employer Phone Number	Numeric	10	734	743	Optional	Employer Alternate Point of Contact ten-digit Phone Number
Optional Employer Phone Extension	Numeric	6	744	749	Optional	Employer Alternate Point of Contact Extension
Optional Employer Contact Name	Char	20	750	769	Optional	Employer Alternate Point of Contact Name
Filler	Char	32	770	801	Optional	Reserved for future use.