Life Insurance Coverage Report

This report can only be used with Group 3 Type 5 life insurance deductions and only when the deduction is defined to use the As Of Salary or Fixed coverage where the actual coverage has been loaded in to the employee's limit field.

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 Premium Amount export file includes the following fields:

Payroll ID code
Employee number
Employee name
SIN/SSN
Deduction code
Description
Birth date
As of Age
Gender
Employer premium
Employee premium
Coverage

The As Of Salary export file includes the following fields:

Payroll ID code
Employee name
Employee number
SIN/SSN
Deduction code
Description
Birth date
As of Age
Gender
As of Salary
As of Date
Coverage

Enter Life Insurance Deduction Codes

Enter 1 to 25 valid Group 3 Type 5 life insurance deductions to be reported.

The age setting on the first deduction entered determines the reporting of the heading used for the age column. If the first deduction entered uses the As Of Age the report header will list the age under 'As of Age'. If the first deduction entered uses the actual age the report header will list the age under 'Age'.

Include / Exclude Suspended Deductions

Enter 'I' to include suspended deductions.
Enter 'E' to exclude suspended deductions.

Report All or Selected Employees

The following prompt is omitted if Selected Employees was used:

Report Employees Terminated / On Leave / Both

Report Premium Amounts or As of Salary and Date

Enter 'P' to report the employee and employer premium amounts.
Enter 'A' to report the employees As of Salary and As of Date instead of the premium values.

Sort Report By Employee Number or Name

Enter 'E' to produce the report in employee number order.
Enter 'N' to produce the report in employee name order.

Report Employee Number or SIN

Enter 'E' to produce the report reporting the employee number.
Enter 'S' to produce the report reporting the employee's SIN in place of the employee number.

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:

The employee's number and name
Deduction code and description
Employee's birth date
Employee's age, actual age or as of age as per each deduction definition
Employee's gender
Employer portion or employee's As Of Salary
Employee deduction amount or employee's As Of Date
Employee's coverage amount

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:

Payroll ID code
Employee number
Employee name
Hours per deduction
Earnings per deduction
Employer share
Eligible earnings
Employee deduction taken
Total employee and employer deduction amounts
Employee's status

Report by Employee or Name

Enter 'E' to produce the report in employee number sequence.
Enter 'N' to produce the report in employee name sequence.

Enter Start Period[YYYYPP]

Enter the period you wish to start the report.

Enter End Period[YYYYPP]

Enter the last period you want included in the report. The ending period must be equal to or greater than the starting period.

Employee Deduction Code

Enter the deduction code to be reported.

Report All or Selected Employees

Report Employees Terminated / On Leave / Both

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:

The employee number and name
The hours and earnings as defined by the deduction
The employer share, eligible earnings and employee amount for deduction
The employees activity status
Total employee share plus employee deduction amount

CPP with Full Exemption was selected this prompt will omit all employees that have not under-contributed.

Enter 'N' to report all employees EI and/or CPP calculations.

