AU_Log ver 19.7.1.0
An audit table to capture changes to the Log table. In order to generate data the plugin DCF: USA OH Audit must be enabled.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AUD_SEQ | 19.7.1.0 | Number(19) | The system assigned number for the record. |
| Transaction_Date | 19.7.1.0 | TimeStamp(6) | The date the change was made. |
| DML_Type | 19.7.1.0 | VarChar2(1) | Indicates the type of change: update, insert or delete. Table values are saved as U, I, or D |
| DCID | 19.7.1.0 | Number(10) | The DCID of the record that is changed. |
| ID | 19.7.1.0 | Number(10) | The ID of the record that is changed. |
| O_ID | 19.7.1.0 | Number(10) | The previous (old) ID for the record. |
| N_ID | 19.7.1.0 | Number(10) | The new ID for the record. |
| IP_Address | 19.7.1.0 | VarChar2(39) | The IP address associated with the computer from which this change was processed. |
| LogTypeID | 19.7.1.0 | Number(10) | The Log Type ID associated with the record. |
| StudentID | 19.7.1.0 | Number(10) | The student's ID. |
| WhoModifiedID | 19.7.1.0 | Number(10) | The user ID of the person who made the change. |
| WhoModifiedType | 19.7.1.0 | VarChar2(1) | The user type associated with the person who made the change. Table values are saved as A for Admin; T for Teacher; P for Parent; S for Student; U for Substitute; M for Maintenance and '?' for Unknown. |