Snowflake Reader Account

Snowflake Reader Account Views U-Z

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.
  • Updated

Unit Driver History View (unit_driver_history)

Column Name

Data Type

Description

UNIT_ID

NUMBER

A unique identifier for the vehicle, used within Fleet.

DRIVER_ID

NUMBER

A unique identifier for the driver, used within Fleet.

FROM_TIME_UTC

TIMESTAMP_NTZ

The time at which the assignment began.

TO_TIME_UTC

TIMESTAMP_NTZ

The time at which the assignment ended. Null value when the assignment is ongoing.

ROW_UPDATE_TIME

TIMESTAMP_NTZ

The time, in UTC, when this database entry was last updated.

Vehicle View (vehicle)

Column Name

Slow Changing Behavior

Data Type

Description

VEHICLE_KEY

N/A

NUMBER

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

VEHICLE_ID

N/A

NUMBER

A unique identifier for the vehicle, used within Fleet. Use VEHICLE_ID for grouping by this view.

VEHICLE_NAME

Current

TEXT

The vehicle's display name.

VEHICLE_NAME_HISTORY

Historic

TEXT

The vehicle's display name.

FUEL_TYPE

Historic

TEXT

The type of fuel that the vehicle uses.

YEAR

Historic

TEXT

The year that the vehicle was made.

MAKE

Historic

TEXT

The vehicle's make.

MODEL

Historic

TEXT

The vehicle's model.

VIN

Historic

TEXT

The unique Vehicle Identification Number (VIN) of the vehicle.

COLOR

Historic

TEXT

The vehicle's color.

REGO

Historic

TEXT

The vehicle's registration details (number plate).

VEHICLE_TYPE

Historic

TEXT

The vehicle's type, as defined in Fleet.

ENGINE_SERIAL

Historic

TEXT

The unique serial number of the vehicle’s engine.

JSON_HIERARCHY

Current

VARIANT

An array of hierarchy node names from top-level node down to the node that the vehicle is in.

JSON_HIERARCHY_IDS

Current

VARIANT

An array of hierarchy node IDs from top-level node down to the node that the vehicle is in.

HIERARCHY

Current

VARIANT

An array of hierarchy node names from top-level node down to the node that the vehicle is in.

HIERARCHY_IDS

Current

VARIANT

An array of hierarchy node IDs from top-level node down to the node that the vehicle is in.

HIERARCHY_HISTORY

Historic

VARIANT

An array of hierarchy node names from top-level node down to the node that the vehicle was in.

HIERARCHY_IDS_HISTORY

Historic

VARIANT

An array of hierarchy node IDs from top-level node down to the node that the vehicle was in.

INACTIVE

N/A

BOOLEAN

Whether the vehicle is inactive.

FLEETS

Current

VARIANT

An array of names for the fleets that the vehicle is part of.

FLEET_IDS

Current

VARIANT

An array of IDs for the fleets that the vehicle is part of.

TAG_IDS

Historic

VARIANT

An array of vehicle tag IDs that have been defined in Fleet.

TAGS

Historic

VARIANT

An array of vehicle tags that have been defined in Fleet.

OEM_NAME

Historic

TEXT

The name of the OEM (original equipment manufacturer) or vehicle manufacturer.

CLASS

Historic

TEXT

The vehicle class.

ENGINE_TYPE

Historic

TEXT

The type of engine that is in the vehicle.

BODY_TYPE

Historic

TEXT

The body type of the vehicle, for example dry van or refrigerated.

ASSET_TYPE_NAME

Historic

TEXT

The name of the asset type associated with the vehicle, as defined in Fleet.

VEHICLE_CATEGORY

Historic

TEXT

The vehicle category, as defined in Fleet.

ASSET_TYPE_ID

Historic

NUMBER

The ID of the asset type associated with the vehicle, as defined in Fleet.

INSTALL_TYPE_NAME

Historic

TEXT

The name of the install type associated with the vehicle, as defined in Fleet.