Enter a Forgiveness Factor [####.##]

Enter a forgiveness factor. Calculations 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.

When more than one payroll was selected, the follow prompt appears:

Report Only Employees with Multiple Payrolls

Enter 'N' to include employees with only one payroll entry.
Enter 'Y' to only include those employees with multiple payrolls.

Sort Employees By Employee Number or Name

Enter 'E' to generate the report in employee number sequence.
Enter 'N' to generate the report in employee name sequence.

The EI detail lists the following:

The employee number, name and status
The payroll ID code
The deduction code and description
Non-eligible earnings (excluded earnings)
Eligible earnings, based on the include/exclude list of the deduction
Taxable benefits, based on the include/exclude list of the deduction
Accumulated Share taken
Accumulated Eligible Earnings taken
Accumulated employee deduction amount taken
Recalculated employee deduction amount
Difference between actual taken and recalculated amount, a positive indicates an under-contribution while a negative difference indicates an overage in contributions.

Combined EI Recalculation lists the following:

Re totaled EI insurable earnings
Accumulated employee deduction amount taken
Combined recalculated employee deduction amount
Difference between actual taken and combined recalculated amount, a positive indicates an under-contribution while a negative difference indicates a overage in contributions.

** Indicates a combined calculation where the re totaled insurable earnings do not match the accumulated YTD earnings.

The CPP detail lists the following:

The employee number, name and status
The payroll ID code
The deduction code and description
Non-eligible earnings (excluded earnings)
Eligible earnings, based on the include/exclude list of the deduction
Taxable benefits
Periods paid out of total periods per year
Exemption amount used (yearly exemption divided by periods in year multiplied by periods paid so far)
Accumulated Share taken
Accumulated Eligible Earnings taken
Accumulated employee deduction amount taken
Recalculated employee deduction amount
Difference between actual taken and recalculated amount, a positive indicates an under contribution while a negative difference indicates an overage in contributions.

Combined CPP Recalculation lists the following:

Number of months of exemption
Actual CPP eligible earnings and calculated CPP exemption
Eligible earnings reduced by CPP exemption amount
Accumulated employee deduction amount taken
Combined recalculated employee deduction amount
Difference between actual taken and combined recalculated amount, a positive indicates an under-contribution while a negative difference indicates a overage in contributions.

** Indicates a combined calculation where the re totaled insurable earnings do not match the accumulated YTD earnings.

On Leave without reactivating them. When the ALLOW RETRO field is inactive, then this prompt will generate a separate report listing the retro amount for the Terminated and On Leave employee without creating a retro entry.

If 'Y' is selected, the following prompt will appear:

Exclude Terminated Employees Prior to Date

Enter a date. Employees terminated prior to that date are NOT included in the retro calculations.

Leave the Termination date empty to indicate that only those Terminated employees with retro to be reported will be included.

Omit Reporting Terminated Employees with Zero Retro

Enter 'N' to include Terminated employees within the selection criteria even when they have zero retro.
Enter 'Y' to exclude Terminated employees with zero retro.

Exclude Employees by Employee Number / Salary Grid / Cycle / None

Enter "N' when no specific employees should be excluded from this retro processing.
Enter 'E' to select specific employees based on employee number to be omitted from this retro processing.
Enter 'S' to define specific salary grids for employee exclusion.
Enter 'C' to define specific pay cycle code for employee exclusion.
If 'E' selected above, the following prompt will appear:

Enter the Number of Employee(s) to be Excluded

Enter employee numbers one at a time for those employees to be omitted from the retro process.

If 'S' selected above, the following prompt will appear:

Enter Salary Grids for Employee Exclusion [XXXXXX]

Enter up to 55 salary grids for employee exclusions. Employees with one of these salary grids on their master function line will be omitted from the retro process.

If 'C' selected above, the following prompt will appear:

ENTER pay cycle codes FOR EMPLOYEE EXCLUSION [X]

Enter up to 38 pay cycle codes for employee exclusions. Employees with one of these pay cycle codes on their master function line will be omitted.

Report Only or Process

Enter 'R’ to generate just a report. The retro entries will not be generated.
Enter 'P' to generate the reports and process the retro timesheet entry batch.

Enter Batch Period

Enter the pay period for the batch. This should be the period in which the retro is to be paid. Employees not in cycle for this pay period will be bypassed.

Enter BatchPay Code

Enter the default pay code under which to pay the retro. Retro should be paid out under a money only pay code.

Batch Pay Code Exceptions allow retro from selective pay codes to be paid out under either the same pay code or another pay code. This feature will split the retro to be paid to multiple pay codes based on the ratio of earnings per pay code.

Enter the pay code from history followed by the pay code to be used for payment of the retro for those earnings. Use the wild card * to indicate all digits in a series. For example, 7* means all 70 series pay codes.

Use the <UP>/<DOWN> arrows to move through the list of pay codes to make necessary changes. Press <PF2> to clear a pay using pay code or when clearing a pay code then <CR> will remove a specific line.

Enter Batch Type

Enter a valid batch type code. The batch type code entered will be used to generate batches of retro transactions. This is validated by the system.

The report will list the following:

Employee number and name
Employee's salary grid or occupation code when selection is applicable
Employee accumulated gross pay when applicable
Employees total retro amount
Employee retro and costing distribution
GL account and cost center when costing by GL history was selected.

The final run will create the payroll batches of transactions. The batch numbers generated will appear in the program log.

NOTE: On-leave employees are only reported if the terminated employee report is selected. NO costing is done on Terminated/On-Leave employees. The amounts of retro pay for these types are reported only.

The report containing the Terminated and On-Leave employees is produced and printed separately. The report number is #####T.LST where ##### is the first 5 characters of the retro pay job number.