Column |
Description |
Example |
---|---|---|
vehicle_dimension |
Maps directly to the Vehicle dimension table using the vehicle_[COLUMN NAME] naming convention. For example vehicle_model to query the model column of the Vehicle dimension table. |
SELECT |
start_day_dimension |
Maps directly to the Date dimension table using the start_day_[COLUMN NAME] naming convention. For example start_day_name_of_week to query the name_of_week column of the Date dimension table. |
SELECT |
distance |
Total distance traveled by this vehicle, in the user's default distance units (miles or kilometers). |
34756 |
total_idle |
The total time spent in idling status, in seconds |
675 |
hard_accel |
The number of hard acceleration events recorded during this trip. |
3 |
hard_brake |
The number of hard acceleration events recorded during this trip. |
6 |
seatbelt_violations |
The number of seatbelt violations recorded for this vehicle. |
2 |
speeding_over_posted |
The number of speeding over posted violation events recorded for this vehicle during this trip. |
1 |
speeding_excessive |
The number of excessive speeding events recorded for this vehicle during this trip. |
0 |
engine_time |
The total engine running time recorded for this vehicle, in seconds, during this trip. |
5678 |
fuel_used |
The amount of fuel used by this vehicle, in the user's default volume units (gallons or liters), in this trip. |
219 |
total_non_productive_idle |
|
|
best_distance |
|
|
best_duration |
|
|
dtc_count |
The number of diagnostic trouble codes logged by this vehicle during the trip. |
|
Vehicle_Day Fact Table
This is a printed page that might be out of date. To read the most up-to-date help content, visit https://fleet-help.verizonconnect.com.
Comments
0 comments
Please sign in to leave a comment.