The LAPP APEX Regeneration Report produces the report and UTF pension files for submission to the Alberta pension authorities. This report processes the pension transactions first generated under the LAPP APEX Generation and then changed through the LAPP APEX Adjustments.
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.
For complete details on the fields and contents of the UTF file, refer to the LAPP APEX Generation documentation.
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. The prompt set description will be included on the header of the report.
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 Service Year
-
Enter the year to be used as the pension service year.
Enter Employer Number
-
Enter a 3-digit number assign to each employer.
Sort by Name, Employee Number 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
-
Employees Pay frequency 1, 2, 3, or 4
-
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