Time Entry Adjustment Process
The Time Entry Adjustment process will calculate the employees daily average wage for the 30 calendar days immediately preceding the selected timesheet entry date. The selected timesheet entry will be updated with the total daily average wage is divided by the unit of time on the timesheet, thus totaling the daily wage.
This process may be run for the current payroll only or you can include other payrolls and have the employees total daily average based on all earnings for the previous 30 calendar days.
The export file includes the following fields:
Payroll ID code
Employee number
Employee name
Time entry date
Pay Code
Pay Code Description
Hours on time entry
Original rate on time entry
Start date of 30-day range
End date of 30-day range
Number of days worked in 30-day range
Total earnings accumulated over the 30 days
Average Daily earnings
New timesheet rate
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.
Starting Period/Batch to Report
Enter a start range for batch transaction selection. The start 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 batch transactions to be processed.
NOTE: The century is NOT automatically added.
Ending Period/Batch to Report
Enter an end range for batch 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 number values (TTTSS) required to select the batch transactions to be processed.
NOTE: The century is NOT automatically added
Report All or Selected Employees
Enter 'A' for All
Enter 'S' for Selective
Pay Codes to be Recalculated
Enter one or up to 20 pay codes to be selected to have the pay rate recalculated and updated.
Pay Codes to be Excluded from Averaging
Enter a list of pay codes that are to be omitted from the daily average accumulation of earnings.
Include Earnings From Additional Payrolls
Enter one or multiple payroll ID's along with the payroll type and any pay codes to be excluded from that payroll
For payroll type:
Enter “T” when the other payroll is a timesheet driven payroll and the process should read the employee timesheets for the previous 30 calendar days.
Enter ‘S’ when the other payroll is not a timesheet payroll and instead the process will use the HR scheduling system to determine the employees’ working days for the previous 30 calendar days. The pay period from this other payroll are selected based on the 30 day range. The history earnings from those pay period are broking into the number of days in the period then the applicable number of days, per the schedule for the 30 days is calculated.
All earnings for the same calendar day per defined payroll are combined to generate the number of working days and the average daily wage.
Assignment Codes to be Excluded
Enter a list of Assignment codes that are to be excluded when processing a schedule-based payroll.
Report Only or Process Update
Enter 'R' to produce only a report of the timesheet entries that would be updated with the calculated daily average wage.
Enter 'P' to update the timesheet entries with the employees’ new calculated daily average wage.
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 will list the following:
Employee Number and Name / Payroll Id for additional payrolls
Selected Timesheet Date
Pay Code
Timesheet hours
Timesheet current rate
30 days date range
Earnings for previous 30 calendar days for current payroll, by timesheets
Number of days worked of the last 30 calendar days
Total earnings accumulated for days work in the last 30
Average earnings, total earnings divided by the days worked
New timesheet rate, daily average divided by number of hours for entry