The OMERS Pension Report Regeneration reports all the pension or retro values previously created for the pension year through the OMERS Pension Report Creation. The OMERS Pension Report Regeneration process would be used to generation a new report listing and submission file of pension information that was first created through the OMERS Pension Report Creation and then adjusted as needed through the OMERS Pension Report Adjustments.
This process will generate the bulk extract file ready for uploading to OMERS while at the same time creating a .csv export file of selected information which may be used in conjunction with the OMERS Import File builder spreadsheet. The bulk extract pension file for direct submission to OMERS is SRB$OPSWRK:FORM119_yyyymmdd.txt, where yyyymmdd is the date when the text file was created. The bulk extract retro file for direct submission to OMERS is SRB$OPSWRK:FORMRET_yyyymmdd.txt. These files can be download from the payroll using the Payroll Download File Process for direct upload to OMERS.
The excel output contains all of pension information included on the pension extract record in a comma delimited format. This .CSV files should not be used for submission to the pension board.
Please refer to the OMERS Employer Administration Manual supplied by OMERS for complete pension and retro reporting details and instructions.
The Pension excel csv file contains the following columns:
Employee Last Name
Employee First Name
SIN
Empty column
Empty column
Enrollment Date
Employee Number, if applicable
Empty column
Effective Date
Empty column
Employment Status Code, if applicable
PA Amount, if applicable
Service Credits
Pension Earnings
RPP Contribution
RCA Contribution
The Retro excel csv file contains the following columns:
Employee Last Name
Employee First Name
SIN
Service Start Date (01-JAN-pension year)
Retro Type (R- regular)
Retro Start Date
Retro End Date
Effective Year
Retro Earnings
Process Pension Or Retro Entries
Enter ‘P’ to generate pension entries.
Enter ‘R’ to generate retro entries.
This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.
Enter Pension Reporting Year
Enter the applicable year for pension reporting.
When ‘P’ension Reporting was selected, the next prompt apply:
Include PA Amounts on Pension Report
Enter ‘Y’ to pull in and report the previously generation PA amount. These values will be included in the pension extract file. Note, when upload is selected, this will override any previously entered PA Amounts.
Sort By SIN, Employee Name or Employee Number
Enter ‘S’ to produce the report in employee SIN sequence.
Enter 'N' to produce the report in employee name sequence.
Enter 'E' to produce the report in employee number sequence.
Include Generation Of Pension Extract File
Enter 'Y’ to generate the preformatted pension extract file to be submitted to the pension board.
Enter ‘N’ to omit generating the pension extract file.
When ‘P’ension Reporting was selected, the next prompt apply:
Include Employee Number in Extract File
Enter 'Y’ to include the reporting of the payroll employee number in the preformatted pension extract file. When provided, OMERS will print the employee number on your employees’ OMERS supplied Pension Reports.
Enter ‘N’ to omit the reporting of the payroll employee number.
The Pension report lists the following:
Employee number
Employee Name
SIN
Effective Date
Employment Status
Pension Service
Pensionable Earnings
RPP Contribution
RCA Contribution
Employee Total Contribution
PA Amount, if loaded
Employee total for multiple entries
Total employees reported
Total number of records
Total unique SIN
The Retro report lists the following:
Employee number
Employee Name
SIN
Pension year
Payroll ID
Retro Start Date
Retro End Date
Retro Earnings
Total employees
Total records
Total retro earnings