Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

AUDITEVENTS: Data Dictionary Audit Events

Contents Previous Home Next More

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

string(240)

Application Name

Application name.

APPLICATION_USER

string(240)

Application User

Application user.

BILLING_ID

string

Billing ID

ID for billing.

BILLING_REFERENCE

string

Billing Reference

Reference for billing, such as your cost centers.

DATA_CONTAINER_ID

string

Data Container ID

ID of the data container.

DIMENSION1_NAME

string

Dimension 1 Name

Name of dimension 1.

DIMENSION1_VALUE

string

Dimension 1 Value

Value of dimension 1.

DIMENSION10_NAME

string

Dimension 10 Name

Name of dimension 10.

DIMENSION10_VALUE

string

Dimension 10 Value

Value of dimension 10.

DIMENSION11_NAME

string

Dimension 11 Name

Name of dimension 11.

DIMENSION11_VALUE

string

 

Value of dimension 11.

DIMENSION12_NAME

string

Dimension 12 Name

Name of dimension 12.

DIMENSION12_VALUE

string

 

Value of dimension 12.

DIMENSION13_NAME

string

Dimension 13 Name

Name of dimension 13.

DIMENSION13_VALUE

string

 

Value of dimension 13.

DIMENSION14_NAME

string

Dimension 14 Name

Name of dimension 14.

DIMENSION14_VALUE

string

 

Value of dimension 14.

DIMENSION15_NAME

string

Dimension 15 Name

Name of dimension 15.

DIMENSION15_VALUE

string

 

Value of dimension 15.

DIMENSION16_NAME

string

Dimension 16 Name

Name of dimension 16.

DIMENSION16_VALUE

string

 

Value of dimension 16.

DIMENSION17_NAME

string

Dimension 17 Name

Name of dimension 17.

DIMENSION17_VALUE

string

 

Value of dimension 17.

DIMENSION18_NAME

string

Dimension 18 Name

Name of dimension 18.

DIMENSION18_VALUE

string

 

Value of dimension 18.

DIMENSION19_NAME

string

Dimension 19 Name

Name of dimension 19.

DIMENSION19_VALUE

string

 

Value of dimension 19.

DIMENSION2_NAME

string

Dimension 2 Name

Name of dimension 2.

DIMENSION2_VALUE

string

Dimension 2 Value

Value of dimension 2.

DIMENSION20_NAME

string

Dimension 20 Name

Name of dimension 20.

DIMENSION20_VALUE

string

 

Value of dimension 20.

DIMENSION3_NAME

string

Dimension 3 Name

Name of dimension 3.

DIMENSION3_VALUE

string

Dimension 3 Value

Value of dimension 3.

DIMENSION4_NAME

string

Dimension 4 Name

Name of dimension 4.

DIMENSION4_VALUE

string

Dimension 4 Value

Value of dimension 4.

DIMENSION5_NAME

string

Dimension 5 Name

Name of dimension 5.

DIMENSION5_VALUE

string

Dimension 5 Value

Value of dimension 5.

DIMENSION6_NAME

string

Dimension 6 Name

Name of dimension 6.

DIMENSION6_VALUE

string

Dimension 6 Value

Value of dimension 6.

DIMENSION7_NAME

string

Dimension 7 Name

Name of dimension 7.

DIMENSION7_VALUE

string

Dimension 7 Value

Value of dimension 7.

DIMENSION8_NAME

string

Dimension 8 Name

Name of dimension 8.

DIMENSION8_VALUE

string

Dimension 8 Value

Value of dimension 8.

DIMENSION9_NAME

string

Dimension 9 Name

Name of dimension 9.

DIMENSION9_VALUE

string

Dimension 9 Value

Value of dimension 9.

GUI_ACTION

string(240)

GUI Action

Action performed within the user interface.

GUI_IP_ADDRESS_EXTERNAL

string(240)

GUI External IP Address

External IP address of the GUI application.

GUI_IP_ADDRESS_INTERNAL

string(240)

GUI Internal IP Address

Internal IP address of the GUI application.

GUI_MACHINE

string(240)

GUI Machine

Name of the machine running the GUI application.

GUI_MODULE_NAME

string(240)

 

Module within the GUI application currently running.

GUI_MODULE_VERSION

string(240)

 

Version of module within the GUI application currently running.

GUI_MODULE

string(240)

GUI Module

Module within the GUI application currently running.

GUI_OS_USER

string(240)

GUI OS User

OS user running the GUI application.

IIID

string

IIID

Invantive installation ID.

IS_APPLICATION_MANAGED

boolean

Application Managed

Indicator whether event was managed by the application.

IS_MONITORING

boolean

Is Monitoring

Indicator whether event must be forwarded for monitoring.

IUID

string

IUID

Invantive user ID.

LAST_LOGON_TIME

datetime

Logon Time

Date at which the last logon found place.

LAST_NATURAL_KEY

string(4000)

Last Natural Key

Last seen natural key of business object.

LICENSE_CONTRACT_CODE

string

License Contract Code

License contract code.

LICENSE_KEY_IDENTIFIER

string

License Key Identifier

License key identifier.

LOGGING_LEVEL

string(30)

Logging Level

Type of logging message.

MESSAGE_CODE

string(30)

Message Code

 

MESSAGE_UID

guid

Message UID

Specific UID for easy recognition.

METRIC_NAME

string

Metric Name

Name of monitoring metric.

METRIC_VALUE

string

Metric Value

Value of monitoring metric.

OCCURRENCE_DATE_UTC

datetime

Occurrence Date (UTC)

UTC date at which the event occurred.

PARAMETER_VALUES

string(4000)

Parameter Values

Parameter values.

PARTITION

string(240)

Partition

Specific partition on which the event was registered.

POOL_IDENTITY

string(60)

Pool Identity

Pool identity.

PROVIDER_NAME

string

Provider

Name of provider.

REFERENCE_KEY

string

Reference Key

Key of the referenced business object.

REFERENCE_TABLE_CODE

string

Reference Table Code

Table code of the referenced business object.

SERVICE_NAME

string

Service Name

Name of service.

SERVICE_STATE

string

Service State

Status of service (production, acceptance, test).

SESSION_ID

string(240)

Session ID

ID of the session.

SHOWN_TO_USER

boolean

Shown to User

Indicator whether event was shown to the user.

SQL_STATEMENT

string(4000)

SQL Statement

SQL statement.

UNIT_OF_MEASURE

string

Unit of Measure

Unit of Measure of value of monitoring metric.

USER_MESSAGE

string(4000)

User Message

Text of the message without message code.

 

17-05-2021 11:57 Version 20.1.419-BETA+3191