DW_EB_X_EBS_COMMON_W_WEEK_D
This is a dimension table that stores information about every calendar week that exists in the base time dimension table DW_EB_X_EBS_COMMON_W_DAY_D. One row is stored in this table for each week. This table gets loaded from DW_EB_X_EBS_COMMON_W_DAY_D.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Week Dimension
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 | True | Surrogate key to uniquely identify a record. This key is frmed in YYYYWK format for example YYYYWK | |||
| CAL_WEEK | NUMBER | 2 | Identifies which Calendar Week this day belongs to like 1,2..53. | |||
| CAL_WEEK_END_DT | TIMESTAMP | 6 | Identifies the Last Date of the Calendar Week. | |||
| CAL_WEEK_END_DT_KEY | NUMBER | 10 | Identifies the Last Date of the Calendar Week in Julian. | |||
| CAL_WEEK_END_DT_WID | NUMBER | 38 | Identifies the Last Day(in YYYYMMDD) of the week this day belongs to. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CAL_WEEK_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the Calndar Week. | |||
| CAL_WEEK_START_DT_KEY | NUMBER | 10 | Identifies the Start Date of the Calndar Week in Julian. | |||
| CAL_WEEK_START_DT_WID | NUMBER | 38 | Identifies the First Day(in YYYYMMDD) of the week this day belongs to. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CAL_YEAR | NUMBER | 4 | Identifies Calendar Year in YYYY format. | |||
| CAL_YEAR_END_DT | TIMESTAMP | 6 | Identifies the Last Date of the Calendar Year. | |||
| CAL_YEAR_END_DT_WID | NUMBER | 38 | Identifies the Last Day(in YYYYMMDD) of the Year this day belongs to. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CAL_YEAR_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the Calendar Year. | |||
| CAL_YEAR_START_DT_WID | NUMBER | 38 | Identifies the First Day(in YYYYMMDD) of the Year this day belongs to. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| FST_WEEK_CAL_YEAR_FLG | VARCHAR2 | 1 CHAR | This Flag indicates whether this Week is the First Week of the Calendar Year. | |||
| JULIAN_WEEK_NUM | NUMBER | 10 | Identifies the Julian Week Number this day belongs to. | |||
| JULIAN_YEAR_NUM | NUMBER | 10 | Identifies the Julian Year This day belongs to. | |||
| LAST_WEEK_CAL_YEAR_FLG | VARCHAR2 | 1 CHAR | This Flag indicates whether this Week is the Last Week of the Calendar Year. | |||
| WEEK_KEY | NUMBER | 10 | Week Key(Obsolete) | |||
| W_CURRENT_CAL_WEEK_CODE | VARCHAR2 | 50 CHAR | This is the code that indicates whether it is Current or Next or Previous week with reference to current week. This code gets updated everyday and the default value is '__NOT_APPLICABLE__'. | |||
| W_CURRENT_CAL_YEAR_CODE | VARCHAR2 | 50 CHAR | This is the code that indicates whether it is Current or Next or Previous year with reference to current year. This code gets updated everyday and the default value is '__NOT_APPLICABLE__'. | |||
| 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 |