8.2.2 Loading Non-business Days
After obtaining non-business days (or weekly off-days; typically Saturday and Sunday) from an Oracle client, load this information for the upcoming calendar year into the KDD_CAL_WKLY_OFF table.
The following snippet provides an example of a SQL script for loading the table.
INSERT INTO KDD_CAL_WKLY_OFFS (CLNDR_NM, DAY_OF_WK) VALUES ('SYSCAL',1);
INSERT INTO KDD_CAL_WKLY_OFFS (CLNDR_NM, DAY_OF_WK) VALUES (By default, the system identifies Saturdays and Sundays as non-business days in the system calendar (SYSCAL).
The following table provides the contents of the KDD_CAL_WKLY_OFF table.
Table 8-1 KDD_CAL_WKLY_OFF Table Contents
| Column Name | Description |
|---|---|
| CLNDR_NM | Specific calendar name. |
| DAY_OF_WK | Value that represents the day of the week: Sunday=1, Monday=2, Tuesday=3 ... Saturday=7. |
If the table does not contain records for any calendar in the list, the system logs a Warning message that the specific calendar contains no weekly off-days.