The OMERS Pension Report Creation module is used to generate either the annual Form 119 pension report and bulk file submission or the retro bulk file submission.
The OMERS pension creation process allows for global pension reporting for multiple payrolls at the same time. This feature allows the OMERS pension extract to include all payrolls for a combined upload.
Fully Terminated employees will be omitted from the OMERS extract although these employees are included on the report and csv for balancing purposes. A fully Terminated employee is one that is not active on any reported payroll. Since the report totals will not represent the extract file totals, the actual extract totals are also included along with the number of excluded Terminated employees.
The OMERS Pension and Retro values can be adjusted as necessary through the OMERS Pension Report Adjustments and then re reported and file extracts generated through the OMERS Pension Report Regeneration option. The OMERS Pension Report Adjustments allows for the manual addition, deletion or changes of all pension and retro records to be reported.
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 directly to the pension board. Although the .CSV values could be used in conjunction with the OMERS File Build Spreadsheet.
This option includes both a detailed and summary version. The detailed option includes values per pay period with a subtotal per employee. The detailed option does not generate the preformatted bulk upload files.
The pension report includes the option to report a default Employment Status with the option to override Employment Status to the alternate value based on defined Employee Type codes. When you run the pension report you can define the default Employment Status code, either C for continuous or O for other than continuous. Everyone on that payroll will be assign that Employment Status. You can then optionally define an override list of Employee type codes, which includes the wild card feature, that indicates those employee’s with an override Employee type code will receive the alternate or opposite Employment Status code as the default value. When an override list of Employee type codes is defined, the pension process will also pull the employee’s Employee type code changes details from the current year audit history. When an employee has had an Employee type code changes that effectives their Employment Status, based on the audit history, split pension records will be created. The audit date will be used as the pension effective date. Only master function line Employee Type code and changes are applicable for the pension reporting.
Enter OMERS STARTS DD-MMM-YYYY on an employee deduction master memo field will allow the pension report to pick up the date defined and report that as the employee’s effective date.
This report includes the option to report the vacation/holiday pay and subsequent pension credit bump up based on the vacation/holiday percentage. You defined a list of pay codes that represent the earnings that make up the applicable vacation/holiday earnings. You also have the option to define a list of pay codes of earnings that are vacationable but are not pensionable. The report will calculate the percentage from the total vacation/holiday in relation to the pension eligible, per employee per pay period. The percentage will then be used to bump up the pension service credits for the pay period. The report will subtract out any variable deductions eligible amount and add in the non-pensionable for the applicable pension deduction, before calculating the percentage to ensure variables will not impact on this formula. The bump up of the pension service credit only appears on the report; the employee’s pension credit records are not actually adjusted. This feature is also available under the Pension Credit Report where you can actually get details of the pension credit bump up per employee per pay period.
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, 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.
Enter one or multiple payroll ID's along with the applicable starting and ending periods, employment status settings and pension deductions to be reported per payroll. You can run this process for all OMERS payrolls/deductions through one payroll to generate a single pension submission file or run this process for each payroll separately and submit multiple files to OMERS.
Default, enter the Employment status default for the payroll, C – Continuous Full-time or O-Other than Continuous Full-time.
Override Types, enter the employee type codes that are an override to the Employment Status default. You can list employee type codes or you wild carding to reduce the number of entries.
All employees for a payroll will be assigned the default Employment status code, unless the employee’s employee type is an override, then that person will receive the alternate Employment status code.
When ‘r’etro Reporting was selected:
Enter one or multiple payroll ID's along with the applicable starting and ending periods, retro start and end dates and applicable retro pay codes to be reported. You can run this process for all OMERS payrolls through one payroll to generate a single pension submission file or run this process for each payroll separately and submit multiple files to OMERS.
Report All Or Selected Employees
When ‘S’elective Employees was selected:
Enter the employee number followed by the appropriate payroll ID code. Use the lookup to search all employees and select the appropriate employee + payroll ID. You can only include employees from payroll ID that have been selected for this processing of PAD.
Select the View Employee icon to see a listed of selected employees.
Select the Clear icon to clear all selected employees.
When ‘P’ension Reporting was selected, the next five prompts apply:
Annual YMPE For Reporting Year
Enter the YMPE amount for the pension reporting year. The YMPE is used in the calculation of the RCA portion of the RPP.
RPP Annual Limit For Reporting Year
Enter the annual RPP limit for the pension reporting year. This value is used in the calculation of the RCA portion of the RPP.
Rate Up To YMPE For Reporting Year
Enter the rate of pension up to the YMPE amount for the pension reporting year.
Rate Over YMPE For Reporting Year
Enter the rate of pension over the YMPE amount for the pension reporting year.
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.
Report Summary or Period Detail
Enter ‘S’ to generate the year end Summary report and pension file extract. Only the Summary option will create the preformatted bulk pension files for submission to OMERS.
Enter ‘D’ to generate a pension report detailing the activities per pay period. The Detailed option does not generate the preformatted pension file extract.
When ‘P’ension Reporting was selected, the next four prompts apply:
Bump Up Pension Service By Vacation Percent
Enter 'N’ or <ENTER> when the pension service credits should not be bumped up.
Enter ‘Y’ when the pension service credits should be bumped up by the vacation/holiday pay percentage.
When ‘Y’ES Bump Up The Pension Service was selected the next three prompts apply, per payroll to be process:
Round Percentage to 2, 3, or 4 Decimals
Define the number of decimals the vacation/holiday percentage should be rounded to. For example, if you vacation percentage is 4.4% or .044 you would want to calculate to 3 decimals, while a percentage of 4% or .04 would only require calculations to 2 decimals. Final reporting of the pension service will be as 2 decimals.
Enter Vacation Pay Codes For Service Increase
Enter one or up to 25 pay codes, that represent the vacation/holiday pay earnings that are pensionable. The total earnings from these pay codes will be used to calculate the employee’s percentage and the pension service credits will be bumped up by that percentage. When the employee has no vacation/holiday earnings, the pension credits will not be adjusted.
Enter Vacationable But Not Pensionable Pay Codes
Enter one or up to 25 pay codes, which represent the earnings that were included in the vacation/holiday pay earning generation but are not pensionable and therefore not included in the pension eligible. For example, overtime may be included in the vacation pay percentage calculation but is not pensionable earnings. The earnings accumulated from these pay codes will be added to the pension eligible for the determination of the vacation percentage.
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
Effective Date
Pension year or pay period
Payroll ID
Employment Status Code
Employee Type Code
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
Extract file totals, as used in the OMERS files header.
Totals per payroll break down.
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