LAPP APEX Generation Report

The LAPP APEX Generation Report process generates the LAPP report and APEX annual electronic file for submission to the pension board. All values generated by this report can be adjusted as necessary through the LAPP APEX Adjustments process. Changed values would then be regenerated through the LAPP APEX Regeneration Report. The pension service is accumulated from the pension credits attached to each pension deduction. Changes to the pension credits is available through the Pension Credit Changes or the Pension Credit Recalculation process.

This report may create three types of pension records. The annual type 4 records must be submitted and accepted before any adjustments including retro can be submitted. Due to this requirement, this process generates two separate electronic files, the first only contains the type 4 records and the second will contain any A or 5 records.

Type 4 Report the annual year-end detail record.

Type A Report non-parenting LWOS (Leave Without Salary) earnings and service.  This entry will produce a Notice of Cost (for optional buy back) and if the cost is over $500.00, an amortization schedule will be produced. This ‘A’ record is created when an employee has a period of time without salary. This process will estimate the missing earnings based on the pay period earnings prior to the LWOS. Refer to page 7.4 of the LAPP manual, 1988 for more details.

Type 5 Report retroactive salary adjustments which includes: salary, member contributions and employer contributions.  Retro can be handled by either a specific pay code or preferably a separate retro pension deduction.  When a separate retro deduction is used, the retro earnings reported are based on the eligible earnings from the retro pension deduction. 

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.

This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The export file is generated where the logical SRB$OPSWRK is defined. All fields within the export file have any extra spaces removed from the front and back of the fields and all fields are separated by a comma.

The export file includes the following fields:

• Employee Number

• Employee Name

• SIN

• Type

• Status

• Pay Frequency

• Pensionable Salary

• Employee Contribution

• Employer Contribution

• Pensionable Service

• From Date

• To Date

• Part Time Percentage

• 100% Annual Salary

• Province of Work

• Affiliation.

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 Starting Pay Period / From Date

• Enter the payroll period number to use as the starting point for the data collection. The pay start date from the calendar selected will be used as the From Date.

When an employee's LAPP Hire Date is more recent than the default From Date, the employee's LAPP Hire Date will be used as the From Date.

Enter Ending Pay Period / To Date

• Enter the ending payroll period to be used in the data collection process. The pay ending date from the calendar selected will be used as the To Date.

When an employee is Terminated and the Termination date is earlier than the default To Date, the employees Termination date will be used as the To Date.

Select Date for Employee's Hire Date

• Enter 'O' to use the employee's Original Hire Date as the override value for the From Date.

• Enter 'C' to use the employee's Current Hire Date as the override value for the From Date.

• Enter 'S' to use the employee's Seniority date as the override value for the From date.

• Enter 'I' to use the employee's Increment date as the override value for the From date.

• Enter 'V' to use the employee's Vacation date as the override value for the From date.

Enter Pension Service Year

• Enter the year to be used as the pension service year.

Enter Pension Deduction Codes

• Enter at least one or up to 25 pension deduction codes to be reported. The employee must have at least one of these deductions currently on their deduction master to be included on this report.

Enter Employer Number

• Enter a 4-digit number assign to each employer.

Report All or Selected Employees

Enter Date for Termination Exclusion

Enter a termination exclusion date. All terminated employees with a Termination date prior to the exclusion date will be omitted from the report.

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.

Retro Pay Codes to Be Reported

• Enter one or more pay codes that represents the retroactive portion of the previously enter pension deduction. Use this feature when the retro has been paid combined with the regular pension earnings under the regular pension deduction. The employer and employee contributions will be determined based on a ratio of retro earnings to regular pensionable earnings.

Retro Deduction S Codes to BE Reported

• Enter one or more deduction codes that represent the retroactive pension for the range of pay periods previously defined for this report. The total employee and employer retro contribution is accumulated from the retro pension deduction. The eligible earnings of the retro pension deductions determine the retro earnings. When retro is included it is reported as a separate entry as a type 5.

Only When Retro Pay or Deduction S Codes are Defined:

Enter Retro From Date

• Enter the starting date of the retro range. When an employees Original Hire Date is more recent than the default retro From Date, the employees Original Hire Date will be used as the From Date.

Enter Retro to Date

• Enter the ending date for the retro range. When an employee is Terminated and the Termination date is earlier than the default retro To Date, the employees Termination date will be used as the retro To Date.

NOTE: An override to the pension service exists on this report that will force the total pension service to 1.000 when the total pension service equals .9996 or greater.

Include generation of CSV export file:

Enter 'N' or enter to omit the generation of the export file.

Enter 'Y' to include the generation of the export file.

The report lists the following:

• Employee SIN and employee name

• Pension type code 4, A or 5

• The employees pension status, Full or Part time

• Pension reporting year

• Employees pay frequency

• Employees pension-able earnings

• Employees contribution amount

• Employer contribution amount

• Pension service amount

• Employees From and To dates

• Employee's FTE when employee is Part time.

• Employee's Annualized Salary bumped to 100% FTE.

• Grand totals

• Totals per detail type, UTF file per detail type

The following describes the fixed field size format UTF file fields and contents.

Detail Transaction Record

** For hourly employees with no Percentage Employed on their function lines, the report totals the employee's pension credits for the range of pay periods defined, counting the number of pay periods the employee worked. An average pension credit (total divided by number of periods worked) is then annualized base on the number of pay periods defined on the employee's pay cycle code. This determines the employee's full FTE.

Hourly employees have their annualized salary determined by averaging the total pension eligible earnings by the number of periods worked and annualized by multiplying by the number of pay periods from the employee's pay cycle code.

Batch Summary Record