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 |
|
| 4 | SCHOOL YEAR DATE | DATE, REQUIRED, FIRST LOAD ONLY |
|
| 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 |
|
| 10 | CHASSIS MANUFACTURER CODE | CHARACTER, REQUIRED, UPDATEABLE |
|
| 11 | GROSS VEHICLE WEIGHT RATING | NUMBER (0 DECIMALS), REQUIRED, UPDATEABLE | Enter number. Must be greater than 0. |
| 12 | FUEL TYPE CODE | CHARACTER, REQUIRED, UPDATEABLE |
|
| 13 | SPECIAL LIFT EQUIPMENT INDICATOR | CHARACTER, REQUIRED, UPDATEABLE |
|
| 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 |
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 |
|
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