Atrieve Payroll

Batch Pay Rate Update

The Batch Pay Rate Update process will update or refresh the pay rate used during timesheet entry with the pay rate from the employees' function line. This option allows timesheet entry pay rate to be changed to match the pay rate changes made to employee's function line pay rates.

Money only and adjustment timesheet entries will be omitted. Adjustment timesheets refers to any timesheet entry where the input pay rate does not equal the base rate (the pay rate was overridden during timesheet entry). Only Finalized batches will be processed.

This process compares the input rate (which includes all premiums) with the pay rate from the employees' function line. The function line pay rate, by default, is generated using the pay code, shift code and occupation code from the timesheet entry. When these two rates do not match, this process updates the timesheet entry with the new pay rate. The EI is adjusted for the total amount of the change, when applicable. Storage Bank online balances are adjusted for the monetary change, when applicable.

An option is available to refresh or replace the occupation and/or shift code on the timesheet entry with the occupation and/or shift code from the function line.
Each timesheet entry changed is marked when updated. Updated pay rates will be listed un-bolded in the Employee Transaction Inquiry screen display. Unchanged pay rates are displayed bolded as usual.

Warning: This process should NOT be used after changing pay code settings such as EI allocation, EI eligibility or storage bank transactions. If a pay code was setup for special EI allocation during timesheet entry, the pay code must remain set that way for the running of this process.

Enter Starting 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.

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

Refresh Shift, Occupation, Both, None

  • Enter 'N' to omit the refreshing of the shift and occupation codes on the timesheet entries.

  • Enter 'S' to have the shift code and premium on the timesheet entries replaced with the shift code from the applicable function line.

  • Enter 'O' to have the occupation code and premium on the timesheet entries replaced with the occupation code from the applicable function line.

  • Enter 'B' to have both the shift and occupation codes and premiums on the timesheet entries replaced with the codes from the applicable function line.

By default, or when you answer 'N'one to the refresh prompt, the pay rate from the function line is generated using the occupation and shift codes used on the timesheet entry. This process ensures any differences in pay rates between the function line and the timesheet entry is not due to premiums.

Refreshing the occupation code and/or shift code will set the applicable premium to the same as those on the function lines.

Timesheet entries where no difference in pay rate is found will not have the occupation and/or shift code refreshed.

Enter Optional Starting Date Range

  • Enter a start date for a range of dates to be reported and/or updated.

Enter Optional Ending Date Range

  • Enter an ending date for a range of dates to be reported and/or updated.

Report Only or Process Update

  • Enter 'R' to produce only a report of the timesheet entries that would be updated with the employees' new pay rate from the function line.

  • Enter 'P' to update the timesheet entries with a new employee pay rate.

The report will list the following:

  • Batch number

  • Line 1 - Timesheet entry values

  • Function line number

  • Date

  • Employee number

  • Shift Code

  • Occupation code

  • Pay code and short description

  • Hours

  • Input Rate

  • Full base rate (including premiums)

  • Base rate

  • Pay code premium

  • Shift Code premium

  • Occupation code premium

  • Line 2 - Function line values

  • Function line number

  • Adjusted input rate as per function line

  • Base rate

  • Pay code premium

  • Shift Code premium

  • Occupation code premium

  • Line 3 - Differences

  • Amount of difference for input rate

  • Total monetary difference

  • Total monetary differences for report

  • Total number of employees reported