S_TN_AUD_EXTRACT_044_S (ver 18.2.0)
This table is a standalone Audit table for the Extract 44.
| 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 |
| TableName | 18.2.0 | Varchar2(30) | Name of the table that had a change |
| E_ID | 18.2.0 | Number(11,0) | ID of record that changed (logical key) |
| E_RecordDCID | 18.2.0 | Number(11,0) | DCID of record that changed (logical key) |
| E_SchoolID | 18.2.0 | Number(11,0) | School ID of Student Classification record (logical key) |
| E_ClassificationType | 18.2.0 | Varchar2(80) | Student Classification Type (logical key) |
| E_BeginDate | 18.2.0 | Date | Student Classification Begin Date. (logical key) |
| O_ClassificationType | 18.2.0 | Varchar2(80) | Old Student Classification Type. |
| O_BeginDate | 18.2.0 | Date | Old Student Classification Begin Date. |
| O_EndDate | 18.2.0 | Date | Old Student Classification End Date. |
| N_ClassificationType | 18.2.0 | Varchar2(80) | New Student Classification Type. |
| N_BeginDate | 18.2.0 | Date | New Student Classification Begin Date. |
| N_EndDate | 18.2.0 | Date | New Student Classification End Date. |