Time Approval Data

Time Approval Data

Archive or Purge
Archive
Commit Type (Default)
EVERY_X_EMPLOYEE
Commit Parameters (Default)
EMP_BATCH_SIZE=10
CONTROLLING_POLICY_PRIORITY=20
Tables affected
EA_TIME_APPROVAL_ERROR
EA_TIME_APPROVAL
Description/Notes

Moves all time approval data to the archive schema. This process involves moving:

  1. All data from EA_TIME_APPROVAL table where eata_start_work_date is before the aging date and matches the emp_id of the employee whose records are being archived.
  2. All data from EA_TIME_APPROVAL_ERROR where eatae_start_work_date is before the aging date and matches emp_id of the employee whose records are being archived.