The Alberta TRF Merge Process is to be used to compress multiple payroll TRF export files for submission to ATRF. This process matches employees based on SIN and combines the employee's transactions when applicable. An employee who was paid under both payrolls will be merged so one employee record exists, but two contribution records will be recorded. The demographic and other information used on the employee record is taken from the payroll indicated to be the Main payroll. The Main payroll should always be the Teachers payroll.
This process requires that the TRF export files for the month for all applicable payrolls be generated already through the TRF Export Process. Only information generated for the same month may be merged.
This process combines records from multiple PRTR02.YPP files and generates a new PRTR0M.YPP. This merged file is generated at the location pointed to by the logical SRB$OPSWRK for the payroll under which the merge process is run. The value of YPP on the merged file is taken from the corresponding TRF export file from the Main payroll. You would then send the PRTR0M.YPP file to the ATRF.
Enter Main Payroll ID Code
-
Enter the payroll ID code for the main payroll. The main payroll should always by the Teachers payroll. The initial default is the payroll ID for the payroll you are currently in. Use look-up for a list of valid payroll ID codes.
Enter Pay Period For code
-
Enter the pay period used in the generation of the main TRF export file for this payroll.
Enter Payroll ID Code to Merge
-
Enter the payroll ID code for the payroll to be merged with the main payroll TRF information.
Enter Pay Period For SUBS
-
Enter the pay period used in the generation of the TRF export file under this subsequent payroll.
The Report will list the following:
-
Employee name and SIN
-
Employees FTE Days Paid and FTE percentage
-
Days missed
-
FT-MRS, Full time monthly rate of salary
-
PT-MRS, Part time monthly rate of salary
-
PSP, Pensionable salary paid
-
Employees TRF contribution
-
Employees ATA dues
-
School code, when applicable
The Report Totals include:
-
Number of Full-Time employees, FTE of 1.0000
-
Total FT-MRS for Full Time (multiple entries on a period are only totaled once per employee)
-
Total PT-MRS for Full Time (multiple entries on a period are only totaled once per employee)
-
Total PSP for Full Time
-
Total TRF Contributions for Full Time
-
Number of Part Time employees, FTE less than 1.0000
-
Total FT-MRS for Part Time (multiple entries on a period are only totaled once per employee)
-
Total PT-MRS for Part Time (multiple entries on a period are only totaled once per employee)
-
Total PSP for Part Time
-
Total TRF Contributions for Part Time
The report header includes your board number, ATA local number, start of school year and total operational days as will be reported to ATRF