Transportation
Transportation
This view captures the vehicle and vehicle mileage data as published in the localEducationAgencyTransportation, vehcileSnapshot, and vehicleMileage resources. The layout includes the Vehicle ID, VIN, Odometer Reading Date, Vehicle Use Indicator, and mileage data.
localEducationAgencyTransportation
This association indicates the transportation data for the LEA being published.
Primary PowerSchool Source Data
[Prefs]
Selection Criteria
Records are published if the following criteria are met:
There is no record selection criteria for this resource
Note: If a data source field is blank, a count of 0 will be published.
Resource Output
All LEA’s will always have 5 records published.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
localEducationAgencyTransportation | ||||
/categoryDescriptor01TransportationCategoryDescriptor | The first category of the district transportation. | String | Always Bus Transportation | R |
/categoryDescriptor02TransportationCategoryDescriptor | The second category of the district transportation. | Always one of the following: ELIGSTUDNOTSTARS MILEAGE FEEDER PROJSTUDENTS K12PMILEAGE | ||
/transportationSetCodeDescriptor | The transportation set code. | Always one of the following: ELIGSTUDNOTSTARS MILEAGE FEEDER PROJSTUDENTS K12PMILEAGE | ||
localEducationAgencyReference A reference to the LEA of the vehicle. | ||||
/localEducationAgencyId | The LEA associated with this student and program. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+000 | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber The last 3 digits will be 000 | ||
/count | The count for the measure. Note: If a data source field is blank, a count of 0 will be published. | ELIGSTUDNOTSTARS - [pref]Transp_NotinSTARS MILEAGE - [pref]Transp_FeederMileage FEEDER - [pref]Transp_FeederRoutes PROJSTUDENTS - [pref]Transp_ProjectedStudents K12PMILEAGE - [pref]Transp_K5p | ||
vehicleSnapshot
This association indicates the vehicle being published.
Primary PowerSchool Source Data
[S_NM_Vehicles_S]
Selection Criteria
Records are published if the following criteria are met:
The vehicle is not excluded from state reporting.
Note: All fields in this resource are marked required by PED. Due to this, each element listed below must be populated for a given vehicleSnapshot record to successfully publish.
Resource Output
A vehicleSnapshot record is published for each qualifying vehicle record.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
vehicleSnapshot | ||||
/vehicleId* | The unique identifier for the vehicle. | String | [S_NM_Vehicles_S]BusNumber | R |
/vehicleIdentificationNumber* | The vehicle VIN number. | String | [S_NM_Vehicles_S]VIN | R |
localEducationAgencyReference | ||||
/localEducationAgencyId* | The LEA associated with this student and program. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+000 | String | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber The last 3 digits will be 000 | |
schoolYearTypeReference | ||||
/schoolYear* | The school year. | |||
/grossVehicleWeightRating* | The vehicle's gross weight rating. | [S_NM_Vehicles_S]GrossVehicleWeightRating | ||
/licensePlateNumber* | The vehicle's license number. | [S_NM_Vehicles_S]LicenseplateNumber | ||
/manufacturerYear* | The year the vehicle was manufactured. | [S_NM_Vehicles_S]ManufacturerYear | ||
/numberOfDaysInUse* | The vehicle's number of days in use. | [S_NM_Vehicles_S]NumberOfDaysInUse | ||
/odometerMileage* | The vehicle's odometer mileage. | [S_NM_Vehicles_S]OdometerMileage | ||
/odometerReadingDate* | The vehicle's odometer reading date. Note: In order for a vehicle to be counted correctly for a given reporting period, this date must be the actual reporting period date. | [S_NM_Vehicles_S]OdometerReadingDate | ||
/registeredOwnerCode* | The vehicle's registered owner. | [S_NM_Vehicles_S]RegisteredOwner | ||
/seatingCapacity* | The vehicle's seating capacity. | [S_NM_Vehicles_S]SeatingCapacity | ||
/specialLiftEquipmentIndicator* | Indicates whether the vehicle has special lift equipment. | [S_NM_Vehicles_S]SpecialLiftEquipment | ||
/vehicleBodyManufacturerDescriptor* | The vehicle's body manufacturer. Vehicle Body Manufacturer Descriptor Set | [S_NM_Vehicles_S]BodyManufacturerCode | ||
/vehicleChassisManufacturerDescriptor* | The vehicle's chassis manufacturer. Vehicle Chassis Manufacturer Descriptor Set | [S_NM_Vehicles_S]ChassisManufacturerCode | ||
/vehicleFuelTypeDescriptor* | The vehicle's fuel type. Vehicle Fuel Type Descriptor Set | [S_NM_Vehicles_S]FuelTypeCode | ||
/vehicleTypeDescriptor* | The vehicle type. Vehicle Type Descriptor Set | [S_NM_Vehicles_S]VehicleTypeCode | ||
/vehicleUseIndicator* | Indicates if the vehicle is in use on the reporting period date.
Note: This value being True indicates the vehicle was in use on the reporting period date and will publish vehicleMileage records for the given vehicle. This value being False indicates the vehicle was not in use on the reporting period date and no vehicleMileage records will be published for the given vehicle. | [S_NM_Vehicles_S]VehicleInUseRptPer | ||
vehicleMileage
This association indicates the vehicle mileage being published.
Primary PowerSchool Source Data
[S_NM_Vehicles_S]
Selection Criteria
Records are published if the following criteria are met:
The vehicle is not excluded from state reporting.
The VehicleUseIndicator in the vehicleSnapshot record must be True.
Note: All fields in this resource are marked required by PED. Due to this, each element listed below must be populated for a given vehicleMileage record to successfully publish.
Resource Output
A vehiclemile record is published for each mileageTypeDescriptor and roadTypeDescriptor combination.
Any vehicle (vehicleSnapshot) record where the VehicleUseIndicator is True will publish 6 vehicleMileage records of the following combinations:
roadTypeDescriptor - PAV & mileageTypeDescriptor - LRT
roadTypeDescriptor - UPV & mileageTypeDescriptor - LRT
roadTypeDescriptor - UIM & mileageTypeDescriptor - LRT
roadTypeDescriptor - PAV & mileageTypeDescriptor - EDH
roadTypeDescriptor - UPV & mileageTypeDescriptor - EDH
roadTypeDescriptor - UIM & mileageTypeDescriptor - EDH
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand ("Run Now" button).
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
vehicleMileage | ||||
/mileageTypeDescriptor* | The mileage type. Mileage Type Descriptor Set | String |
| R |
/reportingDate* | The vehicle's mileage reporting date. | String | [S_NM_Vehicles_S]OdometerReadingDate | R |
/roadTypeDescriptor* | The road type. Road Type Descriptor Set | String |
| |
/vehicleId* | The unique identifier for the vehicle. | String | [S_NM_Vehicles_S]BusNumber | |
/vehicleRouteDescriptor* | The vehicle's route. Vehicle Route Descriptor Set | String | [S_NM_Vehicles_S]RouteID | |
localEducationAgencyReference | ||||
/localEducationAgencyId* | The identifier assigned to a local education agency. | String | [S_NM_Vehicles_S] | |
/dailyMileage* | The daily mileage. | String | [S_NM_Vehicles_S]PavedLiveMileage [S_NM_Vehicles_S]UnpavedLiveMileage [S_NM_Vehicles_S]UnimprovedLiveMileage [S_NM_Vehicles_S]PavedDeadHeadMileage [S_NM_Vehicles_S]UnpavedDeadHeadMileage [S_NM_Vehicles_S]UnimprovedDeadHeadMileage | |