S_TN_AUD_EXTRACT_031_S (ver 18.10.0)
This table is a standalone Audit table for the Extract 31.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| 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_Course_Number | 18.10.0 | Varchar2(11) | Course code for this course (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_SchoolID | 18.10.0 | Number(11,0) | ID of the school to which the updated section is attached (logical key). |
| E_Section_Number | 18.10.0 | Varchar2(10) | Section Number of the updated section (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). |
| N_Course_Number | 18.10.0 | Varchar2(11) | New course code for this course. |
| N_Expression | 18.10.0 | Varchar2(80) | New expression for the updated section. |
| N_Id | 18.10.0 | Number(11,0) | New ID. |
| N_InstructionalProgramNbr | 18.10.0 | Varchar2(2) | New instructional program number. |
| N_OtherPrimarySchools | 18.10.0 | Varchar2(2500) | New other primary schools. |
| N_Section_Number | 18.10.0 | Varchar2(10) | New section number of the updated section. |
| O_Course_Number | 18.10.0 | Varchar2(11) | Old course code for this course. |
| O_Expression | 18.10.0 | Varchar2(80) | Old expression for the updated section. |
| O_Id | 18.10.0 | Number(11,0) | Old ID |
| O_InstructionalProgramNbr | 18.10.0 | Varchar2(2) | Old instructional program number. |
| O_OtherPrimarySchools | 18.10.0 | Varchar2(2500) | Old other primary schools. |
| O_Section_Number | 18.10.0 | Varchar2(10) | Old section number of the updated section. |
| 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 of the user who made the change. |