Audit Columns
The following four audit columns will be created automatically in each state/provincial-specific table.
Column Name | Data Type | Description |
|---|---|---|
WhoCreated | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhenCreated | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhoModified | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |
WhenModified | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |