Specifying List Columns

Many of the panels in Verizon Connect® Dispatch™ display information about routes and jobs as lists. The visibility of the columns of information in these lists is controlled by the column picker, which appears in the title bar of each column.

The columns displayed for unassigned and for assigned jobs in the Jobs List can be configured separately. You might, for example, want to show the Driver column for assigned jobs, but not for unassigned jobs (where there is, of course, not yet an assigned driver) but instead the Preferred Driver and Priority columns.

 
To indicate which columns you want to display and which you want to hide:
 

1.Click any column picker on the far right of a column title bar. The picker will appear as a downward-facing gray arrow:

 
2.Click Columns in the drop-down menu, and then select the name of every column you want to appear in the list.

The information shown under the columns for each list screen is described below:
 

Jobs List Columns
Daily Routes List Columns

Columns that display a time of day, for example 'Arrival Time' and 'Departure Time', show the time at the job location. To see this time converted to your current time zone (configured from Settings > User) hover your mouse over a time value. The selected time, converted to your own time zone and with the abbreviated name of your time zone, is shown in a tool tip below the mouse pointer.

The formatting of dates in columns and on tool-tips is determined by the region chosen in your platform user settings (such as 'US' or 'UK'), not the regional settings of your PC. To set this region, and therefore the date formatting you want to use, click your account name in the upper right corner of the screen, and then click Settings. In the Settings dialog box that opens, click the User tab and then specify your region from the Region drop-down menu. For example, select 'US' for MM/DD/YYYY date formats, or 'UK' for DD/MM/YYY date formats.

Jobs List Columns

Column

Details

Job Name

The name of the job. Click to open the Edit Job dialog box.

Code

The arbitrary code assigned to this job.

Driver

The name of the driver this job is assigned to. Click to open the Edit Driver dialog box.

Time on Site

The length of time that will be spent at the customer site servicing this job; typically in hours and minutes, or minutes, but can also include seconds.

Planned Arrival

The time and date at which the driver is expected to arrive at this job site. These times are displayed using the time zone configured for the territory that the job occurs within (Territories screen, Properties tab).

Actual Arrival

The actual time and date at which the driver arrived at this job site, if the driver has arrived at the job site. If the route is still in progress, an estimated arrival time is shown in italic text. This column is only visible when viewing the current day ('Today'), and is only available to customers using Verizon Connect® Dispatch™.

Planned Departure

The time and date at which the driver is expected to leave this job site. These times are displayed using the time zone configured for the territory that the job occurs within (Territories screen, Properties tab).

Actual Departure

The actual time and date at which the driver left this job site, if the driver has left the job site. If the route is still in progress, an estimated departure time is shown in italic text. This column is only visible when viewing the current day ('Today'), and is only available to customers using Verizon Connect® Dispatch™.

Timezone

The time zone at the job location ("PST" or "EST", for example).

Priority

The priority of this job (Lowest, Low, Normal, High or Highest). Higher priority jobs are routed ahead of lower priority jobs when building routes.

Driver Requires

The attributes that must be provided by the driver in order to complete this job. These could be a specific license category, or training to handle a class of goods, or to operate one type of equipment, for example.

Vehicle Requires

The attributes that must be provided by the vehicle in order to complete this job. These could be a high load capacity, a crane, PTO capabilities, or a refrigeration unit, for example.

Job Type

The type of this job. Job types are arbitrary, and created from the Job Types screen in the main platform interface.

Tags

The text tags, if any, associated with this job. Tags are arbitrary, and defined using the Tags screen of the main platform interface.

Due on Date

The date this job is due to occur. For jobs with a requested arrival time window spanning several days, this indicates the last day that this job can occur on within that window.

Time Window

The arrival time window (the earliest and latest times that the job can be completed) of the job at the customer site.

Time Window 2

The secondary arrival time window (the earliest and latest times that the job can be completed) of the job at the customer site. Optional. Note that If the end of this second time window ('Time Window 2') is earlier than the start of the first time window ('Time Window'), the time window spans midnight. If 'Time Window 2' starts at an earlier time than 'Time Window', it is assumed to occur after midnight (on the following day).

Requested Dates

The requested arrival date range of the job at the customer site.

Preferred Driver

The preferred driver for this job. Jobs with a driver preference that cannot be met (if the driver is unavailable on the day of the job, for example) cause a warning message to be shown. Click to open the Edit Driver dialog box.

Weight (Total)

The total weight of the load carried as part of this job.

Volume (Total)

The total volume of the load carried as part of this job.

Custom Properties

Custom properties, if any, configured for jobs will be added as additional selectable columns. The number of these columns varies according to your account configuration.

Custom Capacity Metrics

Capacity limits that you have defined for vehicles, if any, are added as additional selectable columns.

