S_TN_AUD_EXTRACT_030_S (ver 18.10.0)
This table is a standalone Audit table for Extract 30.
Column Name | Version | Data Type | Description |
---|---|---|---|
BeginDate | 18.10.0 | Date | Begin date for the updated class. |
ChangedCoreColumnNames | 18.10.0 | Varchar2(4000) | List of column names changed. |
DataVersion | 18.10.0 | Varchar2(50) | Generated identifier of the data change event. |
DMLDate | 18.10.0 | Date | Data Transaction Date. |
DML_Type | 18.10.0 | Varchar2(5) | Data Transaction Type. |
E_AddlSchoolID | 18.10.0 | Number(11,0) | Additional SchoolID to generate EIS 030 records for this section. (logical key) |
E_Alt_Course_Number | 18.10.0 | Varchar2(4000) | Alternate SDE course code for this course. (logical key) |
E_Course_Number | 18.10.0 | Varchar2(11) | course code for this course. (logical key) |
E_CoursesDCID | 18.10.0 | Number(11,0) | DCID of the courses record corresponding to this change. (logical key) |
E_DCID | 18.10.0 | Number(11,0) | DCID (logical key) |
E_ID | 18.10.0 | Number(11,0) | ID (logical key) |
E_InstructionalProgramNbr | 18.10.0 | Varchar2(2) | (logical key) |
E_Section_Number | 18.10.0 | Varchar2(11) | Section number for this class. (logical key) |
E_SchoolID | 18.10.0 | Number(11,0) | ID of the school to which the updated section is attached. (logical key) |
E_SectionsDCID | 18.10.0 | Number(11,0) | DCID of the updated section. (logical key) |
E_TermID | 18.10.0 | Number(11,0) | ID of the term to which the updated record is attached. (logical key) |
EndDate | 18.10.0 | Date | Begin date for the updated class. |
N_Alt_Course_Number | 18.10.0 | Varchar2(4000) | New Alternate SDE course code for this course. |
N_Course_Number | 18.10.0 | Varchar2(11) | New course code for this course. |
N_ClassType | 18.10.0 | Varchar2(1) | New class type. |
N_DualEnrollment | 18.10.0 | Varchar2(5) | New dual enrollment indicator. |
N_HonorsClassIndicator | 18.10.0 | Varchar2(1) | New honors class indicator. |
N_ID | 18.10.0 | Number(11,0) | New ID |
N_InstructionalProgramNbr | 18.10.0 | Varchar2(2) | New instructional program number. |
N_Section_Number | 18.10.0 | Varchar2(11) | New section number for this class. |
N_LocalDualCredit | 18.10.0 | Varchar2(5) | New local dual credit. |
N_OtherPrimarySchools | 18.10.0 | Varchar2(2500) | New other primary schools. |
N_SecondaryInstuition | 18.10.0 | Varchar2(50) | New Secondary Institution ID as a string. |
N_StateDualCredit | 18.10.0 | Varchar2(5) | New state dual credit indicator. |
N_TeachingMethod | 18.10.0 | Varchar2(1) | New teaching method. |
N_TestAdminWindow | 18.10.0 | Varchar2(5) | New test administration window. |
N_WhereTaught | 18.10.0 | Number(11,0) | New school where taught. |
N_WhereTaughtDistrict | 18.10.0 | Number(11,0) | New district number where taught. |
O_Alt_Course_Number | 18.10.0 | Varchar2(4000) | Old Alternate SDE course code for this course. |
O_Course_Number | 18.10.0 | Varchar2(11) | Old course code for this course. |
O_ClassType | 18.10.0 | Varchar2(1) | Old class type. |
O_DualEnrollment | 18.10.0 | Varchar2(5) | Old dual enrollment indicator. |
O_HonorsClassIndicator | 18.10.0 | Varchar2(1) | Old honors class indicator. |
O_ID | 18.10.0 | Number(11,0) | Old ID |
O_InstructionalProgramNbr | 18.10.0 | Varchar2(2) | Old instructional program number. |
O_Section_Number | 18.10.0 | Varchar2(11) | Old section number for this class. |
O_LocalDualCredit | 18.10.0 | Varchar2(5) | Old local dual credit. |
O_OtherPrimarySchools | 18.10.0 | Varchar2(2500) | Old other primary schools. |
O_SecondaryInstuition | 18.10.0 | Varchar2(50) | Old Secondary Institution ID as a string. |
O_StateDualCredit | 18.10.0 | Varchar2(5) | Old state dual credit indicator. |
O_TeachingMethod | 18.10.0 | Varchar2(1) | Old teaching method. |
O_TestAdminWindow | 18.10.0 | Varchar2(5) | Old test administration window. |
O_WhereTaught | 18.10.0 | Number(11,0) | Old school number where taught. |
O_WhereTaughtDistrict | 18.10.0 | Number(11,0) | Old district number where taught. |
SchoolYear | 18.10.0 | Varchar2(4) | School year of the updated record. |
StateEventQueueDCID | 18.10.0 | Number(11,0) | DCID for the record created in the StateEventQueue. |
TableName | 18.10.0 | Varchar2(50) | Name of the table that had a change. |
UserID | 18.10.0 | Varchar2(11) | User ID who made the change. |