The DEDUCTION ANALYSIS REPORT is used to list current and year to date information on specific deductions codes. It also lists actual and eligible earnings for the period range 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 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
-
Current earnings
-
To date earnings
-
Current eligible
-
To date eligible
-
Current deduction amount
-
To date deduction amount
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 Codes to Report
-
Enter the deduction code to be reported representing those deductions to be accumulated in the report.
NOTE: This prompt will continue to be displayed until all deduction codes are entered.
Enter Start Period[YYYYPP]
-
Enter the pay period number to start the range.
Enter End Period
-
Enter the pay period number to end the range.
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 will list the following:
-
Employee number and name
-
Current earnings the pay amount for the end pay period entered.
-
To date earnings the pay amount for the entire pay period range.
-
Current eligible the eligible earnings summed up for all the deduction codes entered, for the ending pay period only.
-
To date eligible the eligible earnings for the entire pay period range for the deduction codes entered.
-
Current deduction the ending pay period employee deducted amount for the deduction codes entered.