Timesheet Position Transaction Report

The Timesheet Position Transaction Report allows you to report on timesheet transactions for a range of pay periods with the focus based on the matching criteria used by the Schedule/Absence timesheet matching process. This report not only reports on the new atrieveHR position code used for timesheet matching by the Schedule/Absence Timesheet Matching Process, but the entries are reporting sorted within employee name or number but date, position and card # as used for matching. Variable deductions 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
Timesheet date
Position Code
Card #
Batch code
Salary Grid
Cost center code
Occupation Code
Shift code
Pay code
Description
Input rate per hour
Hours input
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 based on employee number.
Enter 'C' to select employees based on a list of pay cycle codes.

When 'E'mployee was Selected:

Report All or Selected Employees Cycle Code

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 employee's with one of these pay cycle codes on the master function line will be included on the report.

When 'A'LL or 'C'YCLE was Selected:

Select Employee Statuses To Be Reported

The employee selection by employee status allows you to select one or more employee status's to be included.

Enter 'A' to select Active employees.
Enter 'T' to select Terminated employees.
Enter 'L' to select On Leave employees.
Enter 'B' to select On Leave With Benefits employees.
Enter 'F' to select all employees.

Enter Starting Date Range

Enter a start date for a range of dates to be reported.

Enter 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 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 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:

Employee number, employee name, employee status
Timesheet date
Position Code
Card #
Batch code
Salary Grid
Cost center code
Occupation code
Shift code
Pay code and description
Input rate per hour
Hours input
Premiums (include shift and occupation premiums)
Gross earnings (total earnings and premiums)
Total per employee
Total per employee and total for all employees