Memory Configuration Guidelines

The following table provides general recommendations for memory usage on an x64 database server (assuming no other components are enabled):

Physical Server Memory	SQL MaxServerMemory
2GB	1500
4GB	3200
6GB	4800
8GB	6400
12GB	10000
16GB	13500
24GB	21500
32GB	29000
48GB	44000
64GB	60000
72GB	68000
96GB	92000
128GB	124000

If using other applications or SQL components, additional buffer should be provided. The requirements will vary by environment. The following table provides an outline of target memory utilization (under load):

Physical Server Memory	Target Available Memory in Task Manager
< 4GB	512MB – 1GB
4GB – 32GB	1GB – 2GB
32GB – 128GB	2GB – 4GB
> 128GB	> 4GB

You can use T-SQL to set your MaxServerMemory setting. The sample below sets it to 3500, which is the equivalent of 3.5 GB. This setting is dynamic in SQL Server 2005/2008/2012, which means that you can change it and it goes into effect immediately, without restarting SQL Server.

You can also change this setting in the SSMS GUI, as you see below:

Inline Table-Valued Function (TVF)

A TVF is a function that returns a table of values similar to a subquery. An inline TVF is a special type of TVF in SQL Server. Scalar functions and non-inline TVF functions are not costed in the execution plan evaluation. This means if they are complex (e.g. many sub lookups, etc.) SQL Server will underestimate the cost of using them and can come up with a poor quality plan that takes significantly more CPU or IO.

Here is an example of an inline TVF:

The defining points of an inline TVF are the use of the RETURN (…query…) syntax with no work being done outside the …query… section.

Performance Tips: If the query contained in the TVF uses joins or subqueries, it is important to include any parameters in the filters/joins/subqueries as early as possible to help SQL Server know which data is relevant to the remainder of the function. For example:

-- slower

-- faster

Function manipulation should always be performed on the constant portion of the where/join clauses. If they are performed on the table-portion, it prevents SQL Server from being able to use the indexes and will force scans rather than seeks, reducing the overall performance of the system.

For Example:

Here is the analysis from SQL Server of the two clauses above. Notice the “slow” version is 92 percent of the batch or 11.5 times more work than the “fast” version. On small datasets, this difference is negligible but on large datasets it can be significant.

Report Types

This section details the different types reports and all fields associated with each report. There are three types of reports:

Route-centric
Job-centric
Geocode Information

Route-centric Reports

BI_Monthly Planning Route

This report explains the utilization of the routes based on number of stops, capacity (Measure 1) and time. It also contains information for cost, number of stops and distance.

Field Name	Definition
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner™, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field.
InitialLocationKey	The initial location at which the route begins. In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field.
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field.
# of Routes	Total number of routes available
# Used Routes	Number of routes used based on number of jobs
# Empty Routes	Number of unused (empty) routes based on number of jobs
% Used Routes	Percentage of used routes from total number of routes available
% Empty Routes	Percentage of unused routes from total number of routes available
Available Time (Hr)	Total available time the used routes have
Planned Time (Hr)	Time allocated in planning for the used routes
Unused Time (Hr)	Time not allocated in planning from the total available time
% Planned Time	Percentage of time planned from the total available time
% Unused Time	Percentage of time not used from the total available time
Available Resource Measure 1	Available capacity for Measure 1 (Capacity of vehicle multiplied by the number or recharges)
Planned Measure 1 Dropoff	Dropoff planned capacity planned
Unused Measure 1 Dropoff	Unused capacity for measure 1 in Dropoff
% Planned Measure 1 Dropoff	Percentage of planned Measure 1 from total Dropoff
% Unused Measure 1 Dropoff	Percentage of unused Measure 1 from total Dropoff
Planned Measure 1 Pickup	Pickup planned capacity planned
Unused Measure 1 Pickup	Unused capacity for measure 1 in Pickup
% Planned Measure 1 Pickup	Percentage of planned Measure 1 from total Pickup
% Unused Measure 1 Pickup	Percentage of unused Measure 1 from total Pickup
Profile Cost	Cost of the route
Planned # Jobs	Planned number of geographical stops that the vehicle makes
Planned # Stops	Planned number of deliveries
Planned Miles	Planned number of miles per route
Average Distance per Job	Average distance, in miles, per job

BI_Monthly Route Last Report Status

This report depicts the number and percentage of routes that have each different status as their las report status.

