sp122_work_patterns

This table defines operative's work patterns. These define a repeating pattern of day start and end locations and local knowledge values (via the tables sp123_work_pattern_days, sp124_LK_range_patterns and sp125_region_LK_patterns). Thus for example an operative can be specified as starting from "Home" every Monday; with different local knowledge values every other Thursday.

An operative can only ever be assigned to one work pattern.

Table Definition

Field	Type	Default	Nullable
employee_no	number(9)
sync_date	date
period	number(3)

Keys

primary key (employee_no)
foreign key (employee_no) references sp210_employees(employee_no)

Primary Key Referenced From

sp123_work_pattern_days

Column Descriptions

Field	Description
employee_no	The employee whose work pattern this is.
sync_date	Date used to synchronise a multi-week work pattern with the operative. Employee Time zone
period	The number of days after which the work pattern is to be repeated. Must be a multiple of 7, with minimum allowed value of 7. Thus the work pattern defines a cycle of at least 1 week.