Saskatchewan Pension Generation Report

The Saskatchewan Pension Generation Report process generates the pension files and reports for the monthly STRP (Saskatchewan Teachers Retirement Pension) or TSC (Teachers Superannuation Pension Contributions). An option is also available to generate the electronic file for both monthly submissions at the same time. Optional reporting of STF Fees, ICP Premiums, Contingency Fees, McDowell Contributions and Group Life Fees is also available. The reporting of these additional values is only available on Web electronic submission file.

This pension generation report will automatically load a pension code of 1 (superannuated) when the employee's pension deduction frequency is set to "*" and the employee is still being paid. The pension code of 9 (35 years of service) will be loaded when the employee's pension frequency is set to "#' and the employee is still being paid.

When the monthly report for June is selected (or applicable pension recalculation month) the report will include details when an employee's pension was bumped up. Adjustments to prior periods will be listed under the month where the adjustment took place.

Prior year (type 30) records will be created using the month and year from the date taken from the previously entered variable deduction. This process will use the first variable deduction entry found for the prior year pension deduction using the period defined as of the Starting Period to Be Reported. The days taught should also be set up in the variable Reason field in the format "## Days" where ## is the number of days.

The Name of the Electronic Web Files Are:

PRSKSM.Web STRP/Both monthly web file
PRSKTM.Web TSC monthly web file

The Name of the Electronic Files Are:

PRSKSM.TAP STRP/Both monthly electronic file
PRSKTM.TAP TSC monthly electronic file

All pension electronic and web files are generated in the location defined by the logical 'SRB$OPSWRK:' per payroll.

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 the Pension Plan – STRP, TSC or Both

The pension plan selected determines the names of the files generated as well as defines the contents of the Web Plan code per employee record. Web Plan code is A for STRP and F for TSC pension.

Enter 'S' to create the pension records required to produce a Saskatchewan Teachers' Retirement Pension report. Web Plan code is always A.
Enter 'T' to create the pension records required to produce a Saskatchewan Teachers' Superannuation Commission report. Web Plan code is always F.
Enter 'B' to create a combine pension report and extract including both STRP and TSC pension deduction information. The Web Plan code is per pension deduction with the default being A for STRP. This option will look at the External Name fields on the pension deduction code data base to identify TSC pension deductions. Those pension deductions with the word TSC in the External Name field will have the Web Plan code set to F for TSC, all others will be A.

Enter Period Record Type

Enter '10' to record the pension records as regular pension.
Enter '20' to record the pension records as current school year adjustments.
Enter '30' to record the pension records as prior school year adjustments.

Enter Fall Start Period

Enter the pay period representing the first pay period of the fall semester for the current school year.

Enter Spring End Period

Enter the pay period that represents the last pay period for the spring semester for the current school year.

Enter Starting Period to BE Reported

Enter the starting pay period for the month to be reported.

Enter Ending Period to BE Reported

Enter the ending pay period for a range of pay periods, which represent the month to be reported. On monthly payrolls the starting and ending pay period will be the same pay period.

Enter Reporting Month

Enter the report month to be included in the electronic reporting. The default will be based on the reporting pay period entered.

Enter School Year

Enter the school year you want to report on.

Report by Name or Employee Number

Enter 'N' to report by employee name alphabetical order.
Enter 'E' to report by employee number order.

Create the Pension Electronic or Web File

Enter 'W' to create the pension electronic web format file for submission to the Saskatchewan Teachers Retirement Plan via the internet.
Enter 'T' to create the pension electronic file. The electronic file is used to send contribution information to the Saskatchewan Teachers Retirement Plan.
Enter 'N' if you do not want to create the pension electronic file.

Report All or Selected Employees

Enter Pension Deduction Codes

Enter the 2-digit deduction codes assigned to the teacher's pension, one at a time. Use look-up for a list of valid deduction codes.

Enter ICP Premiums Deduction Codes

Enter the 2-digit ICP deduction codes assigned to the teachers, one at a time. Use look-up for a list of valid deduction codes.

Enter Contingency Fees Deduction Codes

Enter the 2-digit Contingency Fee deduction codes assigned to the teachers, one at a time. Use look-up for a list of valid deduction codes.

Enter McDowell Contributions Deduction Codes

Enter the 2-digit McDowell Contributions deduction codes assigned to the teachers, one at a time. Use look-up for a list of valid deduction codes.

Enter Group Life Fees Deduction Codes

Enter the 2-digit Group Life Fees deduction codes assigned to the teachers, one at a time. Use look-up for a list of valid deduction codes.

Enter Prior Year Deduction Codes

Enter one or more prior year pension deduction codes. Entries for these deductions will be reported separately as type 30 records. Prior year (type 30) records will be created using the month and year from the date taken from the previously entered variable deduction. This process will use the first variable deduction entry found for the prior year pension deduction using the period defined as of the Starting Period to Be Reported.

Enter Voluntary Pension Deduction Codes

Enter one or more voluntary pension deduction codes. Entries for these deductions will be reported separately as type 80 records.

Note: Two reports are produces with details as listed below:

The First Monthly Report lists the following:

Employee Social Insurance Number
Employee Name
School Month or Term
School Year
Pension Record Type
Employee Type
CPP Code
Employee Pensionable Earnings
Number of Days Taught, may be affected by pay code Hours Pensionable setting
Employee Pension Contribution
Employee's School Year-To-Date Pensionable Earnings
Employee's School Year-To-Date Days Taught
Employee's School Year-To-Date Pension Contribution

The Second Monthly Report lists the following:

Employee Social Insurance Number
Employee Name
School Month or Term
School Year
Pension Record Type
STF Fees
ICP Premiums
Contingency Fees
McDowell Contributions
Group Life Fees