# AUDITEVENTS: Data Dictionary Audit Events Application-specific events for billing, monitoring and analysis. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `aet` - Label: Audit Events - Retrieve: True - Insert: True - Update: False - Delete: False ## View Columns The columns of the view `AUDITEVENTS` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `APPLICATION_NAME` | `varchar2`(240) | Application Name | ☑ | Application name. | | `APPLICATION_USER` | `varchar2`(240) | Application User | ☐ | Application user. | | `BILLING_ID` | `varchar2` | Billing ID | ☐ | ID for billing. | | `BILLING_POOL_IDENTITY_ID` | `varchar2` | Billing Pool Identity ID | ☐ | Pool identity ID for billing. | | `BILLING_REFERENCE` | `varchar2` | Billing Reference | ☐ | Reference for billing, such as your cost centers. | | `DATA_CONTAINER_ID` | `varchar2` | Data Container ID | ☑ | ID of the data container. | | `DIMENSION1_NAME` | `varchar2` | Dimension 1 Name | ☐ | Name of dimension 1. | | `DIMENSION1_VALUE` | `varchar2` | Dimension 1 Value | ☐ | Value of dimension 1. | | `DIMENSION10_NAME` | `varchar2` | Dimension 10 Name | ☐ | Name of dimension 10. | | `DIMENSION10_VALUE` | `varchar2` | Dimension 10 Value | ☐ | Value of dimension 10. | | `DIMENSION11_NAME` | `varchar2` | Dimension 11 Name | ☐ | Name of dimension 11. | | `DIMENSION11_VALUE` | `varchar2` | Dimension 11 Value | ☐ | Value of dimension 11. | | `DIMENSION12_NAME` | `varchar2` | Dimension 12 Name | ☐ | Name of dimension 12. | | `DIMENSION12_VALUE` | `varchar2` | Dimension 12 Value | ☐ | Value of dimension 12. | | `DIMENSION13_NAME` | `varchar2` | Dimension 13 Name | ☐ | Name of dimension 13. | | `DIMENSION13_VALUE` | `varchar2` | Dimension 13 Value | ☐ | Value of dimension 13. | | `DIMENSION14_NAME` | `varchar2` | Dimension 14 Name | ☐ | Name of dimension 14. | | `DIMENSION14_VALUE` | `varchar2` | Dimension 14 Value | ☐ | Value of dimension 14. | | `DIMENSION15_NAME` | `varchar2` | Dimension 15 Name | ☐ | Name of dimension 15. | | `DIMENSION15_VALUE` | `varchar2` | Dimension 15 Value | ☐ | Value of dimension 15. | | `DIMENSION16_NAME` | `varchar2` | Dimension 16 Name | ☐ | Name of dimension 16. | | `DIMENSION16_VALUE` | `varchar2` | Dimension 16 Value | ☐ | Value of dimension 16. | | `DIMENSION17_NAME` | `varchar2` | Dimension 17 Name | ☐ | Name of dimension 17. | | `DIMENSION17_VALUE` | `varchar2` | Dimension 17 Value | ☐ | Value of dimension 17. | | `DIMENSION18_NAME` | `varchar2` | Dimension 18 Name | ☐ | Name of dimension 18. | | `DIMENSION18_VALUE` | `varchar2` | Dimension 18 Value | ☐ | Value of dimension 18. | | `DIMENSION19_NAME` | `varchar2` | Dimension 19 Name | ☐ | Name of dimension 19. | | `DIMENSION19_VALUE` | `varchar2` | Dimension 19 Value | ☐ | Value of dimension 19. | | `DIMENSION2_NAME` | `varchar2` | Dimension 2 Name | ☐ | Name of dimension 2. | | `DIMENSION2_VALUE` | `varchar2` | Dimension 2 Value | ☐ | Value of dimension 2. | | `DIMENSION20_NAME` | `varchar2` | Dimension 20 Name | ☐ | Name of dimension 20. | | `DIMENSION20_VALUE` | `varchar2` | Dimension 20 Value | ☐ | Value of dimension 20. | | `DIMENSION3_NAME` | `varchar2` | Dimension 3 Name | ☐ | Name of dimension 3. | | `DIMENSION3_VALUE` | `varchar2` | Dimension 3 Value | ☐ | Value of dimension 3. | | `DIMENSION4_NAME` | `varchar2` | Dimension 4 Name | ☐ | Name of dimension 4. | | `DIMENSION4_VALUE` | `varchar2` | Dimension 4 Value | ☐ | Value of dimension 4. | | `DIMENSION5_NAME` | `varchar2` | Dimension 5 Name | ☐ | Name of dimension 5. | | `DIMENSION5_VALUE` | `varchar2` | Dimension 5 Value | ☐ | Value of dimension 5. | | `DIMENSION6_NAME` | `varchar2` | Dimension 6 Name | ☐ | Name of dimension 6. | | `DIMENSION6_VALUE` | `varchar2` | Dimension 6 Value | ☐ | Value of dimension 6. | | `DIMENSION7_NAME` | `varchar2` | Dimension 7 Name | ☐ | Name of dimension 7. | | `DIMENSION7_VALUE` | `varchar2` | Dimension 7 Value | ☐ | Value of dimension 7. | | `DIMENSION8_NAME` | `varchar2` | Dimension 8 Name | ☐ | Name of dimension 8. | | `DIMENSION8_VALUE` | `varchar2` | Dimension 8 Value | ☐ | Value of dimension 8. | | `DIMENSION9_NAME` | `varchar2` | Dimension 9 Name | ☐ | Name of dimension 9. | | `DIMENSION9_VALUE` | `varchar2` | Dimension 9 Value | ☐ | Value of dimension 9. | | `GUI_ACTION` | `varchar2`(240) | GUI Action | ☐ | Action performed within the user interface. | | `GUI_IP_ADDRESS_EXTERNAL` | `varchar2`(240) | GUI External IP Address | ☑ | External IP address of the GUI application. | | `GUI_IP_ADDRESS_INTERNAL` | `varchar2`(240) | GUI Internal IP Address | ☑ | Internal IP address of the GUI application. | | `GUI_MACHINE` | `varchar2`(240) | GUI Machine | ☐ | Name of the machine running the GUI application. | | `GUI_MODULE_NAME` | `varchar2`(240) | GUI Module Name | ☐ | Module within the GUI application currently running. | | `GUI_MODULE_VERSION` | `varchar2`(240) | GUI Module Version | ☐ | Version of module within the GUI application currently running. | | `GUI_MODULE` | `varchar2`(240) | GUI Module | ☐ | Module within the GUI application currently running. | | `GUI_OS_USER` | `varchar2`(240) | GUI OS User | ☐ | OS user running the GUI application. | | `IIID` | `varchar2` | IIID | ☐ | Invantive installation ID. | | `IS_APPLICATION_MANAGED` | `char` | Application Managed | ☑ | Indicator whether event was managed by the application. | | `IS_MONITORING` | `char` | Is Monitoring | ☐ | Indicator whether event must be forwarded for monitoring. | | `IUID` | `varchar2` | IUID | ☐ | Invantive user ID. | | `LAST_LOGON_TIME` | `datetime` | Logon Time | ☐ | Date at which the last logon found place. | | `LAST_NATURAL_KEY` | `varchar2`(4000) | Last Natural Key | ☐ | Last seen natural key of business object. | | `LICENSE_CONTRACT_CODE` | `varchar2` | License Contract Code | ☑ | License contract code. | | `LICENSE_KEY_IDENTIFIER` | `varchar2` | License Key Identifier | ☑ | License key identifier. | | `LOGGING_LEVEL` | `varchar2`(30) | Logging Level | ☑ | Type of logging message. | | `MANAGED_THREAD_ID` | `int32` | Managed Thread ID | ☐ | Managed thread ID. | | `MESSAGE_CODE` | `varchar2`(30) | Message Code | ☐ | Code of the message. May not start with 'itgen' or 'bubs'. | | `MESSAGE_UID` | `guid` | Message UID | ☑ | Specific UID for easy recognition. | | `METRIC_NAME` | `varchar2` | Metric Name | ☐ | Name of monitoring metric. | | `METRIC_VALUE` | `varchar2` | Metric Value | ☐ | Value of monitoring metric. | | `OCCURRENCE_DATE_UTC` | `datetime` | Occurrence Date (UTC) | ☑ | UTC date at which the event occurred. | | `PARAMETER_VALUES` | `varchar2`(4000) | Parameter Values | ☐ | Parameter values. | | `PARTITION` | `varchar2`(240) | Partition | ☐ | Specific partition on which the event was registered. | | `POOL_IDENTITY` | `varchar2`(60) | Pool Identity | ☐ | Pool identity. | | `PROVIDER_INSTANCE_UID` | `guid` | Provider Instance UID | ☐ | Unique ID of the provider instance. | | `PROVIDER_NAME` | `varchar2` | Provider | ☐ | Name of provider. | | `REFERENCE_KEY` | `varchar2` | Reference Key | ☐ | Key of the referenced business object. | | `REFERENCE_TABLE_CODE` | `varchar2` | Reference Table Code | ☐ | Table code of the referenced business object. | | `REQUEST_ID` | `varchar2`(60) | Request ID | ☐ | Request ID. | | `SERVICE_NAME` | `varchar2` | Service Name | ☐ | Name of service. | | `SERVICE_STATE` | `varchar2` | Service State | ☐ | Status of service (production, acceptance, test). | | `SESSION_ID` | `varchar2`(240) | Session ID | ☑ | ID of the session. | | `SHOWN_TO_USER` | `char` | Shown to User | ☑ | Indicator whether event was shown to the user. | | `SQL_STATEMENT` | `varchar2` | SQL Statement | ☐ | SQL statement. | | `TASK_ID` | `int32` | Task ID | ☐ | Task ID. | | `UNIT_OF_MEASURE` | `varchar2` | Unit of Measure | ☐ | Unit of Measure of value of monitoring metric. | | `USER_MESSAGE` | `varchar2` | User Message | ☐ | Text of the message without message code. |