New Hire Report - Data Mapping

The following tables outline the Michigan field names, descriptions, format, length, position, and the location from which the data is retrieved.

Field Name	Description	Format	Length	Position	Required/Optional	Location
Employee SSN#	Social security number of the employee Zeroes are rejected	Numeric	9	1-9	Required	employee.ssn (without dashes)
Employee First Name	The first name of the employee	Character	16	10-25	Required	employee.f_name
Employee Middle Initial	The middle initial of the employee Leave blank if unknown	Character	1	26-26	Optional	employee.m_name
Employee Last Name	The last name of the employee	Character	20	27-46	Required	Concatenation of employee.l_name and employee.name_suffix
Employer Name	Name of the employer	Character	40	47-86	Required	wrkmain.ename
Employer FEIN	Federal employer identification number Zeroes are rejected	Numeric	9	87-95	Required	wrkmain.eid without the dash
Employer Address Line 1	Address line 1 of the employer	Character	35	96-130	Required	wrkmain.addr1
Employer Address Line 2	Address line 2 of the employer	Character	35	131-165	Optional	wrkmain.addr2
Employer City	City of the employer	Character	25	166-190	Required	wrkmain.city
Employer State	State of the employer	Character	2	191-192	Required	wrkmain.state_id
Employer Zip Code	Zip code of the employer Zeroes are rejected	Numeric	5	193-197	Required	wrkmain.zip
Employer Zip+4	Zip+4 of the employer Zeroes are rejected	Numeric	4	198-201	Optional	wrkmain.zipext without the dash
Employee Address Line 1	Address line 1 of the employee	Character	35	202-236	Required	employee.addr1
Employee Address Line 2	Address line 2 of the employee	Character	35	237-271	Optional	employee.addr2
Employee City	City of the employee	Character	25	272-296	Required	employee.city
Employee State	State of the employee Must be a valid two-letter state code	Character	2	297-298	Required	employee.state_id
Employee Zip Code	Zip code of the employee Zeroes are rejected Leave blank if unknown	Numeric	5	299-303	Required	employee.zip (first five digits)
Employee Zip+4	Zip+4 of the employee Zeroes are rejected Leave blank if unknown	Numeric	4	304-307	Optional	employee.zip (last four digits)
Filler	Filler Must be 2 Spaces	Character	2	308-309	Required	Not Applicable
Employee’s Date of Birth	Birthdate of the employee Format: MMDDYYYY	Numeric	8	310-317	Optional	employee.birthdate USING “MMDDYYYY”
Employee’s Date of Hire	Hire date of the employee Format: MMDDYYYY	Numeric	8	318-325	Required	employee.hire_date USING “MMDDYYYY”
Employee’s Driver License Number	The driver license number of the employee	Character	16	326-341	Optional	Not Applicable