INSTALL_TYPE_ID

Historic

NUMBER

The name of the install type associated with the vehicle, as defined in Fleet.

DEPOT_NAME

Current

TEXT

The name of the vehicle's depot.

ELECTRONIC_SERIAL_NUMBER

Current

TEXT

The serial number of the GPS unit installed in the vehicle.

UNIT_ID

N/A

NUMBER

A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.

LICENSE_STATUS

Current

TEXT

The current billing status of the vehicle within Fleet.

IS_CURRENT

N/A

BOOLEAN

Whether this vehicle database entry is current or has been replaced by a newer copy.

START_TIME_UTC

N/A

TIMESTAMP_NTZ

The time at which this video course entry was created, in UTC.

END_TIME_UTC

N/A

TIMESTAMP_NTZ

The time at which this video course entry became historical, in UTC.

ROW_UPDATE_TIME

N/A

TIMESTAMP_NTZ

The time, in UTC, when this entry was last updated.

Vehicle Day View (vehicle_day)

Column Name

Data Type

Description

UNIT_ID

NUMBER

A unique identifier for the vehicle, used within Fleet. Use UNIT_ID for grouping by this view.

VEHICLE_KEY

NUMBER

A unique identifier for the vehicle, used within the Analytics server. Use VEHICLE_KEY for joining this view.

DATE

DATE

The date for which the aggregation is done.

START_TIME_UTC

TIMESTAMP_NTZ

The start time of the vehicle day, in UTC time zone.

END_TIME_UTC

TIMESTAMP_NTZ

The end time of the vehicle day, in UTC time zone.

DISTANCE

NUMBER

The distance that the vehicle has traveled on the given date, in meters.

TOTAL_IDLE

NUMBER

The total time the vehicle spent idling on the given date, in seconds.

HARD_ACCEL

NUMBER

The number of hard acceleration events recorded for the vehicle on the given date.

HARD_BRAKE

NUMBER

The number of hard braking events recorded for the vehicle on the given date.

SEATBELT_VIOLATIONS

NUMBER

The number of seatbelt violation events recorded for the vehicle on the given date.

SPEEDING_OVER_POSTED

NUMBER

The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit on the given date.

SPEEDING_EXCESSIVE

NUMBER

The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit on the given date.

ENGINE_TIME

NUMBER

The total engine running time recorded for this vehicle and date, in seconds.

FUEL_USED

NUMBER

The amount of fuel the vehicle used on the given date, in gallons or liters.

TOTAL_NON_PRODUCTIVE_IDLE

NUMBER

The total time the vehicle spent in non-productive idling on the given date, in seconds.

DTC_COUNT

NUMBER

The number of diagnostic trouble codes (DTCs) logged for this vehicle on the given date.

PTO_DURATION

NUMBER

The total time for which the PTO (power take off) is active on the given date, in seconds.

DRIVING_WITHOUT_SEATBELT

NUMBER

The total time for which the seatbelt was not in use for this vehicle on the given date.

DRIVING_WITHOUT_SEATBELT_TRIP_DURATION

NUMBER

Trip_duration used to calculate trip values for DRIVING_WITHOUT_SEATBELT metric.

TRIP_DISTANCE

NUMBER

The distance that the vehicle has driven, on the given date, in meters.

TRIP_FUEL_USED

NUMBER

The amount of fuel the vehicle used on the given date, in gallons or liters.

SPEEDING_COUNT_HIGH_BAND

NUMBER

The number of speeding events recorded where the vehicle was in the high band on the given date.

SPEEDING_COUNT_MED_BAND

NUMBER

The number of speeding events recorded where the vehicle was in the medium band on the given date.

SPEEDING_COUNT_LOW_BAND

NUMBER

The number of speeding events recorded where the vehicle was in the low band on the given date.

TIME_IN_ECO_BAND

NUMBER

Total time the vehicle was driving within a good economical range (1500 - 2500 RPM) on the given date.

TIME_IN_ECO_BAND_TRIP_DURATION

