Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Audit Log Id |
The automatically generated primary key of the audit_log table. |
LONG |
Yes |
Audit Event Type Id |
The unique identifier for an instance of Audit Event Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values.
|
LONG |
Yes |
Audit Transaction Id |
A Foreign Key to the Audit Transaction table. |
LONG |
Yes |
Create Date |
The transaction date of the Audit Log entry. This date may not be in strict order with the Audit Log id in the event that features are used to continue a previous Audit Log transaction.
|
DATE |
Yes |
Insert Update Delete Code |
Indicates I-Insert, U-Update, D-Delete database action. |
VARCHAR(255) |
No |
String Parameter 1 |
A substitution parameter for the referenced formatted string. |
VARCHAR(4000) |
No |
String Parameter 2 |
A substitution parameter for the referenced formatted string. |
VARCHAR(255) |
No |
String Parameter 3 |
A substitution parameter for the referenced formatted string. |
VARCHAR(255) |
No |
String Parameter 4 |
A substitution parameter for the referenced formatted string. |
VARCHAR(255) |
No |
String Parameter 5 |
A substitution parameter for the referenced formatted string. |
VARCHAR(255) |
No |
String Parameter 6 |
A substitution parameter for the referenced formatted string. |
VARCHAR(255) |
No |
String Parameter 7 |
A substitution parameter for the referenced formatted string. |
VARCHAR(255) |
No |
String Parameter 7 Int |
This is a computed column. The integer version of parameter 7. It is only indexed when parameter 8 is '_USER_SESSION_'. It greatly increases the User browse screens ability to compute the last_login.
|
VARCHAR(4000) |
No |
String Parameter 8 |
A substitution parameter for the referenced formatted string. |
VARCHAR(255) |
No |
Raw Message |
The value of a Audit Log, stored as a long text object. |
TEXT |
No |
Audit Property Dimension Id |
A Foreign Key to the Audit Property Dimension table. |
LONG |
No |
Domain Object Id |
The numeric Primary Key of the Object that is autologged. |
LONG |
No |
Audit Message Template Id |
A Foreign Key to the Audit Message Template table. |
LONG |
No |