This table contains the names of all of the holiday specifications which have been defined by the system administrator.

The system administrator is able to define a number of holiday specifications: each specification consists of a set of public holidays. Once the specifications have been defined, other users may specify which set of holidays is to be taken by each employee, so that employees in Scotland, for example, can be assigned different public holidays from those in England.

Table Definition

Field	Type	Default	Nullable
holiday_spec	number(4)
spec_name	varchar2(30)
field_id	varchar2(100)

Keys

primary key (holiday_spec)
foreign key (field_id) references sp900_language_translation (field_id)

Primary Key Referenced From

sp203_holiday_assignments

Column Descriptions

Field	Description
holiday_spec	ServiceOptimizer-generated unique identifier
spec_name	The name of the specification
field_id	key to language translations for spec_name

Browser not supported