This report produces totals for an input pay period range. It lists total gross, net, and deductions as well as pay code and deduction code information. Short pay and deduction code descriptions applied when applicable.
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 (omitted for summary selection)
-
Employee name (omitted for summary selection)
-
Type Earnings or Deductions
-
Code (pay or deduction)
-
Description
-
Hours or Share
-
Earnings or Eligible
-
Deduction Taken
-
Taxable Benefit
Enter Starting Pay Period
-
Enter the starting pay period for the range.
Enter Ending Pay Period
-
Enter the ending pay period for the range.
Report Pay / Adjustment / Manual Cheque / Cheque Cancel
-
Enter the history record type to report on, to report all history types.
More than one history type can be reported on at one time. The record types selected are displayed below the prompt as each type is selected. The report heading also reflects the history types selected for that report.
Select Employees by Employee Number, Salary Grid GL Segment
-
Enter 'E' to select employees based on employee numbers.
-
Enter 'S' to select employees based on the salary grid from the master function line.
-
Enter 'G' to select employees based on the GL account on the master function line or based on GL accounts from the employee's GL history.
Report All or Selected Employees
When selection by 'S'alary grid was chosen:
Enter Range of Salary Grids or A List of Salary Grids
-
Enter 'R' to enter a range of salary grids for employee selection.
-
Enter 'L' to enter a list of salary grids for employee selection.
When selection by a 'R'ange of salary grids was chosen:
Enter Start Salary Grid
-
Enter a starting salary grid for a range of salary grid for employee selection.
Enter Last Salary Grid
-
Enter the ending salary grid for a range of salary grids for employee selection. Employee selection is based on the salary grid from the master function line.
When selection by a 'L'ist of salary grids was chosen:
Enter Salary Grids for Selection Criteria
-
Enter salary grids one at a time for a list of up to 15 salary grids to define the employee selection.
When selection by a 'G'L segment was chosen:
Enter GL Selection Criteria Code
-
Enter a predefined GL selection criteria code. Use look-up for access to all available GL criteria code definitions. For complete documentation on the use of GL selection criteria codes please refer to Appendix AK in the Finance manual. NOTE: Payroll does not utilize the Alias code, therefore GL selection criteria used in payroll should not include Alias code definitions.
GL Selection Based on Function Lines or GL History
-
Enter 'F' to specify that the GL selection of employees should be based on the GL accounts on the employee's master function line.
-
Enter 'H' to specify that the GL selection of employees should be based on the GL accounts from the employee's GL history. This option reviews the GL account history per pay period to determine when an employee's pay period information will be included. An employee's totals represent the accumulated pay periods where the GL selection criteria was met. The GL history entries included in the selection process match the history record types selected to be reported. For example, when only Cheque Cancellation records were selected to printed then only Cheque Cancellation GL history will be review for employee selection.
Generate Full or Summary Only Report
-
Enter 'F' to select a full report.
-
Enter 'S' to generate a report that only contains the pay code and deduction code summary information.
When a Summary report is required, you are not prompted for the sort sequence.
Sort by Employee Number, Name or Location
-
Enter 'E' to sort the report by employee number.
-
Enter 'N' to sort the report by employee name.
-
Enter 'L' to sort the report by location
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 following is listed on the report for the pay period range inclusive, for each employee on file for a full report:
-
Employee number and name
-
Regular hours - '+' pay code
-
Other hours - '*' pay code
-
Regular earnings - '+' or 'M' pay code
-
Other earnings - '*' pay code
-
Gross earnings, taxable earnings, Taxable Benefits
-
Statutory deductions - group 6-9
-
Non-voluntary deductions - group 1-3,5
-
Voluntary deductions - group 4
-
Total deductions, Net pay
For each pay and deduction code:
-
Code and description
-
Hours - pay code only
-
Amount
-
Eligible earnings, employer's share, Taxable Benefit - deduction code only