The following table outlines the Iowa field names, descriptions, and the location from which the data is retrieved for the monthly 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 |
|
All 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 |
|
Male Employees |
The number of male employees |
Calculated |
|
Female Employees |
The number of female employees |
Calculated |
|
Faculty |
The number of employees designated as faculty. |
Calculated from the number of employees whose empuser 32000 screen, ftext2 ‘Faculty’ field = ‘Y’. |
|
Male Wages |
Total wages for male employees for the month |
Calculated from payroll.tearn_m for male employees |
|
Female Wages |
Total wages for female employees for the month |
Calculated from payroll.tearn_m for female employees |
|
Total Wages |
Total wages for the month |
Calculated from payroll.tearn_m |