New Hire Report - Data Mapping | PowerSchool ERP Compliance

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