Drivers
Internal Table Name: Driver
Use the Drivers table to define the characteristics of a specific driver class. These characteristics include costs, allowed assets, and constraints, such as maximum distance and work time.
When using driver scheduling with Transportation Optimization output, drivers are assigned to routes within the constraints defined. If a driver cannot be assigned, the route is considered unscheduled.
Driver Class
Technology: TO
Table: Driver
Internal Name: DriverClass
Type: Short Text (100)
Use this column to identify a specific class of drivers. All drivers in this class will have the same costs and constraints applied.
Fixed Cost
Technology: TO
Table: Driver
Internal Name: FixedCost
Type: Short Text (100)
Enter the cost incurred to each driver of this driver class that is used in driver scheduling.
Fixed Cost Per Route
Technology: TO
Table: Driver
Internal Name: FixedCostPerRoute
Type: Short Text (100)
Enter the cost incurred when a driver of this class is assigned to a route in driver scheduling.
Variable Cost Per Hour
Technology: TO
Table: Driver
Internal Name: VariableCostPerHour
Type: Short Text (100)
Enter the cost per hour per route incurred when a driver of this class is scheduled.
Allowed Assets
Technology: TO
Table: Driver
Internal Name: AllowedEquipment
Type: Short Text (100)
Enter the transportation assets or asset group/filter that this driver class can use when scheduled on a route. If you are not using a group or filter, you can separate different asset types with the pipe character (|). For example, a driver supports 3 asset types that are listed as Truck53|Truck48|Truck53_Reefer.
Min Time Between Routes
Technology: TO
Table: Driver
Internal Name: MinTimeBetweenRoutes
Type: Short Text (100)
Use this column to define the minimum time that must occur between the routes assigned to a driver of this class. This is the time from the End Date Time of one route to the Start Date Time of the next route assigned to the driver. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.
Max Time Between Routes
Technology: TO
Table: Driver
Internal Name: MaxTimeBetweenRoutes
Type: Short Text (100)
Use this column to define the maximum time that can occur between the routes assigned to a driver of this class. This is the time from the End Date Time of one route to the Start Date Time of the next route assigned to the driver. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.
Min Work Time Per Driver
Technology: TO
Table: Driver
Internal Name: MinWorkTimePerDriver
Type: Short Text (100)
This column specifies the minimum work time that must be assigned to each driver in this driver class that is scheduled. The work time of a route is the duration from the route's start time to its end time. The work time per driver is the sum of all route work times in their schedule. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.
Max Work Time Per Driver
Technology: TO
Table: Driver
Internal Name: MaxWorkTimePerDriver
Type: Short Text (100)
This column specifies the maximum work time that can be assigned to each driver in this driver class that is scheduled. The work time of a route is the duration from the route's start time to its end time. The work time per driver is the sum of all route work times in their schedule. Enter a value, then optionally select a time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.
Min Number Of Routes
Technology: TO
Table: Driver
Internal Name: MinNumberOfRoutes
Type: Float
This column specifies the minimum total number of routes that must be assigned to a driver of this class.
Max Number Of Routes
Technology: TO
Table: Driver
Internal Name: MaxNumberOfRoutes
Type: Float
This column specifies the maximum total number of routes that can be assigned to a driver of this class.
Min Distance Per Driver
Technology: TO
Table: Driver
Internal Name: MinDistancePerDriver
Type: Short Text (100)
This column specifies the minimum total distance that must be assigned to a driver of this class. Enter a value, then optionally select a distance unit of measure. If you do not select a unit of measure, the default Distance Unit Of Measure from Model Settings is used.
Max Distance Per Driver
Technology: TO
Table: Driver
Internal Name: MaxDistancePerDriver
Type: Short Text (100)
This column specifies the maximum total distance that can be incurred for a driver of this class. Enter a value, then optionally select a distance unit of measure. If you do not select a unit of measure, the default Distance Unit Of Measure from Model Settings is used.
Max Duty Time Per Shift
Technology: TO
Table: Driver
Internal Name: MaxDutyTimePerShift
Type: Short Text (100)
This column specifies the maximum allowed duty time in a shift before Rest Time must be taken for a driver of this class. Duty time includes drive time, non-drive working time, break time and wait time. Each route must be completed within one shift. Routes to be scheduled for this driver class must have a duration that is less than Max Duty Time Per Shift. The duty-time clock of the driver is reset after a Rest Time is scheduled, and a new shift begins after the Rest Time. Enter a value, then optionally select time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.
Max Drive Time Per Shift
Technology: TO
Table: Driver
Internal Name: MaxDriveTimePerShift
Type: Short Text (100)
This column specifies the time budgeted for every shift that is expended by any driving activity. Once the Max Drive Time Per Shift has been reached, the driver is not allowed to drive until they take a long break, specified by the Rest Time. Once the Rest Time has been taken, the budget for drive time is reset. Enter a value, then optionally select time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.
When specifying driver service time constraints, do not set “Maximum” column values, such as Max Drive Time Per Shift, to 0. This can cause unexpected routing results, including violation of other hours of service constraints.
Rest Time
Technology: TO
Table: Driver
Internal Name: Break Time
Type: Short Text (100)
This column specifies the minimum amount of off duty time after Max Duty Time Per Shift has been met. Rest Time must be taken before being on duty again for this driver class. Rest Time is incurred between routes. Max Time Between Routes must be greater than Rest Timeor else the driver cannot take the rest and can only be assigned a single shift. The Rest Time is scheduled in between consecutive routes assigned to the driver; therefore, its value must be less than or equal to the driver’s Max Time Between Routes. Enter a value, then optionally select time unit of measure. If you do not select a unit of measure, the default Time Unit Of Measure from Model Settings is used.
Status
Technology: TO
Table: Driver
Internal Name: Status
Type: Short Text (25)
One of Include, Exclude.
Choose the driver status:
- Include - This driver class is included when the model is run.
- Exclude - This driver class is excluded when the model is run.
Default: Include
Last modified: Wednesday May 15, 2024