sp125_region_LK_patterns
- Jason Andrew
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. |
Â
Â