Document toolboxDocument toolbox

sp065_local_knowledge

Owned by Jason Andrew
Oct 02, 2024

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
Nullable
employee_nonumber(9) (error)
region_nonumber(9) (error)
region_refvarchar2(26) (error)
local_knowledgenumber(2) (error)
start_datedatetrunc(sysdate)(tick)
end_datedate (tick)
is_derivednumber(1) (error)

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

FieldDescription
employee_noEmployee identifier. 
region_noRegion identifier 
region_refEnd users' unique identifier 
local_knowledgeThis employee's local knowledge of this region. 
start_dateDate on which the employee acquires this level of knowledge. Uses employee's Time Zone. 
end_dateDate on which the employee ceases to have this level of knowledge. Uses employee's Time Zone. 
is_derivedFor 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. 

 

Â