Each record in this table defines an employee's local knowledge of a particular travel range. This table is used when determining the suitability of an operative to do a particular job. The local knowledge factor will be a value from 0 to 10 which if 0 means that the range is a 'don't go' area (the higher the number the more familiar the region is to the operative).

Table Definition

Field	Type	Default
employee_no	number(9)
travel_range	number(3)
local_knowledge	number(2)
start_date	date	trunc(sysdate)
end_date	date
is_derived	number(1)	0

Keys

primary key (employee_no, travel_range, start_date, is_derived)

foreign key (employee_no) references sp210_employees (employee_no)

foreign key (local_knowledge) references sp272_knowledge (local_knowledge)

Column Descriptions

Field	Description
employee_no	Employee identifier.
travel_range	Minimum travel time, in minutes, for this local knowledge
local_knowledge	This employee's local knowledge of this region.
start_date	Date on which the employee acquires this level of knowledge. Uses employee's Time Zone.
end_date	Date on which the employee ceases to have this level of knowledge. Uses employee's Time Zone.
is_derived	No longer used

Browser not supported