14.1 sp122_work_patterns
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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 14.1 sp210_employees(employee_no)
Primary Key Referenced From
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. |