IMRF Pay Period Report - File Layout and Data Mapping
The default file name for the IMRF Pay Period report is IL IMRF Pay period Report_<Report creation date>_<Report creation time>.csv.
The report file contains one record per employee per month, irrespective of whether the employee received multiple checks that month.
The report reflects the monthly dates based on the Report Date selected on the IL IMRF Pay Period Report-Report page. If the report date falls in May 2024, then the Payment Date, Period Start, and End Dates are 05-31-2024, 05-01-2024, and 05-31-2024, respectively.
Do not tamper with the .csv electronic file by opening it in Excel and saving it, as this might cause the date formats, etc., to change and not in the order that IMRF is expecting. It is recommended that you open it using Notepad.
The following table outlines the field names, descriptions, data types, lengths, and whether they are required for the IMRF Pay Period report.
Field Name | Description | Data Type | Length | Required? |
---|---|---|---|---|
SSN | Social security number without hyphens. | Integer | 9 | Yes |
MemberID | The employee's unique member ID. | Integer | 11 | No |
FirstName | The employee's first name. | Character | 50 | Yes |
LastName | The employee's last name. | Character | 50 | Yes |
Plan | The pension plan. | Code | 7 | Yes |
PeriodStartDate | The beginning date of the wage reporting period. | Date | 10 | Yes |
PeriodEndDate | The ending date of the wage reporting period. | Date | 10 | Yes |
PaymentDate | The date when the employee was paid. | Date | 10 | Yes |
ReportableWages | The wage amount reported. | Decimal | 21 | Yes |
Overtime | The overtime wage amount reported. | Decimal | 21 | No |
Contributions | The employee contribution amount reported. | Decimal | 21 | Yes |
VoluntaryAdditionalContributions | The voluntary additional contribution amount reported. | Decimal | 21 | No |
FinalWages | Indicates whether reported amounts are the final wages. | Code | 1 | Yes |