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: M F
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: RG03 RG01 VA01 VA03 SL01 ECR1 ECR2 ECS1 ECS2 EPR1 EPS1 SL03 EPR3 EPS3
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.