Skip to Content

Vehicle Snapshot Template

Vehicle Snapshot Template 2019-07-29T16:05:02-06:00

Target Table: VEHICLE_SNAPSHOT

Data Submission Schedule: K5P, 80 Day, 120 Day

Grain: One record per district / Vehicle

Load Sequences/Dependencies: None

TEMPLATE DESCRIPTION

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

FIELD
NUMBER
FIELD
NAME
CODESVALID
VALUES
1DISTRICT CODECHARACTER, REQUIRED, KEY
2VEHICLE IDCHARACTER, REQUIRED, KEY Enter bus number
3REPORTING DATEDATE, REQUIRED, KEY
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2019-09-01 = K5P
4SCHOOL YEAR DATEDATE, REQUIRED, FIRST LOAD ONLY
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
5VEHICLE IDENTIFICAITON NUMBERCHARACTER, REQUIRED, UPDATEABLEEnter VIN, cannot exceed 21 characters and cannot be duplicated within the state.
6LICENSE PLATE NUMBERCHARACTER, REQUIRED, UPDATEABLEEnter license plate number.  Cannot exceed 7 characters.
8MANUFACTURER YEARNUMBER (0 DECIMALS), REQUIRED, UPDATEABLEEnter year.  Must not be greater than current year or more that 20 years old.
9BODY MANUFACTURER CODECHARACTER, REQUIRED, UPDATEABLE
  • AMT = Amtram
  • BLU = Bluebird
  • CE3 = CE300
  • CHV = Chevy
  • COL = Collins
  • FOR = Ford
  • FRE = Freightliner
  • GEN = Gene
  • GMC = GMC
  • IC = IC
  • INT = International
  • MID = Mid Bus
  • OTH = Other
  • THO = Thomas
  • VI = Vision
10CHASSIS MANUFACTURER CODECHARACTER, REQUIRED, UPDATEABLE
  • AMT = Amtram
  • BLU = Bluebird
  • CE3 = CE300
  • CHV = Chevy
  • COL = Collins
  • FOR = Ford
  • FRE = Freightliner
  • GEN = GENE
  • GMC = GMC
  • IC = IC
  • INT = International
  • MID = Mid Bus
  • OTH = Other
  • THO = Thomas
  • VI = Vision
11GROSS VEHICLE WEIGHT RATINGNUMBER (0 DECIMALS), REQUIRED, UPDATEABLEEnter number.  Must be greater than 0.
12FUEL TYPE CODECHARACTER, REQUIRED, UPDATEABLE
  • ALT = Alternative fuel
  • ULG = Unleaded gasoline
  • DIE = Diesel
  • DYD = Dyed diesel
13SPECIAL LIFT EQUIPMENT INDICATORCHARACTER, REQUIRED, UPDATEABLE
  • Y = Yes
  • N = No
14SEATING CAPACITYNUMBER (0 DECIMALS), REQUIRED, UPDATEABLEEnter number.   Must be 1 through 85.
15REGISTERED OWNER CODECHARACTER, REQUIRED, UPDATEABLEEnter the name of the registred owner.  20 character max.  Abbreviate if necessary.
18ODOMETER MILEAGENUMBER (0 DECIMALS), REQUIRED, UPDATEABLEOdometer reading as of reporting day.  Must be greater than 0 and less than 500,000
19ODOMETER READING DATEDATE, REQUIRED, UPDATEABLEYYYY-MM-DD format
20NUMBER OF DAYS IN USENUMBER, (0 DECIMALS), RQUIRED, UPDATEABLEEnter the number of days in use during the school year.  Cannot exceed the number of district school days in district fact.
21VEHICLE IN USE INDICATORCHARACTER, REQUIRED UPDATEABLE
  • Y = Yes
  • N = No

Identifies whether a bus was in use on reporting day.  If Y, then 6 vehicle mileage template records must be submitted for this vehicle.

23VEHICLE TYPE CODECHARACTER, REQUIRED UPDATEABLE
  • BUS
  • SUV

TEMPLATE GUIDANCE

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?
ANSWER:

  • 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
Page last updated July 29, 2019