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