14.1 sp107_holidays

This table contains details of the dates and names of public holidays for each named set of holidays.

Table Definition

Field	Type	Default	Nullable
holiday_spec	number(4)
holiday_date	date
description	varchar2(30)
field_id	varchar2(100)

Keys

primary key (holiday_spec, holiday_date)
foreign key (holiday_spec) references sp106_holiday_specifications (holiday_spec)
foreign key (field_id) references sp900_language_translation (field_id)

Column Descriptions

Field	Description
holiday_spec	The identifier of the holiday specification which is to include this holiday.
holiday_date	The date on which the holiday will fall. Uses employee's Time Zone.
description	Depreciated - A description of the public holiday.
field_id	Key to language translations for description.