The Batch Transaction Analysis Report allows you to report on expanded batch transactions (gross earnings) based on employee number for a range of pay periods or batch codes. This report produces batch transactions per employee in date order with a blank line separating actual weeks of transactions. Variable deduction transactions are omitted from this report. The report allows selection of employees based on employee pay cycle codes or status, which allows for reporting of or exclusion of employees based on status. This report also allows for the definition of specific pay codes to be either included or excluded from the report.
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
-
Employee status
-
Cost Center code
-
Occupation code
-
Batch number
-
Salary grid
-
Pay code
-
Description
-
Input rate
-
Card number
-
Date
-
Hours
-
Sub total of hours per date
-
Earnings (less premiums)
-
Premiums (include shift and occupation premiums)
-
Gross earnings (total earnings and premiums)
Enter Starting Batch to Report
-
Enter a starting range for transaction selection. The starting pay period range must be entered (YYYYPP), although you may enter as much or as little of the batch code and document number values (TTTSS) required to select the transactions to be reported. Note: The century is not automatically added for these batch entries.
For example:
You may enter only the pay period YYYYPP to start selection at that pay period. You may enter the pay period and batch code YYYYPPTTT, for selection starting at a specific pay period and batch code.
You may enter the pay period, batch code and document number YYYYPPTTTSS to start the transaction selection at a specific batch.
Enter Ending Batch to Report
-
Enter an end range for transaction selection. The end pay period range must be entered (YYYYPP), although you may enter as much or as little of the batch code and document values (TTTSS) required to select the transaction to be reported.
Selection by Employee Number or Pay Cycle Code
-
Enter 'E' to select employees by employee number.
-
Enter 'C' to select employees by pay cycle code.
Report All or Selected Employees
When 'C'YCLE Code was selected:
Enter the Pay Cycle Codes for Employee Selection
-
Enter up to 38 pay cycle codes for employee selection. Only employees with one of these pay cycle codes on the master function line will be included on the report.
Enter Optional Salary Grid for Timesheet Selection
-
Enter one or up to 11 salary grids. Only those timesheets with one of the selected salary grids will be included on the report. You may enter a valid salary grid or any combination using the wild card '?'. The '?' character means that the element value is to be taken from the timesheet salary grid code to form a new selection code. For example, enter a selection salary grid with the value of CS????, means include timesheets where on the salary grid code begins with 'CS'.
When 'A'll or 'R'ange was selected:
Select Employee Statuses To Be Reported
The employee selection by employee status allows you to select one or more employee statuses to be included.
-
Enter 'A' to select Active employees.
-
Enter 'T' to select Terminated employees.
-
Enter 'O' to select On Leave employees.
-
Enter 'B' to select On Leave With Benefits employees.
-
Enter 'F' to select all employees.
Enter Optional Starting Date Range
-
Enter a start date for a range of dates to be reported.
Enter Optional Ending Date Range
-
Enter an ending date for a range of dates to be reported.
Report by Employee Number or Name
-
Enter 'E' to produce the report in employee number sequence.
-
Enter 'N' to produce the report in employee name sequence.
Enter Pay Code Include/Exclude
-
Enter 'E' to indicate the following list of pay codes will be excluded from the report.
-
Enter 'I' to indicate that the following list of pay codes will be included on the report.
Enter Pay Codes
-
Enter 1 to 25 pay codes to be included or excluded from the report.
Include Employee Pay Code Total
-
Enter 'N' to omit the summary by pay code per employee.
-
Enter 'Y' to include a summary per pay code per employee on the report.
-
Enter 'O' to include the summary per pay code per employee while omitting printing the transaction details per employee.
The following prompt only applies when 'Batch Transaction Summary Criteria' in the User Specific Parameters Profile was filled in
Produce Summary Criteria
-
Enter 'N' to have the summary criteria reporting omitted.
-
Enter 'Y' to include the summary criteria reporting.
Omit Page Break per Employee
-
Enter 'N' to page break per employee.
-
Enter 'Y' to omit the page break per employee.
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 information:
-
Page break per employee, when applicable
-
Employee number, employee name, employee status
-
Cost center code
-
Occupation code
-
Batch code
-
Shift code
-
Pay code and description
-
Input rate per hour
-
Timesheet Card number
-
Date
-
Hours input
-
Sub total of hours per date
-
Earnings (less premiums)
-
Premiums (include shift and occupation premiums)
-
Gross earnings (total earnings and premiums)
-
Total per employee
-
Total per employee and total for all employees