The LAPP APEX Merge Process allows you to merge the LAPP APEX report results from multiple payrolls into one report while maintaining the details of the entries per payroll. This process also generates a combine electronic file for submission to the pension board. This process requires that the LAPP APEX pension files for the year for all applicable payrolls be generated already. Only information generated for the same year may be merged.
All records are generated under the file named SRB$OPSWRK:UTFX%%%%YYYYMMDD###.TXT, where %%%% is your employer number, YYYYMMDD is the current date and ### is an auto incrementing number per day. This file is used to submit to LAPP.
The new merged export file UTFX%%%YYYYMMDD0##.PEN is generated in the work directory of the payroll where the merge is run from.
For complete details on the fields and contents of the UTF file, refer to the LAPP APEX Generation documentation.
Enter Main Payroll ID Code
-
Enter the payroll ID code for the main payroll. The main payroll should always by the existing 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 Pension Service Year
-
Enter the year to be used as the pension service year.
The next two prompt will repeat.
Enter Payroll ID Code to Merge
-
Enter the payroll ID code for the payroll to be merged with the main payroll LAPP information.
Enter Pension Service Year
-
Enter the year to be used as the pension service year.
Enter Employer Number
-
Enter a 4-digit number assign to each employer.
Sort by Name, Employee # Or SIN
-
Enter 'N' to produce the report in employee name sequence.
-
Enter 'E' to produce the report in employee number sequence.
-
Enter 'S' to produce the report in employee SIN sequence.
The report lists the following:
-
Employee SIN and employee name
-
Pension type code 4, A or 5
-
The employee's pension status, Full or Part time
-
Employee's Pay Frequency
-
Pension reporting year
-
Employee's pensionable earnings
-
Employee's contribution amount
-
Employer contribution amount
-
Pension service amount
-
Employees From and To dates.
-
Employee's Worked Percentage, if part time
-
Employee's Annualized Salary bumped to 100% FTE
-
Grand totals.
-
Totals per detail type, UTF file per detail type