Vehicle Snapshot Extract
Introduction
This template is used to report a district’s bus inventory. All buses used by a district on 80 and 120 Days are reported.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Reporting Period | Choose the reporting period from the pop-up menu:
|
Vehicle in Use | Select the designation for the vehicle. |
Odometer Mileage | Enter the mileage shown on the odometer. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tables for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Begin / End Position |
1 | District Code | PED assigned three-digit district number. | [Prefs]Name=DistrictNumber [Prefs]Value | N/A |
2 | Vehicle ID | The vehicle ID (bus number) of the vehicle. | [S_NM_Vehicles_S]busNumber | N/A |
3 | Reporting Date | The PED denoted reporting date. Valid values:
| N/A | N/A |
4 | School Year Date | This value is automatically extracted as June 30th. The report determines the year by referencing the school year associated with the term selected when the report is run. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD. | N/A | N/A |
5 | Vehicle Identification Number (VIN) | The VIN number of the reported vehicle. | [S_NM_Vehicles_S]VIN | N/A |
6 | License Plate Number | The license plate number of the reported vehicle. | [S_NM_Vehicles_S]LicensePlateNumber | N/A |
7 | Not Collected | N/A | N/A | |
8 | Manufacturer Year | The year the vehicle was manufactured. Note: The vehicle cannot be more than 20 years old. | [S_NM_Vehicles_S]ManufacturerYear | N/A |
9 | Body Manufacturer Code | The code denoting the body manufacturer. | [S_NM_Vehicles_S]BodyManufacturerCode | N/A |
10 | Chassis Manufacturer Code | The code denoting the chassis manufacturer. | [S_NM_Vehicles_S]ChassisManufacturerCode | N/A |
11 | Gross Vehicle Weight Rating | The gross weight rating of the vehicle. Note: Must be greater than 0. | [S_NM_Vehicles_S]GrossVehicleWeightRating | N/A |
12 | Fuel Type Code | The code denoting the type of fuel used by the vehicle. | [S_NM_Vehicles_S]FuelTypeCode | N/A |
13 | Special Lift Equipment indicator | Indicates whether the vehicle has special lift equipment. Valid values: Y – Yes N - No Note: If the source field is blank, the report will return N | [S_NM_Vehicles_S]SpecialLiftEquipment | N/A |
14 | Seating Capacity | The seating capacity of the vehicle. Note: Value must be between 1 and 85. | [S_NM_Vehicles_S]SeatingCapacity | N/A |
15 | Registered Owner Code | The registered owner of the vehicle. | [S_NM_Vehicles_S]RegisteredOwner | N/A |
16 | Not Collected | N/A | N/A | N/A |
17 | Not Collected | N/A | N/A | N/A |
18 | Odometer Mileage | The mileage of the vehicle as of 40 day. Note: value must be greater than 0 and less than 500000. | [S_NM_Vehicles_S]OdometerMileage | N/A |
19 | Odometer Reading Date | The date the odometer reading was taken. Note: The Odometer Reading Date element will now be derived from the reporting period selected when the extract is run and the district level STARS dates. | [S_NM_Vehicles_S]OdometerReadingDate | N/A |
20 | Number of Days In Use | The number of days the vehicle has been in use. Note: Reported value cannot exceed 365. | [S_NM_Vehicles_S]NumberOfDaysInUse | N/A |
21 | Vehicle In Use Indicator | Indicates whether or not the vehicle was actually in use on 40-day. | [S_NM_Vehicles_S]VehicleInUseRptPer | N/A |
22 | Not Collected | N/A | N/A | N/A |
23 | Vehicle Type Code | Indicates the type of vehicle. Valid values:
Note: If the source field is blank, the report will return BUS | [S_NM_Vehicles_S]VehicleTypeCode | N/A |