Unstaffed Shift Data

Unstaffed Shift Data

Archive or Purge
Archive
Commit Type (Default)
ALL_OR_NOTHING
Commit Parameters (Default)
Default Aging Days
1096 days
Tables affected
UNSTFD_SHIFT
Description/Notes

Move all unstaffed shift data to the archive schema. This process involves moving:

  1. All data from the UNSTFD_SHIFT table where unss_date is before the aging date.