IPERS Monthly Retirement Report - File Layouts
Unless specified, all fields in the Description column are required fields. When submitting a field with no information, use blank spaces.
Ensure all text is in the proper case.
The Name and Address fields allow special characters. For example, you may use hyphens in hyphenated names and apostrophes in names such as O'Leary.
All numeric fields are right-justified and zero-filled.
All alpha and alphanumeric fields are left-justified and space-filled.
Header Record
Each report has one header record.
The following table outlines the column name, start, end, length, data type, description, and the location from which the data is retrieved for the Header record.
Column Name | Start | End | Length | Data Type | Description | Location in Application |
|---|---|---|---|---|---|---|
Record Type | 1 | 1 | 1 | Numeric/9 | Indicates the start. Valid value: 1 | NA |
Employer ID | 2 | 6 | 5 | Numeric/99999 | The five-digit employer ID assigned to the employer by IPERS. | hrmstate.state2 |
Wage Report Month | 7 | 12 | 6 | Numeric/YYYYMM | The four-digit year and two-digit month of the reporting period. | NA |
Total Reported Wages | 13 | 23 | 11 | Numeric/999999999V99 (V indicates implied decimal) | Total of all wages in detail records reported below on this report. Record format does not include periods, commas, or dollar signs. | NA |
Filler | 24 | 400 | 377 | Fill with spaces. | Possible future use. | NA |
Detail Record
Each report may have multiple detail records.
The following table outlines the column name, start, end, length, data type, description, and the location from which the data is retrieved for the Detail record.
Column Name | Start | End | Length | Data Type | Description | Location in Application |
|---|---|---|---|---|---|---|
Record Type | 1 | 1 | 1 | Numeric/9 | Indicates the start. Valid value: 1 | NA |
Employer ID | 2 | 6 | 5 | Numeric/99999 | The five-digit employer ID assigned to the employer by IPERS. | Hrmstate.state2 |
State Agency Code | 7 | 11 | 5 | Numeric/99999 (Blank for all employers except for the State of Iowa or Centralized Payroll.) | The five-digit employer ID assigned to state agencies. Required only for the State of Iowa or Centralized Payroll. All other employers should use blank spaces. | NA |
Occupation Code | 12 | 13 | 2 | Numeric/99 | The two-digit occupation code related to each member’s employment type and corresponding contribution rate. Members may not have multiple Detail Records with the same occupation code on the same report but may have multiple Detail Records with different occupation codes. Employers are limited to using occupation codes associated with their employer type. For example, all schools, community colleges, AEAs, and universities should be reporting all of their employees under Occupation Code 11. If you have questions about which occupation codes employees should be reported under, contact a member of IPERS’ Employer Relations Bureau. Valid values:
| iarettab.occ_cls |
SSN | 14 | 22 | 9 | Numeric/999999999 | Member social security number | iarettab.ssn |
Last Name | 23 | 72 | 50 | Alpha | Member last name | iarettab.l_name |
First Name | 73 | 122 | 50 | Alpha | Member first name | iarettab.f_name |
Middle Initial | 123 | 123 | 1 | Alpha | Member middle initial. It may also be blank (not required). | iarettab.l_name |
Street Address | 124 | 173 | 50 | Alphanumeric | Member street address | iarettab.addr1 |
Address - Qualifier | 174 | 223 | 50 | Alphanumeric | Secondary address line. It may also be blank (not required). | iarettab.addr2 |
City | 224 | 273 | 50 | Alpha | City name. Must correspond with state and zip code fields. | iarettab.city |
State | 274 | 275 | 2 | Alpha | State name. Must correspond with city and zip code fields. | iarettab.state_id |
Zip – 5 | 276 | 280 | 5 | Numeric | The five-digit zip code. Must correspond with city and state fields. | iarettab.zip |
Zip – 4 | 281 | 284 | 4 | Numeric (or blank) | The four-digit zip code suffix. It may also be blank (not required). | iarettab.zip |
Date of Birth | 285 | 292 | 8 | Numeric/YYYYMMDD | Member date of birth. | iarettab.dob |
Gender | 293 | 293 | 1 | Alpha | Valid values:
| iarettab.gender |
First Date of Employment | 294 | 301 | 8 | Numeric/YYYYMMDD | First date of employment with this employer. Optional field for existing (before I-Que) employment record. This is a required field for new employment records. If the member terminates and later returns to employment, a new employment date is required. | iarettab.hire_date |
Termination Date | 302 | 309 | 8 | Numeric/YYYYMMDD (or blank) | Member termination date. A valid date is required for employees who have terminated employment. This field should be blank if the member is an active employee. | iarettab.term_date |
Last Check Date | 310 | 317 | 8 | Numeric/YYYYMMDD (or blank) | Date of last IPERS-covered check for terminated employees. A valid date is required for employees who have terminated employment. This field should be blank if the member is an active employee. | iarettab.last_chk_dt |
Period Wages | 318 | 325 | 8 | Numeric/999999V99 (V indicates implied decimal) | Total covered wages for this occupation code and member for this reporting period. Record format does not include periods, commas, or dollar signs. Lead with zeros if the dollar amount does not require all available spaces. Example: $12,345.67 should be 01234567 | iarettab.wages |
Filler | 326 | 400 | 75 | Fill with spaces. | Possible future use | NA |
Trailer Record
Each report has one trailer record.
The following table outlines the column name, start, end, length, data type, description, and the location from which the data is retrieved for the Trailer record.
Column Name | Start | End | Length | Data Type | Description | Location in Application |
|---|---|---|---|---|---|---|
Record Type | 1 | 1 | 1 | Numeric/9 | Indicates the start. Valid value: 1 | NA |
Employer ID | 2 | 6 | 5 | Numeric/99999 | The five-digit employer ID assigned to the employer by IPERS. | hrmstate.state2 |
Wage Report Month | 7 | 12 | 6 | Numeric/YYYYMM | The four-digit year and 2-digit month of the reporting period. | NA |
Record Count | 13 | 22 | 10 | Numeric/999999999V99 (V indicates implied decimal) | Total of all wages in detail records reported on this report. Record format does not include periods, commas, or dollar signs. Lead with zeros if the dollar amount does not require all available spaces. Example: $12,345.67 should be 00001234567 | NA |
Filler | 23 | 400 | 378 | Fill with spaces. | Possible future use. | NA |