NUMBER

Trip_duration used to calculate trip values for TIME_IN_ECO_BAND metric.

SPEEDING_OVER_65_MPH

NUMBER

The number of events recorded where the vehicle was traveling at a speed over 65 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.

SPEEDING_OVER_75_MPH

NUMBER

The number of events recorded where the vehicle was traveling at a speed over 75 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.

SPEEDING_OVER_80_MPH

NUMBER

The number of events recorded where the vehicle was traveling at a speed over 80 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.

SPEEDING_OVER_90_MPH

NUMBER

The number of events recorded where the vehicle was traveling at a speed over 90 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.

SPEEDING_OVER_100_MPH

NUMBER

The number of events recorded where the vehicle was traveling at a speed over 100 MPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.

SPEEDING_OVER_105_KMPH

NUMBER

The number of events recorded where the vehicle was traveling at a speed over 105 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.

SPEEDING_OVER_110_KMPH

NUMBER

The number of events recorded where the vehicle was traveling at a speed over 110 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.

SPEEDING_OVER_120_KMPH

NUMBER

The number of events recorded where the vehicle was traveling at a speed over 120 KPH on the given date. Counts the first speed event. Does not count consecutive events. The vehicle's speed must drop below the threshold then rise back above the threshold before an additional event is counted.

ACTIVE_MOVING_COUNT

NUMBER

Indicator of the vehicle’s activity on the given date. Equal to 1 if the driver was sufficiently active and 0 otherwise.

SEATBELT_OFF_5_MILES_DRIVER

NUMBER

The total time for which the seatbelt was not in use by the driver for more than 5 miles for the vehicle on the given date.

SEATBELT_OFF_5_MILES_PASSENGER

NUMBER

The total time for which the seatbelt was not in use by the driver’s passenger for more than 5 miles for the vehicle on the given date.

SEATBELT_OFF_10_MILES_PASSENGER

NUMBER

The total time for which the seatbelt was not in use by the driver for more than 10 miles for the vehicle on the given date.

SEATBELT_OFF_10_MILES_DRIVER

NUMBER

The total time for which the seatbelt was not in use by the driver’s passenger for more than 10 miles for the vehicle on the given date.

SEATBELT_OFF_2_MINUTES_DRIVER

NUMBER

The total time for which the seatbelt was not in use by the driver for more than 2 minutes for the vehicle on the given date.

SEATBELT_OFF_2_MINUTES_PASSENGER

NUMBER

The total time for which the seatbelt was not in use by the driver’s passenger for more than 2 minutes for the vehicle on the given date.

SEATBELT_OFF_10_MINUTES_DRIVER

NUMBER

The total time for which the seatbelt was not in use by the driver for more than 10 minutes for the vehicle on the given date.

SEATBELT_OFF_10_MINUTES_PASSENGER

NUMBER

The total time for which the seatbelt was not in use by the driver’s passenger for more than 10 minutes for the vehicle on the given date.

SEATBELT_OFF_35_MPH_DRIVER

NUMBER

The total time for which the seatbelt was not in use by the driver at the speed of more than 35 MPH for the vehicle on the given date.

SEATBELT_OFF_35_MPH_PASSENGER

NUMBER

The total time for which the seatbelt was not in use by the driver’s passenger at the speed of more than 35 MPH for the vehicle on the given date.

SEATBELT_OFF_60_MPH_DRIVER

NUMBER

The total time for which the seatbelt was not in use by the driver at the speed of more than 60 MPH for the vehicle on the given date.

SEATBELT_OFF_60_MPH_PASSENGER

NUMBER

The total time for which the seatbelt was not in use by the driver’s passenger at the speed of more than 60 MPH for the vehicle on the given date.

TOTAL_TRIP_COUNT

NUMBER

Total count of trips the vehicle makes on the given date.

RPM_767_DURATION

NUMBER

Total count of RPM 767 events the vehicle makes on the given date.

FUEL_USED_IDLING

NUMBER

