Driver Dimension Table

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

Column

Description

Example

name

The driver’s full name (first, middle and last where available).

John Peter Smith

first_name

The driver’s first name.

John

middle_name

The driver’s middle name.

Peter

last_name

The driver’s last name.

Smith

address_field_1

The first field of the driver’s address details.

Unit A

address_field_2

The second field of the driver’s address details.

20 Enterprise

address_field_3

The third field of the driver’s address details.

Suburb Name

city

The city this driver lives in.

Aliso Viejo

state

The state this driver lives in.

California

postcode

The post code area this driver lives within.

92705

country

The country this driver lives in.

US

phone_number_1

This driver’s primary telephone number.

(949) 555-5582

phone_number_2

This driver’s secondary or alternative telephone number.

(949) 555-5521

mobile_phone_number

This driver’s mobile phone number.

555-555-5555

email_address

This driver’s email address.

john_smith@example.com

supervisor_id

The ID number of this driver's supervisor

1234567

employee_number

This driver’s employee number.

15235346

hire_date

The date this driver was hired.

2000-01-01

leave_date

The date this driver left the organization.

2005-01-01

license_number

This driver’s unique driver's license number.

C5727462

license_state

The state in which the driver’s license was issued.

CA

license_class

The class of driver’s license issued to this driver.

C

license_expiry

The expiration date of the driver’s license.

2013-09-08

insurance_carrier

The insurance provider of the driver’s vehicle insurance policy.

Liberty Mutual

insurance_account_number

The account number of the driver’s vehicle insurance policy.

2536AJ876GF-CA

insurance_expiry

The expiration date of the driver’s vehicle insurance policy.

2000-01-01

hos_status

The Hours of Service status of the driver. True if enabled, false if disabled.

True

hos_rule_type

The Hours of Service rules the driver is currently complying with. For example 'Federal', 'California', 'Texas' or 'Canada'.

Federal

hierarchy

The hierarchy nodes to which this driver belongs. Maximum of six levels. Comma delimited.

Demo,Florida,Central,Node 4,Node 5,Node 6

hierarchy_1

The first level hierarchy node containing this vehicle.

Demo

hierarchy_2

The second level hierarchy node containing this driver.

Florida

hierarchy_3

The third level hierarchy node containing this driver.

Central

hierarchy_4

The fourth level hierarchy node containing this driver.

Node 4

hierarchy_5

The fifth level hierarchy node containing this driver.

Node 5

hierarchy_6

The sixth level hierarchy node containing this driver.

Node 6

hierarchy_7

The seventh level hierarchy node containing this driver.

Node 7

hierarchy_8

The eighth level hierarchy node containing this driver.

Node 8

hierarchy_9

The ninth level hierarchy node containing this driver.

Node 9

hierarchy_10

The tenth level hierarchy node containing this driver.

Node 10

hierarchy_11

The eleventh level hierarchy node containing this driver.

Node 11

hierarchy_12

The twelfth level hierarchy node containing this driver.

Node 12

hierarchy_13

The thirteenth level hierarchy node containing this driver.

Node 13

hierarchy_14

The fourteenth level hierarchy node containing this driver.

Node 14

hierarchy_ids

The unique IDs (10-digit) of the hierarchies to which this user belongs as a comma delimited list.

185462547,185467839,448683139

is_current

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

true

teams

The names of the teams this driver is assigned to.

|Team|Central|Florida|Demo|HOS Team|

team_ids

The unique 9-digit IDs of the teams to which this driver belongs (called using teams).

|185467845|185467855|185467213|710506556|427227035|

depot_name

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

West HQ