S_TN_AUD_EXTRACT_010_S (ver 18.3.0)
This table is a standalone Audit table for the Extract 10.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ChangedCoreColumnNames | 18.3.0 | Varchar2(4000) | List of column names changed. |
| DataVersion | 18.3.0 | Varchar2(50) | Generated identifier of the data change event. |
| DML_Type | 18.3.0 | Varchar2(5) | Data transaction type. |
| DMLDate | 18.3.0 | Date | Data transaction date. |
| E_CalendarNumber | 18.3.0 | Number(11,0) | ID of the related calendar (logical key). |
| E_ID | 18.3.0 | Number(11,0) | ID of record that changed (logical key). |
| EndDate | 18.3.0 | Date | End date of the calendar. |
| N_AbbreviatedDays | 18.3.0 | Number(11,0) | New number of abbreviated days. |
| N_CalendarDescription | 18.3.0 | Varchar2(50) | New calendar description. |
| N_CalendarName | 18.3.0 | Varchar2(50) | New calendar name. |
| N_DiscretAdminDays | 18.3.0 | Number(25,10) | New number of discretionary administrative days. |
| N_DiscretInServiceDays | 18.3.0 | Number(25,10) | New number of discretionary in-service days. |
| N_DiscretInstructionalDays | 18.3.0 | Number(25,10) | New number of discretionary instructional days. |
| N_DiscretOtherDays | 18.3.0 | Number(25,10) | New number of discretionary other days. |
| N_DiscretTeacherVacDays | 18.3.0 | Number(25,10) | New number of discretionary teacher vacation days. |
| N_ExtendedDayMakeup | 18.3.0 | Number(25,10) | New number for extended day makeup. |
| N_InServiceDays | 18.3.0 | Number(25,10) | New number of in-service days. |
| N_InstructionalCalendar | 18.3.0 | Varchar2(50) | New name of the updated calendar. |
| N_InstructionalDays | 18.3.0 | Number(11,0) | New number of instructional days. |
| N_OptionalInServiceDays | 18.3.0 | Number(25,10) | New number of optional in-service days. |
| N_ParentTeacherDays | 18.3.0 | Number(11,0) | New number of parent/teacher conference days. |
| N_ScheduleDays | 18.3.0 | Varchar2(50) | New scheuled days in the updated calendar. |
| N_StockpileIWD | 18.3.0 | Number(11,0) | New number of stockpile inclement weather days. |
| N_StockpilePDD | 18.3.0 | Number(11,0) | New number of stockpile professional development days. |
| N_TeacherVacationDays | 18.3.0 | Number(11,0) | New number of teacher vacation days. |
| O_AbbreviatedDays | 18.3.0 | Number(11,0) | Old number of abbreviated days. |
| O_CalendarDescription | 18.3.0 | Varchar2(50) | Old calendar description. |
| O_CalendarName | 18.3.0 | Varchar2(50) | Old calendar name. |
| O_DiscretAdminDays | 18.3.0 | Number(25,10) | Old number of discretionary administrative days. |
| O_DiscretInServiceDays | 18.3.0 | Number(25,10) | Old number of discretionary in-service days. |
| O_DiscretInstructionalDays | 18.3.0 | Number(25,10) | Old number of discretionary instructional days. |
| O_DiscretOtherDays | 18.3.0 | Number(25,10) | Old number of discretionary other days. |
| O_DiscretTeacherVacDays | 18.3.0 | Number(25,10) | Old number of discretionary teacher vacation days. |
| O_ExtendedDayMakeup | 18.3.0 | Number(25,10) | Old number for extended day makeup. |
| O_InServiceDays | 18.3.0 | Number(25,10) | Old number of in-service days. |
| O_InstructionalCalendar | 18.3.0 | Varchar2(50) | Old name of the updated calendar. |
| O_InstructionalDays | 18.3.0 | Number(11,0) | Old number of instructional days. |
| O_OptionalInServiceDays | 18.3.0 | Number(25,10) | Old number of optional in-service days. |
| O_ParentTeacherDays | 18.3.0 | Number(11,0) | Old number of parent/teacher conference days. |
| O_ScheduleDays | 18.3.0 | Varchar2(50) | Old scheuled days in the updated calendar. |
| O_StockpileIWD | 18.3.0 | Number(11,0) | Old number of stockpile inclement weather days. |
| O_StockpilePDD | 18.3.0 | Number(11,0) | Old number of stockpile professional development days. |
| O_TeacherVacationDays | 18.3.0 | Number(11,0) | Old number of teacher vacation days. |
| StartDate | 18.3.0 | Date | Start date of the calendar. |
| StateEventQueueDCID | 18.3.0 | Number(11,0) | DCID of record saved in the StateEventQueue. |
| TableName | 18.3.0 | Varchar2(50) | Name of the updated table. |
| UserID | 18.3.0 | Varchar2(11) | User ID who made the change. |
| YearID | 18.3.0 | Varchar2(4) | School year of the record that had a change. |