AUD_S_TN_DISTRICTBUS_S (ver 14.6.3)
This table is a standalone Audit table for TN District Bus Information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.6.3 | Number(11,0) | Unique Record ID. |
OLD_AirConditioning | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
New_AirConditioning | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
OLD_AudioVideoSurveillance | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_AudioVideoSurveillance | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
OLD_BUSNUMBER | 14..6.3 | Number(11,0) | Audit value old Bus Number - Deprecated as 14.10.0. |
NEW_BUSNUMBER | 14..6.3 | Number(11,0) | Audit value new Bus Number - Deprecated as 14.10.0. |
OLD_BUSNUMBER_NEW | 14.10.0 | Number(11,0) | Audit value old Bus Number. |
NEW_BUSNUMBER_NEW | 14.10.0 | Number(11,0) | Audit value new Bus Number. |
OLD_BusType | 14..6.3 | Varchar2(20) | Audit value old A, B, C or D. |
NEW_BusType | 14.6.3 | Varchar2(20) | Audit value new A, B, C or D. |
OLD_CommercialAdvertising | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_CommercialAdvertising | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
OLD_DailyMiles | 14.6.3 | Number(11,0) | Audit value old Daily Miles - Effective as of sr15.2.2. |
NEW_DailyMiles | 14.6.3 | Number(11,0) | Audit value new Daily Miles - Effective as of sr15.2.2. |
OLD_DailyMiles_NEW | 14.10.0 | Number(11,0) | Audit value old Daily Miles - Deprecated as of sr15.2.2. |
NEW_DailyMiles_NEW | 14.10.0 | Number(11,0) | Audit value new Daily Miles - Deprecated as of sr15.2.2. |
OLD_DOSInspectionCurrent | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_DOSInspectionCurrent | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
DistrictID | 14.6.3 | Number(11,0) | District ID value. |
OLD_FuelType | 14.6.3 | Varchar2(40) | Audit value old ‘Diesel’, ‘Gas’, ‘CNG’. |
NEW_FuelType | 14.6.3 | Varchar2(40) | Audit value new ‘Diesel’, ‘Gas’, ‘CNG’. |
OLD_GPSSystem | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_GPSSystem | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
OLD_InvolvedAccident | 14.6.3 | Varchar2(20) | Audit value old 0-9 - Deprecated as 14.10.0. |
NEW_InvolvedAccident | 14.6.3 | Varchar2(20) | Audit value new 0-9 - Deprecated as 14.10.0. |
OLD_InvolvedAccident_NEW | 14.10.0 | Number(11,0) | Audit value old 0-9. |
NEW_InvolvedAccident_NEW | 14.10.0 | Number(11,0) | Audit value new 0-9. |
OLD_OccupantRestraints | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_OccupantRestraints | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
OLD_PrivatelyOwned | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_PrivatelyOwned | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
SCHOOLYEAR | 14.6.3 | Number(11,0) | Two digit school year id. |
OLD_SpeciallyEquipped | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_SpeciallyEquipped | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
OLD_TwoWayCommunication | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_TwoWayCommunication | 14.6.3 | Varchar2(20) | Audit value new Y or N. |
OLD_WheelChairLifts | 14.6.3 | Varchar2(20) | Audit value old Y or N? |
NEW_WheelChairLifts | 14.6.3 | Varchar2(20) | Audit value new Y or N? |
OLD_YearBeganOperation | 14.6.3 | Number(11,0) | Audit value old year began (2010). |
NEW_YearBeganOperation | 14.6.3 | Number(11,0) | Audit value new year began (2010). |
DML_TYPE | 14.6.3 | Varchar2(1) | The transaction type that occurred to t.he audited table. 'I' for insert, 'U' for update, and 'D' for delete. |
TRANSACTION_DATE | 14.6.3 | Date | Audit change date. |
AUDIT_SEQ | 14.6.3 | Number(11,0) | Audit sequence number. |
WHOMODIFIEDID | 14.6.3 | Number(11,0) | Who modified ID. |
WHOMODIFIEDTYPE | 14.6.3 | Varchar2(1) | Who modified field type. |
IP_ADDRESS | 14.6.3 | Varchar2(39) | IP address of who modified ID. |