Subject Area Name
|
Definition
|
902 - Columns Added
|
Columns added since the last release.
|
|
ER Diagram Name
|
Physical Display Level
|
|
Logical
|
Column
|
|
Physical
|
Column
|
|
Physical Name
|
Entity/Table Name
|
Logical Only
|
Do Not Generate
|
Definition
|
|
|
audit_txn
|
Audit Transaction
|
|
false
|
A record of the Principal and create time of the start of the commit time of a logical transaction. In many cases multiple Audit Log entries will use the same transaction.
|
|
|
Physical Name
|
Attribute/Column Name
|
Definition
|
Physical Data Type
|
|
|
audit_txn_id
|
Audit Transaction Id
|
The automatically generated primary key of the audit_txn table.
|
bigint
|
|
|
txn_start_date
|
Transaction Start 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.
|
datetime
|
|
|
app_user_id
|
Application User Id
|
A Foreign Key to the Application User table. The audit trail transaction may or may not be associated with a customer or agent user. If this column is null, then a system component should be identified.
|
bigint
|
|
|
sys_component_id
|
System Component Id
|
This is a foreign key to the system component table. The audit trail transaction may or may not be associated with a customer or agent user. The system component will be set if there is no application user identified. It identifies the source of the transaction. Values include SYSTEM, WEB_SERVICES, ASSET_MANAGEMENT, CALENDAR,
IMPORTING, etc. All identifiers are negative, so that they can be distinguished from userids in case they are both stored in the same dynamic table CreatedBy, and UpdatedBy fields. We are going to try first normal form normalization here and see if it works.
|
int
|
|
|
audit_rule_name_id
|
Audit Rule Name Id
|
The primary key is the original rule definition id. It will not change as the rule is renamed. If the rule is deleted, the deleted date will be filled in, but the rule name will still be known in this table.
|
bigint
|