The Saskatchewan Teachers Group Life Report reports and exports the Teachers group life insurance information previously generated from the Saskatchewan Teachers Group Life Generation/Report process. The employees are reported in employee name order. This process must be used to reproduce the Saskatchewan Teachers Group Life Report after making changes to the employee records in the Saskatchewan Teachers Group Life Adjustments data entry screen.
This process generates a tab delimited export file containing the Teachers Group Life information that can be used for electronic submission to the Saskatchewan Teachers' Superannuation Commission. The format of the export is based on the requirements of the Superannuation Commission's Group Life Insurance Remittance Template spreadsheet, available on their web site. The export file ######.CSV, where ###### is the job number of the report run. This export file is generated at the location defined by the logical SRB$OPSWRK.
-
Reporting Date (first day of the reporting month)
-
School Board Division Number
-
Employee's SIN
-
Employee's Name
-
Commencement Date, when applicable
-
Certificate number
-
Teacher code (T for Teacher, S for Secretary – Treasurer)
-
Employee's Life Insurance Premium Amount
Enter the Pay Period to Report
-
Enter the pay period you want to report. The cheque date from this pay period will determine the reporting month and date.
Enter the School Division Number
-
Enter up to 6 characters representing the school division number.
The report lists the following:
-
Record type 10 Commencement, 20 Regular, 40 Termination Adjustment
-
Employee's SIN and name
-
Teaching certificate number
-
Teacher code
-
Commencement Date, if applicable
-
Employee's Life Insurance premium amount
-
School Year-to-date premium amount
-
Total employees and premium totals