14.1 sp125_region_LK_patterns
- Billy Sewell (Unlicensed)
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. |