Name |
Datatype |
Comment |
Is PK |
Is FK |
audit_log_id |
bigint |
The automatically generated primary key of the audit_log table. |
Yes |
No |
audit_event_type_id |
BIGINT |
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.
|
No |
Yes |
audit_txn_id |
bigint |
A Foreign Key to the Audit Transaction table. |
No |
Yes |
create_date |
datetime |
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.
|
No |
No |
insert_update_delete_cd |
varchar(255) |
Indicates I-Insert, U-Update, D-Delete database action. |
No |
No |
string_parm_1 |
varchar(4000) |
A substitution parameter for the referenced formatted string. |
No |
No |
string_parm_2 |
varchar(255) |
A substitution parameter for the referenced formatted string. |
No |
No |
string_parm_3 |
varchar(255) |
A substitution parameter for the referenced formatted string. |
No |
No |
string_parm_4 |
varchar(255) |
A substitution parameter for the referenced formatted string. |
No |
No |
string_parm_5 |
varchar(255) |
A substitution parameter for the referenced formatted string. |
No |
No |
string_parm_6 |
varchar(255) |
A substitution parameter for the referenced formatted string. |
No |
No |
string_parm_7 |
varchar(255) |
A substitution parameter for the referenced formatted string. |
No |
No |
string_parm_8 |
varchar(255) |
A substitution parameter for the referenced formatted string. |
No |
No |
raw_msg |
varchar(max) |
The value of a Audit Log, stored as a long text object. |
No |
No |
audit_prop_dim_id |
bigint |
A Foreign Key to the Audit Property Dimension table. |
No |
Yes |
domain_obj_id |
bigint |
The numeric Primary Key of the Object that is autologged. |
No |
No |
audit_msg_tmpl_id |
bigint |
A Foreign Key to the Audit Message Template table. |
No |
Yes |
string_parm_7_int |
varchar(4000) |
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.
|
No |
No |