The Ontario Teachers Pension Report Creation module is used to generation the pension report and file submission for Payroll-based Reporting to the Teachers’ pension plan.
See section 7 Data Processing of the TPP Reporting specifications for details related to the file submission requirements. The Teachers’ Pension report and submission file is generated using the pension reporting pay period. This means that new pension files are created for each pay period range submitted.
This process will pull the Teachers Certification number from the HR system based on the setting from field DISPLAY PRM CERTIFICATE under the User Specific Parameter Profile. The Certification number will remain blank in the extract file if this setting is not defined or the Teacher does not have a Certificate Number defined in the HR system. See PRM Certificate Inquiry.
The Teachers Pension Plan Report values can be adjusted as necessary through the Ontario Teachers’ Pension Report Adjustments and then re reported through the Ontario Teachers Pension Report Regeneration option. The Ontario Teachers’ Pension Report Adjustments allows for the manual addition, deletion or changes of all pension records to be reported.
This Ontario Teachers Pension Report Creation generates a unique pension file based on the primary pension deduction code and the pay period being reported. The pension work file PENS##.yyp is created at the logical SRB$OPSDAT0: points to, where ## is the primary pension deduction code and yyp is the ending pay period reported. For example, PENS10.003 is a pension report file created for pension deduction 10 for the 202003 pay period.
The extract file for submission to the Ontario Pension board SRB$OPSWRK:TPP_PEN##.yyp, where ## is the primary pension deduction and yyp is the pay period. When creation of the extract file is selected, the full file name and location is included in the header of the report.
You may also merge multiple payrolls OTPP submission files by using the Ontario Teachers Pension Merge Process.
Please refer to the Ontario Teachers Pension Plan Employer Handbook supplied by OTPP for complete reporting details and instructions.
Negative pension numbers are reported and displayed as regular negative numbers on reports and the CSV export. The negative number in the OTPP file submission however are handled by replacing the last digit of the number with a unique character. For example, 1 would become J, 2 a K, etc.
This option includes an excel export option for information purposes only. These 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. See below the reporting details for CSV contents.
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 Starting Pay Period
Enter the starting pay period in a range of pay periods to be reported.
Enter Pension Reporting Ending Pay Period
Enter the ending pay period in a range of pay periods to be reported.
The pay period ending date, from the ending pay period calendar, will be used as the initial default value for the Reporting Pay Date. The last three digits of the ending pay period will be used for the pension reporting and file submission file names.
When the working days in the payroll calendar for the ending period is zero, you will be prompted as follows. Zero working days indicates that the employee’s service credits and hours paid should be reported as zero.
Enter the Reporting Pay Date
Enter the Pay Date to be reported in the header and trail of the pension file to be submitted to the pension board for the current pay period. By default, the Cheque Date from the Ending Pay Period will display.
Pension Reporting Based on Days or Storage Bank
Enter 'D' to generate the Teachers' Pension report using the days as per the year-to-date history for the given pay period. This is the default setting.
Enter 'S' to generate the Teachers' Pension report using an alternate storage bank that is defined to track pensionable days worked. The employee's bank value for the given period will determine the employee's FTE and Service Credits.
When Reporting by Days was Selected the Next Two Prompts Apply:
Service Credit Percent Reduced by Statutory Days
By default, 1.00 or 100% will be displayed. Use 1.0 when no reduction to service credits related to statutory holidays is required.
Enter the percentage of service credits to be used for the pay period. As the service credits are generated based on the days paid, the number of service credits will be overstated when Teachers are paid full days but due to a statutory holiday the service credits need to be reduce
For example, if the employees were paid for 10 days but should only receive 9 days service credits due to a statutory holiday day, enter .90 or 90% of the service credits. Note, this does not apply to Contract function line time that is already defined as Actual Days.
Adjusting Pay Codes to Exclude from Stat Reduction
Enter one or up to 15 pay codes that are to be omitted when the Statutory Days Reduction Percentage is applied. The time for these pay codes will be used as is for the Service Credit determination.
When Reporting by Storage Bank was Selected:
Storage Banks to Define Service Credits
Enter one or up to 5 storage banks to be used to define the employee’s FTE and Service Credit per pay period in comparison to the Calendar Working Days. When multiple storage banks are entered, the first bank found on an employee will be applied.
Enter Pension Deduction Codes to Report
-
Enter one or up to 5 pension deduction codes to be included on the report. Pension deductions must be a Group 1 deduction codes.
The first or primary deduction entered will be used as part of the pension file name to allow multiple pension deductions to be reported at the same time for the same pay period. Access for adjustments and regenerating of the pension information will require this deduction code value.
Report All or Selected Employees
Sort by Employee Name, Employee Number Or SIN
-
Enter 'N' to produce the report in employee name sequence.
-
Enter 'E' to produce the report in employee number sequence.
-
Enter 'S' to produce the report in employee SIN sequence.
Create the Pension Extract File
-
Enter 'Y' to generate the pension extract file to be submitted to the pension board.
-
Enter 'N' to omit generating the pension extract file.
Enter Prior Year Retro Pay Codes to BE Reported Separately
-
Enter one or up to 25 pay codes which represent prior year retro earnings to be reported separately. These earnings would be included in the regular pension deduction and calculation and should represent a prior year retro.
When Retro Pay Codes Are Defined, the following prompts will display:
Enter Retro Start Date
-
Enter the starting date for a range of retro dates to be reported.
Enter Retro End Date
-
Enter the ending date for a range of retro dates to be reported.
The report lists the following:
-
Employee number and Last Name
-
Employee OCT Number
-
Employees FTE for contractual (days bank divided by calendar days) or Credit Hours for hourly paid
-
Hours per day for hourly paid (hourly based on H or P Pay Type or Hourly Employee Type code from master function line)
-
Employee type code and work code
-
Union affiliation code and short description of union
-
Employee’s % Rate Of Pay, 100% of current base salary.
-
CPP Liable flag, based on CPP Exemption and CPP Effective date on employee Pay screen.
-
TPP Contribution flag, controlled by Employee Type Receiving OTPP in Ontario Profile
-
Employee’s Salary paid
-
Employee’s retro salary, when applicable
-
Employee’s pension contribution amount
-
Employee’s Service Credits for pay period range
The excel csv file contains the following columns:
-
Payroll Id code
-
Employee Number
-
Employee Name
-
Employee OCT Number
-
Employee SIN
-
Employee’s Apartment number
-
Employee’s Address 1
-
Employee’s Address 2
-
Employee’s City
-
Employee’s Province
-
Employee’s Postal Code
-
Employee’s Birth Date
-
Employee’s Death Date
-
Employee’s Termination Date
-
Salary Paid
-
Employee Hours, if hourly
-
Employee’s TPP Contributions
-
Employee FTE
-
Work Code
-
Hours Per day, if hourly
-
CPP Liable Flag
-
TPP Contribution flag
-
Retro Salary
-
Retro Start Date
-
Retro End Date
-
Re-employment Flag
-
Event Start Date
-
Event End Date
-
Union Affiliation Code
-
Employee’s Service Credit
-
Rate of Pay at 100%
-
Event Type code