This table contains details of each of the working shift periods for each working day. Each record in the table represents one working shift period; for a typical shift pattern involving employees working Monday to Friday, there will be five records in this table, one for each day of the week.

The shift can specify a "night shift", or similar. This is achieved by specifying that the shift period starts before "0000", or alternatively by specifying that the shift period ends after "2400". A shift period must be within the bounds of its working day and must not be longer than 24 hours.

The shift may include a number of breaks. If specified, they must be within the bounds of the shift. If breaks are not defined, then break_spec_id will be null.

Table Definition

Field	Type	Nullable
shift_spec	number(4)
day_number	number(3)
start_time	number(4)
end_time	number(4)
~~lunch_start~~	~~number(4)~~	(deprecated)
~~lunch_end~~	~~number(4)~~	(deprecated)
~~lunch_duration~~	~~number(4)~~	(deprecated)
capacity_shift	number(1)
ADJ_shift	number(1)
break_spec_id	number(4)

Keys

primary key (shift_spec, day_number)
foreign key (shift_spec) references sp114_shift_specifications (shift_spec)

Column Descriptions

Field	Description
shift_spec	Shift pattern identifier
day_number	Day number within the shift pattern (0 to 370) to which this shift applies. The number must be less than the period specified for the shift in sp114_shift_specifications. Day 0 is a Sunday, as are days 7, 14 and 21 etc.; days 1, 8, 15 and 22 etc. are Mondays; etc. (Note that this differs from the usual convention of numbering days from 1, Sunday, to 7, Saturday.).
start_time	The time of day at which the shift period starts. Uses employee's Time Zone. This is expressed as a number of minutes offset from "0000" and must be in the range –1380 to +1380.
end_time	The time of day at which the shift period ends. Uses employee's Time Zone. This is expressed as a number of minutes offset from "0000" and must be in the range +60 to +2820.
capacity_shift	A flag indicating whether this shift provides capacity that jobs on the shift then consume. A value of 1 indicates that the shift provides capacity A value of 0 indicates that the shift does not provide capacity A value of NULL causes the shift pattern's capacity_shift flag to be used instead.
ADJ_shift	A flag indicating whether All Day Jobs can be automatically allocated to this shift. A value of 1 indicates that All Day jobs can be automatically allocated to this shift. A value of 0 indicates that All Day jobs cannot be automatically allocated this shift. A value of NULL causes the shift pattern's ADJ_shift flag to be used instead.
break_spec_id	The associated break pattern to be used for this shift specification

Browser not supported