Table Driven Employee Date Range Recalculation Task
The Table Driven Employee Date Range Recalculation Task recalculates payroll records based on entries in the recalculation table (TA_CALC_EMP_DATES). This table stores employees and dates that require recalculation based on employee imports.
The recalculation table is populated by APIs that insert a record for each employee, and the dates to calculate.
Two sources fill the recalculation table.
Employee imports fill the recalculation table through APIs. The APIs insert a record for each employee and the dates to calculate. For example, an employee is updated through employee import. A recalculation then runs from the beginning of the year to the end of the year to update the employee balances.
Time attestation approval fills the recalculation table when RE_CALC_ON_APPROVAL is set to ASYNC . When a user approves a time attestation, the system queues the employee and the attested date into the recalculation table. The Time Attestation calculation source (TA_CALC_SOURCE) identifies the queued entries. The system recalculates the attested date and no other dates.
The task then performs the deferred recalculation with the full rule engine, including pay rules and authorization.
For example, an employee is updated via employee import and a recalculation must be made from the beginning of the year to end of year to update their balances as a result of the change. The APIs will insert records into the TA_CALC_EMP_DATES table to be recalculated by the task.
The TA Calculation Requests page can be used to look up recalculation records. Select .