This report lists all deductions as entered against an employee. The report will also list all employees with a deduction. The Amount will be reported as <###.##> when the Pension Eligible Override is on for a specific pension deduction. This report includes the option of only reporting suspended deductions, to supply a listing of those employees with a given deduction suspended.
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 extra spaces removed from 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
-
Employee Status
-
Deduction code
-
Deduction description
-
Deduction Table Code (blank when not applicable)
-
Frequency code
-
Start period
-
End period
-
Deduction Amount
-
Deduction Limit
-
Deduction Share %
-
Employer's share to date
-
Eligible earnings to date
-
Deducted amount to date
-
Taxable Benefit amount to date
-
Pension Eligible Override marker Y/N
Report by Employee Number or Name
-
Enter 'N' to produce the report sorted by employee name.
-
Enter 'E' to produce the report sorted by employee number.
Deduction Code to Report
-
Enter 1 to 26 deduction codes, one at a time, to be reported. When you report on selective deduction codes, only those employees with the deduction will be listed.
-
Accept default to report on all deduction codes.
Include / Exclude Suspended Deductions
-
Enter 'I' to include all selected deductions on the report.
-
Enter 'E' to omit all suspended deductions from the deductions selected to be reported.
-
Enter 'O' to only report suspended deductions from the deductions selected to be reported.
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 with this report.
This report lists the following:
-
Employee number, name and status when applicable
-
Deduction code and description,
-
Deduction Table Code (if applicable)
-
Frequency—for each deduction
-
Start/End periods, Amount, Limit, Share % – for each deduction
-
Employer's share to date: – for each employee deduction
-
Eligible earnings, Deducted amount to date: – for each deduction
-
To date deduction—the deducted amount for the entire period range for the specific deduction codes entered.
-
To date benefits—the taxable benefits per deduction code.