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

Default Aging Days

2557 days

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.