S_TN_AUD_EXTRACT_020_S (ver 18.5.0)
This table is a standalone Audit table for the Extract 20.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| DML_Type | 18.5.0 | Varchar2(5) | Data Transaction Type. |
| DMLDate | 18.5.0 | Date | Data Transaction Date. |
| ChangedCoreColumnNames | 18.5.0 | Varchar2(4000) | List of column names changed. |
| UserID | 18.5.0 | Varchar2(11) | User ID who made the change. |
| DataVersion | 18.5.0 | Varchar2(50) | Generated identifier of the data change event. |
| StateEventQueueDCID | 18.5.0 | Number(11,0) | DCID of record saved in the StateEventQueue |
| TableName | 18.5.0 | Varchar2(30) | Name of the table that had a change. |
| SchoolYear | 18.5.0 | Varchar2(4) | School year of the record that had a change. |
| E_SchoolsDCID | 18.5.0 | Number(11,0) | DCID of the schools record associated with record that changed (logical key). |
| E_ID | 18.5.0 | Number(11,0) | ID of record that changed (logical key). |
| E_SchoolID | 18.5.0 | Number(11,0) | ID of the schools record associated with record that changed (logical key). |
| E_YearID | 18.5.0 | Number(11,0) | ID number of the school year associated with record that changed (logical key). |
| E_CalendarNumber | 18.5.0 | Varchar2(2) | Calendar number for the record that changed (logical key). |
| E_InstructionalProgramNumber | 18.5.0 | Varchar2(2) | Instructional program number for the record that changed (logical key). |
| O_CalendarNumber | 18.5.0 | Varchar2(2) | Old calendar number. |
| O_InstructionalProgramNumber | 18.5.0 | Varchar2(2) | Old instructional program number. |
| O_InstructionalCalendar | 18.5.0 | Varchar2(1) | Old instructional calendar type. |
| O_StudentDayLength | 18.5.0 | Number(11,0) | Old student day length. |
| O_TeacherDayLength | 18.5.0 | Number(11,0) | Old teacher day length. |
| O_Stockpile_PDD | 18.5.0 | Number(11,0) | Old number of stockpile professional development days. |
| O_BlockSchedule | 18.5.0 | Number(11,0) | Old block schedule indicator (Y/N). |
| O_SpringBlockScheduleDate | 18.5.0 | Date | Old spring block begin date. |
| N_CalendarNumber | 18.5.0 | Varchar2(2) | New calendar number. |
| N_InstructionalProgramNumber | 18.5.0 | Varchar2(2) | New instructional program number. |
| N_InstructionalCalendar | 18.5.0 | Varchar2(1) | New instructional calendar type. |
| N_StudentDayLength | 18.5.0 | Number(11,0) | New student day length. |
| N_TeacherDayLength | 18.5.0 | Number(11,0) | New teacher day length. |
| N_Stockpile_PDD | 18.5.0 | Number(11,0) | New number of stockpile professional development days. |
| N_BlockSchedule | 18.5.0 | Number(11,0) | New block schedule indicator (Y/N). |
| N_SpringBlockScheduleDate | 18.5.0 | Date | New spring block begin date. |