The Manitoba TRAF Pension Report produces and corresponding CSV file for submission to the TRAF pension board. This report reads the transaction file which was created in step one of the process and produces the report considering any adjustments made in step two using the Manitoba TRAF Pension Adjustments program.
The Teachers PSP number will be extracted from the atrieveHR system and included on the report following the gender, when available. The PSP number would be defined as a certificate number per Teacher with the atrieveHR Certificate code is setup in the atrieveHR database and attached to employee through the atrieveHR Certificate Entry Menu screens.
This process generates a comma delimited file,SRB$OPSWRK:atrieveHRB0A.CSV(annual) andSRB$OPSWRK:atrieveHRB0M.CSV(monthly) for submission to the TRAF board. The comma delimited retro fileSRB$OPSWRK:atrieveHRBRA.CSV(annual) orSRB$OPSWRK:atrieveHRBRM.CSV(monthly) is only generated when retro entries are included on the report.
Annual Report or Monthly Report
-
Select which file to report. The A(nnual) or M(onthly) relate directly to which option was used during the generation phase.
Report By employee #, SIN or Name
-
Enter 'E' to produce the report in employee number sequence.
-
Enter 'S' to produce the report in employee SIN sequence.
-
Enter 'N' to produce the report in employee name sequence.
The report lists the following:
-
Employee number, name, birth date and sex
-
Employee's PSP number extracted from the atrieveHR system, when applicable
-
Pension record type
-
Employee SIN
-
The school division and district numbers, as per profile.
-
The reporting year and month
-
Pension service code
-
Employee contribution total
-
Days paid
-
Working days for year per employee.
-
Full time Contractual Salary.
-
Substitute pensionable earnings
-
Percent of Service (FTE)
-
Non-serviceable Pensionable earnings
-
Employment Commencement date (current hire date). The hire dates are reported when the employee's current hire date is greater than or equal to the starting date of the starting pay period.
-
Employment Termination date. Reported when an employee's termination date exists, and the employee is terminated.
Note: A separate report line is reported when the Contractual Salary or FTE changes.