File Layouts - Wage Report

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