View Public Events Calendar
NM Public Education Department logo
stripes illustration

Vehicle Snapshot Template

  1. Home
  2. Offices and Programs
  3. Information Technology
  4. STARS Information, Manuals, and Supporting Documents
  5. Transportation Domain
  6. Vehicle Snapshot Template

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		 CODES VALID
VALUES
1 DISTRICT CODE CHARACTER, REQUIRED, KEY
2 VEHICLE ID CHARACTER, REQUIRED, KEY  Enter bus number
3 REPORTING DATE DATE, REQUIRED, KEY
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2019-09-01 = K5P
4 SCHOOL YEAR DATE DATE, REQUIRED, FIRST LOAD ONLY
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
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
  • 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
10 CHASSIS MANUFACTURER CODE CHARACTER, 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
11 GROSS VEHICLE WEIGHT RATING NUMBER (0 DECIMALS), REQUIRED, UPDATEABLE Enter number.  Must be greater than 0.
12 FUEL TYPE CODE CHARACTER, REQUIRED, UPDATEABLE
  • ALT = Alternative fuel
  • ULG = Unleaded gasoline
  • DIE = Diesel
  • DYD = Dyed diesel
13 SPECIAL LIFT EQUIPMENT INDICATOR CHARACTER, REQUIRED, UPDATEABLE
  • Y = Yes
  • N = No
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
  • 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.
23 VEHICLE TYPE CODE CHARACTER, 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