Driver Schedule

Internal Table Name: DriverSchedule

The Driver Schedule table provides information about every scheduled route. It includes details such as the start time, equipment type and total distance for the route.

Scenario

Table: DriverSchedule

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Route ID

Table: DriverSchedule

Internal Name: RouteID

The identifier of the route.

Driver ID

Table: DriverSchedule

Internal Name: DriverId

The driver that has been scheduled on the route.

Asset Origin

Table: DriverSchedule

Internal Name: AssetOrigin

The origin of the asset that is assigned to the route.

Start Time

Table: DriverSchedule

Internal Name: StartTime

The duration (in minutes) from the earliest start time across all routes from the Routes table to the route’s start time.

Route Time

Table: DriverSchedule

Internal Name: RouteTime

The duration of the route in minutes.

Drive Time

Table: DriverSchedule

Internal Name: DriveTime

The drive time defined for the route. This is populated in the Drive Time column on the Routes input table.

Asset Name

Table: DriverSchedule

Internal Name: EquipmentTypeId

The transportation asset that has been assigned to this route.

Start Timestamp

Table: DriverSchedule

Internal Name: StartTimestamp

The start date and time of the route.

Total Distance

Table: DriverSchedule

Internal Name: TotalDistance

The total distance traveled on the route.

Scenario ID

Table: DriverSchedule

Internal Name: ScenarioID

The identifier of the scenario for which the output data was generated.

Sub-Scenario ID

Table: DriverSchedule

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the output data was generated.