Payroll data

Payroll data

Archive or Purge
Archive
Commit Type (Default)
Every_X_Employee
Commit Parameters (Default)
EMP_BATCH_SIZE=10
CONTROLLING_POLICY_PRIORITY=60
Tables affected
OVERRIDE
WORK_DETAIL_ADJUST
EMPLOYEE_BALANCE_LOG
CLOCK_TRAN_PROCESSED
WORK_DETAIL WORK_SUMMARY
TIMESHEET_LOCK MASS_ENTRY_OVR
SC_WARNING WBI_OVERRIDE_VALUE
TIME_OFF_DAY_OVR
EMPLOYEE_SCHEDULE
Description/Notes
Payroll Data will be archived for all employees.
Moves all payroll data to the archive schema. This process involves moving:
  1. All data from the WORKBRAIN_SUMMARY table where wrks_work_date is before the aging date and matches the emp_id of the employee whose records are being archived.
  2. All data from the WORK_DETAIL table for the work summaries identified in #1.
  3. All data from the CLOCK_TRAN_PROCESSED table for the work summaries identified in #1.
  4. All data from the EMPLOYEE_BALANCE_LOG table for the work summaries identified in #1.
  5. All data from the EMPLOYEE_SCHEDULE table where WORK_DATE falls in WRKS_WORK_DATE of work summaries identified in #1.
  6. All data from the WORK_DETAIL_ADJUST table where wrkda_work_date is before the aging date and matches the emp_id in #1.
  7. All data from OVERRIDE table where ovr_start_date is before the aging date and ovrtyp_id is:
    • >= 700 and < 900
    • Are not >= 1500 and < 1600
    • Are not >= 400 and < 500

    For emp_id in #1.

  8. All data from the MASS_ENTRY_OVR table where ovr_id is in the overrides identified in #7.
  9. All data from the SC_WARNING table ovr_id is in the overrides identified in #7.
  10. All data from the WBI_OVERRIDE_VALUE table where ovr_id is in the the overrides identified in #7.
  11. All data from the TIME_OFF_DAY_OVR table where ovr_id is in the overrides identified in #7.
  12. All data from the TIMESHEET_LOCK table where tsl_end_date is before the aging date and matches the emp_id in #1.