sp114_shift_specifications

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)

primary key (shift_spec)
unique (spec_name)
foreign key (field_id) references sp900_language_translation (field_id)

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