HOLIDAY

Table: HOLIDAY

Table Name

HOLIDAY

Table Description

The HOLIDAY table contains the holidays used by the rating. To customize the holidays, see the Desktop Tool Online Help .

Tablespace

CATALOG_DATA

Database

Columns

The HOLIDAY database table is defined by the following columns.

Value Type	VARCHAR(256), NOT NULL
Column Description	The code of the holiday.

Value Type	DECIMAL(1)
Column Description	The type of holiday. Possible values are: 0: a fixed day. Example: New Year's day, January the 1st 1: a relative day. Example: Thanksgiving, the fourth thursday of November 2: a Easter relative day 3: an enumeration of days

Value Type	DECIMAL(2)
Column Description	The month when the holiday occurs. This field is only used if the TYPE is fixed or relative. Values range from 1 (January) to 12 (December).

Value Type	DECIMAL(2)
Column Description	The day when the holiday occurs in the month. This field is only used if the TYPE is fixed.

Value Type	VARCHAR(2000)
Column Description	The list of the days when the holiday occurs. This field is only used if the TYPE is enumeration. Use the ISO 8601 format for the dates (YYYY-MM-DD) and separate them with commas.

Value Type	DECIMAL(1)
Column Description	The day in the week when the holiday occurs. This field is only used if the TYPE is relative. Values range from 1 (sunday) to 7 (saturday).

Value Type	DECIMAL(1)
Column Description	The position of the weekday in the month. This field is only used if the TYPE is relative. Possible values are: 0: the last 1: the first 2: the second 3: the third 4: the fourth 5: the fifth Note: Combined with the WEEKDAY and the MONTH fields, the POSITION field enables to define the fourth thursday of november for example.

Value Type

DECIMAL(1)

Column Description

The position of the weekday in the month. This field is only used if the TYPE is relative.

Possible values are:

Note: Combined with the WEEKDAY and the MONTH fields, the POSITION field enables to define the fourth thursday of november for example.

Value Type	DECIMAL(3)
Column Description	The number of the days between the holiday and Easter. This field is only used if the TYPE is Easter relative.

Value Type	VARCHAR(2000)
Column Description	The csv list of the countries where the holiday occurs. The coutries are identified by their ISO 3166 code. See also the CODE field of the HOLIDAYS_GROUP_DESCRIPTION table.

Value Type	VARCHAR(2000)
Column Description	The csv list of the descriptions of the holiday. Each element in the list is a pair language/label.

Document Version: SP04 and later