This table defines operative's region LK values for a specific day within the operative's work pattern.

If no region LKs are defined for a particular work pattern day, then the operative's defaults (from sp065_local_knowledge) apply.

If any region LKs are defined for a particular work pattern day, then the operative's defaults (from sp065_local_knowledge) are completely ignored (i.e. this set of region LKs replaces the operative defaults).

Table Definition

Field	Type	Default	Nullable
employee_no	number(9)
day_number	number(3)
region_no	number(9)
local_knowledge	number(2)

Keys

primary key (employee_no, day_number, region_no)
foreign key (employee_no, day_number) references sp123_work_pattern_days(employee_no, day_number)
foreign key (region_no) references sp057_regions (region_no)
foreign key (local_knowledge) references sp272_knowledge (local_knowledge)

Column Descriptions

Field

Description

employee_no,

day_number

These fields together identify the work pattern day to which this local knowledge region value applies.

region_no

Region identifier.

local_knowledge

This employee's local knowledge of this region.

Browser not supported