Target Table: VEHICLE_SNAPSHOT
Data Submission Schedule: K5P, 80 Day, 120 Day
Grain: One record per district / Vehicle
Load Sequences/Dependencies: None
This template is used to report a districts’ bus inventory. All buses used by a district are to be reported.
School Year 2019-2020 Changes:
- Added K5P Submission Windows Dates
- Snapshot Change:
- 9/1(K5P) snapshot date and collection window has been added.
- K5P will be used to collect K5P Transportation data only.
File Name Format: DDD_VEHICLE_SNAPSHOT_YYYYMMDDHHMM.fff
File Name Format Example: 001_VEHICLE_SNAPSHOT_201907071201.csv
|1||DISTRICT CODE||CHARACTER, REQUIRED, KEY|
|2||VEHICLE ID||CHARACTER, REQUIRED, KEY||Enter bus number|
|3||REPORTING DATE||DATE, REQUIRED, KEY||
|4||SCHOOL YEAR DATE||DATE, REQUIRED, FIRST LOAD ONLY||
|5||VEHICLE IDENTIFICAITON NUMBER||CHARACTER, REQUIRED, UPDATEABLE||Enter VIN, cannot exceed 21 characters and cannot be duplicated within the state.|
|6||LICENSE PLATE NUMBER||CHARACTER, REQUIRED, UPDATEABLE||Enter license plate number. Cannot exceed 7 characters.|
|8||MANUFACTURER YEAR||NUMBER (0 DECIMALS), REQUIRED, UPDATEABLE||Enter year. Must not be greater than current year or more that 20 years old.|
|9||BODY MANUFACTURER CODE||CHARACTER, REQUIRED, UPDATEABLE||
|10||CHASSIS MANUFACTURER CODE||CHARACTER, REQUIRED, UPDATEABLE||
|11||GROSS VEHICLE WEIGHT RATING||NUMBER (0 DECIMALS), REQUIRED, UPDATEABLE||Enter number. Must be greater than 0.|
|12||FUEL TYPE CODE||CHARACTER, REQUIRED, UPDATEABLE||
|13||SPECIAL LIFT EQUIPMENT INDICATOR||CHARACTER, REQUIRED, UPDATEABLE||
|14||SEATING CAPACITY||NUMBER (0 DECIMALS), REQUIRED, UPDATEABLE||Enter number. Must be 1 through 85.|
|15||REGISTERED OWNER CODE||CHARACTER, REQUIRED, UPDATEABLE||Enter the name of the registred owner. 20 character max. Abbreviate if necessary.|
|18||ODOMETER MILEAGE||NUMBER (0 DECIMALS), REQUIRED, UPDATEABLE||Odometer reading as of reporting day. Must be greater than 0 and less than 500,000|
|19||ODOMETER READING DATE||DATE, REQUIRED, UPDATEABLE||YYYY-MM-DD format|
|20||NUMBER OF DAYS IN USE||NUMBER, (0 DECIMALS), RQUIRED, UPDATEABLE||Enter the number of days in use during the school year. Cannot exceed the number of district school days in district fact.|
|21||VEHICLE IN USE INDICATOR||CHARACTER, REQUIRED UPDATEABLE||
Identifies whether a bus was in use on reporting day. If Y, then 6 vehicle mileage template records must be submitted for this vehicle.
|23||VEHICLE TYPE CODE||CHARACTER, REQUIRED UPDATEABLE||
QUESTION: Do I have to submit vehicle snapshot if the bus was not used on 80 (120) day?
ANSWER: If a bus is not used on 80 (120) day no vehicle mileage records are submitted. The vehicle snapshot “vehicle in use indicator” must equal “N”.
QUESTION: How does the vehicle snapshot “vehicle in use indicator” influence the submission of vehicle mileage?
- If the vehicle snapshot “vehicle in use indicator” = “N” then no vehicle mileage records are submitted
- If the vehicle snapshot “vehicle in use indicator” = “Y” then 6 vehicle mileage records are submitted