HOLIDAY
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
Technical Data
| Schema Version | 4.6.2 | |
| Tablespace | 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 | ||||
| MONTH |
|
The month when the holiday occurs | ||||
| DAY |
|
The day when the holiday occurs in the month | ||||
| DAYS |
|
The list of the days when the holiday occurs | ||||
| WEEKDAY |
|
The day in the week when the holiday occurs | ||||
| POSITION |
|
The position of the weekday in the month | ||||
| INCR |
|
The number of the days between the holiday and Easter | ||||
| COUNTRIES |
|
The csv list of the countries where the holiday occurs | ||||
| DESCRIPTIONS |
|
The CSV list of the descriptions of the holiday |
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 | VARCHAR2(256 CHAR), NOT NULL |
TYPE
| Definition | The type of holiday |
| Format |
The possible values are:
|
| 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 | VARCHAR2(2000 CHAR), 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:
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 | VARCHAR2(2000 CHAR), 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 | VARCHAR2(2000 CHAR), NULL |