Shift Billboard Posting Data

Shift Billboard Posting Data

Archive or Purge
Archive
Commit Type (Default)
ALL_OR_NOTHING
Commit Parameters (Default)
None
Tables affected
OSB_GROUP_SHIFT_POSTING
OSB_SHIFT_POSTING
OSB_SHIFT_POSTING_BUS_OBJ
Description/Notes
Moves all data for Shift Billboard postings for MVS shifts to the archive schema. This process involves moving:
  1. All data from the OSB_SHIFT_POSTING table where the SHIFTSUM_ID is not null and where the OSBPOSTING_SHIFT_DATE is before the aging date.
  2. All data from the OSB_GROUP_SHIFT_POSTING table for the shift posts identified in #1.
  3. All data from the OSB_SHIFTPOSTING_BUS_OBJ table for the shift posts identified in #1.