S_TN_AUD_EXTRACT_051_S (ver 18.2.0)
This table is a standalone Audit table for the Extract 51.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| DML_Type | 18.2.0 | Varchar2(5) | Data Transaction Type |
| DMLDate | 18.2.0 | Date | Data Transaction Date |
| ChangedCoreColumnNames | 18.2.0 | Varchar2(4000) | List of column names changed |
| UserID | 18.2.0 | Varchar2(11) | User ID who made the change |
| DataVersion | 18.2.0 | Varchar2(50) | Generated identifier of the data change event. |
| StateEventQueueDCID | 18.2.0 | Number(11,0) | DCID of record saved in the StateEventQueue |
| TableName | 18.2.0 | Varchar2(50) | Name of the table that had a change. |
| E_DCID | 18.2.0 | Number(11,0) | DCID of record that changed (logical key) |
| E_RecordDCID | 18.2.0 | Number(11,0) | DCID of record that changed (logical key) |
| E_ID | 18.2.0 | Number(11,0) | ID of record that changed (logical key) |
| E_StudentID | 18.2.0 | Number(11,0) | ID of the student related to the record that changed (logical key) |
| E_SchoolID | 18.2.0 | Number(11,0) | School ID (logical key) |
| E_Enrollment_SchoolID | 18.2.0 | Number(11,0) | Enrollment School ID (logical key) |
| E_Track | 19.3.0 | Varchar2(20) | Track (logical key) |
| E_SSN | 18.2.0 | Varchar2(12) | SSN (logical key) |
| E_EntryDate | 18.2.0 | Date | Entry Date (logical key). |
| E_ExitDate | 18.2.0 | Date | Exit Date (logical key). |
| E_CompletionDate | 18.2.0 | Date | Completion document date (logical key). |
| E_StudentPIN | 18.2.0 | Varchar2(9) | Student Pin (logical key) |
| E_DistrictOfResidence | 18.2.0 | Varchar2(20) | District of Residence (logical key) |
| E_State_StudentNumber | 18.2.0 | Varchar2(32) | State assigned student id (logical key) |
| E_ExitCode | 18.2.0 | Varchar2(10) | Exit code (logical key) |
| O_ExitDate | 18.2.0 | Date | Old exit date. |
| O_EnrollmentID | 18.2.0 | Number(11,0) | Old enrollment id. |
| O_EndOfServiceAction | 18.2.0 | Varchar2(1) | Old end of service action. |
| O_CompletionDate | 18.2.0 | Date | Old completion document type. |
| O_CompletionType | 18.2.0 | Varchar2(2) | Old completion document type. |
| O_GraduationPeriod | 18.2.0 | Number(11,0) | Old completion document period. |
| N_ExitDate | 18.2.0 | Date | New exit date. |
| N_EnrollmentID | 18.2.0 | Number(11,0) | New enrollment id. |
| N_EndOfServiceAction | 18.2.0 | Varchar2(1) | New end of service action. |
| N_CompletionDate | 18.2.0 | Date | New completion document type. |
| N_CompletionType | 18.2.0 | Varchar2(2) | New completion document type. |
| N_GraduationPeriod | 18.2.0 | Number(11,0) | New completion document period. |