Total amount of fuel used while the vehicle was idling on the given date. If the vehicle reports fuel usage, this KPI is based on reported fuel usage during idle time. If the vehicle does not report fuel usage, this KPI is calculated based on a fixed value of 0.8 gallons per hour (3.028 liters per hour) multiplied by idle time.

DIAGNOSTIC_PTO_DURATION

NUMBER

The total time for which the PTO (power take off) was active on the given date, in seconds. Data based on diagnostic readings.

DRIVE_TIME_DURATION

NUMBER

The total time for which the vehicle was actively driving on the given date.

HARD_CORNERING

NUMBER

The number of events recorded where the vehicle was harshly cornering on the given date.

FIRST_ADDRESS_ID

NUMBER

The first vehicle’s address ID reported for the day.

LAST_ADDRESS_ID

NUMBER

The last vehicle’s address ID reported for the day.

LAST_REPORTED_DEF_LEVEL

NUMBER

The last fill level of the vehicle's DEF tank reported for the day in percent, shown in increments of 5%.

IS_DEF_LEVEL_KNOWN

BOOLEAN

Whether the fill level of the vehicle's DEF tank is known or not.

LAST_DEF_LEVEL_REPORT_TIME

TIMESTAMP_NTZ

The last time fill level of the vehicle's DEF tank was reported for the day.

SPEEDING_5_MPH_OVERPOSTED

NUMBER

The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit on the given date.

SPEEDING_10_MPH_OVERPOSTED

NUMBER

The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit on the given date.

SPEEDING_10_KMPH_OVERPOSTED

NUMBER

The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit on the given date.

SPEEDING_20_KMPH_OVERPOSTED

NUMBER

The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit on the given date.

SPEEDING_10_PERCENT_OVERPOSTED

NUMBER

The number of events recorded where the vehicle was speeding 10% over the posted speed limit on the given date.

SPEEDING_20_PERCENT_OVERPOSTED

NUMBER

The number of events recorded where the vehicle was speeding 20% over the posted speed limit on the given date.

IDLE_BANDED_0_5_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving and the engine is on for a duration between 0 and 5 minutes on the given date.

IDLE_BANDED_5_10_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving and the engine is on for a duration between 5 and 10 minutes on the given date.

IDLE_BANDED_10_15_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving and the engine is on for a duration between 10 and 15 minutes on the given date.

IDLE_BANDED_15_30_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving and the engine is on for a duration between 15 and 30 minutes on the given date.

IDLE_BANDED_30_60_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving and the engine is on for a duration between 30 and 60 minutes on the given date.

IDLE_BANDED_60_1440_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving and the engine is on for a duration between 60 and 1440 minutes on the given date.

IDLE_OVER_FIVE_MINUTES

NUMBER

Total count of events where the vehicle was not moving and the engine is on for longer than 5 minutes on the given date.

IDLE_OVER_TEN_MINUTES

NUMBER

Total count of events where the vehicle was not moving and the engine was on for longer than 10 minutes on the given date.

IDLE_OVER_FIFTEEN_MINUTES

NUMBER

Total count of events where the vehicle was not moving and the engine is on for longer than 15 minutes on the given date.

IDLE_OVER_THIRTY_MINUTES

NUMBER

Total count of events where the vehicle was not moving and the engine is on for longer than 30 minutes on the given date.

IDLE_OVER_SIXTY_MINUTES

NUMBER

Total count of events where the vehicle was not moving and the engine is on for longer than 60 minutes on the given date.

NON_PRODUCTIVE_IDLE_BANDED_0_5_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 0 and 5 minutes on the given date.

NON_PRODUCTIVE_IDLE_BANDED_5_10_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 5 and 10 minutes on the given date.

NON_PRODUCTIVE_IDLE_BANDED_10_15_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 10 and 15 minutes on the given date.

NON_PRODUCTIVE_IDLE_BANDED_15_30_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 15 and 30 minutes on the given date.

