Skip to Content

Vehicle Mileage Template

Vehicle Mileage Template 2019-07-29T16:07:28-06:00

Target Table: VEHICLE_MILEAGE

Data Submission Schedule: K5P, 80 Day, 120 Day

Grain: One record per district / Vehicle / road type / mileage type

Load Sequences/Dependencies:

  1. Vehicle Snapshot Required

TEMPLATE DESCRIPTION – The vehicle mileage template is used report the following:

  • The number of miles traveled by a bus on the snapshot date.
  • The type of routes traveled.
  • The road types traveled.
  • The mileage type traveled.

School Year 2019-2020 Changes:

  •  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_MILEAGE_YYYYMMDDHHMM.fff
File Name Format Example:  001_VEHICLE_MILEAGE_201907071201.csv

FIELD
NUMBER
FIELD
NAME
CODESVALID
VALUES
1DISTRICT CODE CHARACTER, REQUIRED, KEY
2VEHICLE ID CHARACTER, REQUIRED, KEY Enter the bus number
3ROUTE ID CHARACTER, REQUIRED, KEY
  • RTF = Regular to and from
  • COF = Contract feeder
  • SEO = Special education only
  • KGO = Kindergarten only
  • VCO = Vocational only
  • 34Y = 3-4 year old D.D. only
  • ACT = Activity Bus
4REPORTING DATEDATE, REQUIRED, KEY
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2019-09-01 = K5P
5ROAD TYPE CODE CHARACTER, REQUIRED, KEY
  • PAV = Paved
  • UPV = Unpaved
  • UIM = Unimproved
6MILEAGE TYPE CODE CHARACTER, REQUIRED, KEY
  • LRT = Live Route
  • EDH = Essential Dead Head
7DAILY MILEAGENUMBER (1 DECIMAL), REQUIRED, UPDATEABLE Number of miles must be greater than or equal to 0 and less than 500.

 

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

QUESTION:  How many mileage records must be submitted per bus?
ANSWER:

  • If a bus is used on 80 (120) day six mileage records must be submitted.
  • If a bus does not travel one of the “road type” / “mileage type” combinations report “0” in daily mileage.
  • Allowable combinations for “road type” and “mileage type” are shown in the table below.
  • The route id must be the same on each record when entering multiple records for one vehicle.
ROAD TYPEMILEAGE TYPE
PavedLive Route
UnpavedLive Route
UnimprovedLive Route
PavedEssential Dead Head
UnpavedEssential Dead Head
UnimprovedEssential Dead Head

 

 

Page last updated July 29, 2019