DW_EB_X_EBS_COMMON_W_MONTH_D
This is a dimension table that stores information about every calendar month that exists in the base time dimension table DW_EB_X_EBS_COMMON_W_DAY_D. One row is stored in this table for every year-month. This table gets loaded from DW_EB_X_EBS_COMMON_W_DAY_D.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Month 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 | 38 | True | Surrogate key to uniquely identify a record. This key is formed in YYYYMM format for example 200512. | ||
| CAL_HALF | NUMBER | 2 | Identifies which Calendar Half-Year this day belongs to like 1 or 2. | |||
| CAL_MONTH | NUMBER | 2 | Identifies the Calendar Month in MM format. | |||
| CAL_MONTH_END_DT | TIMESTAMP | 6 | Identifies the last Date of the Calendar month. | |||
| CAL_MONTH_END_DT_KEY | NUMBER | 10 | Identifies the last Date of the month in Julian. | |||
| CAL_MONTH_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the Calendar month. | |||
| CAL_MONTH_START_DT_KEY | NUMBER | 10 | Identifies the Start Date of the month in Julian. | |||
| CAL_QTR | NUMBER | 1 | Identifies which Calendar Quarter this day belongs to like 1,2..4. | |||
| CAL_QTR_END_DT | TIMESTAMP | 6 | Identifies the Last Date of the Quarter in Calendar Year. | |||
| CAL_QTR_END_DT_WID | NUMBER | 38 | Identifies the Last Day(in YYYYMMDD) of the Quarter this day belongs to. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CAL_QTR_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the Quarter in Calendar Year. | |||
| CAL_QTR_START_DT_WID | NUMBER | 38 | Identifies the First Day(in YYYYMMDD) of the Quarter this day belongs to. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| CAL_TRIMESTER | NUMBER | 10 | Identifies which Calendar Trimester. this day belongs to like 1,2 or 3. | |||
| 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_MONTH_CAL_QTR_FLG | VARCHAR2 | 1 CHAR | This Flag indicates whether this month is First month of the Calendar Quarter. | |||
| FST_MONTH_CAL_YEAR_FLG | VARCHAR2 | 1 CHAR | This Flag indicates whether this month is First month of the Calendar Year. | |||
| HALF_AGO_WID | NUMBER | 10 | Identifies the date in YYYYMMDD format of the day half-a year ago. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| JULIAN_MONTH_NUM | NUMBER | 10 | Identifies the Julian Month Number this day belongs to. | |||
| JULIAN_QTR_NUM | NUMBER | 10 | Identifies the Julian Quarter Number this day belongs to. | |||
| JULIAN_TER_NUM | NUMBER | 10 | Identifies the Julian Trimester Number this day belongs to. | |||
| JULIAN_YEAR_NUM | NUMBER | 10 | Identifies the Julian Year This day belongs to. | |||
| LAST_MONTH_CAL_QTR_FLG | VARCHAR2 | 1 CHAR | This Flag indicates whether this month is Last month of the Calendar Quarter. | |||
| LAST_MONTH_CAL_YEAR_FLG | VARCHAR2 | 1 CHAR | This Flag indicates whether this month is First month of the Calendar Year. | |||
| MONTH_AGO_WID | NUMBER | 10 | Identifies the Date in YYYMMDD format of the day one Month Ago. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| MONTH_KEY | NUMBER | 10 | Month Key(Obsolete) | |||
| M_END_CAL_DT_WID | NUMBER | 38 | Identifies the Last Day(in YYYYMMDD) of the month this day belongs to. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| M_STRT_CAL_DT_WID | NUMBER | 38 | Identifies the First Day(in YYYYMMDD) of the month this day belongs to. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PER_NAME_HALF | VARCHAR2 | 50 CHAR | Identifies Calendar half Year Period Name for example "1979 Half2". | |||
| PER_NAME_MONTH | VARCHAR2 | 50 CHAR | Identifies the Calendar Month Period Name for example "1979 / 12" . | |||
| PER_NAME_QTR | VARCHAR2 | 50 CHAR | Identifies the Calendar Quarter Period Name for example "1979 Q 4". | |||
| PER_NAME_TER | VARCHAR2 | 50 CHAR | Identifies the Calendar Trimester Period Name for example "1979T3". | |||
| PER_NAME_YEAR | VARCHAR2 | 50 CHAR | Identifies the Calendar Year Period Name for example "1979". | |||
| QUARTER_AGO_WID | NUMBER | 10 | Identifies the Date in YYYYMMDD format of the day one quarter ago( same day three months before). | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| TRIMESTER_AGO_WID | NUMBER | 10 | Identifies the Date in YYYYMMDD format of the day one trimester ago( same day four months before). | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| W_CURRENT_CAL_MONTH_CODE | VARCHAR2 | 50 CHAR | This is the code that indicates whether it is Current or Next or Previous month with reference to current month. This code gets updated everyday and the default value is '__NOT_APPLICABLE__'. | |||
| W_CURRENT_CAL_QTR_CODE | VARCHAR2 | 50 CHAR | This is the code that indicates whether it is Current or Next or Previous quarter with reference to current quarter. 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__'. | |||
| W_MONTH_CODE | VARCHAR2 | 50 CHAR | Identifies the name of the Month this day belongs to for example January, February. | |||
| 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. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |