The LIFE INSURANCE COVERAGE COMPARISON REPORT generates a report comparing the current Payroll Processing life insurance coverage results with a prior period coverage results and detailing the differences. The pay period for the history coverage amounts is based on the employee's pay cycle as well as the deduction frequency codes. The ‘coverage’ applies to Group 3 Type 5 deductions (only) where the deduction has been defined to store the life insurance coverage under the deduction eligible earnings field on the history record. Refer to the EXTRA line of the Group 3 Type 5 deduction definition under the deduction code data base.
This report accesses temporary files created by running the Payroll Processing. This report cannot be run until the applicable Payroll Processing phase has been completed.
The Life Insurance Coverage Comparison field, under the Users Specific Parameter Profile, supplies the option of having this report automatically generated during the Payroll Processing run. This prompt also allows you to define which life insurance deductions are to be included on the report. Life insurance deductions other than Group 3 Type 5 may be included, although no coverage amount will be reported.
When this report is generated automatically under the Payroll Processing run the report can also be archived through the Pay Report Output system. The Payroll Processing run will use the prompt values from the stored prompt set called 'DEFAULT' for all prompts except for the pay period prompt values. When no prompt set called 'DEFAULT' exists, the Life Insurance Coverage Comparison report is generated with no omissions, no forgiveness factor and sorted first by deduction then based on the Sort Sequence Employee ##, Department Or Name field of the User Specific Parameters Profile.
NOTE: This report can only be run after completing the Payroll Processing run and before the Payroll Update.
Default Prompt Storage & Retrieval
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.
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.
NOTE: This Report will on Run in Batch.
Batch and Print Queue Screen
Omit Zero Coverage Differences [Y/N]
Enter 'N' to include all employee entries on the report.
Enter 'Y' to omit entries where the coverage difference is zero. This option gives you a listing of just changes between the two pay periods.
Enter Current Pay Period [YYYYPP] < >
Enter the pay period for which the Payroll Processing was run.
Enter a Forgiveness Factor [####.##]
Enter a forgiveness factor. Coverage differences that are off by the amount of the forgiveness factor, will be omitted from the report. The forgiveness factor covers both positive and negative values. For example a forgiveness factor of 1.00 will omit entries that are from –1.00 through to 1.00.
Report By Employee Or Deduction Number [E/D]
Enter 'E' to generate the report organized by employee.
Enter 'D' to generate the report organized by deduction number.
Sort Employee By Employee Number Or Name [E/N]
Enter 'E' to sort the entries by employee number.
Enter 'N' to sort the entries by employee name.
Include Generation Of CSV Export File [Y/N]
Enter 'N' to omit the export file.
Enter 'Y' to include the generation of the export file. Note: An Excel button is not available as this option is a batch only process.
The CSV export file contains the following:
-
Employee number
-
Employee name
-
Deduction Code
-
Deduction Description
-
Current Employer Share
-
Current Employee Taken
-
Current Coverage
-
Prior Coverage
-
Coverage Difference
The report lists the following:
-
Employee number and name
-
Deduction code and description
-
Current pay period employer share
-
Current pay period employee taken
-
Current pay period coverage amount
-
Prior pay period coverage amount
-
Coverage difference
-
Summary totals per deduction