NON_PRODUCTIVE_IDLE_BANDED_30_60_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 30 and 60 minutes on the given date.

NON_PRODUCTIVE_IDLE_BANDED_60_1440_MINUTES_EVENTS

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for a duration between 60 and 1440 minutes on the given date.

NON_PRODUCTIVE_IDLE_OVER_FIVE_MINUTES

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 5 minutes on the given date.

NON_PRODUCTIVE_IDLE_OVER_TEN_MINUTES

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 10 minutes on the given date.

NON_PRODUCTIVE_IDLE_OVER_FIFTEEN_MINUTES

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 15 minutes on the given date.

NON_PRODUCTIVE_IDLE_OVER_THIRTY_MINUTES

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 30 minutes on the given date.

NON_PRODUCTIVE_IDLE_OVER_SIXTY_MINUTES

NUMBER

Total count of events where the vehicle was not moving, the engine was on, and the PTO sensor was off for longer than 60 minutes on the given date.

SPEEDING_OVER_75_MPH_2MIN

NUMBER

The number of events recorded where the vehicle was speeding over 75 MPH for 2 minutes on the given date.

SPEEDING_10_MPH_OVERPOSTED_DURATION_2MIN

NUMBER

Total duration of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes on the given date.

SPEEDING_20_PERCENT_OVERPOSTED_2MIN

NUMBER

The number of events recorded where the vehicle was speeding 20% over the posted speed limit for 2 minutes on the given date.

SPEEDING_10_PERCENT_OVERPOSTED_2MIN

NUMBER

The number of events recorded where the vehicle was speeding 10% over the posted speed limit for 2 minutes on the given date.

AIRBAG_DEPLOYED_EVENTS

NUMBER

The number of events recorded where an airbag was deployed for the vehicle on the given date.

MINIMUM_BATTERY_VOLTAGE

NUMBER

The lowest battery voltage recorded for the vehicle on the given date.

MAXIMUM_BATTERY_VOLTAGE

NUMBER

The highest battery voltage recorded for the vehicle on the given date.

DEF_LEVEL_WARNING

NUMBER

Total number of times the DEF (Diesel Exhaust Fluid) level warning light was active for the vehicle on the given date.

MINIMUM_OIL_LIFE_REMAINING

NUMBER

The lowest oil life time recorded for the vehicle on the given date. The oil life time is the time remaining before an oil change is due.

MAXIMUM_OIL_LIFE_REMAINING

NUMBER

The highest oil life time recorded for the vehicle on the given date. The oil life time is the time remaining before an oil change is due.

OIL_LIFE_WARNING

NUMBER

Total number of times that the oil life remaining warning light was active for the vehicle on the given date.

LOW_TIRE_PRESSURE_WARNING

NUMBER

Total number of times that the low tire pressure warning light was active for the vehicle on the given date.

WATER_IN_FUEL_WARNING

NUMBER

Total number of times that the water in fuel warning light was active for the vehicle on the given date.

MIL_CEL_STATUS

NUMBER

The number of times the malfunction indicator lamp (MIL), or check engine light, was active for the vehicle on the given date.

AIRBAG_WARNING

NUMBER

Total number of times the airbag warning light was active for the vehicle on the given date.

LIFE_TIME_ENGINE_HOURS

NUMBER

Maximum reported Total Engine Hours for the vehicle on the given date.

MINIMUM_COOLANT_TEMPERATURE

NUMBER

Minimum reported coolant temperature for the vehicle on the given date.

MAXIMUM_COOLANT_TEMPERATURE

NUMBER

Maximum reported coolant temperature for the vehicle on the given date.

VEHICLE_MAX_SPEED

NUMBER

Maximum reported speed for the vehicle on the given date.

SEATBELT_WARNING

NUMBER

The number of events recorded where the seat belt warning light was active for the vehicle on the given date.

SPEEDING_OVER_85_2MIN_MPH

NUMBER

The number of events recorded where the vehicle was speeding over 85 MPH for 2 minutes on the given date.

