Auditing Tables/Fields
Tables
The following table prefixes may or may not exist for any given table at any given time as these are added dynamically depending on the configuration.
| Table Name Prefix | |
|---|---|
| AU_ | Audit Tables |
| DQ$ | Data Version Subscriptions |
| LG_ | Log Tables |
Fields
The following fields may or may not exist on any given table at any given time as these are added dynamically depending on the configuration. Columns may be present based on past configurations but no longer populated.
Note: Core and Compliance can both trigger these to be added to any given table.
| Column Name | DataType |
|---|---|
| ExecutionID | Varchar2(64) |
| IP_Address | Varchar2(39) |
| Transaction_Date | Timestamp(6) |
| WhoModifiedID | Number(10,0) |
| WhoModifiedType | Varchar2(1) |
WhoModifiedType
The following table represents the values that are found in the WhoModifiedType field.
| Code | User |
|---|---|
| a | Administrator |
| m | Maintenance |
| n | No Session - This includes all non-authenticated user changes. Such as AutoComm and background processes |
| p | Parent |
| s | Student |
| t | Teacher |
| u | Substitute |
| x | OAuth Plugin/API |