The Manitoba TRAF Pension Generation Report lists all the pension figures and information according to the criteria of Manitoba TRAF. The reported values can be adjusted as necessary through Manitoba TRAF Pension Adjustments option. The reporting of the modified pension information is then recreated through the Manitoba TRAF Pension Report.
Days Paid reported are the actual teaching days per period times the employee's FTE and the Working Days are the total number of Teach days or Alternate* Teaching days as per the Payroll Calendar or the Manitoba Pension Profile. The actual teachings days are taken from the Working Days in the applicable payroll calendar or may be overridden based on the Alternate Days setting on the Manitoba Pension Profile. The Days Paid and Working Days are as of the settings when this report is run.
Note: *the Payroll Calendar Alternate Days will only be used when the Manitoba Pension Profile Alternate days is left empty.
When Display atrieveHR Certificate is active in the User Specific Parameters Profile, 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 Certificate Code Database and attached to employee through the atrieveHR Certificate Entry Menu.
The Manitoba TRAF Pension Generation Report creates a unique temporary pension file and CSV formatted export file for monthly and annual reporting. The process generates a comma delimited file SRB$OPSWRK:atrieveHRB0A.CSV (annual); SRB$OPSWRK:atrieveHRB0M.CSV (monthly), for submission to the TRAF board. The comma delimited retro earnings file SRB$OPSWRK:atrieveHRBRA.CSV (annual) or SRB$OPSWRK:atrieveHRBRM.CSV (monthly) is only generated when retro entries are included on the report.
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 Deduction Codes
-
Enter one or up to 5 pension deduction codes to be reported.
Enter Variant Deduction Codes
-
Enter one or up to 5 deduction codes to be reported as variant amounts. The deduction amount for these deductions are reported separately as a Record Type CA and Service Type 140.
Enter Voluntary Deduction Codes
-
Enter one or up to 5 deduction codes to be reported as voluntary amounts. The deduction amount for these deductions are reported separately as a Record Type VA and Service Type 043.
Enter Starting Pay Period
-
Enter the starting pay period for a range of pay periods to be reported.
Enter End Period
-
Enter the ending payroll period for a range of pay periods to be reported.
Annual Report or Monthly Report
Two different files are maintained for this pension system which allows on-going work to be done on the annual report while a monthly report is generated.
-
Enter 'A' to generate an annual report.
-
Enter 'M' to generate a monthly report.
Report All or Selected Employees
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.
Commencement Date Source from Employee Date
Select which date to use for the source of the employee's commencement date. This date will be reported when the employee's date is newer than the starting date of the reporting period.
-
Enter 'C' to use the employee's Current Hire date.
-
Enter 'O' to use the employee's Original Hire date.
-
Enter 'S' to use the employee's Seniority date.
-
Enter 'I' to use the employee's Increment date.
-
Enter 'V' to use the employee's Vacation date.
Enter Report Year
Enter the year to be used for this report.
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 field 2 and 3 from the Manitoba Pension profile.
-
The reporting year and month
-
Pension service code
-
Employee contribution total
-
Days Paid - Actual Days paid (Working days from calendar times FTE), less Docking Days. May be affected by pay code Hours Pensionable setting. May be overridden by Alternate Teaching Days.
-
Working (Teaching) days for year, as per field 5 or 6 from the Manitoba Pension profile or override by Annual Days from the Employee Type code, when applicable.
-
Full time Contractual Salary.
-
Substitute pensionable earnings
-
Percent of Service (FTE)
-
Non-serviceable Pensionable earnings
-
Employment Commencement date (current hire, original hire, seniority, increment or vacation date). The commencement date is reported when the employee's selected 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.
-
Contractual Salary = Contractual Earnings paid per field 08 in profile, annualized and bumped to 100%. Where FTE is determined from Pensionable YTD days per 08 in Manitoba Pension profile (omit if pay code is Hours Pensionable = N) divided by school days per period. School days per period is annual school days from profile divided by the number of periods per pay cycle.
Note: A separate report line is reported when the Contractual Salary or FTE changes.