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_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
Â
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 |