4.25 C. Record Format for Web Wage Reporting

Files can be submitted as Excel worksheets.

If you do not have Microsoft Excel, you can use Open Office Calc to prepare the Excel Worksheet. Open Office Calc is part of the free Open Office software suite. You can download the free Open Office software at http://download.openoffice.org/index.html.

Excel worksheet format

You can download a sample Microsoft Excel Template from the Employer Access area of the IMRF Website.

Please note
: the wage data must be on the first sheet.

Column Description

Requirement Description

employer_nbr

Employer number (text):
5-digits. Use 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.
 

report_month

Wage Report Month (text)
2-digit month of wage report period
 

report_year

Wage Report Year (text)
4-digit year of wage report period
 

member_ssn

Member Social Security Number (text)
9-digit Social Security Number without dashes
 

member_name

Member Name (text)
The member name should be entered delimited by a space or comma. Enter the member name as ’lastname[space or comma]firstname’ (e.g., ’JACKSON JOHN’ or ’JACKSON,JOHN’).

Enter two-part names without spaces or punctuation (e.g., ’Van Horn’ should be entered as ’VANHORN’ and ’O’Brien’ should be entered as ’OBRIEN’).
 

member_gender

Member gender (text)
1-character. Use ”F” for female, ”M” for male, or leave blank (space).
 

plan_code

IMRF Member Plan Code Tier 1 (text)
4-characters (use a zero ’0.’ Not the alphabet ’O’)

  • If the plan is Regular, use RG01

  • If the plan is SLEP, use SL0l

  • If the plan is Voluntary Additional, use VA0

  • If the plan is ECO use:
    ECR1
    ECR2
    ECS1
    ECS2
    EPR1
    ERS1
     

See Section 4.23 for an explanation of ECO codes.

 

IMRF Member Plan Code Tier 2

  • If the plan is Regular, use RG03

  • If the plan is SLEP, use SL03

  • If the plan is ECO Regular, use EPR3

  • If the plan is ECO SLEP, use EPS3

  • If the plan is Voluntary Additional, use VA03

current_wages

Current Member Wages (number)
Cannot be a number greater than 99999.99
May contain up to two decimals.
 

current_contributions

Current Member Contributions
Cannot be a number greater than 99999.99
May contain up to two decimals
 

 

 

Related Topics