SO historical data and SO schedule data

SO historical data

Archive or Purge
Archive
Commit Type (Default)
ALL_OR_NOTHING
Commit Parameters (Default)
Default Aging Days
3653 for SO HISTORICAL DATA

2557 days for SO SCHEDULE DATA

Tables affected
SO_RESULTS_DETAILS
SO_INTERVAL_REQ
Description/Notes
Move all SO historical data to the archive schema. This process involves moving:
  1. All data from the SO_INTERVAL_REQ table where INTREQ_DATE is before the aging date.
  2. All data from the SO_RESULTS_DETAIL table where RESDET_DATE is before the aging date

SO Schedule Data

Archive or Purge
Archive
Commit Type (Default)
ALL_OR_NOTHING
Commit Parameters (Default)
None
Tables affected
SO_FCAST_DETAIL
SO_FCAST
SO_SCHEDULE_COST
SO_SCHEDULE_SCORE
SO_SHIFT_ACTIVITY
SO_SHIFT_DETAIL
SO_SCHEDULED_SHIFT
SO_TASK
SO_SCHEDULE
SO_SHIFT_REQ
SO_INTERVAL_REQ
SO_SCHED_BAT_DET
SO_SKD_EMPGRP
SO_HIST_INT_REQ
SO_REGEN_SCHEDULE
SO_FCAST
OSB_GROUP_SHIFT_POSTING
OSB_SHIFT_POSTING
OSB_SHIFT_POSTING_BUS_OBJ
Description/Notes

Moves all SO schedule data to the archive schema. This includes data related to Shift Billboard postings for LFSO shifts.

Note: Run the purge policy Auto Assignment Schedule Generation Detail Log before running the archiving policy SO SCHEDULE DATA.

This process involves moving:

  1. All data from the SO_SCHEDULE table where SKD_GEN_DATE is before the aging date.
  2. All data from the SO_REGEN_SCHEDULE table for the schedules identified in #1.
  3. All data from the SO_HIST_INT_REQ table for the schedules identified in #2.
  4. All data from the SO_TASK table for the schedules identified in #1.
  5. All data from the SO_SKD_EMPGRP table for the schedules identified in #1.
  6. All data from the SO_SCHED_BAT_DET table for the schedules identified in #1.
  7. All data from the SO_INTERVAL_REQ table for the schedules identified in #1.
  8. All data from the SO_SCHEDULED_SHIFT table for the schedules identified in #1.
  9. All data from the SO_SHIFT_REQ table for the schedules identified in #1.
  10. All data from the SO_SHIFT_DETAIL table for the schedules identified in #1.
  11. All data from the SO_SHIFT_ACTIVITY table for the schedules identified in #1.
  12. All data from the SO_SCHEDULE_SCORE table for the schedules identified in #1.
  13. All data from the SO_SCHEDULE_COST table for the schedules identified in #1.
  14. All data from the SO_FCAST table where FCAST_TO_DATE is before the aging date and FCAST_PARENT_ID is null.
  15. All data from the SO_FCAST table where FCAST_TO_DATE is before the aging date and FCAST_PARENT_ID is not null.
  16. All data from the SO_FCAST_DETAIL table where the forecasts are in all the data from SO_FCAST where FCAST_TO_DATE is before the aging date.
  17. All data from the OSB_SHIFT_POSTING table for the schedules identified in #1.
  18. All data from the OSB_GROUP_SHIFT_POSTING table for the schedules identified in #1.
  19. All data from the OSB_SHIFT_POSTING_BUS_OBJ table for the schedules identified in #1.