MVS SCHEDULE AND TEMPLATE TRANSACTION DATA

MVS SCHEDULE AND TEMPLATE TRANSACTION DATA

Archive or Purge
Archive
Commit Type (Default)
EVERY_X_DAYS
Commit Parameters (Default)
START_DATE=01/01/2014,BATCH_DAYS=1
Default Aging Days
2557 days
Tables affected

ES_SHIFT_SUMMARY

ES_SHIFT_DETAIL

ES_SHIFT_DETAIL_LAYER

ES_SHIFT_SUMMARY_BLOCK

ES_SHIFT_SUMMARY_SKILL

ES_SHIFT_LINK

ES_SHIFTSUM_COMMENT

ES_SHIFT_HISTORY

ES_SHIFT_HIST_DET

ES_SHIFT_HIST_DETAIL_LAYER

ES_SHIFT_HIST_SKILL

ES_SHIFT_LINK_HISTORY

ES_TMPL_SCHDGEN_TEMPLATE

ES_TMPL_SCHEDULE_GEN

OSB_GROUP_SHIFT_POSTING

OSB_SHIFT_POSTING

OSB_SHIFT_POSTING_BUS_OBJ

SCH_SHIFT_OFFER_EMP_SHIFT

SCH_SHIFT_OFFER_SHIFT

ES_ROT_PUBLISH_SHIFT_SUM

ES_ROTROW_CONFLICTS

ES_CALL_LOG

RTSS_PROCESS_SHIFT

Description/Notes
Moves all data for schedules in MVS to the archive schema. This process involves moving:
  1. All data from the ES_SHIFT_SUMMARY table where the SHIFTSUM_WORK_DATE is before the aging date.
  2. All data from the ES_SHIFT_DETAIL table for the shifts identified in #1.
  3. All data from the ES_SHIFT_SUMMARY_SKILL table for the shifts identified in #1.
  4. All data from the ES_SHIFTSUM_COMMENT table for the shifts identified in #1.
  5. All data from the ES_SHIFT_DETAIL_LAYER table for the shifts identified in #1.
  6. All data from the ES_SHIFT_LINK table for the shifts identified in #1.
  7. All data from the ES_CALL_LOG table for the shifts identified in #1.
  8. All data from the ES_ROTROW_CONFLICTS table for the shifts identified in #1.
  9. All data from the ES_ROT_PUBLISH_SHIFT_SUM for the shifts identified in #1.
  10. All data from the RTSS_PROCESS_SHIFT table for the shifts identified in #1.
  11. All data from the ES_SHIFT_SUMMARY_BLOCK table for the shifts identified in #1.
  12. All data from the ES_TMPL_SCHEDGEN_TEMPLATE table where the TMPLSCHD_ID matches the same column in one of the shifts identified in #1.
  13. All data from the ES_TMPL_SCHEDULE_GEN table where the TMPLSCHD_ID matches the same column in one of the shifts identified in #1.
  14. All data from the SCH_SHIFT_OFFER_SHIFT table for the shifts identified in #1.
  15. All data from the SCH_SHIFT_OFFER_EMP_SHIFT table for the offered shifts identified in #14.
  16. All data from the OSB_SHIFT_POSTING table for the shifts identified in #1.
  17. All data from the OSB_GROUP_SHIFT_POSTING table for the billboard posts identified in #16.
  18. All data from the OSB_SHIFT_POSTING_BUS_OBJ table for the billboard posts identified in #16.
  19. All data from the ES_SHIFT_HISTORY table for the shifts identified in #1.
  20. All data from the ES_SHIFT_HIST_DET table for shift history records identified in #19.
  21. All data from the ES_SHIFT_HIST_DETAIL_LAYER table for the shift history records identified in #19.
  22. All data from the ES_SHIFT_HIST_SKILL table for the shift history records identified in #19.
  23. All data from the ES_SHIFT_LINK_HISTORY table for the shift history records identified in #19.