sp124_LK_range_patterns
- Jason Andrew
This table defines operative's range LK values for a specific day within the operative's work pattern.
 Collectively, the set of range LK values for a particular work pattern day form an LK set that defines the LK ranges for that day.
 If no range LKs are defined for a particular work pattern day, then the operative's defaults (from sp066_knowledge_ranges) apply.
 If any range LKs are defined for a particular work pattern day, then the operative's defaults (from sp066_knowledge_ranges) are completely ignored (i.e. this set of range LKs replaces the operative defaults).
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| employee_no | number(9)Â | Â | Â  |
| day_number | number(3) | Â | Â |
| travel_range | number(3) | Â | Â |
| local_knowledge | number(2) | Â | Â |
KeysÂ
primary key (employee_no, day_number, travel_range)Â
foreign key (employee_no, day_number) references sp123_work_pattern_days(employee_no, day_number)Â
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 range applies. |
| travel_range | Minimum travel time, in minutes, for this local knowledge. |
| local_knowledge | This employee's local knowledge within this travel range. |