New Hire Report - Data Mapping
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 |