HOLIDAY

Public Holidays (in Business and Custom Data)

Definition

The HOLIDAY table contains the public holidays used during the charging and refilling operations

Description

The HOLIDAY table contains the holidays used by the SAP CC Core Server system when executing the pricing logic during the charging or refilling operations. You use this list when configuring some charges or refill logic objects in SAP CC.

Notes

This business data is defined in the complete SAP CC system. It is not restricted to a pricing catalog. It is shared by all the service providers.
To customize or maintain the holidays, see the Core Tool Primary Help.

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The HOLIDAY table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	FK	IX	Uses	Used by	Definition
CODE						The identification code of the holiday
TYPE						The type of holiday More...
MONTH						The month when the holiday occurs More...
DAY						The day when the holiday occurs in the month More...
DAYS						The list of the days when the holiday occurs More...
WEEKDAY						The day in the week when the holiday occurs More...
POSITION						The position of the weekday in the month More...
INCR						The number of the days between the holiday and Easter More...
COUNTRIES						The csv list of the countries where the holiday occurs More...
DESCRIPTIONS						The CSV list of the descriptions of the holiday More...

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

CODE

Definition	The identification code of the holiday
Type	NVARCHAR(256), NOT NULL

TYPE

Definition The type of holiday

Format

The 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 day relative to Easter
3: a list of days

Type DECIMAL(1), NULL

MONTH

Definition	The month when the holiday occurs
Description	The month when the holiday occurs. This field is only used if the holiday type (see TYPE) is a fixed day or a day relative to Easter.
Format	The possible numerical values are in the range from `1` (January) to `12` (December).
Type	DECIMAL(2), NULL

DAY

Definition	The day when the holiday occurs in the month
Description	The day when the holiday occurs in the month. This field is only used if the holiday type (see TYPE) is a fixed day.
Type	DECIMAL(2), NULL

DAYS

Definition	The list of the days when the holiday occurs
Description	The list of the days when the holiday occurs. This field is only used if the holiday type (see TYPE) is a list of days.
Format	Use the ISO 8601 format for the dates (YYYY-MM-DD) and separate them with commas.
Type	NVARCHAR(2000), NULL

WEEKDAY

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

POSITION

Definition	The position of the weekday in the month
Description	The position of the weekday in the month. This field is only used if the TYPE is relative.
Format	The 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 defining the fourth thursday of November for example.
Type	DECIMAL(1), NULL

INCR

Definition

The number of the days between the holiday and Easter

Description

The number of the days between the holiday and Easter. This field is only used if the TYPE is Easter relative.

Type

DECIMAL(3), NULL

COUNTRIES

Definition

The csv list of the countries where the holiday occurs

Description

The csv list of the countries where the holiday occurs. The countries are identified by their ISO 3166 code. See also the CODE field of the HOLIDAYS_GROUP_DESCRIPTION table.

Type

NVARCHAR(2000), NULL

DESCRIPTIONS

Definition

The CSV list of the descriptions of the holiday

Description

The CSV list of the descriptions of the holiday. Each element in the list is a pair language/label.

Type

NVARCHAR(2000), NULL