Each record in this table defines an employee's local knowledge of a particular region. This table is used when determining the suitability of an operative to do a particular job. The local knowledge factor will be a value between 0 and 10, where 10 means complete local knowledge and 0 means no local knowledge i.e. 'don't go there' (hard constraint).

HouseKeeping

This table is tidied by sp_dbtidy's Global group

Table Definition

Field	Type	Default
employee_no	number(9)
region_no	number(9)
region_ref	varchar2(26)
local_knowledge	number(2)
start_date	date	trunc(sysdate)
end_date	date
is_derived	number(1)

Keys

primary key (region_no, employee_no, start_date, is_derived)

foreign key (employee_no) references sp210_employees (employee_no)

foreign key (region_no,region_ref) references sp057_regions (region_no, region_ref)

foreign key (local_knowledge) references sp272_knowledge (local_knowledge)

Column Descriptions

Field	Description
employee_no	Employee identifier.
region_no	Region identifier
region_ref	End users' unique identifier
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	For crews, a flag indicating whether or not the local knowledge has been derived from the crewmembers' local knowledge, or whether it is independent of the crewmembers' knowledge. A value of 1 indicates that the local knowledge was derived from the crewmembers' knowledge, 0 that it was not.

Browser not supported