Please enable JavaScript to view this site.

Data Dictionary Data Model Data Dictionary Forums

Navigation: Schema: Invantive > Tables

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

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)

GUI Module Name

☐

Module within the GUI application currently running.

GUI_MODULE_VERSION

string(240)

GUI Module Version

☐

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

☐

Code of the message. May not start with 'itgen' or 'bubs'.

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_INSTANCE_UID

guid

Provider Instance UID

☐

Unique ID of the provider instance.

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.

REQUEST_ID

string(60)

 

☐

Request ID.

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

User Message

☐

Text of the message without message code.

 

12-09-2023 15:02 Version 22.1.262-BETA+4120

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.
  
Disclaimer