Vehicle Mileage Template

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

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.