Employee schedule data

Employee schedule data

Archive or Purge

Archive

Commit Type (Default)

EVERY_X_EMPLOYEE

Commit Parameters (Default)

EMP_BATCH_SIZE=10

CONTROLLING_POLICY_PRIORITY=20

Default Aging Days

2557 days

Tables affected

OVERRIDE

EMPLOYEE_SCHEDULE

EMPLOYEE_SCHED_DTL

EMP_SCHD_DTL_LAYER

MASS_ENTRY_OVR

SC_WARNING

WBI_OVERRIDE_VALUE

TIME_OFF_DAY_OVR

Description/Notes

Moves all employee schedule data to the archive schema. This process involves moving:

1. All data from the EMPLOYEE_SCHEDULE table where 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 EMP_SCHD_DTL_LAYER table for the employee schedules identified in #1.
3. All data from the EMPLOYEE_SCHED_DTL table for the employee schedules identified in #1.
4. All data from the OVERRIDE table where ovr_start_date is before the aging date and override type is between 1500 AND 1599 or between 400 and 499 and matches the emp_id in #1.
5. All data from the MASS_ENTRY_OVR table for the overrides identified in #4.
6. All data from the SC_WARNING table for the overrides identified in #4.
7. All data from the WBI_OVERRIDE_VALUE table for the overrides identified in #4.
8. All data from the TIME_OFF_DAY_OVR table for the overrides identified in #4.