S_TN_AUD_EXTRACT_041_S (ver 17.9.1)
This table is a standalone Audit table for the Extract 41.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| DML_Type | 17.9.1 | Varchar2(5) | Data Transaction Type |
| DMLDate | 17.9.1 | Date | Data Transaction Date |
| ChangedCoreColumnNames | 17.9.1 | Varchar2(4000) | List of column names changed |
| UserID | 17.9.1 | Varchar2(11) | User ID who made the change |
| DataVersion | 17.9.1 | Varchar2(50) | Generated identifier of the data change event |
| TableName | 17.9.1 | Varchar2(50) | Name of the table that had a change |
| E_DCID | 17.9.1 | Number(11,0) | DCID (logical key) |
| E_RecordDCID | 17.9.1 | Number(11,0) | DCID of record that changed (logical key) |
| E_ID | 17.9.1 | Number(11,0) | ID (logical key) |
| E_StudentID | 17.9.1 | Number(11,0) | Student ID (logical key) |
| E_SchoolID | 17.9.1 | Number(11,0) | School ID (logical key) |
| E_Enrollment_SchoolID | 17.9.1 | Number(11,0) | Enrollment School ID (logical key) |
| E_Track | 19.3.0 | Varchar2(20) | Track (logical key) |
| E_SSN | 17.9.1 | Varchar2(12) | SSN (logical key) |
| E_EntryDate | 17.9.1 | Date | Entry Date (logical key). |
| E_StudentPIN | 17.9.1 | Varchar2(9) | Student Pin (logical key) |
| E_DistrictOfResidence | 17.9.1 | Varchar2(20) | District of Residence (logical key) |
| E_State_StudentNumber | 17.9.1 | Varchar2(32) | State Student Number (logical key) |
| O_EntryDate | 17.9.1 | Date | Old Entry Date |
| O_EntryCode | 19.3.0 | Varchar2(80) | Old Entry Code |
| O_DistrictOfResidence | 17.9.1 | Varchar2(20) | Old District of Residence |
| O_Enrollment_SchoolID | 17.9.1 | Number(11,0) | Old Enrollment School ID |
| O_ISPTOS | 17.9.1 | Varchar2(1) | Old ISPTOS. |
| O_ELB | 17.9.1 | Varchar2(1) | Old ELB |
| O_CourseOfStudy | 17.9.1 | Varchar2(1) | Old Course of Study |
| O_HomelessPrimaryNightTimeRes | 17.9.1 | Varchar2(2) | Old Homeless Primary Night Time Residence |
| O_HomelessServedByMckinney | 17.9.1 | Varchar2(1) | Old Homeless Served by McKinney |
| O_HomelessUnaccompaniedYouth | 17.9.1 | Varchar2(1) | Old Homeless Unaccompanied Youth |
| N_EntryDate | 17.9.1 | Date | New Entry Date |
| N_EntryCode | 19.3.0 | Varchar2(80) | New Entry Code |
| N_DistrictOfResidence | 17.9.1 | Varchar2(20) | New District of Residence |
| N_Enrollment_SchoolID | 17.9.1 | Number(11,0) | New Enrollment School ID |
| N_ISPTOS | 17.9.1 | Varchar2(1) | New ISPTOS |
| N_ELB | 17.9.1 | Varchar2(1) | New ELB |
| N_CourseOfStudy | 17.9.1 | Varchar2(1) | New Course of Study |
| N_HomelessPrimaryNightTimeRes | 17.9.1 | Varchar2(2) | New Homeless Primary Night Time Residence |
| N_HomelessServedByMckinney | 17.9.1 | Varchar2(1) | New Homeless Served by McKinney |
| N_HomelessUnaccompaniedYouth | 17.9.1 | Varchar2(1) | New Homeless Unaccompanied Youth |