sp127_region_LK_overrides
Â
Table Definition
Field | Type | Default | Nullable |
---|---|---|---|
employee_no | number(9) | Â | Â |
override_date | date | Â | Â |
region_no | number(9) | Â | Â |
local_knowledge | number(2) | Â | Â |
KeysÂ
primary key (employee_no, override_date, region_no)Â
foreign key (employee_no, override_date) references sp064_overrides(employee_no, override_date)Â
foreign key (region_no) references sp057_regions (region_no)Â
foreign key (local_knowledge) references sp272_knowledge (local_knowledge)
Column Descriptions
Field | Description |
---|---|
employee_no | Operative to which this region LK applies |
override_date | Date to which this region LK applies (employee time zone). |
region_no | Region identifier |
local_knowledge | This employee's local knowledge of this region |
Â
Â