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. |