14.1 sp067_knowledge_sets

This table contains the definitions of a number of sets of range Local Knowledge which are each identified by a set name. The sets are used to 'preset' an Operative with some standard Local Knowledge ranges in sp066.

Table Definition

Field	Type	Default	Nullable
set_name	varchar2(20)
travel_range	number(3)
local_knowledge	number(2)

Keys

primary key (set_name, travel_range)

foreign key (set_name) references sp276_knowledge_set_names (set_name)

foreign key (local_knowledge) references sp272_knowledge (local_knowledge)

Column Descriptions

Field	Description
set_name	Set identifier
travel_range	Minimum travel time, in minutes, for this local knowledge
local_knowledge	Employee's local knowledge of this region