The following tables outline the Iowa field names, descriptions, and the location from which the data is retrieved.
Employee Section - Page Header Information
The page header information for the employee section of the report includes the following:
|
Field Name Field Name |
Description |
Location in Application |
|---|---|---|
|
FEIN |
Federal Employee ID |
wrkmain.eid |
|
IOWA suffix |
IOWA suffix to FEIN |
hrmstate.state7[1,3 |
|
Employer name |
Employer's name |
hrm_prof.emp_name[1,32] |
|
Employer address (two lines) |
Employer's address |
hrm_prof.emp_add[1,32], hrm_prof.emp_city[1,16], r_hrm_prof.emp_state, " ", r_hrm_prof.emp_zip[1,5] |
|
Employer telephone |
Employer's telephone number |
wrkmain.phone |
Employee Section
Each row of the employee section of the report includes the following:
|
Field Name |
Description |
Location in Application |
|---|---|---|
|
Social Security Number |
Employee’s social security number, including the dashes |
employee.ssn
|
|
Employee number |
Employee’s employee number |
employee.empl_no |
|
Employee Last Name |
Employee’s last name. Cannot be left blank. |
employee.l_name, “ “, employee.name_suffix |
|
Employee First Name |
Employee’s first name. Cannot be left blank. |
employee.f_name |
|
Employee middle name |
Employee middle initial. It may be left blank if the employee does not have a middle initial. |
employee.m_name[1] |
|
Employee Address |
Employee's address |
employee.addr1 |
|
Employee Address 2 |
Employee's address second line |
employee.addr2 |
|
Employee City |
Employee's city |
employee.city[1,16] |
|
Employee State |
Employee's state |
employee.state_id |
|
Employee Zip |
Employee's zip code |
employee.zip[1,5] (or [1,10] if available) |
Contractor Section
Each row in the contractor section of the report includes the following:
|
Field Name |
Description |
Location in Application |
|---|---|---|
|
Social Security Number |
Vendor’s social security number, including the dashes |
vnduser.ftext2[1,9] where page_no = 10 |
|
Vendor number |
Vendor number |
vendor.vend_no |
|
Vendor Last Name |
Vendor’s last name. Cannot be left blank. |
vnduser.ftext3[1,16] where page_no = 10 |
|
Vendor First Name |
Vendor’s first name. Cannot be left blank. |
r_ia_vnduser.ftext4[1,15] r_ia_vnduser.ftext5[1,15] where page_no = 10 |
|
Vendor Address |
Vendor's address |
vendor.p_addr_1[1,32] |
|
Vendor Address 2 |
Vendor's address second line |
vendor.p_addr_1[1,32] |
|
Vendor City |
Vendor's city |
vendor.p_city[1,16] |
|
Vendor State |
Vendor's state |
vendor.p_state |
|
Vendor Zip |
Vendor's zip code |
vendor.p_zip[1,5] or [1,10] if available |