MiUI Format - File Layout and Data Mapping - Employee Detail (S) Record
The following table lists the field names, descriptions, positions, lengths, formats, and data sources or valid values for the MiUI Format report’s Employee Detail (S) record.
Field Name | Description | Position | Length | Data Source or Valid Values |
|---|---|---|---|---|
Record Identifier | Identifies the record type. | 1-1 | 1 | The valid value is S. |
Social Security Number | The employee's Social Security number. | 2-10 | 9 | Retrieved from the Social Security Number field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Employee Last Name | The employee's last name. | 11-30 | 20 | Retrieved from the Last Name field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Employee First Name | The employee’s first name. | 31-42 | 12 | Retrieved from the First Name field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Employee Middle Initial | The employee's middle initial. | 43-43 | 1 | Retrieved from the Middle Name field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Michigan FIPS Code | The Michigan FIPS code. | 44-45 | 2 | The valid value is 26 and is hardcoded. |
Adjustment Code | The reason for any adjustments, corrections, or changes made to an employee's previously reported quarterly wage data. | 46-47 | 2 | Valid values:
Retrieved from the Adjustment Code field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Filler | Fill with spaces | 48-49 | 2 | spaces |
Total UI Gross Wages | The total gross wages paid to the employee during the quarter. | 50-63 | 14 | Calculated during the data load process based on the Type of Gross Wages, Excess Wages Limit, and Add in Group Life Benefit field values on the MI Quarterly Unemployment Report - Load page. |
Total State Quarterly Wages Subject to Unemployment Tax | MI UIA does not use this field. | 64-77 | 14 | Not applicable |
Quarterly Wages in Excess of the State UI Taxable Wage Base | MI UIA does not use this field. | 78-91 | 14 | Not applicable |
State Quarterly UI Total Wages Less State Quarterly Excess Wages | MI UIA does not use this field. | 92-105 | 14 | Not applicable |
Quarterly State Disability Insurance Taxable Wages | MI UIA does not use this field. | 106-120 | 15 | Not applicable |
Quarterly Tip Wages | MI UIA does not use this field. | 121-129 | 9 | Not applicable |
Number of Weeks Worked | MI UIA does not use this field. | 130-131 | 2 | Not applicable |
Number of Hours Worked | MI UIA does not use this field. | 132-134 | 3 | Not applicable |
Filler | Fill with spaces | 135-142 | 8 | spaces |
Taxing Entity Code | MI UIA does not use this field. | 143-146 | 4 | Not applicable |
Michigan Unemployment Insurance Employer Account Number (EAN) | Your Michigan Unemployment Insurance Agency (UIA) account number assigned by the state. | 147-153 | 7 | Retrieved from the Employer Account Number field on the MI Quarterly Wage Report - Setup - Employer page. |
Filler | Fill with spaces | 154-160 | 7 | spaces |
Unit Number | The worksite or unit location identifier for the employee. | 161-163 | 3 | Retrieved from the Unit Number field on the Employee Information form of the MI Quarterly Unemployment Report page (derived from the Unit Number Location setting on the MI Quarterly Wage Report - Setup - Employer page). |
Filler | Fill with spaces | 164-176 | 13 | spaces |
State Taxable Wages | MI UIA does not use this field. | 177-190 | 14 | Not applicable |
State Income Withheld | MI UIA does not use this field. | 191-204 | 14 | Not applicable |
Seasonal Indicator | Indicates whether the employee is a seasonal worker. | 205-205 | 1 | Valid values:
Retrieved from the Seasonal Employment field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Filler | Fill with spaces | 206-206 | 1 | spaces |
Employer Health Insurance Code | MI UIA does not use this field. | 207-207 | 1 | Not applicable |
Employee Health Insurance Code | MI UIA does not use this field. | 208-208 | 1 | Not applicable |
Probationary Code | MI UIA does not use this field. | 209-209 | 1 | Not applicable |
Officer Code | Indicates whether the employee is a corporate officer or executive. | 210-210 | 1 | Valid values:
Retrieved from the Officer field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Wage Plan Code | MI UIA does not use this field. | 211-211 | 1 | Not applicable |
Employment Data (Month 1) | Indicates whether the employee was paid in the pay run containing the 12th of the first month of the quarter. | 212-212 | 1 | Calculated during the data load process based on the Pay Run(s) For 1st Month selection from the MI Quarterly Unemployment Report - Load page. |
Employment Data (Month 2) | Indicates whether the employee was paid in the pay run containing the 12th of the second month of the quarter. | 213-213 | 1 | Calculated during the data load process based on the Pay Run(s) For 2nd Month selection from the MI Quarterly Unemployment Report - Load page. |
Employment Data (Month 3) | Indicates whether the employee was paid in the pay run containing the 12th of the third month of the quarter. | 214-214 | 1 | Calculated during the data load process based on the Pay Run(s) For 3rd Month selection from the MI Quarterly Unemployment Report - Load page. |
Reporting Period | The quarter and year of the report data. | 215-220 | 6 | Calculated from the Reporting Quarter and Reporting Year fields on the MI Quarterly Unemployment Report - Load page (formatted as quarter + year). |
Month and Year First Employed | MI UIA does not use this field. | 221-226 | 6 | Not applicable |
Month and Year of Separation | MI UIA does not use this field. | 227-232 | 6 | Not applicable |
Out of State Wages | The amount of wages earned for work performed outside of Michigan. | 233-243 | 11 | Retrieved from the Out of State Wages field on the Employee Information form of the MI Quarterly Unemployment Report page. |
State Code Where Out of State Wages Were Earned | The state code for the location where out-of-state work was performed. | 244-245 | 2 | Retrieved from the Out of State Code field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Obligation Gross Wages | The wages subject to specific obligation or garnishment reporting. | 246-259 | 14 | Retrieved from the Obligation Gross Wages field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Visa Wage Indicator | The wages paid to employees working under a visa (non-citizen workers). | 260-260 | 1 | Valid values:
Retrieved from the Visa Wage field on the Employee Information form of the MI Quarterly Unemployment Report page. |
Filler | Fill with spaces | 261-274 | 14 | spaces |