Attendance Control Logs

Attendance Control Logs

Archive or Purge
Archive
Commit Type (Default)
ALL_OR_NOTHING
Commit Parameters (Default)
None
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:
  1. All data from the AC_EVENT_LOG table where the ACEVTLOG_DATE is before the aging date.
  2. All data from the AC_VIOLATION_LOG table where the ACVIOLOG_DATE is before the aging date.
  3. All data from the AC_VIOEVT_LOG table for the logs identified in #1 and #2.