14.1 sp066_knowledge_ranges
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
Each record in this table defines an employee's local knowledge of a particular travel range. This table is used when determining the suitability of an operative to do a particular job. The local knowledge factor will be a value from 0 to 10 which if 0 means that the range is a 'don't go' area (the higher the number the more familiar the region is to the operative).
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| employee_no | number(9) |  | |
| travel_range | number(3) | | |
| local_knowledge | number(2) | | |
| start_date | date | trunc(sysdate) | |
| end_date | date |  | |
| is_derived | number(1) | 0 | |
Keys
primary key (employee_no, travel_range, start_date, is_derived)
foreign key (employee_no) references sp210_employees (employee_no)
foreign key (local_knowledge) references sp272_knowledge (local_knowledge)
Column Descriptions
| Field | Description |
|---|---|
| employee_no | Employee identifier. |
| travel_range | Minimum travel time, in minutes, for this local knowledge |
| local_knowledge | This employee's local knowledge of this region. |
| start_date | Date on which the employee acquires this level of knowledge. Uses employee's Time Zone. |
| end_date | Date on which the employee ceases to have this level of knowledge. Uses employee's Time Zone. |
| is_derived | No longer used |