Status

The status of the job (Assigned, En Route, On Site, Completed, or Unassigned). Only available to customers using Verizon Connect® Dispatch™.

Marker

The name of the marker at which the job takes place. Click to open the Marker Details dialog box.

Days

The days of the week that this job is permitted to be serviced. When this column is visible, letters for days that are available are shown in dark text, while days that are unavailable are shown in light text. Hover your mouse over the letters to see a tool-tip listing the available days for the corresponding job. See also Specifying Job Time Windows.

Last Modified

The time and date that details of this job were last changed. Use the sorting feature on this column to view the most recently edited jobs, or the oldest jobs that have remained unchanged. Hover your mouse over a value to see a tool-tip containing the time of the edit in the time zone of your account.

Linked Job Marker

The marker location at which the job that has been linked with this job (that is, the job specified to take place immediately before or after this job in the assigned route) is scheduled to occur. Only available if your subscription includes support for linked jobs.

Linked Job Time on Site

The length of time that will be spent at the customer site servicing the job that has been linked to this job; typically in hours and minutes, or minutes, but can also include seconds. Only available if your subscription includes support for linked jobs.

Recurring Job

The name of the recurring job created in Scenarios that was used to generate this job. Click the name to view the recurring job in the Scenarios user interface. Only available to subscriptions that include the Verizon Connect® Scenarios™ product.

Ordinal

The order of the recurring job in a route. Only available to subscriptions that include the Verizon Connect® Scenarios™ product.

Daily Route Columns

Column

Details

Route Name

The name of the route. Click to open the Edit Route dialog box.

Same Side Routing

The 'same side routing' status of this route. If there is an icon () in this column beside a route, the turn-by-turn directions of that route ensure that the vehicle approaches stops on the same side of the road as the stop entrance, preventing crossing the street and oncoming lanes of traffic. If there is no icon, the route will be generated without taking the side of the stop into consideration. Same side routing is configured on individual territories or vehicles, or globally from the Routing Defaults screen.

Driver

The name of the driver assigned to this route. Click to open the Edit Driver dialog box.

Vehicle

The name of the vehicle assigned to the route. Click to open the Edit Vehicle dialog box.

Cost

The estimated cost of the route. This is based on the length of the route, the cost of fuel (diesel or gas), the vehicle's fuel consumption figures, the duration of the shift, and the driver's hourly pay rate (both normal and overtime).

Duration

The estimated length of time that this route will take to complete, including time spent on site; typically in hours and minutes, or hours.

Distance

The total length of this route in the distance units configured; typically in miles or kilometers.

Jobs

The number of jobs on this route, not including the start location; typically a depot or driver's home.

Timezone

The time zone of the territory containing the route ("PST" or "EST", for example). If 'All Territories' is selected from the Territory Filter, the Timezone column is enabled automatically on both the Jobs List and the Routes List. If a specific territory is then selected, the two columns are automatically hidden.

Start Time

The date and time that the route is planned to begin.

Weight

The total weight of the load carried on this route (that is, the sum of the weight of all products that will be picked up and delivered on each job on the route). No calculations are carried out to subtract pick-ups from deliveries.

Volume

The total volume of the load carried on this route (that is, the sum of the volume of all products that will be picked up and delivered on each job on the route). No calculations are carried out to subtract pick-ups from deliveries.

Weight Utilization

This column includes a bar graph that indicates the percentage of the vehicle's weight capacity required by the route. When the route load exceeds 79% of the vehicle's weight capacity, this graph is colored orange. When it exceeds 100% of the vehicle's weight capacity, the graph is colored red. When decimal values are used in your vehicle weight capacities, these are rounded up or down to the nearest whole number (for example a total delivery of 10.5 units on a route assigned to a vehicle with a capacity of 100 units will be shown as a load of 11% in the graph).

Volume Utilization

This column includes a bar graph that indicates the percentage of the vehicle's volume capacity required by the route. When the route load exceeds 79% of the vehicle's volume capacity, this graph is colored orange. When it exceeds 100% of the vehicle's volume capacity, the graph is colored red. When decimal values are used in your vehicle volume capacities, these are rounded up or down to the nearest whole number (for example a total delivery of 10.5 units on a route assigned to a vehicle with a capacity of 100 units will be shown as a load of 11% in the graph).

Custom Capacity Metrics

Capacity limits that you have defined, if any, are added as additional selectable columns.

Last Modified

The time and date that details of this route were last changed. Use the sorting feature on this column to view the most recently edited routes. Hover your mouse over a value to see a tool-tip containing the time of the edit in the time zone of your account.

Driving Time

The total driving time of this route. That is, the route duration minus any time spent on site. Only available once the cost of the route has been generated.