14.1 sp064_overrides

This table contains overrides to an employee's normal operative day and shift attributes. Each record in this table corresponds to an override to the data for one operative day.

A record in this table may contain operative day attributes and shift attributes. If any of these values is NULL, then the default value for that attribute is retained.
Some operative days do not have a shift defined by default (via the shift assignment, sp113). If any shift attributes are defined for such days, then all mandatory shift attributes must be specified. In that case, a record in this table defines an Extra Shift.
Local knowledge overrides are specified in tables sp126_LK_range_overrides and sp127_region_LK_overrides.

HouseKeeping

This table is tidied by sp_dbtidy's Global group

Table Definition

Field	Type	Nullable
employee_no	number(9)
override_date	date
start_location	number(1)
end_location	number(1)
start_region_no	number(9)
end_region_no	number(9)
start_postcode	varchar2(30)
end_postcode	varchar2(30)
lk_location	number(1)
lk_region_no	number(9)
lk_postcode	varchar2(30)
start_time	number(4)
end_time	number(4)
~~lunch_start~~	~~number(4)~~	(deprecated)
~~lunch_end~~	~~number(4)~~	(deprecated)
~~lunch_duration~~	~~number(4)~~	(deprecated)
capacity_shift	varchar2(1)
ADJ_shift	varchar2(1)
use_LK_range_defaults	number(1)
use_region_LK_defaults	number(1)
vehicle_capacity	number(9)

Keys

primary key (employee_no, override_date)

foreign key (employee_no) references 14.1 sp210_employees (employee_no)

foreign key (start_location) references /wiki/spaces/SCH141/pages/27066920 (location)

foreign key (end_location) references sp271_start_end_locations(location)

foreign key (start_region_no) references /wiki/spaces/SCH141/pages/27068047 (region_no)

foreign key (end_region_no) references sp057_regions (region_no)

foreign key (lk_location) references sp271_start_end_locations (location)

foreign key (lk_region_no) references sp057_regions (region_no)

Primary Key Referenced From

14.1 sp641_break_overrides

Column Descriptions

Field	Description
employee_no	Employee identifier.
override_date	Together with employee_no, identifies a particular operative day whose attributes are overridden by this record. Uses FRU local time zone.
start_location start_postcode start_region_no	Location from which employee starts work. See sp210_employees (default_start_loc, default_start_loc_postcode, default_start_loc_region_no).
end_location end_postcode end_region_no	Location from which employee finishes work. See sp210_employees (default_end_loc, default_end_loc_postcode, default_end_loc_region_no).
end_region_no	Location from which employee finishes work. See sp210_employees (default_end_loc, default_end_loc_postcode, default_end_loc_region_no).
lk_location lk_postcode lk_region_no	Location about which employee's range local knowledge is centred. See sp210_employees (default_LK_centre_loc, default_LK_centre_postcode, default_LK_centre_region_no).
start_time	Shift start time override value. See 14.1 sp115_shifts (start_time). Uses employee (operative) time zone.
end_time	Shift end time override value. See 14.1 sp115_shifts (end_time). Uses employee (operative) time zone.
capacity_shift	Indicates whether this shift provides capacity. See 14.1 sp115_shifts (capacity_shift).
ADJ_shift	Indicates whether All Day jobs can be allocated automatically to this shift. See 14.1 sp115_shifts (ADJ_shift).
use_LK_range_defaults	Indicates whether the operative's local knowledge ranges are overridden on this date. (If not, default ranges in sp066_knowledge_ranges or, if present, work pattern ranges in sp123_work_pattern_days/sp124_LK_range_patterns are used.) 0 indicates that local knowledge ranges are overridden on this date. The set of local knowledge ranges to use on this date are in sp126_LK_range_overrides. If no LK range overrides are specified in sp126_LK_range_overrides then this implies that the operative has no LK ranges defined for this day. 1 indicates that local knowledge ranges are not overridden on this date.
use_region_LK_defaults	Indicates whether the operative's local knowledge regions are overridden on this date. (If not, default regions in sp065_local_knowledge or, if present, work pattern regions in sp123_work_pattern_days/sp125_region_lk_patterns are used.) 0 indicates that region local knowledge is overridden on this date. The set of local knowledge regions to use on this date are in sp127_region_LK_overrides. If no region LK overrides are specified in sp127_region_LK_overrides then this implies that the operative has no region LK defined for this day. 1 indicates that region local knowledge is not overridden on this date
vehicle_capacity	This is the vehicle capacity for the specified override date. A null value indicates that the underlying sp210_employees.vehicle_capacity value should be used. A value of 0 indicates that the day is explicitly overridden to have no vehicle capacity.