DW_NS_workCalendarHoliday_D
This table contains list of holidays for each work calendar.
Details
Module:
Key Columns
exceptiondate, workcalendar
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| workcalendar | NUMBER | 38 | 0 | True | workcalendar id | DW_NS_workCalendar_D | id |
| exceptiondate | TIMESTAMP | True | Holiday date | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| description | VARCHAR2 | 128 | Friday |