S_TN_DISTRICTBUS_S (ver 14.6.3)
This table is a standalone table for TN District Bus Information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.6.3 | Number(11,0) | Unique Record ID. |
SchoolYear | 14.6.3 | Number(11,0) | Two digit school year ID. |
BusNumber | 14.6.3 | Number(11,0) | Deprecated. |
BusNumber_New | 14.10.0 | Varchar2(12) | Bus Number. |
SpeciallyEquipped | 14.6.3 | Varchar2(5) | Indicates whether the bus has equipment for special needs |
DailyMiles | 14.6.3 | Number(11,0) | Daily miles One Way AM - Reverted to from DailyMiles_New effective as of sr15.2.2. |
DailyMiles_NEW | 14.10.0 | Number(11,0) | Daily miles - Deprecated - No Longer used as of sr15.2.2. |
BusType | 14.6.3 | Varchar2(10) | A, B, C or D. |
YearBeganOperation | 14.6.3 | Number(11,0) | 2010. |
DOSInspectionCurrent | 14.6.3 | Varchar2(5) | Indicates whether the inspection is current. |
PrivatelyOwned | 14.6.3 | Varchar2(5) | Indicates whether the bus is privately owned. |
WheelChairLifts | 14.6.3 | Varchar2(5) | Indicates whether the bus is equipped with a wheelchair lift |
CommercialAdvertising | 14.6.3 | Varchar2(5) | Indicates whether the bus has commercial ads |
InvolvedAccident | 14.6.3 | Varchar2(5) | 0 - 9 - Deprecated as of sr14.10.0 |
InvolvedAccident_NEW | 14.10.0 | Number(11,0) | Converted to Total Number Accidents as of 2015-16 - 15.7.1 release. |
OccupantRestraints | 14.6.3 | Varchar2(5) | Indicates whether the bus has seatbelts |
TwoWayCommunication | 14.6.3 | Varchar2(5) | Indicates whether the bus has two way communication. |
AudioVideoSurveillance | 14.6.3 | Varchar2(5) | Indicates whether the bus has audio-video surveillance |
FuelType | 14.6.3 | Varchar2(10) | Indicates the buses fuel type: ‘Diesel’, ‘Gas’, ‘CNG’, 'ELEC',or 'LNG' |
GPSSystem | 14.6.3 | Varchar2(5) | Indicates whether the bus is equipped with a GPS. |
AirConditioning | 14.6.3 | Varchar2(5) | Indicates whether the bus is air conditioned. |
| PersonalInjury | 15.7.1 | Number(11,0) | Number of personal injury accidents. |
| TreatedAndReleased | 15.7.1 | Number(11,0) | Number of students treated and released. |
| Hospitalized | 15.7.1 | Number(11,0) | Number of Students hospitalized overnight or longer. |
| FatalitiesOnBoard | 15.7.1 | Number(11,0) | Number of deaths on bus. |
| FatalitiesOffBoard | 15.7.1 | Number(11,0) | Number of deaths off bus. |
| PropertyDamage | 15.7.1 | Number(11,0) | Number of property damage accidents. |
DistrictID | 14.6.3 | Number(11,0) | District ID. |
IP_Address | 14.6.3 | Varchar2(39) | URL of the user who last modified the record |
WhoModifiedID | 14.6.3 | Number(11,0) | Indicates who last modified the record. |
WhoModifiedType | 14.6.3 | Varchar2(1) | Indicates the type of modification made to the record. |
| SafetyComplaints | 19.6.2.0 | Number(4,0) | Captures Safety Complaints |
| ElecStbCtrlSy | 19.6.2.0 | Boolean | Indicates whether the bus has an Electronic Stability control system |