14.1 sp123_work_pattern_days

This table defines operative's location and local knowledge values within a work pattern. A work pattern day exists for every day in the work pattern. A record in this table represents one calendar day in the work pattern. It specifies optional pattern overrides for day start and end locations and LK centre location.

Local knowledge range and region values for this work pattern day can be found in sp124_LK_range_patterns and sp125_region_LK_patterns respectively.

Table Definition

Field	Type	Default	Nullable
employee_no	number(9)
day_number	number(3)
day_start_loc	number(1)
day_start_postcode	varchar2(30)
day_start_region_no	number(9)
day_end_loc	number(1)
day_end_postcode	varchar2(30)
day_end_region_no	number(9)
LK_centre_loc	number(1)
LK_centre_postcode	varchar2(30)
LK_centre_region_no	number(9)
use_LK_range_defaults	number(1)
use_region_LK_defaults	number(1)

Keys

primary key (employee_no, day_number)

foreign key(employee_no) references 14.1 sp122_work_patterns(employee_no)

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

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

foreign key (day_end_loc) references sp271_start_end_locations(location)

foreign key (day_end_region_no) references sp057_regions (region_no)

foreign key (LK_centre_loc) references sp271_start_end_locations(location)

foreign key (LK_centre_region_no) references sp057_regions (region_no)

Column Descriptions

Field	Description
employee_no	The employee whose work pattern day this is.
day_number	Identifies the day within the work pattern – 0 to 370. The number must be less than the period specified for the work pattern in sp122_work_patterns. Day 0 is a Sunday, as are days 7, 14 and 21 etc. ; days 1, 8, 15 and 22 etc. are Mondays; etc.
day_start_loc	The location of the operative at the start of his shift. Its value can specify that the operative starts at his Home location, or at his Depot, or at his Work location, or at the location supplied in day_start_postcode. If NULL, then the operative default (from sp210_employees) is used.
day_start_postcode, day_start_region_no	The location of the operative at the start of his shift when day_start_loc (above) is 'Specified'.
day_end_loc	The location of the operative at the end of his shift. Its value can specify that the operative ends at his Home location, or at his Depot, or at his Work location, or at the location supplied in day_end_postcode. If NULL, then the operative default (from sp210_employees) is used.
day_end_postcode, day_end_region_no	The location of the operative at the end of his shift when day_end_loc (above) is 'Specified'.
LK_centre_loc	Identifies the location from which range local knowledge is calculated. Its value can specify that the operative's LK centre is at his Home location, or at his Depot, or at his Work location, or at the location supplied in LK_centre_postcode. If NULL, then the operative default (from sp210_employees) is used.
LK_centre_postcode, LK_centre_region_no	Location from which range local knowledge is calculated when LK_centre_loc is 'Specified'.
use_LK_range_defaults	Indicates whether the operative's default Local Knowledge ranges (in sp066_knowledge_ranges) are used: 0 - Operative's default Local Knowledge ranges are not used; those defined in sp124_LK_range_patterns (if any) are used instead. 1 - Operative's default region Local Knowledge is used.
use_region_LK_defaults	Indicates whether the operative's default region Local Knowledge (in sp065_local_knowledge) are used: 0 - Operative's default region Local Knowledge are not used; those defined in sp125_region_LK_patterns (if any) are used instead. 1 - Operative's default region Local Knowledge is used.