The travel matrix defines the region to region travel times for use in offering and scheduling appointments.

Not all combinations of regions will be held here, only the sensible region to region trips. If the value for a particular trip is not present then the travel time for the journey between the higher level regions in the region hierarchy will be used.

Table Definition

Field	Type	Default	Nullable
region_no1	number(9)
region_ref1	varchar2(26)
region_no2	number(9)
region_ref2	varchar2(26)
start_date	date
end_date	date
journey_type	number(3)
travel_time	number(11)
adjacent	number(1)

Keys

primary key (region_no1, region_no2)
unique (region_ref1, region_ref2)
foreign key (region_no1, region_ref1) references /wiki/spaces/SCH141/pages/27068047 (region_no, region_ref)
foreign key (region_no2, region_ref2) references sp057_regions (region_no, region_ref)
foreign key (journey_type) references 14.1 sp263_journey_types (journey_type)

Column Descriptions

Field	Description
region_no1	ServiceOptimizer identifier of region 1.
region_ref1	User identifier of region 1.
region_no2	ServiceOptimizer identifier of region 2.
region_ref2	User identifier of region 2.
start_date	Not used.
end_date	Not used.
journey_type	Journey type - urban, rural etc.
travel_time	Travel time in minutes between region 1 and region 2.
adjacent	Flag indicating whether or not regions 1 and 2 are adjacent - 0 - not adjacent 1 - adjacent

Browser not supported