Field Name	Definition
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
Usage (Hide and equal to 1)	Usage equal to 1 means that the route is used as opposed to empty
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins. In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
# Routes	Number of routes used based on number of jobs
# Pending Routes	Number of routes with pending as their last reported status
% Pending Routes	Percentage of routes with pending as their last reported status from the total number of assigned routes
# Arrived Routes	Number of routes with arrived as their last reported status
% Arrived Routes	Percentage of routes with arrived as their last reported status from the total number of assigned routes
# Completed Routes	Number of routes with completed as their last reported status
% Completed Routes	Percentage of routes with completed as their last reported status from the total number of assigned routes
# Exception Routes	Number of routes with exception as their last reported status
% Exception Routes	Percentage of routes with exception as their last reported status from the total number of assigned routes
# Missed Routes	Number of routes with missed as their last reported status
% Missed Routes	Percentage of routes with missed as their last reported status from the total number of assigned routes

BI_Monthly Publish Routes

This report shows the number and percentage of routes that are created (not published), published or changed after published.

Field Name	Definition
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
Usage (Hide and equal to 1)	Usage equal to 1 means that the route is used as opposed to empty
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins. In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
# Routes	Number of routes used based on number of jobs
# Routes Created (Not Published)	Number of routes with a publish status of created
% Routes Created (Not Published)	Percentage of routes with a publish status of created from # of used routes
# Published Routes	Number of routes with a publish status of publish
% Published Routes	Percentage of routes with a publish status of publish from # of used routes
# Routes Changed After Published	Number of routes with a publish status of changes after publish
% Routes Changed After Published	Percentage of routes with a publish status of publish from # of from # of used routes

BI_Monthly Alerts by Route

This report shows the number of routes that had any of the listed (12) alerts.

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
Usage (Hide and equal to 1)	Usage equal to 1 means that the route is used as opposed to empty
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins. In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
# Routes	Number of routes used based on number of jobs
Capacity Exceeded Violation	Number of routes with the given alert
% Capacity Exceeded Violation	Percentage of routes with the given alert from total number of used routes
Commodity Violation	Number of routes with the given alert
% Commodity Violation	Percentage of routes with the given alert from total number of used routes
Job Late Violation	Number of routes with the given alert
% Job Late Violation	Percentage of routes with the given alert from total number of used routes
Job Early Violation	Number of routes with the given alert
% Job Early Violation	Percentage of routes with the given alert from total number of used routes
Location Capacity Exceeded Violation	Number of routes with the given alert
% Location Capacity Exceeded Violation	Percentage of routes with the given alert from total number of used routes
Near Window Close Warning	Number of routes with the given alert
% Near Window Close Warning	Percentage of routes with the given alert from total number of used routes
Related Previous Job Violation	Number of routes with the given alert
% Related Previous Job Violation	Percentage of routes with the given alert from total number of used routes
Requirements Violation	Number of routes with the given alert
% Requirements Violation	Percentage of routes with the given alert from total number of used routes
Route Late Or Too Many Hours Violation	Number of routes with the given alert
% Route Late Or Too Many Hours Violation	Percentage of routes with the given alert from total number of used routes
Served Before Available Violation	Number of routes with the given alert
% Served Before Available Violation	Percentage of routes with the given alert from total number of used routes
Too Many Stops Violation	Number of routes with the given alert
% Too Many Stops Violation	Percentage of routes with the given alert from total number of used routes
Wrong Sequence Violation	Number of routes with the given alert
% Wrong Sequence Violation	Percentage of routes with the given alert from total number of used routes

BI_Monthly Planned vs Actual

This report shows the difference between the planned and the actual quantities measured.

Note: All the delta quantities are calculated as planned minus actual.

