sp116_break_specifications

This defines a break pattern of up to 5 breaks that may be assigned to a shift.

Table Definition

Field	Type	Default	Nullable
break_spec_id	number(9)
break_num	number(4)
break_start	number(4)
break_end	number(4)
break_duration	number(4)
break_name	varchar(20)
field_id	varchar2(100)

unique (break_spec_id,break_name) unique (break_spec_id,break_num)

foreign key (field_id) references sp900_language_translation (field_id)

Field	Description
break_spec_id	Identifier for this specification (references SP115 & SP128)
break_num	reserved (default 1)
break_start	a number of minutes from midnight representing the earliest start time for the break (using the operative's timezone)
break_end	a number of minutes from midnight representing the latest start time for the break (using the operative's timezone)
break_duration	The break duration ( in minutes)
break_name	Name of the break
field_id	key to language translations for break_name