This report lists deduction amounts, eligible earnings and hours or deduction amount, eligible earnings, employer share and total deduction (employee portion plus employer portion) for the deduction codes selected.
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 name
-
Employee number
-
SIN when applicable or empty column
-
Deducted amount
-
Eligible earnings
-
Hours worked or Employer Share, depending on selection
-
Pay cycle from master function line
-
Deduction code and table, when applicable
Report by Employee No 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 the deduction code(s) to be reported, one at a time. Enter at least one deduction code.
When One or More Deduction Selected is a Table Deduction:
Report Breaks per Deduction Table
-
Enter 'N' to generate the report summarized by employee.
-
Enter 'Y' to generate the report sorted by deduction code tables with a page break per deduction table. Each deduction and table will report the applicable employees with totals.
Enter Starting Pay Period[YYYYPP]
-
Enter the starting pay period number to report on.
Enter Ending Pay Period[YYYYPP]
-
Enter the ending pay period number to report on.
Omit Employee’s SIN
-
Enter “N’ to include the employee's SIN on the report.
-
Enter 'Y' to omit the printing of the employee's SIN on the report.
Report Hours or Employer Share
-
Enter 'H' to include the employee’s hours worked.
-
Enter 'S' to generate a report that lists the employer share as well as the total employee and employer portions.
When report Hours was selected:
Enter Hours Pay Code Include/Exclude
-
Enter 'E' to indicate the hours for the pay codes entered on the following prompt are to be excluded from the reported.
-
Enter 'I' to indicate the hours for the pay codes entered of the following report are to be included on the report.
Enter Hours Pay Codes
-
Enter the pay codes to determine the hours to be include/excluded from the report.
Selection by Cycle Code
-
Enter to report employee regardless of pay cycle code.
-
Enter pay cycle codes, one at a time, to define the employees to be reported. Employees who have a master function line with one of the selected pay cycles will be included on the report.
Enter Non-Eligible Pay Codes For Summary
-
Enter to omit the Non-eligible pay code summary.
-
Enter one or more pay codes, one at a time. The earnings for the selected pay period range for the pay codes selected will be included on an earning summary following this deduction report.
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.
The report will list the following:
-
Employee name and number, SIN if accepted
-
Deduction amount, eligible earnings, and hours
-
Hours worked, when selected.
-
Employer share and total of employee plus employer share, when selected.