The Ontario OMERS Pension Adjustment Upload option loads the PA values from an OMERS supplied PA upload CSV file. The PA entries will be created on the employee’s payroll with the highest pensionable earnings for the taxation year, based on the selected payrolls. You can add to or override the existing PA amounts, although the Pension Adjustment Purge option can be used to clear out any incorrect or unwanted PA amounts. The income tax deduction to be used per employee is taken from the first active income tax deduction code on the employee's deduction master.
Any rejected entries will be listed on the bottom of the report along with the reason for the rejection. Each rejected entry includes a record number of the invalid entry. This number refers to the record number of the import file, providing a way for you to identifying the invalid entry.
The predefined contents of the OMERS PA file to be imported must be the following:
Please note the Service Period Start date must be in the format of YYYY-MM-DD. This date is used to identify the applicable taxation year of the entries. This file must be a CSV or comma separated value file.
|
FIELD |
DESCRIPTION |
Format |
|
1 |
Last Name |
|
|
2 |
First Name |
|
|
3 4 |
SIN Sex |
|
|
5 6 |
Date Of Birth Enrolment Date |
|
|
7 8 9 10 11 12 13 14 15 16 17 |
Employee Id Department Employee Affiliation Service Period Start NRA Employment Status PA Amount Credit Service Contributory Earnings Primary RPP Normal Primary RCA Normal Membership Status 7 additional columns not used |
YYYY-MM-DD ** |
|
|
|
|
Taxation Year
Enter a 4-digit year (eg. 2022) to identify the taxation year to be assigned to all pension adjustments to be uploaded into the payrolls for this process.
This year will also be used to filter the PA Import entries for the given year.
Payroll Selection
Enter one or up to eight payroll id followed by the applicable OMERS pension deductions per each payroll. Only the payrolls identified will be included in the upload of the PA amounts.
Enter Location of File To Be Imported
Enter up to 35 characters of a logical or exact directory location where your import file can be found. Select the file upload icon to select a file from your PC.
Enter Name of The File to be Imported
Enter the exact name of your import file.
Add to or Override Existing PA Amounts
Enter ‘A’ to add the import PA amount to any existing PA amount.
Enter 'O’ to replace any existing PA amount with the imported PA amount.
For both options, if a PA record does not exist, one will be created.
Report Only or Process
Enter 'R' to indicate a preliminary run. This option only generates the report and error listings. It is recommended that a preliminary is run first so you are aware of any rejected entries before processing.
Enter 'P' for a Process Run. The process will generate Pension Adjustment entries for the given taxation year.
Sort By Employee Name, Employee Number, SIN
Enter 'N' to generate the report in employee name order.
Enter 'E' to generate the report in employee number order.
Enter 'S' to generate the report in employee SIN order.
Omit Zero PA Entries
All zero PA entries will be rejected.
Enter 'Y' to omit reporting zero PA entries.
Enter ‘N’ to include the rejection message for all zero PA entries.
The report lists the following:
Employee SIN, name and number as defined in the OMERS import file.
The physical record number.
The payroll ID where the PA record will be created.
Tax deduction number and description
PA amount to be added.
Existing PA amount for same year and tax code.
Total of PA record for year and tax code.
Number of payrolls, when an employee has multiple applicable payrolls
Total number of entries processed.
The rejection report lists the following:
Employee SIN name and number as defined in the OMERS import file.
The physical record number.
The PA amount to be imported.
The reason the entry was rejected.
The total number of rejections.
The total number of omitted zero PA entries.