Document toolboxDocument toolbox

sp106_holiday_specifications

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_specnumber(4)  (error)
spec_namevarchar2(30)  (error)
field_idvarchar2(100)  (error)

Keys 

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

Primary Key Referenced From

 

Column Descriptions

FieldDescription
holiday_specServiceOptimizer-generated unique identifier
spec_nameThe name of the specification
field_idkey to language translations for spec_name