Field Name	Description
Usage (Hide and equal to 1)	Usage equal to 1 means that the route is used as opposed to empty
OrgUnitName (Hide & Run Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run Time)	Company identifier. Used to filter data
Filter Date (Hide & Run Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins. In parenthesis is the number or records (routes) that belong to this field
DriverKey	Database Identifier of the driver record
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
DriverName	Driver first and last name
ResourceKey	Database Identifier of the Route record
PlannedNumberofStops
NumberofStops
Delta Number of Stops
PlannedNumberofJobs
NumberofJobs
Delta Number of Jobs
PlannedMiles
ActualMiles
Delta Distance
PlannedMeasure1Dropoff
ActualMeasure1Dropoff
Delta Measure 1 Dropoff
PlannedMeasure1Pickup
ActualMeasure1Pickup
Delta Measure 1 Pickup
PlannedTravelTime
ActualTravelTime
Delta Travel Time
Planned Work Time
Actual Work Time
Delta Work Time
Planned Parking Time
Actual Parking Time
Delta Parking Time
Planned Packup Time
Actual Packup Time
Delta Packup Time

BI_Monthly Service Time Compliance – Histogram of Service Time Compliance

Field Name	Definition
Usage (Hide)	Usage Text where Is Equal to : ‘Used’
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins
DriverKey	Database Identifier of the driver record
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
DriverName	Driver first and last name
ResourceKey	Database Identifier of the Route record
# Routes	Total number of used routes
Planned vs Actual Service time < -40%
Planned vs Actual Service time -20 to -40%
Planned vs Actual Service time -10 to -20%
Planned vs Actual Service time -5 to -10%
Planned vs Actual Service time -1 to -5%
Planned vs Actual Service time -1 to 1%
Planned vs Actual Service time 1 to 5%
Planned vs Actual Service time 5 to 10%
Planned vs Actual Service time 10 to 20%
Planned vs Actual Service time 20 to 40%
Planned vs Actual Service time < 40%

BI_Monthly Driving Time Compliance – Histogram of Driving Time Compliance

Field Name	Description
Usage (Hide)	Usage Text where Is Equal to : ‘Used’
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins
DriverKey	Database Identifier of the driver record
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
DriverName	Driver first and last name
ResourceKey	Database Identifier of the Route record
# Routes	Total number of assigned routes
Planned vs Actual Driving Time < -40%
Planned vs Actual Driving Time -20 to -40%
Planned vs Actual Driving Time -10 to -20%
Planned vs Actual Driving Time -5 to -10%
Planned vs Actual Driving Time -1 to -5%
Planned vs Actual Driving Time -1 to 1%
Planned vs Actual Driving Time 1 to 5%
Planned vs Actual Driving Time 5 to 10%
Planned vs Actual Driving Time 10 to 20%
Planned vs Actual Driving Time 20 to 40%
Planned vs Actual Driving Time < 40%

BI_Monthly Distance Compliance – Histogram of Distance Compliance

Field Name	Description
Usage (Hide)	Usage Text where Is Equal to : ‘Used’
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins
DriverKey	Database Identifier of the driver record
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
DriverName	Driver first and last name
ResourceKey	Database Identifier of the Route record
# Routes	Total number of assigned routes
Planned vs Actual Distance < -40%
Planned vs Actual Distance -20 to -40%
Planned vs Actual Distance -10 to -20%
Planned vs Actual Distance -5 to -10%
Planned vs Actual Distance -1 to -5%
Planned vs Actual Distance -1 to 1%
Planned vs Actual Distance 1 to 5%
Planned vs Actual Distance 5 to 10%
Planned vs Actual Distance 10 to 20%
Planned vs Actual Distance 20 to 40%
Planned vs Actual Distance < 40%

BI_Monthly Late Start Compliance – Histogram of Late Start Compliance

Field Name	Description
Usage (Hide)	Usage Text where Is Equal to : ‘Used’
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins
DriverKey	Database Identifier of the driver record
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
DriverName	Driver first and last name
ResourceKey	Database Identifier of the Route record
# Routes	Total number of assigned routes
Planned vs Actual Late Start < -40%
Planned vs Actual Late Start -20 to -40%
Planned vs Actual Late Start -10 to -20%
Planned vs Actual Late Start -5 to -10%
Planned vs Actual Late Start -1 to -5%
Planned vs Actual Late Start -1 to 1%
Planned vs Actual Late Start 1 to 5%
Planned vs Actual Late Start 5 to 10%
Planned vs Actual Late Start 10 to 20%
Planned vs Actual Late Start 20 to 40%
Planned vs Actual Late Start < 40%

BI_Monthly Late End Compliance – Histogram of Late End Compliance

Field Name	Description
Usage (Hide)	Usage Text where Is Equal to : ‘Used’
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins
DriverKey	Database Identifier of the driver record
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
DriverName	Driver first and last name
ResourceKey	Database Identifier of the Route record
# Routes	Total number of assigned routes
Planned vs Actual Late End < -40%
Planned vs Actual Late End -20 to -40%
Planned vs Actual Late End -10 to -20%
Planned vs Actual Late End -5 to -10%
Planned vs Actual Late End -1 to -5%
Planned vs Actual Late End -1 to 1%
Planned vs Actual Late End 1 to 5%
Planned vs Actual Late End 5 to 10%
Planned vs Actual Late End 10 to 20%
Planned vs Actual Late End 20 to 40%
Planned vs Actual Late End < 40%

BI_Monthly Stop Sequence Compliance - Histogram of Sequence Compliance

Field Name	Description
Usage (Hide)	Usage Text where Is Equal to : ‘Used’
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
InitialLocationKey	The initial location at which the route begins
DriverKey	Database Identifier of the driver record
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
DriverName	Driver first and last name
ResourceKey	Database Identifier of the Route record
# Routes	Total number of assigned routes
Planned vs Actual Stop Sequence < -40%
Planned vs Actual Stop Sequence -20 to -40%
Planned vs Actual Stop Sequence -10 to -20%
Planned vs Actual Stop Sequence -5 to -10%
Planned vs Actual Stop Sequence -1 to -5%
Planned vs Actual Stop Sequence -1 to 1%
Planned vs Actual Stop Sequence 1 to 5%
Planned vs Actual Stop Sequence 5 to 10%
Planned vs Actual Stop Sequence 10 to 20%
Planned vs Actual Stop Sequence 20 to 40%
Planned vs Actual Stop Sequence < 40%

Jobs-centric Reports

BI_Jobs Assignment

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
# Days
# Jobs
# Assigned Jobs
# Jobs not Assigned
% Assigned Jobs
% Jobs not Assigned

BI_Jobs Jobs Location Type

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
# Days
Total # Jobs
# Assigned Jobs
# Customer
% Customer
# Depots
% Depots
# Lunch
% Lunch
# Breaks
% Breaks
# Rests
% Rests
# Fuel
% Fuel

BI_Jobs Jobs Type

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
# Days
Total # Jobs
# Assigned Jobs
# Delivery
% Delivery
# Delivery (Complex)
% Delivery (Complex)
# Final
% Final
# Initial
% Initial
# Locationless
% Locationless
# Pickup
% Pickup
# Pickup (Complex)
% Pickup (Complex)
# Recharge
% Recharge

BI_Jobs Jobs Alerts

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
# Days
# of Jobs
# Assigned Jobs
Capacity Exceeded Violation
% Capacity Exceeded Violation
Commodity Violation
% Commodity Violation
Job Late Violation
% Job Late Violation
Job Early Violation
% Job Early Violation
Location Capacity Exceeded Violation
% Location Capacity Exceeded Violation
Near Window Close Warning
% Near Window Close Warning
Related Previous Job Violation
% Related Previous Job Violation
Requirements Violation
% Requirements Violation
Route Late Or Too Many Hours Violation
% Route Late Or Too Many Hours Violation
Served Before Available Violation
% Served Before Available Violation
Too Many Stops Violation
% Too Many Stops Violation
Wrong Sequence Violation
% Wrong Sequence Violation

BI_Jobs Jobs Status

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
# Days
# Jobs
# Assigned Jobs
# Arrived
% Arrived
# Pending
% Pending
# Completed
% Completed
# Locationless
% Locationless
# Exception
% Exception
# Missed
% Missed

Geocode Information

BI_Geocode Source and Score Summary

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
GeocodeScore
# Jobs
# Routes
# Days
AvgAutoCorrectVsPlacedLocationDistance
StDevAutoCorrectVsPlacedLocationDistance
AvgGeocodeVsPlacedLocationDistance
StDevGeocodeVsPlacedLocationDistance
AvgStatusVsLocationGeoDistance
StDevStatusVsLocationGeoDistance

BI_Geocode Flags

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Geocodeflags
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.). In parenthesis is the number or records (routes) that belong to this field
# Jobs
# Routes
NumTotal
# Days

