IMRF Monthly Report - File Layout and Data Mapping
The default file name for the IMRF Monthly report is IL IMRF Monthly Report_<Report creation date>_<Report creation time>.csv.
The following table outlines the columns, names, descriptions, data types, lengths, and data sources or valid values for the IMRF Monthly report.
Column | Name | Description | Data Type | Length | Data Source or Valid Values |
---|---|---|---|---|---|
A | employer_nbr | The employer’s unique number. Use the last four digits of the nine-digit Employer SSA Number, preceded by a zero. Otherwise, if the employer joined IMRF on or after January 9, 1993, use the five-digit identification number issued by IMRF, including the leading zero. | Integer | 5 | Retrieved from the Employer Number field on the Employee Information form accessed from the IL IMRF Monthly Report page. |
B | report_month | The two-digit month of the wage report period. | Integer | 2 | Retrieved from the Month field on the Employee Information form accessed from the IL IMRF Monthly Report page. |
C | report_year | The four-digit year of the wage report period. | Integer | 4 | Retrieved from the Year field on the Employee Information form accessed from the IL IMRF Monthly Report page. |
D | member_ssn | The nine-digit Social Security number without dashes. | Integer | 9 | Retrieved from the Social Security Number field on the Employee Information form accessed from the IL IMRF Monthly Report page. |
E | member_name | The IMRF member’s name. Enter the member name as ’lastname[space or comma]firstname’. | Character | 40 | Retrieved from the Last Name and First Name fields on the Employee Information form accessed from the IL IMRF Monthly Report page. |
F | member_gender | The member’s gender. | Character | 1 | Retrieved from the Sex field on the Employee Information form accessed from the IL IMRF Monthly Report page. Valid values:
|
G | plan_code | The IMRF Member Plan Code. | Character | 4 | Retrieved from the Plan Code field on the Employee Information form accessed from the IL IMRF Monthly Report page. Valid values:
|
H | current_wages | The employee's current wage amount. The value must be less than 500,000.00 and can contain up to two decimal places. | Numeric | 9 | Retrieved from the Current Wages field on the Employee Information form accessed from the IL IMRF Monthly Report page. |
I | current_contributions | The employee's IMRF member contribution. The value must be less than 500,000.00 and can contain up to two decimal places. | Numeric | 9 | Retrieved from the Member Contribution field on the Employee Information form accessed from the IL IMRF Monthly Report page. |