This report lists employees' total earnings information against the information for one specific deduction for a specified pay period range. The earnings information consists of total earned hours and amounts. The deduction information consists of the specified deduction's share, eligible and amount. All employees or a selected group of employees can be reported. Terminated or on-leave employees can be included on the report if desired.
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 employee's activity status
-
Total employee share plus employee deduction amount