BI_Geocode Daily Summary

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Filter Date (Hide & Run-Time)	Start date. Used to filter data
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.)
VC_FilterStartDate
GeocodeSource
GeocodeScore
# Jobs
# Routes
# Days
AvgAutoCorrectVsPlacedLocationDistance
StDevAutoCorrectVsPlacedLocationDistance
AvgGeocodeVsPlacedLocationDistance
StDevGeocodeVsPlacedLocationDistance
AvgStatusVsLocationGeoDistance
StDevStatusVsLocationGeoDistance

BI_Geocode Source and Score Detail

Field Name	Description
OrgUnitName (Hide & Run-Time)	Organizational Unit Name. Used to filter data
SourceName (Hide & Run-Time)	Name of the database where data is coming from. Used to filter data
AppOrgName (Hide & Run-Time)	Company identifier. Used to filter data
Filter Date (Hide & Run-Time)	Start date. Used to filter data
Year	Year where data is coming from. In parenthesis is the number or records (routes) that belong to this field
Month	Month where data is coming from. In parenthesis is the number or records (routes) that belong to this field
GeocodeSource
GeocodeScore
BusinessOrgUnitName	This field represents the Organizational Unit (Schedule in Descartes Route Planner, FK_tblLocation in Descartes Route Planner On-demand, etc.)
# Jobs
# Routes
# Days
AvgAutoCorrectVsPlacedLocationDistance
StDevAutoCorrectVsPlacedLocationDistance
AvgGeocodeVsPlacedLocationDistance
StDevGeocodeVsPlacedLocationDistance
AvgStatusVsLocationGeoDistance
StDevStatusVsLocationGeoDistance

Appendix