SPEEDING_OVER_POSTED_5_MPH_2MIN

NUMBER

The number of events recorded where the vehicle was speeding 5 MPH over the posted speed limit for 2 minutes on the given date.

SPEEDING_OVER_POSTED_10_MPH_2MIN

NUMBER

The number of events recorded where the vehicle was speeding 10 MPH over the posted speed limit for 2 minutes on the given date.

SPEEDING_OVER_POSTED_10_KPH_2MIN

NUMBER

The number of events recorded where the vehicle was speeding 10 KPH over the posted speed limit for 2 minutes on the given date.

SPEEDING_OVER_POSTED_20_KPH_2MIN

NUMBER

The number of events recorded where the vehicle was speeding 20 KPH over the posted speed limit for 2 minutes on the given date.

EV_ENERGY_USED_MOTOR

NUMBER

The amount of energy used by the electric vehicle motor on the given date.

EV_ENERGY_GENERATED_MOTOR

NUMBER

The amount of energy generated by the electric vehicle motor on the given date.

EV_ENERGY_USED_HVAC

NUMBER

The amount of energy used by the HVAC (Heating, Ventilation, and Air Conditioning) systems in the electric vehicle on the given date.

EV_ENERGY_USED_AUX

NUMBER

The amount of energy used by auxiliary systems (for example, lights and radio) in the electric vehicle on the given date.

EV_ENERGY_USED_IDLE

NUMBER

The amount of energy used by the electric vehicle while idle on the given date.

EV_ENERGY_USED_RECHARGING

NUMBER

The raw amount of electricity consumption that occurs during the electric vehicle recharge on the given date.

EV_BATTERY_ENERGY_USED_RECHARGING

NUMBER

The amount of energy used when recharging the electric vehicle on the given date.

EV_BATTERY_ENERGY_GAINED_RECHARGING

NUMBER

The gain in battery energy that occurs when recharging an electric vehicle for the vehicle on the given date.

EV_BATTERY_ENERGY_LOST_RECHARGING

NUMBER

The difference between power used recharging and battery level gained for the vehicle on the given date.

EV_RECHARGE_DURATION

NUMBER

The time duration that the electric vehicle spent recharging on the given date.

EV_DISTANCE_IN_ECO_BAND

NUMBER

The distance traveled by the electric vehicle inside a good economical range (1500 - 2500 RPM) on the given date.

EV_CO2_SAVINGS

NUMBER

The amount of CO2 emission prevented by using the electric vehicle on the given date.

EV_ENERGY_CONSUMED

NUMBER

The total amount of energy used by an electric vehicle for the driver on the given date.

LONGEST_ENGINE_TIME

NUMBER

The longest engine running time on each particular day for the vehicle on the given date.

ABS_COUNT

NUMBER

Total number of times the Anti-Lock Braking System (ABS) was engaged for the vehicle on the given date.

STABILITY_COUNT

NUMBER

Total number of times the Roll Over Protection (ROP) engine control unit or ROP brake control was engaged for the vehicle on the given date.

TRACTION_COUNT

NUMBER

Total number of times the Anti-Slip Regulation (ASR) was engaged for the vehicle on the given date.

SMARTSPEEDING_5_MPH_OVERPOSTED

NUMBER

Total count of events when the vehicle was speeding more than 5 MPH over the posted speed limit and the speed was faster than the Smart Speed.

SMARTSPEEDING_OVER_POSTED_5MPH_2MIN

NUMBER

Total count of events when a vehicle was speeding more than 5 MPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_10_MPH_OVERPOSTED

NUMBER

Total count of events when the vehicle was speeding more than 10 MPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_OVER_POSTED_10MPH_2MIN

NUMBER

Total count of events when a vehicle was speeding more than 10 MPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_10_KMPH_OVERPOSTED

NUMBER

Total count of events when the vehicle was speeding more than 10 KPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_OVER_POSTED_10_KPH_2MIN

NUMBER

