This table contains the names of all of the shift patterns which have been defined by the system administrator.

Table Definition

Keys

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