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:
- 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.
- All data from the EMP_SCHD_DTL_LAYER table for the employee
schedules identified in #1.
- All data from the EMPLOYEE_SCHED_DTL table for the employee
schedules identified in #1.
- 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.
- All data from the MASS_ENTRY_OVR table for the overrides
identified in #4.
- All data from the SC_WARNING table for the overrides identified
in #4.
- All data from the WBI_OVERRIDE_VALUE table for the overrides
identified in #4.
- All data from the TIME_OFF_DAY_OVR table for the overrides
identified in #4.