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 |