14.1 sp106_holiday_specifications
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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 |