14.1 sp114_shift_specifications
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
This table contains the names of all of the shift patterns which have been defined by the system administrator.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| shift_spec | number(4) |  | |
| spec_name | varchar2(30) | | |
| period | number(3) | | |
| capacity_shift | number(1) |  | |
| ADJ_shift | number(1) | | |
| field_id | varchar2(100) | |
Keys
primary key (shift_spec)
unique (spec_name)
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| shift_spec | ServiceOptimizer-generated unique identifier |
| spec_name | The name of the pattern - this text is used in pop up lists in the forms application and in the "Display time" menu on the Gantt display. |
| period | The number of days after which the shift pattern is to be repeated - a multiple of 7, up to 371. Thus the shift pattern defines a cycle of between 1 and 53 weeks (inclusive). |
| capacity_shift | A flag indicating whether shifts in this shift pattern provide capacity that jobs on the shifts then consume. Can be overridden by a specific shift period. A value of 1 or NULL indicates that the shifts provides capacity (by default) A value of 0 indicates that the shifts do not provide capacity (by default) |
| ADJ_shift | A flag indicating whether All Day jobs can be automatically allocated to the shifts in this shift pattern. Can be overridden by a specific shift period. A value of 1 or NULL indicates that All Day jobs can be automatically allocated to shifts in this shift pattern (by default) A value of 0 indicates that All Day jobs cannot be automatically allocated to shifts in this shift pattern (by default) field_idkey to language translations (in sp900) for spec_name |