The Pension Eligibility Report reports on employees who do not currently have pension but meet the pensionable requirements for one or both selected pay period ranges. This option produces two separate reports. The first report lists employees that are eligible for pension for both specified pay period ranges. The second report lists those employees that did not meet the requirements for the earlier pay period range but do meet the requirements for the second or more recent pay period range. Employees not meeting the requirements of either pay period ranges are omitted from this report.
An employee is considered eligible for pension in a specific pay period range when an employee's pension-able earnings meet or exceed a percentage of that years YMPE values.
A second window will allow for the insertion of additional payroll definitions to be included on the report. This cross-payroll reporting will allow employee's pension values from other payrolls to be included on this report. Each subsequent pay id would have a separate pay period range, pay code and pension deduction definitions.
This report includes an option to generate an export file, ######.CSV, where ###### is the job number. The CSV file is generated in the work directory of the payroll, pointed to by the logical SRB$OPSWRK. The CSV file can be opened directly in Excel or emailed from the Email process on the main menu.
The export file includes the following fields:
-
Employee number
-
Employee name
-
Employee Status
-
Payroll ID
-
Current Hire Date
-
Original Hire Date
-
First Year Earnings
-
Second Year Earnings
Enter Starting Pay Period for First Year
-
Enter the pay period for a range of periods to define the first/earliest reporting year.
Enter Ending Pay Period for First Year
-
Enter the ending pay period for a range of periods to define the first or earliest reporting year.
Enter Starting Pay Period for Second
-
Enter the pay period for a range of periods to define the second or most recent reporting year.
Enter Ending Pay Period for Second Year
-
Enter the ending pay period for a range of periods to define the second or most recent reporting year.
Exclude Terminated Employees
-
Enter 'N' to include terminated employees on this report.
-
Enter 'Y' to excluded terminated employees from this report.
Enter Pension Deduction Codes
-
Enter the pension deduction codes one at a time. At least one pension deduction code must be entered. Only employees that do not have any of the listed pension deduction codes will be reported.
-
Accept the default to continue when the list of pension deductions is complete.
Deduction codes with a frequency of '*' (suspended) will be ignored. (The employee will be reported.)
Include / Exclude Pay Code List
-
Enter 'E' to indicate the following list of pay codes are to be excluded from the calculation of the employee's total pensionable earnings.
-
Enter 'I' to indicate the following list of pay codes are the only pay codes to be included in the calculation of the employee's total pensionable earnings.
Enter Pensionable Pay Codes
-
Enter the pay codes one at a time to define a list of pay codes to be included or excluded in the calculation of the employee's total pensionable earnings.
Enter YMPE Value for the First Year
-
Enter the dollar value of the Yearly Maximum Pensionable Earnings for the first or earliest year.
Enter Eligibility Percentage for the First Year
-
Enter the percentage of YMPE that defines the eligibility for pension in the first or earliest year.
Pension eligibility for the first year is determined by multiplying this percentage by the YMPE value for the first year. An employee's pensionable earnings must be greater than or equal to this calculated amount for the first year for the employee to be considered eligible in the first year.
Enter YMPE Value for the Second Year
-
Enter the dollar value of the Yearly Maximum Pensionable Earnings for the second or most recent year.
Enter Eligibility Percentage for the Second Year
-
Enter the percentage of YMPE that defines the eligibility for pension for the second or most recent year.
Pension eligibility for the second year will be determined by multiplying this percentage by the YMPE value for the second year. An employee's pensionable earnings must be greater than/equal to this calculated amount for the second year for the employee to be considered eligible in the second year.
Include Generation of CSV Export File
-
Enter 'N' to omit the generation of the export file.
-
Enter 'Y' to include the generation of the export file.
The report lists the following:
-
Employee number
-
Employee name
-
Employee Status
-
Payroll ID
-
Current Hire Date
-
Original Hire Date
-
First Year Earnings
-
Second Year Earnings
-
Totals