Quarterly Report
The following table outlines the Iowa field names, descriptions, and the location from which the data is retrieved for the quarterly report.
Field Name | Description | Location in Application |
---|---|---|
Worksite | Unique location identified within the state IU system. | Unique employee.base_loc |
Building Name | Building name | Regtb.building_name where location code is distinct employee.base_loc for applicable employees |
Employees | Employee count in which employment is the total number of full- and part-time employees who worked during or received wages for the pay period, including the 12th of the month. Include all employees who were subject to Unemployment Insurance laws. | Calculated |
Month1 | Employee count for the month in which employment is the total number of full- and part-time employees who worked during or received wages for the pay period, including the 12th of the month. Includes all employees who were subject to Unemployment Insurance laws. | Calculated – number of employees whose empuser.tcode1 field is ‘1’ |
Month2 | Same as Month1. | Calculated – number of employees whose empuser.tcode1 field is ‘1’ |
Month3 | Same as Month1. | Calculated – number of employees whose payroll.tearn_m > 0 |
Total Wages | Total wages for the quarter. The total wage for the quarter should match the total wages from the Quarterly Wage report. | Calculated from payroll.tearn_q |