Total count of events when a vehicle was speeding more than 10 KPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_20_KMPH_OVERPOSTED

NUMBER

Total count of events when the vehicle was speeding more than 20 KPH over the posted speed limit and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_OVER_POSTED_20_KPH_2MIN

NUMBER

Total count of events when a vehicle was speeding more than 20 KPH over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_10_PERCENT_OVERPOSTED

NUMBER

Total count of events when a vehicle was speeding more than 10% over the posted speed limit and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_10_PERCENT_OVERPOSTED_2MIN

NUMBER

Total count of events when a vehicle was speeding more than 10% over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_20_PERCENT_OVERPOSTED

NUMBER

Total count of events when a vehicle was speeding more than 20% over the posted speed limit and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_20_PERCENT_OVERPOSTED_2MIN

NUMBER

Total count of events when a vehicle was speeding more than 20% over the posted speed limit for a duration of more than 2 minutes, and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_COUNT_LOW_BAND

NUMBER

The number of speeding events recorded where the vehicle was in the low band and the speed was faster than the Smart Speed on the given date.

SMARTSPEEDING_COUNT_MED_BAND

NUMBER

The number of speeding events recorded where the vehicle was in the medium band and the speed was faster than the Smart Speed on the given date.

NATURAL_GAS_USED

NUMBER

The amount of natural gas used by the vehicle on the given date.

ROW_INSERT_TIME

TIMESTAMP_NTZ

The time, in UTC, when the last entry for the vehicle was inserted in the Analytics database on the given date.

ROW_UPDATE_TIME

TIMESTAMP_NTZ

The time, in UTC, when the last entry for the vehicle was updated in the Analytics database on the given date.

WORKING_DURATION

NUMBER

The total time the vehicle was working on the given date, in seconds.

TIMER_ERROR_QUALITY_FLAG

BOOLEAN

Preview - Indicator as to whether some of the timer data might not be trustworthy.

NO_DISTANCE_QUALITY_FLAG

BOOLEAN

Preview - Indicator as to whether the distance data might not be trustworthy due to a mismatch between fuel usage and/or speed.

NO_SPEED_QUALITY_FLAG

BOOLEAN

Preview - Indicator as to whether the maximum speed data might not be trustworthy.

HIGH_DISTANCE_QUALITY_FLAG

BOOLEAN

Preview - Indicator as to whether the distance data might not be trustworthy due to incompatibilities with engine time and idle time.

Video course View (video_course)

Column Name

Slow Changing Behavior

Data Type

Description

VIDEO_COURSE_KEY

N/A

NUMBER

A unique identifier for the video course, used within the Analytics server. Use VIDEO_COURSE_KEY for joining this view.

VIDEO_COURSE_ID

N/A

TEXT

A unique identifier for the video course, used within Fleet. Use VIDEO_COURSE_ID for grouping by this view.

VIDEOCHANNEL_UUID

Historic

TEXT

A unique identifier for the video course channel, used within Fleet. Use VIDEOCHANNEL_UUID for grouping by this view.

VIDEO_NAME

Current

TEXT

The video course name.

VIDEO_DESCRIPTION

Historic

TEXT

The video course description.

URL

Historic

TEXT

The video course URL.

THUMBNAIL

Historic

TEXT

The video course thumbnail.

DURATION

Historic

NUMBER

The video course duration.

CHANNEL_NAME

Current

TEXT

The video course channel name.

CHANNEL_DESCRIPTION

Historic

TEXT

The video course channel description.

IS_CURRENT

N/A

BOOLEAN

Whether this video course database entry is current or has been replaced by a newer copy.

START_TIME_UTC

N/A

TIMESTAMP_NTZ

The time at which this video course entry was created, in UTC.

END_TIME_UTC

N/A

TIMESTAMP_NTZ

The time at which this video course entry became historical, in UTC.

ROW_UPDATE_TIME

N/A

TIMESTAMP_NTZ

The time, in UTC, when this entry was last updated.

Related articles

Comments

0 comments

Article is closed for comments.