DW_EB_X_EBS_COMMON_W_YEAR_D
This is a dimension table that stores information about every calendar year 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 year. This table gets loaded from DW_EB_X_EBS_COMMON_W_DAY_D.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Year 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 | 10 | True | This uniquely identifies a calendar year record in this table. The ROW_WID is generated as year in YYYY format. | ||
| CAL_YEAR | NUMBER | 4 | Identifies the Calendar Year in YYYY format. | |||
| CAL_YEAR_END_DT | TIMESTAMP | 6 | Identifies the Last Date of the Calendar Year. | |||
| CAL_YEAR_END_DT_KEY | NUMBER | 10 | Identifies the Last Date of the Year in Julian. | |||
| 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_KEY | NUMBER | 10 | Identifies the Start Date of the Year in Julian. | |||
| CAL_YEAR_START_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 | ||
| JULIAN_YEAR_NUM | NUMBER | 10 | Identifies the Julian Year This day belongs to. | |||
| PER_NAME_YEAR | VARCHAR2 | 200 CHAR | Identifies the Calendar Year Period Name for example "1979". | |||
| 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. | |||
| YEAR_AGO_WID | NUMBER | 10 | Identifies the Date in YYYYMMDD format of the same day in the previous year. | |||
| YEAR_KEY | NUMBER | 10 | Year Key(Obsolete) | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |