Quarterly Wage - File Layout
The electronic file contains four record types.
The payer of income data for contractors is the same as employer data for employees.
‘A’ record – Employer Record
The following table outlines the column position, field name and description, length, and the location from which the data is retrieved for the Employer record.
Column Position | Field Name / Description | Length | Location |
---|---|---|---|
1-1 | Constant "A" | 1 | N/A |
2-33 | Employer name | 32 | hrm_prof.emp_name[1,32] |
34-65 | Employer address-1 | 32 | hrm_prof.emp_add[1,32] |
66-97 | Employer address-2 | 32 | N/A |
98-113 | Employer city | 16 | hrm_prof.emp_city[1,16] |
114-115 | Employer state | 2 | hrm_prof.emp_state |
116-120 | Employer zip code | 5 | hrm_prof.emp_zip[1,5] |
121-124 | Employer zip extension, if known; otherwise, constant "0000" | 4 | hrm_prof.emp_zip[7,10] |
125-136 | Employer federal ID (FEIN) with 3-digit Iowa suffix | 12 | wrkmain.eid[1,2], wrkmain.eid[4,10], hrmstate.state7[1,3] |
137-168 | Blank filler | 32 | N/A |
169-200 | Blank filler | 32 | N/A |
201-216 | Blank filler | 16 | N/A |
217-218 | Blank filler | 2 | N/A |
219-223 | Blank filler | 5 | N/A |
224-227 | Blank filler | 4 | N/A |
228-237 | Employer telephone number, including area code, without hyphens | 10 | wrkmain.phone[1,3], wrkmain.phone[5,7], wrkmain.phone[9,12] |
238-250 | Blank filler | 13 | N/A |
‘B’ record – Employee Record
The following table outlines the column position, field name and description, length, and the location from which the data is retrieved for the Employee record.
Column Position | Field Name / Description | Length | Location |
---|---|---|---|
1-1 | Constant "B" | 1 | N/A |
2-17 | Employee last name | 16 | First 16 chars of employee.l_name, r_employee.name_suffix |
18-32 | Employee first name | 15 | First 15 chars of employee.f_name |
33-47 | Employee middle name | 15 | First 15 chars of employee.m_name |
48-55 | Employee date of birth | 8 | employee.birthdate |
56-64 | Employee social security number, without hyphens | 9 | employee.ssn[1,3], employee.ssn[5,6], employee.ssn[8,11] |
65-96 | Employee address-1 | 32 | employee.addr1 |
97-128 | Employee address-2 | 32 | employee.addr2 |
129-144 | Employee city | 16 | employee.city[1,16] |
145-146 | Employee state | 2 | employee.state_id |
147-151 | Employee zip code | 5 | employee.zip[1,5] |
152-155 | Employee zip extension, if known; otherwise, constant "0000" | 4 | employee.zip[7,10] |
156-156 | Dependent health insurance available? Valid values:
| 1 | empuser.ftext4[1,1] where page_no = ‘32000’ |
157-164 | Approximate date employee qualifies for family health insurance | 8 | empuser.ftext5_date where page_no = ‘32000’ |
165-172 | Employee start date (hire date) | 8 | employee.hire_date |
173-250 | Blank filler | 78 | N/A |
‘C’ record – Payer of Income Data Record
The following table outlines the column position, field name and description, length, and the location from which the data is retrieved for the Payer of Income Data record.
Column Position | Field Name / Description | Length | Location |
---|---|---|---|
1-1 | Constant "C" | 1 | N/A |
2-11 | Payer of income telephone number, including area code, without hyphens | 10 | wrkmain.phone[1,3], wrkmain.phone[5,7], wrkmain.phone[9,12] |
12-23 | Payer of income federal ID (FEIN) with 3-digit Iowa suffix | 12 | wrkmain.eid[1,2], wrkmain.eid[4,10], hrmstate.state7[1,3] |
24-55 | Payer of income name | 32 | hrm_prof.emp_name[1,32] |
56-87 | Payer of income address-1 | 32 | hrm_prof.emp_add[1,32] |
88-119 | Payer of income address-2 | 32 | N/A |
120-135 | Payer of income city | 16 | hrm_prof.emp_city[1,16] |
136-137 | Payer of income state | 2 | hrm_prof.emp_state |
138-142 | Payer of income zip code | 5 | hrm_prof.emp_zip[1,5] |
143-146 | Payer of income zip extension, if known; otherwise, constant "0000" | 4 | hrm_prof.emp_zip[7,10] |
147-250 | Blank filler | 104 | N/A |
‘D’ record – Contractor Data Record
The following table outlines the column position, field name and description, length, and the location from which the data is retrieved for the Contractor Data record.
Column Position | Field Name / Description | Length | Location |
---|---|---|---|
1-1 | Constant "D" | 1 | N/A |
2-17 | Contractor last name | 16 | vnduser.ftext3[1,16] where page_no = 10 |
18-32 | Contractor first name | 15 | vnduser.ftext4[1,15] where page_no = 10 |
33-47 | Contractor middle name | 15 | vnduser.ftext5[1,15] where page_no = 10 |
48-55 | Contractor date of birth | 8 | vnduser.ftext6_date where page_no = 10 |
56-64 | Contractor social security number, without hyphens | 9 | vnduser.ftext2[1,9] where page_no = 10 |
65-96 | Contractor address-1 | 32 | vendor.p_addr_1[1,32] |
97-128 | Contractor address-2 | 32 | vendor.p_addr_2[1,32] |
129-144 | Contractor city | 16 | p_city[1,16] |
145-146 | Contractor state | 2 | vendor.p_state |
147-151 | Contractor zip code | 5 | vendor.p_zip[1,5] |
152-155 | Contractor zip extension, if known; otherwise, constant "0000" | 4 | vendor.p_zip[7,10] |
156-163 | Date service contracted (the first day the contractor is owed payment) | 8 | vnduser_ftext7_date where page_no = 10 |
164-250 | Blank filler | 87 | N/A |