DW_EB_X_EBS_COMMON_W_QTR_D
This is a dimension table that stores information about every calendar quarter 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 quarter. This table gets loaded from DW_EB_X_EBS_COMMON_W_DAY_D.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Quarter 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 YYYYQt format for example 200501 where 01 si teh quarter and 2005 is the year. | ||
| CAL_HALF | NUMBER | 2 | Identifies which Calendar Half-Year this day belongs to like 1 or 2. | |||
| 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_KEY | NUMBER | 10 | Identifies the Last Date of the Quarter in Julian. | |||
| CAL_QTR_START_DT | TIMESTAMP | 6 | Identifies the Start date of the Quarter in calendar year. | |||
| CAL_QTR_START_DT_KEY | NUMBER | 10 | Identifies the Start Date of the Quarter in Julian. | |||
| 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_STRT_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_QTR_YEAR_FLG | VARCHAR2 | 1 CHAR | This Flag indicates whether this Quarter is the First Quarter 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_QTR_NUM | NUMBER | 10 | Identifies the Julian Quarter Number this day belongs to. | |||
| JULIAN_YEAR_NUM | NUMBER | 10 | Identifies the Julian Year This day belongs to. | |||
| LAST_QTR_YEAR_FLG | VARCHAR2 | 1 CHAR | This Flag indicates whether this Quarter is the Last Quarter of the Calendar Year. | |||
| PER_NAME_HALF | VARCHAR2 | 50 CHAR | Identifies Calendar half Year Period Name for example "1979 Half2". | |||
| PER_NAME_QTR | VARCHAR2 | 50 CHAR | Identifies the Calendar Quarter Period Name for example "1979 Q 4". | |||
| 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 | ||
| QUARTER_KEY | NUMBER | 10 | Quarter Key(Obsolete) | |||
| Q_END_CAL_DT_WID | NUMBER | 38 | Identifies the Last Day (in YYYYMMDD format) of the Quarter in Calendar year. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| Q_STRT_CAL_DT_WID | NUMBER | 38 | Identifies the First Day (in YYYYMMDD format) of the Quarter in Calendar year. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| 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__'. | |||
| 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 |