Attendance Control Logs
Attendance Control Logs
- Archive or Purge
- Archive
- Commit Type (Default)
- ALL_OR_NOTHING
- Commit Parameters (Default)
- None
- Default Aging Days
- 1096 days
- Tables affected
-
AC_VIOEVT_LOG
AC_EVENT_LOG
AC_VIOLATION_LOG
- Description/Notes
- Moves all data for Attendance Control event and violation logs to the archive
schema. This process involves moving:
- All data from the AC_EVENT_LOG table where the ACEVTLOG_DATE is before the aging date.
- All data from the AC_VIOLATION_LOG table where the ACVIOLOG_DATE is before the aging date.
- All data from the AC_VIOEVT_LOG table for the logs identified in #1 and #2.