Quarterly Unemployment Report - File Layout and Data Mapping
The default file name for the Quarterly Unemployment report is UI<Reporting Year><Reporting Quarter><MDE District Number>.txt.
The following table shows the positions, field names, descriptions, and data source or valid values for the Quarterly Unemployment report.
Position | Field Name | Description | Data Source or Valid Values |
|---|---|---|---|
1-8 | Employer Account Number | The Unemployment Insurance (UI) account number assigned to the employer by the state. | For employees eligible for unemployment insurance, the value is retrieved from the UI Employer Account Number - Non-Exempt field on the Human Resources Profile - State page. For employees exempted from unemployment insurance, the value is retrieved from the UI Employer Account Number - Exempt field on the Human Resources Profile - State page. |
9-12 | Employer Unit Location Number | The number assigned by the state to distinguish between records with the same UI account number. | Retrieved from the UI Employer Unit Location Number field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. |
13-17 | Reporting Period | The four-digit calendar year followed by the single-digit quarter. | Retrieved from the Reporting Year and Reporting Quarter fields on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. |
18 | Month 1 Employment | Indicates whether the employee worked during or received pay for the pay period including the 12th day of the 1st month of the reporting period. | Retrieved from the Paid in Month 1 field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. Valid values:
|
19 | Month 2 Employment | Indicates whether the employee worked during or received pay for the pay period including the 12th day of the 2nd month of the reporting period. | Retrieved from the Paid in Month 2 field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. Valid values:
|
20 | Month 3 Employment | Indicates whether the employee worked during or received pay for the pay period including the 12th day of the 1st month of the reporting period. | Retrieved from the Paid in Month 3 field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. Valid values:
|
21-29 | Employee Social Security Number | The employee’s Social Security number. | Retrieved from the Social Security Number field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. |
30-49 | Employee Last Name | The employee’s last name. | Retrieved from the Last Name field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. |
50-64 | Employee First Name | The employee’s first name. | Retrieved from the First Name field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. |
65 | Employee Middle Initial | The employee’s middle initial. | Retrieved from the Middle Initial field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. |
66-79 | Employee Total Quarterly Wages | The total wages paid to the employee during the quarter. | Retrieved from the Total Quarterly Wages field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. |
80-81 | Blank | Not applicable | Not applicable |
82-84 | Hours Worked | The employee's total work hours in the quarter. | Retrieved from the Hours Worked field on the MN Quarterly Unemployment Table Information form of the MN Quarterly Unemployment Report page. |
85 | Officer Code | Indicates whether the employee is an officer. | Valid values:
|
86-99 | Blank | Not applicable | Not applicable |
100 | End of record indicator | Indicates the end of the record. | The valid value is X. |