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_ |
varchar2 |
Application Name | Application name. | ||
APPLICATION_ |
varchar2 |
Application User | Application user. | ||
BILLING_ |
varchar2 |
Billing ID | ID for billing. | ||
BILLING_ |
varchar2 |
Billing Pool Identity ID | Pool identity ID for billing. | ||
BILLING_ |
varchar2 |
Billing Reference | Reference for billing, such as your cost centers. | ||
DATA_ |
varchar2 |
Data Container ID | ID of the data container. | ||
DIMENSION10_ |
varchar2 |
Dimension 10 Name | Name of dimension 10. | ||
DIMENSION10_ |
varchar2 |
Dimension 10 Value | Value of dimension 10. | ||
DIMENSION11_ |
varchar2 |
Dimension 11 Name | Name of dimension 11. | ||
DIMENSION11_ |
varchar2 |
Dimension 11 Value | Value of dimension 11. | ||
DIMENSION12_ |
varchar2 |
Dimension 12 Name | Name of dimension 12. | ||
DIMENSION12_ |
varchar2 |
Dimension 12 Value | Value of dimension 12. | ||
DIMENSION13_ |
varchar2 |
Dimension 13 Name | Name of dimension 13. | ||
DIMENSION13_ |
varchar2 |
Dimension 13 Value | Value of dimension 13. | ||
DIMENSION14_ |
varchar2 |
Dimension 14 Name | Name of dimension 14. | ||
DIMENSION14_ |
varchar2 |
Dimension 14 Value | Value of dimension 14. | ||
DIMENSION15_ |
varchar2 |
Dimension 15 Name | Name of dimension 15. | ||
DIMENSION15_ |
varchar2 |
Dimension 15 Value | Value of dimension 15. | ||
DIMENSION16_ |
varchar2 |
Dimension 16 Name | Name of dimension 16. | ||
DIMENSION16_ |
varchar2 |
Dimension 16 Value | Value of dimension 16. | ||
DIMENSION17_ |
varchar2 |
Dimension 17 Name | Name of dimension 17. | ||
DIMENSION17_ |
varchar2 |
Dimension 17 Value | Value of dimension 17. | ||
DIMENSION18_ |
varchar2 |
Dimension 18 Name | Name of dimension 18. | ||
DIMENSION18_ |
varchar2 |
Dimension 18 Value | Value of dimension 18. | ||
DIMENSION19_ |
varchar2 |
Dimension 19 Name | Name of dimension 19. | ||
DIMENSION19_ |
varchar2 |
Dimension 19 Value | Value of dimension 19. | ||
DIMENSION1_ |
varchar2 |
Dimension 1 Name | Name of dimension 1. | ||
DIMENSION1_ |
varchar2 |
Dimension 1 Value | Value of dimension 1. | ||
DIMENSION20_ |
varchar2 |
Dimension 20 Name | Name of dimension 20. | ||
DIMENSION20_ |
varchar2 |
Dimension 20 Value | Value of dimension 20. | ||
DIMENSION2_ |
varchar2 |
Dimension 2 Name | Name of dimension 2. | ||
DIMENSION2_ |
varchar2 |
Dimension 2 Value | Value of dimension 2. | ||
DIMENSION3_ |
varchar2 |
Dimension 3 Name | Name of dimension 3. | ||
DIMENSION3_ |
varchar2 |
Dimension 3 Value | Value of dimension 3. | ||
DIMENSION4_ |
varchar2 |
Dimension 4 Name | Name of dimension 4. | ||
DIMENSION4_ |
varchar2 |
Dimension 4 Value | Value of dimension 4. | ||
DIMENSION5_ |
varchar2 |
Dimension 5 Name | Name of dimension 5. | ||
DIMENSION5_ |
varchar2 |
Dimension 5 Value | Value of dimension 5. | ||
DIMENSION6_ |
varchar2 |
Dimension 6 Name | Name of dimension 6. | ||
DIMENSION6_ |
varchar2 |
Dimension 6 Value | Value of dimension 6. | ||
DIMENSION7_ |
varchar2 |
Dimension 7 Name | Name of dimension 7. | ||
DIMENSION7_ |
varchar2 |
Dimension 7 Value | Value of dimension 7. | ||
DIMENSION8_ |
varchar2 |
Dimension 8 Name | Name of dimension 8. | ||
DIMENSION8_ |
varchar2 |
Dimension 8 Value | Value of dimension 8. | ||
DIMENSION9_ |
varchar2 |
Dimension 9 Name | Name of dimension 9. | ||
DIMENSION9_ |
varchar2 |
Dimension 9 Value | Value of dimension 9. | ||
GUI_ |
varchar2 |
GUI Action | Action performed within the user interface. | ||
GUI_ |
varchar2 |
GUI External IP Address | External IP address of the GUI application. | ||
GUI_ |
varchar2 |
GUI Internal IP Address | Internal IP address of the GUI application. | ||
GUI_ |
varchar2 |
GUI Machine | Name of the machine running the GUI application. | ||
GUI_ |
varchar2 |
GUI Module | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI Module Name | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI Module Version | Version of module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI OS User | OS user running the GUI application. | ||
IIID |
varchar2 |
IIID | Invantive installation ID. | ||
IS_ |
char |
Application Managed | Indicator whether event was managed by the application. | ||
IS_ |
char |
Is Monitoring | Indicator whether event must be forwarded for monitoring. | ||
IUID |
varchar2 |
IUID | Invantive user ID. | ||
LAST_ |
datetime |
Logon Time | Date at which the last logon found place. | ||
LAST_ |
varchar2 |
Last Natural Key | Last seen natural key of business object. | ||
LICENSE_ |
varchar2 |
License Contract Code | License contract code. | ||
LICENSE_ |
varchar2 |
License Key Identifier | License key identifier. | ||
LOGGING_ |
varchar2 |
Logging Level | Type of logging message. | ||
MANAGED_ |
int32 |
Managed Thread ID | Managed thread ID. | ||
MESSAGE_ |
varchar2 |
Message Code | Code of the message. May not start with 'itgen' or 'bubs'. | ||
MESSAGE_ |
guid |
Message UID | Specific UID for easy recognition. | ||
METRIC_ |
varchar2 |
Metric Name | Name of monitoring metric. | ||
METRIC_ |
varchar2 |
Metric Value | Value of monitoring metric. | ||
OCCURRENCE_ |
datetime |
Occurrence Date (UTC) | UTC date at which the event occurred. | ||
PARAMETER_ |
varchar2 |
Parameter Values | Parameter values. | ||
PARTITION |
varchar2 |
Partition | Specific partition on which the event was registered. | ||
POOL_ |
varchar2 |
Pool Identity | Pool identity. | ||
PROVIDER_ |
guid |
Provider Instance UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider | Name of provider. | ||
REFERENCE_ |
varchar2 |
Reference Key | Key of the referenced business object. | ||
REFERENCE_ |
varchar2 |
Reference Table Code | Table code of the referenced business object. | ||
REQUEST_ |
varchar2 |
Request ID | Request ID. | ||
SERVICE_ |
varchar2 |
Service Name | Name of service. | ||
SERVICE_ |
varchar2 |
Service State | Status of service (production, acceptance, test). | ||
SESSION_ |
varchar2 |
Session ID | ID of the session. | ||
SHOWN_ |
char |
Shown to User | Indicator whether event was shown to the user. | ||
SQL_ |
varchar2 |
SQL Statement | SQL statement. | ||
TASK_ |
int32 |
Task ID | Task ID. | ||
UNIT_ |
varchar2 |
Unit of Measure | Unit of Measure of value of monitoring metric. | ||
USER_ |
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: