S_TN_AUD_EXTRACT_045_S (ver 18.2.0)
This table is a standalone Audit table for the Extract 45.
| 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(30) | Name of the table that had a change |
| E_DCID | 18.2.0 | Number(11,0) | DCID 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 of transportation record (logical key) |
| E_FromTo | 18.2.0 | Varchar2(80) | Indicates if the bus travels to or from school (logical key) |
| E_AMBusNumber | 18.2.0 | Varchar2(80) | Bus number for AM bus (logical key) |
| E_AMStartDate | 18.2.0 | Date | Start date for the AM bus. (logical key) |
| E_AMEndDate | 18.2.0 | Date | End date for the AM bus. (logical key) |
| E_PMBusNumber | 18.2.0 | Varchar2(80) | Bus number for PM bus (logical key) |
| E_PMStartDate | 18.2.0 | Date | Start date for the PM bus. (logical key) |
| E_PMEndDate | 18.2.0 | Date | End date for the PM bus. (logical key) |
| O_FromTo | 18.2.0 | Varchar2(80) | Old indicates if the bus travels to or from school. |
| O_BusNumber | 18.2.0 | Varchar2(80) | Old Bus number. |
| O_Distance | 18.2.0 | Number(25,10) | Old Route Distance. |
| O_DistanceValue | 18.2.0 | Number(25,10) | Old Distance Traveled in Miles. |
| O_LinkingCode | 18.2.0 | Varchar2(3) | Old Linking Indicator. |
| O_StartDate | 18.2.0 | Date | Old Bus Start Date. |
| O_EndDate | 18.2.0 | Date | Old Bus End Date. |
| N_FromTo | 18.2.0 | Varchar2(80) | New indicates if the bus travels to or from school. |
| N_BusNumber | 18.2.0 | Varchar2(80) | New Bus number. |
| N_Distance | 18.2.0 | Number(25,10) | New Route Distance. |
| N_DistanceValue | 18.2.0 | Number(25,10) | New Distance Traveled in Miles. |
| N_LinkingCode | 18.2.0 | Varchar2(3) | New Linking Indicator. |
| N_StartDate | 18.2.0 | Date | New Bus Start Date. |
| N_EndDate | 18.2.0 | Date | New Bus End Date. |