S_TN_AUD_EXTRACT_040_S (ver 17.9.1)
This table is a standalone Audit table for the Extract 40.
| 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(30) | 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_Track | 19.3.0 | Varchar2(20) | Track (logical key) |
| E_SSN | 17.9.1 | Varchar2(12) | SSN (logical key) |
| E_StudentPIN | 17.9.1 | Varchar2(9) | Student Pin (logical key) |
| O_StudentID | 17.9.1 | Number(11,0) | Old Student ID |
| O_DOB | 17.9.1 | Date | Old Date of Birth |
| O_FedEthnicity | 17.9.1 | Number(11,0) | Old Federal Ethnicity |
| O_First_Name | 17.9.1 | Varchar2(50) | Old First Name |
| O_Gender | 17.9.1 | Varchar2(2) | Old Gender |
| O_Last_Name | 17.9.1 | Varchar2(50) | Old Last Name |
| O_Middle_Name | 17.9.1 | Varchar2(30) | Old Middle Name |
| O_SchoolID | 17.9.1 | Number(11,0) | Old School ID |
| O_SSN | 17.9.1 | Varchar2(12) | Old SSN |
| O_State_StudentNumber | 17.9.1 | Varchar2(32) | Old State Student Number |
| O_StudentPIN | 17.9.1 | Varchar2(9) | Old Student PIN |
| O_Track | 19.3.0 | Varchar2(20) | Old Track |
| O_NameSuffix | 17.9.1 | Varchar2(10) | Old Name Suffix |
| O_PrevSSN | 17.9.1 | Varchar2(11) | Old Previous Social Security Number |
| O_PrevStudentID | 17.9.1 | Varchar2(9) | Old Previous Student ID |
| O_PrevFirstName | 17.9.1 | Varchar2(25) | Old Previous First name |
| O_PrevMiddleName | 17.9.1 | Varchar2(25) | Old Previous Middle Name |
| O_PrevLastName | 17.9.1 | Varchar2(35) | Old Previous Last Name |
| O_ImmigrantStudent | 17.9.1 | Varchar2(1) | Old Immigrant Student |
| O_DateFirstEnrolledInUSSchool | 17.9.1 | Date | Old Date First Enrolled In US School |
| O_YearEnteredNinthGrade | 17.9.1 | Number(11,0) | Old Year Entered Ninth Grade |
| O_DateFirstEnrolledInESLProgra | 17.9.1 | Date | Old Date First Enrolled In ESL Program |
| O_NativeLanguage | 17.9.1 | Varchar2(3) | Old Native Language |
| O_MothersMaidenName | 17.9.1 | Varchar2(25) | Old Mothers Maiden Name |
| O_CityOfBirth | 17.9.1 | Varchar2(30) | Old City of Birth |
| O_CountyBirthCode | 17.9.1 | Varchar2(3) | Old County Birth Code |
| O_StateBirthCode | 17.9.1 | Varchar2(2) | Olde State Birth Code |
| O_CountryBirthCode | 17.9.1 | Varchar2(2) | Old Country Birth Code |
| O_ELB | 17.9.1 | Varchar2(1) | Old ELB |
| N_StudentID | 17.9.1 | Number(11,0) | New Student ID |
| N_DOB | 17.9.1 | Date | New Date of Birth |
| N_FedEthnicity | 17.9.1 | Number(11,0) | New Federal Ethnicity |
| N_First_Name | 17.9.1 | Varchar2(50) | New First Name |
| N_Gender | 17.9.1 | Varchar2(2) | New Gender |
| N_Last_Name | 17.9.1 | Varchar2(50) | New Last Name |
| N_Middle_Name | 17.9.1 | Varchar2(30) | New Middle Name |
| N_SchoolID | 17.9.1 | Number(11,0) | New School ID |
| N_SSN | 17.9.1 | Varchar2(12) | New SSN |
| N_State_StudentNumber | 17.9.1 | Varchar2(32) | New State Student Number |
| N_StudentPIN | 17.9.1 | Varchar2(9) | New Student PIN |
| N_Track | 19.3.0 | Varchar2(20) | New Track |
| N_NameSuffix | 17.9.1 | Varchar2(10) | New Name Suffix |
| N_PrevSSN | 17.9.1 | Varchar2(11) | New Previous Social Security Number |
| N_PrevStudentID | 17.9.1 | Varchar2(9) | New Previous Student ID |
| N_PrevFirstName | 17.9.1 | Varchar2(25) | New Previous First name |
| N_PrevMiddleName | 17.9.1 | Varchar2(25) | New Previous Middle Name |
| N_PrevLastName | 17.9.1 | Varchar2(35) | New Previous Last Name |
| N_ImmigrantStudent | 17.9.1 | Varchar2(1) | New Immigrant Student |
| N_DateFirstEnrolledInUSSchool | 17.9.1 | Date | New Date First Enrolled In US School |
| N_YearEnteredNinthGrade | 17.9.1 | Number(11,0) | New Year Entered Ninth Grade |
| N_DateFirstEnrolledInESLProgra | 17.9.1 | Date | New Date First Enrolled In ESL Program |
| N_NativeLanguage | 17.9.1 | Varchar2(3) | New Native Language |
| N_MothersMaidenName | 17.9.1 | Varchar2(25) | New Mothers Maiden Name |
| N_CityOfBirth | 17.9.1 | Varchar2(30) | New City of Birth |
| N_CountyBirthCode | 17.9.1 | Varchar2(3) | New County Birth Code |
| N_StateBirthCode | 17.9.1 | Varchar2(2) | New State Birth Code |
| N_CountryBirthCode | 17.9.1 | Varchar2(2) | New Country Birth Code |
| N_ELB | 17.9.1 | Varchar2(1) | New ELB |