Staff scheduler data

Staff scheduler data

Archive or Purge

Archive

Commit Type (Default)

ALL_OR_NOTHING

Commit Parameters (Default)

Default Aging Days

2557 days

Tables affected

MP_DAILY_OVERRIDE

MP_EMP_NOTE

MP_TEMPLATE_OVERRIDE

MP_TEMPLATE_REQUIREMENT

MP_TEMPLATE_SHIFT_OVERRIDE

MP_TEMPLATE

MP_TEMPLATE_GRP_CR

MP_TEMPLATE_GROUP

MP_TEMPLATE_GROUP_ MEMBERS

Description/Notes

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

1. All data from the MP_TEMPLATE_GROUP table where MPTG_END_DATE is before the aging date.
2. All data from the MP_TEMPLATE_GRP_CR table for the template groups identified in #1.
3. All data from the MP_TEMPLATE table where MPT_END_DATE is before the aging date.
4. All data from the MP_TEMPLATE_GROUP_MEMBERS table for the template groups identified in #1 or for the templates identified in #3.
5. All data from the MP_TEMPLATE_SHIFT_OVERRIDE table where MPTSO_END_DATE is before the aging date.
6. All data from the MP_TEMPLATE_SHIFT_OVERRIDE table for the templates identified in #3.
7. All data from the MP_TEMPLATE_REQUIREMENT table for the templates identified in #3.
8. All data from the MP_TEMPLATE_OVERRIDE table where MPTO_END_DATE is before the aging date.
9. All data from the MP_TEMPLATE_OVERRIDE table for the templates identified in #3.
10. All data from MP_EMP_NOTE table where MPEN_DATE is before the aging date.
11. All data from the MP_DAILY_OVERRIDE table for the templates identified in #3.
12. All data from the MP_DAILY_OVERRIDE table where MPDO_DATE is before the aging date.