DW_EB_X_EBS_PROJECTS_W_HOLIDAY_DAY_D
This is the dimension table for holiday calendar enumerated across days.
Details
Module: Projects (EBS_PROJECTS)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | |||
| BUSINESS_DAY_NUM | NUMBER | 10 | A non decreasing column with delta max a 1 between adjacent tuples. Column increase by 1 for eachr new business day. For every holiday it remains the same | |||
| BUSINESS_DURATION | NUMBER | 10 | If the duration data exists for a business day , then it would be populated here. | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | ||||
| DAY_DT | TIMESTAMP | 6 | Gregorian day unique within each calendar. | |||
| DAY_DT_WID | NUMBER | 38 | ||||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| HOLIDAY_CAL_WID | NUMBER | 38 | CALENDAR WID , row wid to uniquely identify a holiday calendar | |||
| HOLIDAY_FLG | VARCHAR2 | 1 CHAR | The flag column which specifies whether the day is business day or holiday. Currently B for business day, H for holiday or exceptions and W for weekends. | |||
| HOLIDAY_WEEKEND_CODE | VARCHAR2 | 30 CHAR | H' for holiday and 'W' for weekend or non holiday day off. | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |