invantive documentation
Invantive Support ForumsLog In / Sign Up

AUDITEVENTS: Data Dictionary Audit Events

insert

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Audit Events

Application-specific events for billing, monitoring and analysis.

Can retrieve data and change data using insert.

Table Columns

The columns of the table 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 and update.

Name Data Type Label Required Marks 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.
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.
DIMENSION1_NAME varchar2 Dimension 1 Name Name of dimension 1.
DIMENSION1_VALUE varchar2 Dimension 1 Value Value of dimension 1.
DIMENSION20_NAME varchar2 Dimension 20 Name Name of dimension 20.
DIMENSION20_VALUE varchar2 Dimension 20 Value Value of dimension 20.
DIMENSION2_NAME varchar2 Dimension 2 Name Name of dimension 2.
DIMENSION2_VALUE varchar2 Dimension 2 Value Value of dimension 2.
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 varchar2(240) GUI Module Module within the GUI application currently running.
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_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.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: