Au_TableName_ (ver9.1.0)
Au_[TableName] tables are audit tables. These tables are created dynamically when a data change subscription is processed. The audit records stored in these tables belong to the [TableName]. These tables will have one or more [LogicalKeyFieldName] columns and one or more set of N_[FieldName] and O_[FieldName] columns. These columns have the same type and size as their equivalent in the source [TableName]. These tables and column are not removed when no longer being populated by any active subscriptions.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Aud_Seq | 9.1.0 | Number(19) | Unique identifier for this table. Required. |
DML_Type | 9.1.0 | Varchar2(1) | The type of record transaction. The possible values are I, D, and U. I=Insert, D=Delete, U=Update. |
IP_Address | 9.1.0 | Varchar2(39) | The IP address of the client that initiated the transaction. |
[LogicalKeyFieldName] | ver.. | Based on source field type | A logical key field. There may be 1 or more of these fields. |
N_[FieldName] | ver.. | Based on source field type | The new value of the field. There may be 1 or more of these fields. |
O_[FieldName] | ver.. | Based on source field type | The old value of the field. There may be 1 or more of these fields. |
Transaction_Date | 9.1.0 | Timestamp | The timestamp fo the transaction. |
WhoModifiedID | 9.1.0 | Number(10) | The ID of the client that initiated the transaction. |
WhoModifiedType | 9.1.0 | Varchar2(1) | The type of the client that initiated the transaction. |