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:
- All data from the UNSTFD_SHIFT table where unss_date is before the aging date.