S_TN_AUD_EXTRACT_048_S (ver 18.5.0)
This table is a standalone Audit table for the Extract 48.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| DML_Type | 18.5.0 | Varchar2(5) | Data Transaction Type. |
| DMLDate | 18.5.0 | Date | Data Transaction Date. |
| ChangedCoreColumnNames | 18.5.0 | Varchar2(4000) | List of column names changed. |
| UserID | 18.5.0 | Varchar2(11) | User ID who made the change. |
| DataVersion | 18.5.0 | Varchar2(50) | Generated identifier of the data change event. |
| TableName | 18.5.0 | Varchar2(30) | Name of the table that had a change. |
| E_DCID | 18.5.0 | Number(11,0) | DCID of the record that changed (logical key). |
| E_ID | 18.5.0 | Number(11,0) | ID of record that changed (logical key). |
| E_StudentID | 18.5.0 | Number(11,0) | ID of the student associated with record that changed (logical key). |
| E_SchoolID | 18.5.0 | Number(11,0) | ID of the schools record associated with record that changed (logical key). |
| E_SectionID | 18.5.0 | Number(11,0) | ID of the section associated with record that changed (logical key). |
| E_DateEnrolled | 18.5.0 | Date | Date the student enrolled in the section (logical key). |
| E_SpEnrollmentsDCID | 18.5.0 | Number(11,0) | DCID of the Special Programs enrollment that changed (logical key). |
| E_Course_Number | 18.5.0 | Varchar2(11) | Course number associated with the record that changed. (logical key). |
| E_Track | 19.3.0 | Varchar2(20) | Track (logical key). |
| E_SSN | 18.5.0 | Varchar2(12) | SSN (logical key). |
| E_StudentPIN | 18.5.0 | Varchar2(9) | Student Pin (logical key). |
| E_State_StudentNumber | 18.5.0 | Varchar2(32) | State Student Number (logical key). |
| O_DateEnrolled | 18.5.0 | Date | Old date the student enrolled in the section. |
| O_DateLeft | 18.5.0 | Date | Old date the student left the section. |
| O_VocOutsideIEP | 19.3.0 | Varchar2(25) | Old Vocational Outside IEP indicator. |
| O_SchoolYear | 18.5.0 | Varchar2(10) | Old Vocational Outside IEP school year. |
| N_DateEnrolled | 18.5.0 | Date | New date the student enrolled in the section. |
| N_DateLeft | 18.5.0 | Date | New date the student left the section. |
| N_VocOutsideIEP | 19.3.0 | Varchar2(25) | New Vocational Outside IEP indicator. |
| N_SchoolYear | 18.5.0 | Varchar2(10) | New Vocational Outside IEP school year. |