Currently, Descartes Route Planner has a basic resource management system with its own data elements that are needed to support the other Descartes Route Planner application components. The resource management system consists of the following data tables: Route Template, Location, and Time Zone.
Figure 5: Resource Management
Route Template - This data table holds the default scheduling attributes to be used during any scheduling function. Whenever a resource is created and a Route template is specified, it will utilize the Route template values as needed.
Location - This is a master type table that holds the depot location-specific information.
· The Location table is required and is associated with the resource with two foreign key values: the initial location and the final location keys. Both of the location references are required.
Time Zone - This is a master type table that holds the time zone references. Please see the Order Management section for details.
Resource - Please see the previous Supporting Data section for details.
Route - Please see the previous Schedule Data section for details.
Ü Note - The Route records are used to maintain the link between a specific Schedule and resource records.
