14.1 sp094_travel_times
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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 |