DW_EB_X_EBS_COMMON_W_ENT_QTR_D
Dimension table for storing Enterprise quarters
Details
Module: Common Tables (EBS_COMMON)
Business Name: Enterprise 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 Enterprise Quarter record. This key is formed by appending Enterprise Quarter to Enterprise Year. | ||
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Oracle recommends that you define separate unique source IDs for each of your different source instances. | |||
| ENT_CAL_CLASS | VARCHAR2 | 20 CHAR | Identifies the category of calendar. Valid values are 'Generated', ''File Sourced','OLTP Sourced' | |||
| ENT_CAL_ID | VARCHAR2 | 80 CHAR | Identifies the accounting calendar. | |||
| ENT_CAL_NAME | VARCHAR2 | 30 CHAR | Identifies the name of the accounting calendar | |||
| ENT_CAL_WID | NUMBER | 38 | ID assigned within the warehouse to uniquely identify a calendar. | |||
| ENT_DIM_QTR_NUM | NUMBER | 10 | Identifies the Cumulative quarter number for the years in the table. | |||
| ENT_DIM_YEAR_NUM | NUMBER | 10 | Identifies the Cumulative year number for the years in the table. | |||
| ENT_FST_QTR_FR_KEY | NUMBER | 10 | Identifies the julian date of the first day of the First Enterprise Quarter of the same Enterprise year,this Enterprise quarter belongs to. | |||
| ENT_FST_QTR_TO_KEY | NUMBER | 10 | Identifies the julian date of the last day of the First Enterprise Quarter of the same Enterprise year, this Enterprise quarter belongs to. | |||
| ENT_HALF | NUMBER | 2 | Identifies the Enterprise half this Enterprise quarter belongs to like 1 or 2. | |||
| ENT_PERIOD_TYPE | VARCHAR2 | 50 CHAR | Identifies the accounting period type. | |||
| ENT_PER_NAME_HALF | VARCHAR2 | 50 CHAR | Identifies the Enterprise Half Period Name. | |||
| ENT_PER_NAME_QTR | VARCHAR2 | 50 CHAR | Identifies the Enterprise Quarter Period Name. | |||
| ENT_PER_NAME_YEAR | VARCHAR2 | 50 CHAR | Identifies the Enterprise Year Period Name. | |||
| ENT_PRIOR_QTR_WID | NUMBER | 38 | Surrogate key of prior quarter | |||
| ENT_PRIOR_YEAR_WID | NUMBER | 38 | Surrogate key of prior year | |||
| ENT_QTR | NUMBER | 2 | Identifies which Enterprise Quarter this quarter belongs to like 1,2..4. | |||
| ENT_QTR_AGO_WID | NUMBER | 38 | The ROW_WID of the same quarter in the previous year, e.g. the Q1 2007 prior period is Q1 2006. | |||
| ENT_QTR_END_DAY_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the end day of Enterprise Quarter. | |||
| ENT_QTR_END_DT | TIMESTAMP | 6 | Identifies the Enterprise Quarter End Date. | |||
| ENT_QTR_END_DT_KEY | NUMBER | 10 | Identifies the Julian date of the last day of Enterprise Quarter. | |||
| ENT_QTR_END_DT_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the last day of Enterprise Quarter. | |||
| ENT_QTR_KEY | NUMBER | 10 | ?? | |||
| ENT_QTR_LAST_DAY_OF_YEAR | NUMBER | 10 | Identifies which day of year the last day of this Enterprise quarter is. | |||
| ENT_QTR_START_DAY_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the start day of Enterprise Quarter. | |||
| ENT_QTR_START_DT | TIMESTAMP | 6 | Identifies the Julian date of the first day of Enterprise Quarter. | |||
| ENT_QTR_START_DT_KEY | NUMBER | 10 | Identifies the Julian date of the first day of Enterprise Quarter. | |||
| ENT_QTR_START_DT_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the first day of Enterprise Quarter. | |||
| ENT_YEAR | NUMBER | 4 | Identifies the Enterprise Year in YYYY format. | |||
| ENT_YEAR_END_DAY_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the year end day. | |||
| ENT_YEAR_END_DT | TIMESTAMP | 6 | Identifies the Date of last day of the Enterprise Year. | |||
| ENT_YEAR_END_DT_WID | NUMBER | 38 | Identifies the Date surrogate key of last day of the Enterprise Year. | |||
| ENT_YEAR_START_DAY_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the year start day. | |||
| ENT_YEAR_START_DT | TIMESTAMP | 6 | Identifies the Date of first day of the Enterprise Year. | |||
| ENT_YEAR_START_DT_WID | NUMBER | 38 | Identifies the Date surrogate key of first day of the Enterprise Year. | |||
| ENT_YEAR_START_QTR_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the year start day of enterprise Quarter. | |||
| ENT_YEAR_TOTAL_DAYS | NUMBER | 10 | Total number of days in this Enterprise year. | |||
| ENT_YEAR_TOTAL_WEEKS | NUMBER | 10 | Total number of weeks in this Enterprise year | |||
| ENT_YEAR_WID | NUMBER | 38 | Surrogate key to DW_EB_X_EBS_COMMON_W_ENT_YEAR_D | |||
| FST_QTR_ENT_YEAR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this quarter is the first quarter of the enterprise year. | |||
| LAST_QTR_ENT_YEAR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this quarter is the last quarter of the Enterprise year. | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multitenant environment.This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS). | |||
| W_CURRENT_ENT_QTR_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous quarter depending on whether the quarter is previos,current or next quarter with respect to the current week. Default value is '__NOT_APPLICABLE__'. | |||
| W_CURRENT_ENT_YEAR_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous year depending on whether the year is previos, current or next quarter with respect to the current week.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 |