S_NM_Vehicles_S (ver 14.6.0)
This table houses records for vehicles that are in use by a district. These records will be extracted in the Vehicle Snapshot Template.
Column Name | Version | Data Type | Description |
|---|---|---|---|
BODYMANUFACTURERCODE | 14.6.0 | VARCHAR2(10) | Body Manufacturer Code |
BUSNUMBER | 14.6.0 | VARCHAR2(20) | Vehicle ID (Bus Number) |
CHASSISMANUFACTURERCODE | 14.6.0 | VARCHAR2(10) | Chassis Manufacturer Code |
DEACTIVATED | 14.6.0 | NUMBER(1,0) | Deactivate This Bus? |
FUELTYPECODE | 14.6.0 | VARCHAR2(10) | Fuel Type Code |
GROSSVEHICLEWEIGHTRATING | 14.6.0 | NUMBER(11,0) | Gross Vehicle Weight Rating |
ID | 14.6.0 | NUMBER(11,0) | System Generated Primary Key |
LICENSEPLATENUMBER | 14.6.0 | VARCHAR2(10) | License Plate Number |
MANUFACTURERYEAR | 14.6.0 | NUMBER(11,0) | Manufacturer Year |
NUMBEROFDAYSINUSE | 14.6.0 | NUMBER(11,0) | Number Of Days In Use |
ODOMETERMILEAGE | 14.6.0 | NUMBER(11,0) | Odometer Mileage |
ODOMETERREADINGDATE | 14.6.0 | DATE | Odometer Reading Date |
PAVEDDEADHEADMILEAGE | 14.6.0 | NUMBER(11,0) | Paved - Essential Dead Head Daily Mileage |
PAVEDLIVEMILEAGE | 14.6.0 | NUMBER(11,0) | Paved - Live Route Daily Mileage |
REGISTEREDOWNER | 14.6.0 | VARCHAR2(50) | Registered Owner |
ROUTEID | 14.6.0 | VARCHAR2(10) | Route ID |
SEATINGCAPACITY | 14.6.0 | NUMBER(11,0) | Seating Capacity |
SPECIALLIFTEQUIPMENT | 14.6.0 | VARCHAR2(10) | Special Lift Equipment Indicator |
UNIMPROVEDDEADHEADMILEAGE | 14.6.0 | NUMBER(11,0) | Unimproved - Essential Dead Gead Daily Mileage |
UNIMPROVEDLIVEMILEAGE | 14.6.0 | NUMBER(11,0) | Unimproved - Live Route daily Mileage |
UNPAVEDDEADHEADMILEAGE | 14.6.0 | NUMBER(11,0) | Unpaved - Essential Dead Head daily Mileage |
UNPAVEDLIVEMILEAGE | 14.6.0 | NUMBER(11,0) | Unpaved - Live Route Daily Mileage |
VEHICLEINUSE40D | 14.6.0 | NUMBER(1,0) | Vehicle in use on 40 Day? |
VIN | 14.6.0 | VARCHAR2(25) | Vehicle Identification Number (VIN) |
VEHICLEINUSERPTPER | 15.9.0 | VARCHAR2(10) | Vehicle In Use Report Period |
VEHICLETYPECODE | 18.8.0 | VARCHAR2(3) | Vehicle Type Code |