Vehicle Dimension Table

The SQL Connector does not return deleted records for this table.

Column

Description

Example

id

A unique ID representing the vehicle.

2199

source_id

The user's Verizon Connect platform ID.

123456789

name

The name of the vehicle that this fact dimension record was created from.

Vehicle-123

fuel_type

The type of fuel used by this vehicle.

Gasoline

year

The year this vehicle was manufactured.

2014

make

The manufacturer of this vehicle.

Freightliner

model

The vehicle model.

F150

vin

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

1FTRW12W16KD96501

color

The color of the vehicle.

Silver

rego

The registration details of the vehicle (license plate number).

ABR002

type

The type of vehicle.

Tractor

engine_serial

The unique serial number of the vehicle’s engine.

192486EA987H

hierarchy

The hierarchy nodes to which this vehicle belongs in comma delimited text. Maximum of six levels.

West,California,New Node

hierarchy_ids

The unique IDs (10-digit) of the hierarchies to which this vehicle belongs in comma delimited text.

185462547,185467839,448683139

hierarchy_1

The first level hierarchy node containing this vehicle.

West

hierarchy_2

The second level hierarchy node containing this vehicle.

California

hierarchy_3

The third level hierarchy node containing this vehicle.

New Node

hierarchy_4

The fourth level hierarchy node containing this vehicle.

Node 4 Name

hierarchy_5

The fifth level hierarchy node containing this vehicle.

Node 5 Name

hierarchy_6

The sixth level hierarchy node containing this vehicle.

Node 6 Name

hierarchy_7

The seventh level hierarchy node containing this vehicle.

Node 7 Name

hierarchy_8

The eighth level hierarchy node containing this vehicle.

Node 8 Name

hierarchy_9

The ninth level hierarchy node containing this vehicle.

Node 9 Name

hierarchy_10

The tenth level hierarchy node containing this vehicle.

Node 10 Name

hierarchy_11

The eleventh level hierarchy node containing this vehicle.

Node 11 Name

hierarchy_12

The twelfth level hierarchy node containing this vehicle.

Node 12 Name

hierarchy_13

The thirteenth level hierarchy node containing this vehicle.

Node 13 Name

hierarchy_14

The fourteenth level hierarchy node containing this vehicle.

Node 14 Name

inactive

Whether this vehicle was flagged as inactive. True if inactive, false if active.

true

fleets

The fleets that the vehicle is assigned to. Pipe delimited text.

|NC Test Fleet|EndDemo|Florida|South Fleet|Sunil|Empty fleet|1Test|Central|Demo|

fleet_ids

The unique IDs (9-digit) of the fleets to which this vehicle belongs. Pipe delimited text.

|500183574|412899775| 223805121|437272053|413709679|185467209| 528221422|607070690|

tags

The tags associated with this vehicle. Pipe delimited text.

|Boom|Emergency|Military base clearance|

is_current

Indicates whether this database entry for the vehicle is current or not. Whenever there is a change to a vehicle, a new entry is created and the old entry's is_current status is set to false. Boolean.

true

oem_name

The name of the OEM or vehicle manufacturer.

Hino

class

The vehicle class.

Light

engine_type

The type of engine in the vehicle.

InternalCompustion

body_type

The body type of the vehicle, for example None, Dry Van, Refrigerated, Liquid Tank, Beverage, Dump, Refuse/Recycling, Flat Bed, Wrecker, Auto Carrier, Propane Tank, Shredder, Bucket Truck, Crane, or Other.

Dry Van

asset_type_name

The name of the asset type that this vehicle is assigned to.

Van

vehicle_category

The vehicle category that is defined in the platform on the Vehicle Settings page under Details > Vehicle Category.

Light Duty

tag_ids

An array of unique IDs for the tags that have been applied to this vehicle. Can be NULL if the vehicle has no tags.

12345, 12334

asset_type_id

The unique ID of the asset type that this vehicle is assigned to. Can be NULL if the vehicle has no asset types.

123123

install_type_id

The unique ID of the install type that this vehicle is assigned to. Can be NULL if the vehicle has no install types.

234234

install_type_name

The name of the install type that this vehicle is assigned to.

Hino

depot_name

The name of the vehicle's depot, which is the vehicle's base marker defined in the platform.

West HQ

electronic_serial_number

The serial number of the GPS unit connected to the vehicle. In the platform it is referred to as "ESN".

352252068173955