The DEDUCTION HISTORY COMPARISON REPORT generates a report comparing the employee and/or employer deduction amounts for two history pay periods for selective deduction codes.
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. Only values selected for reporting will be included on the export file.
The export file includes the following fields:
-
Payroll ID code
-
Employee number
-
Employee name
-
Deduction code
-
Deduction code description
-
First pay period employee amount
-
First pay period employer share
-
Total of first pay period employee and employer amount
-
Second pay period employee amount
-
Second pay period employer share
-
Total of Second pay period employee and employer share
-
Second pay period employee amount less first pay period employee amount
-
Second pay period employer share less first pay period employer share
-
Total of second pay period values less first pay period values
Default Prompt Storage & Retrieval
This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30-character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.
Batch and Print Queue Screen
Include Employee, Employer or Both Amounts [E/R/B]
Enter 'B' to include both the employee and employer deduction amounts on the report.
Enter 'E' to report only the employee deduction amounts.
Enter 'R' to report only the employer share deduction amounts.
Report Discrepancies Only or All Details [D/A]
Enter 'D' or <CR> to only report those employee entries where a discrepancy exists between the first and second pay period amounts.
Enter 'A' to report all details even when the employees deduction amounts equal for the two pay periods.
Enter Deduction Codes To Be Reported [##]
Enter the deduction codes one at a time to define a list of deduction codes to be included on the report.
Enter to continue when the list of deduction codes are complete.
Enter First History Pay Period [YYYYPP]
Enter the first history pay period to extract deduction amounts.
Enter Second History Pay Period [YYYYPP]
Enter the second history pay period to extract and compare deduction amounts.
Report All Or Selected Employees [A/S] .
Report By Employee Or Deduction Number [E/D]
Enter 'E' to generate the report organized by employee.
Enter 'D' to generate the report organized by deduction number.
Sort Employee By Employee Number Or Name [E/N]
Enter 'E' to sort the entries by employee number.
Enter 'N' to sort the entries by employee name.
Include Generation Of CSV Export File [Y/N]
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 lists the following:
-
Deduction code and description
-
Employee number and name
-
First pay period employee amount
-
First pay period employer share
-
Total of first pay period employee and employer amount
-
Second pay period employee amount
-
Second pay period employer share
-
Total of Second pay period employee and employer share
-
Second pay period employee amount less first pay period employee amount
-
Second pay period employer share less first pay period employer share
-
Total of second pay period values less first pay period values