/
sp064_overrides
sp064_overrides
- Andrew Hill (Deactivated)
Owned by Andrew Hill (Deactivated)
Oct 06, 2015
Analytics
Loading data...
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.
This table is tidied by sp_dbtidy's Global group
Table Definition
| Field | Type | Default | 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 sp210_employees (employee_no)
foreign key (start_location) references sp271_start_end_locations(location)
foreign key (end_location) references sp271_start_end_locations(location)
foreign key (start_region_no) references sp057_regions (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)
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 Employee 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 sp115_shifts (start_time) |
| end_time | Shift end time override value. See sp115_shifts (end_time) |
| capacity_shift | Indicates whether this shift provides capacity. See sp115_shifts (capacity_shift) |
| ADJ_shift | Indicates whether All Day jobs can be allocated automatically to this shift. See 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. |
, multiple selections available,