S_TN_AUD_EXTRACT_011_S (ver 18.2.0)
This table is a standalone Audit table for the Extract 11.
| 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 |
| SchoolYear | 18.2.0 | Varchar2(4) | School year of the record that had a change. |
| E_ID | 18.2.0 | Number(11,0) | ID of record that changed (logical key) |
| E_A | 18.2.0 | Number(11,0) | In session track A (logical key) |
| E_B | 18.2.0 | Number(11,0) | In session track B (logical key) |
| E_C | 18.2.0 | Number(11,0) | In session track C (logical key) |
| E_D | 18.2.0 | Number(11,0) | In session track D (logical key) |
| E_E | 18.2.0 | Number(11,0) | In session track E (logical key) |
| E_F | 18.2.0 | Number(11,0) | In session track F (logical key) |
| E_DistrictCalendarID | 18.2.0 | Number(11,0) | ID of the related calendar (logical key) |
| E_DateValue | 18.2.0 | Date | Date of the changed record (logical key) |
| E_Note | 18.2.0 | Varchar2(50) | Note (logical key) |
| E_MembershipValue | 18.2.0 | Varchar2(25,10) | Membership Value (logical key) |
| E_Type | 18.2.0 | Number(11,0) | Type (logical key). |
| E_DistrictCycleDayId | 18.2.0 | Number(11,0) | Id of the related Cycle Day (logical key). |
| E_DistrictBellScheduleId | 18.2.0 | Number(11,0) | Id of the related Bell Schedule (logical key). |
| O_DateValue | 18.2.0 | Date | Old date value. |
| O_Type | 18.2.0 | Number(11,0) | Old type. |
| O_DistrictBellScheduleId | 18.2.0 | Number(11,0) | Old related bell schedule. |
| O_InSession | 18.2.0 | Number(1,0) | Old in-session flag. |
| N_DateValue | 18.2.0 | Date | New date value. |
| N_Type | 18.2.0 | Number(11,0) | New type. |
| N_DistrictBellScheduleId | 18.2.0 | Number(11,0) | New related bell schedule. |
| N_InSession | 18.2.0 | Number(1,0) | New in-session flag. |