Document toolboxDocument toolbox

14.1 sp127_region_LK_overrides

Owned by Billy Sewell (Unlicensed)
Jan 26, 2024

This table defines operative's region LK values for a specific date.

HouseKeeping

This table is tidied by sp_dbtidy's Global group.

 

Table Definition

Field
Type
Default
Nullable
employee_nonumber(9)  (error)
override_datedate  (error)
region_nonumber(9)  (error)
local_knowledgenumber(2)  (error)

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

FieldDescription
employee_no Operative to which this region LK applies
override_dateDate to which this region LK applies (employee time zone).
region_noRegion identifier
local_knowledgeThis employee's local knowledge of this region