S_TN_AUD_EXTRACT_046_S (ver 18.2.0)
This table is a standalone Audit table for the Extract 46.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| DML_Type | 18.2.0 | Varchar2(5) | Data Transaction Type |
| DMLDate | 18.2.0 | Date | Data Transaction Date |
| ChangedCoreColumnNames | 18.2.0 | Varchar2(4000) | List of column names changed |
| UserID | 18.2.0 | Varchar2(11) | User ID who made the change |
| DataVersion | 18.2.0 | Varchar2(50) | Generated identifier of the data change event. |
| StateEventQueueDCID | 18.2.0 | Number(11,0) | DCID of record saved in the StateEventQueue |
| E_DCID | 18.2.0 | Number(11,0) | DCID of record that changed (logical key) |
| E_ID | 18.2.0 | Number(11,0) | ID of record that changed (logical key) |
| E_StudentID | 18.2.0 | Number(11,0) | ID of the student related to the record that changed (logical key) |
| E_SchoolID | 18.2.0 | Number(11,0) | School ID of log record (logical key) |
| E_Discipline_ActionTaken | 18.2.0 | Varchar2(79) | Disciplinary Action Type (logical key) |
| E_Discipline_ActionDate | 18.2.0 | Date | Disciplinary Begin Date. (logical key) |
| E_LogDCID | 18.2.0 | Number(11,0) | DCID of the Log record that changed (logical key) |
| O_DisciplineActionTaken | 18.2.0 | Varchar2(79) | Old Disciplinary Action Type. |
| O_Discipline_ActionDate | 18.2.0 | Date | Old disciplinary begin date. |
| O_Discipline_ActionTakenEndDat | 18.2.0 | Date | Old disciplinary end date. |
| O_Discipline_IncidentTypeCateg | 18.2.0 | Varchar2(79) | Old disciplinary primary reason. |
| O_Discipline_IncidentDate | 18.2.0 | Date | Old disciplinary offense date. |
| O_ZeroTolerance_YN | 18.2.0 | Varchar2(1) | Old zero-tolerance. |
| O_ModifiedAction_YN | 18.2.0 | Varchar2(1) | Old SE modified action. |
| O_DisciplinaryActAuthority | 18.2.0 | Varchar2(1) | Old SE disciplinary action authority. |
| N_DisciplineActionTaken | 18.2.0 | Varchar2(79) | New Disciplinary Action Type. |
| N_Discipline_ActionDate | 18.2.0 | Date | New disciplinary begin date. |
| N_Discipline_ActionTakenEndDat | 18.2.0 | Date | New disciplinary end date. |
| N_Discipline_IncidentTypeCateg | 18.2.0 | Varchar2(79) | New disciplinary primary reason. |
| N_Discipline_IncidentDate | 18.2.0 | Date | New disciplinary offense date. |
| N_ZeroTolerance_YN | 18.2.0 | Varchar2(1) | New zero-tolerance. |
| N_ModifiedAction_YN | 18.2.0 | Varchar2(1) | New SE modified action. |
| N_DisciplinaryActAuthority | 18.2.0 | Varchar2(1) | New SE disciplinary action authority. |