This report reports all the pension values previously created for the pension year through the Ontario Teachers Pension Report Creation. The Ontario Teachers 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 Ontario Teachers Pension Report Creation and then adjusted as needed through the Ontario Teachers Pension Report Adjustments.
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 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.703 is a pension report file created for pension deduction 10 for the 201703 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.
Please refer to the Ontario Teachers Pension Plan Employer Handbook supplied by OTPP for complete reporting details and instructions.
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 Ending Pay Period
-
Enter the ending pay period the pension report was generated for. The Ontario Teachers Pension files are maintained per pay period. All pension files will be created using the pension period in the file name, allowing for unique files per pay period.
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.
Enter Primary Pension Deduction Code
-
Enter the primary or first pension deduction code entered during the creation of the pension report. The pension deduction entered during the creation of the pension report is used in determining the pension file name. This allows a payroll to report and maintain pension information for multiple pension deduction at the same time.
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.
The report lists the following:
-
Employee number and SIN
-
Employee Last name
-
Employees FTE for contractual or Credit Hours for hourly paid
-
Hours per day for hourly paid
-
Employee type code
-
Union affiliation code and short description of union
-
Employee's % Rate of Pay, 100% of current base salary.
-
CPP Liable flag
-
TPP Contribution flag
-
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 SIN
-
Employee FTE
-
Employee Hours paid, if hourly
-
Hours Per day, if hourly
-
Employee Type code
-
Union Affiliation Code
-
Union Affiliation description
-
Rate of Pay at 100%
-
CPP Liable Flag
-
TPP Contribution flag
-
Re-employment Flag
-
Salary Paid
-
Retro Salary
-
Retro Start Date
-
Retro End Date
-
Employee's TPP Contributions
-
Employee's Service Credit
-
Event Type code
-
Event Start Date
-
Event End Date
-
Employee's Birth Date
-
Employee's Death Date
-
Employee's Termination Date
-
Employee's Apartment number
-
Employee's Address 1
-
Employee's Address 2
-
Employee's City
-
Employee's Province
-
Employee's Postal Code