View Public Events Calendar
NM Public Education Department logo
stripes illustration

Vehicle Mileage Template

  1. Home
  2. Offices and Programs
  3. Information Technology
  4. STARS Information, Manuals, and Supporting Documents
  5. Transportation Domain
  6. 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

FIELD
NUMBER		 FIELD
NAME		 CODES VALID
VALUES
1 DISTRICT CODE  CHARACTER, REQUIRED, KEY
2 VEHICLE ID  CHARACTER, REQUIRED, KEY  Enter the bus number
3 ROUTE 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
4 REPORTING DATE DATE, REQUIRED, KEY
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2019-09-01 = K5P
5 ROAD TYPE CODE  CHARACTER, REQUIRED, KEY
  • PAV = Paved
  • UPV = Unpaved
  • UIM = Unimproved
6 MILEAGE TYPE CODE  CHARACTER, REQUIRED, KEY
  • LRT = Live Route
  • EDH = Essential Dead Head
7 DAILY MILEAGE NUMBER (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 TYPE MILEAGE TYPE
Paved Live Route
Unpaved Live Route
Unimproved Live Route
Paved Essential Dead Head
Unpaved Essential Dead Head
Unimproved Essential Dead Head