Document toolboxDocument toolbox

sp126_LK_range_overrides

Owned by Jason Andrew
Oct 02, 2024

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


 Collectively, the set of range LK values for a particular date form an LK set that defines the LK ranges for that 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)
travel_rangenumber(3)  (error)
local_knowledgenumber(2)  (error)

Keys 

primary key (employee_no, override_date, travel_range) 
foreign key (employee_no, override_date) references sp064_overrides(employee_no, override_date) 
foreign key (local_knowledge) references sp272_knowledge (local_knowledge)

Column Descriptions

FieldDescription
employee_noOperative to which this range LK applies
override_dateDate to which this range LK applies (employee time zone).
travel_rangeMinimum travel time, in minutes, for this local knowledge.
local_knowledgeThis employee's local knowledge within this travel range.