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