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