The CyberAudit-Web report_audit_events table
Beginning with CyberAudit-Web Enterprise version 7.2, audit trail events from CyberKeys, CyberLocks, and communicators are recorded in the audit_events table of the system database. The schema of this table is mirrored in the report_audit_events table in the formatted events catalog as follows:
| Column Name | Familiar Name | Data Type | Description |
| ae_id | Record number | int | automatically generated |
| ae_utc_time | UTC time | int | Date and time of the event expressed as the number of seconds since 1996-01-01 UTC. This value is derived from the columns ae_local_time and ae_time_zone. |
| ae_local_time | Local time | int | Date and time of the event expressed as the number of seconds since 1996-01-01. This value is computed from the yy-mm-dd hh:mm:ss data retrieved from the CyberKey, CyberLock, or communicator. This field should not be used for time comparison operations without factoring in the time zone from the ae_time_zone column. |
| ae_download_time | Download time | int | Date and time when the record was captured by a communicator or by CyberAudit-Web expressed as the number of seconds since 1996-01-01 UTC. |
| ae_is_time_trustworthy | Time is trustworthy | boolean | A flag indicating wheather the date/time value is reliable. This flag will be set(true) in cases where the clock in the CyberKey or communicator has stopped or the date portion of the data is corrupted or missing(see the columnae_is_bad_date. In these cases the value in ae_utc_time done as a best guess for the purpose of trying to maintain a sort order when sorting data by date/time. |
| ae_is_bad_date | Bad or missing date | boolean | A flag indicating the date portion of the date/time value caused the ae_is_time_trustworthy flag to be set. |
| ae_type | Event type | int | The specific event that occurred. Each event is a unique type 4 byte integer created from
the ae_source_enum and ae_original type as follows: high byte = ae_source_enum low bytes = ae_original_type |
| ae_original_type | Original type | int | The event number of the audit trail event. |
| ae_source_enum | Event source | int | 1 = CyberKey 2 = CyberLock 3 = RFID Access Card 4 = Door 5 = Single Key Vault 6 = Portable Link 7 = Station 8 = Web Authorizer 9 = LAN Authorizer 10 = Flex System Hub 11 = Key Status (information recorded during a communication session with a CyberKey) 12 = Lock Download (information recorded about a CyberLock when it is downloaded 127 = Unknown source |
| ae_raw_event | Raw event data | binary | Stores the raw bytes of the event as received from the source, if available, for information and troubleshooting purposes. |
| ae_extended_data | Data | string | Key-value pairs of data specific to each event type which may add additional information about the event. |
| ae_person_id | Person ID | int | The ID of the person associated with the data, if applicable. Maps to a specific CyberAudit-Web People record. |
| ae_person_name | Person name | string | The name of the person associated with the data, if applicatble, at the time of the event/ |
| ae_comm_serial | Communicator serial number | string | The serial number of the communicator that generated or extracted the event. |
| ae_comm_item_id | Communicator item ID | int | The item ID, if available, of the of the communicator associated with the event. Note: LAN Authorizers do not have item IDs. |
| ae_comm_name | Communicator name | string | The name of the communicator |
| ae_port_serial | Keypad or Flex Module ID | ID-string | Keypad or Flex Hub module ID associated with the event |
| ae_port_name | Port name | string | The name of the Keypad or module, if assigned. |
| ae_cyberlock_serial | Lock ID | ID-string | The serial number of the CyberLock associated with the event |
| ae_cyberlock_name | Lock name | string | The name of the CyberLock at the time of the event. |
| ae_cyberlock_item_id | Lock item ID | int | The item ID of the CyberLock at the time of the event. |
| ae_cyberkey_serial | Key serial number | ID string | The name of the CyberKey at the time of the event. |
| ae_cyberkey_item_id | CyberKey item ID | int | The item ID of the CyberKey at the time of the event. |
| ae_card_rf_serial | RFID card serial number | string | The ID of the RFID card associated with the event. |
| ae_card_name | RFID card name | string | The name of the RFID card at the time of the event. |
| ae_card_number | RFID card item number | int | The record number of the card in the RFID cards table. |
| ae_door_io_serial | Door and I/O module serial number | ID string | The serial number of the door and I/O module associated with the event. |
| ae_door_name | Door name | String | The name of the door associated with the event. |
| ae_door_item_id | Door item ID | int | The item ID of the door |
| ae_mission_id | Mission number ID | ID string | The ID of the mission associated with the event (i.e. M01230777). Mission ID is recorded for mission specific events and anytime a mission is associated with a CyberKey serial number. |
| ae_mission_item_id | Mission item ID | int | The item ID of the mission. |
| ae_template_id | Mission or Key template ID | ID string | The id of the template associated with the event (i.e. T00000002). Template is recorded for some template specific events (primarily from Flex Hubs), or any event in which a CyberKey or mission is linked to a template. |
| ae_template_name | Mission or Key Template name | string | The name of the template associated with the CyberKey or mission, if available. |
| ae_template_item_id | Mission or Key Template item ID | int | The item ID of the template |
| ae_lock_downloaded | Lock downloaded flag | boolean | A flag to indicate whether a CyberLock was downloaded at the time of the event. |
| ae_lock_set | Lock programmed flag | boolean | A flag to indicate whether a CyberLock was programmed at the time of the event. |
| ae_extras | Event extras | int | A count of additional events from a CyberLock or CyberKey with the same event type, date, time, and download time. |
| ae_timezone | Time zone index | byte | The time zone index of the event. |
| ae_mv | CyberKey millivolts | int | Battery voltage of the CyberKey recorded for an event source 11 (Key Status) in millivolts. |
| ae_keyring_name | Key Ring name | string | The name of the Key Ring associated with the event. |
| ae_keyring_id | Key Ring item ID | int | The item ID of the Key Ring. The serial number of the CyberKey is in the ae_extended_data column. |
| ae_config | Lock download config ID | int | The ID of the lockspec as downloaded from a CyberLock. Associated with event source 12, Lock Download Information. |
| ae_rtc_stopped | Clock-stopped flag | boolean | A flag retrieved from CyberKey and CyberLock events that indicates operation of the CyberKey clock was interrupted and had not been set again from CyberAudit-Web at the time of the event. If this flag is set the ae_is_time_trustworthy flag will also be set. |
| ae_port_index | Port number | int | The port number of the communicator associated with the event. For Authorizers this will be 0 or 1 to indicate keyport 1 or 2. For Flex System hubs this will be 1 to 8. |
| ae_group | Group | int | The group number of the Flex System hub associated with the event. |
