File Layouts - Wage Report
The following table outlines the column name, Iowa State field name, description, format, length, and the location from which the data is retrieved for the Wage report.
Column | Field Name | Description | Format | Length | Location in Application |
---|---|---|---|---|---|
A | Sequence Number | Maximum of four digits. It cannot contain leading zeros. The file is limited to 9,999 wage lines. | Text | 4 | N/A |
B | UI Account Number | Must be eight digits. Format to hold leading zeroes. Example: 00123456 | Text | 8 | iaqtrsetup.emp_account |
C | FEIN | Must be nine digits. Example: 42-1234567 | Text | 12 | iaqtrsetup.ein |
D | Year and Quarter | Must be five digits. Example: 20101 | Text | 5 | N/A |
E | Social Security Number* | Must be nine digits. Example: 123-45-6789 | Text | 9 | iaqtrwage.ssn |
F | Last Name | Maximum of 30 characters. | Text | 30 | iaqtrwage.l_name |
G | First Name | Maximum of 15 characters. | Text | 15 | iaqtrwage.f_name |
H | Middle Initial | Maximum of one character (Optional). | Text | 1 | iaqtrwage.mid_init |
I | Gross Wages | Maximum of 12 digits. Format with two decimal places. Example: 99999.99 | Text | 13 | iaqtrwage.tearn_q |
J | Reporting Unit Number | Maximum of four digits. Format to hold leading zeroes. Example: 0001 Note: Reporting unit numbers must match the reporting unit in My Iowa UI. | Text | 4 | iaqtrwage.emp_locn |