Schedule/Absence Timesheet Matching Process

The Schedule/Absence Timesheet Matching Process does a timesheet matching of absences entered for the same date, position code and location as a schedule timesheet and reverses out the schedule timesheet for the number of hours of the absence. Replacement timesheets (specific batch code defined in Payroll Profile) match without the position and location criteria. This process is intended for use on payrolls where employees are being paid by timesheets generated from the Employee Schedule Timesheet Interface Module in the atrieveHR system. The scheduled timesheets represent the employee's full pay period time while absence entries, generated through the atrieveHR Absence system, may be time that should replace the scheduled time. This matching process will link the timesheets and reverse out the schedule time.

Absence timesheets with a prior or future period date are not included in the schedule matching process. These entries will automatically be reversed out using all the absence timesheet entry values except for the pay code will be replaced with the first schedule pay code defined in the Web Time Entry Payroll Profile. These entries will still be reported on the rejection report with a warning message to ensure the entries are not overlooked.

The fields Automatic Schedule Matching through to Absence / TEW Pay Code List on the Web Time Entry Payroll Profile allows you to control the batches included in this process and which pay codes represent schedule or absence time.
Batches created by this matching process will be generated using the reserved batch type code of SAM. Although batches with the type code of SAM may be edited, creation of batches with this batch type code is reserved for this matching process.

Field Automatic Schedule Matching on the Web Time Entry Payroll Profile allows you to indicate this process should be run automatically as part of the Earnings Detail phase of the payroll stream. Since the Earnings Detail phase may be run multiple times, this process is designed to remove all timesheets created under the reserved SAM batch code for this applicable pay period before rerunning this process. Once a batch has been processed through the Payroll Update the batch is marked as Updated and cannot be deleted. This process will not process timesheets for Updated batches.

Enter Pay Period

• Enter the pay period of timesheets to be processed.

Report All or Selected Employees

Report Only or Process

• Enter 'R' to generate just a report. The timesheet batch will not be generated.

• Enter 'P' to generate the reports and build the timesheet entry batch.

The ######.LST Timesheet report (#####S.LST from Earnings Detail) lists the following:

• The function line number

• The location code or card #, used on matching

• The position code per timesheet used on matching

• The date of the entry

• The employee number

• The shift code

• The pay code and description

• The hours generated

• The rate per hour

• The rate including all premiums

• The pay code, shift and occupation premium amounts

• The GL account code used

 The #####R.LST Rejection report is sorted by employee name within rejection reason, and lists the following:

• The employee number and name

• The timesheet date

• The position and location or card # from timesheet

• The hours from rejected timesheet

• The message describing the rejection reason

• Total number of rejected records