DW_EB_X_EBS_COMMON_W_MCAL_QTR_D
Has fiscal quarters aggreegated from fiscal periods
Details
Module: Common Tables (EBS_COMMON)
Business Name: Fiscal Quarter Dimension Table
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| MCAL_QTR | NUMBER | 2 | Identifies which Fiscal Quarter this quarter belongs to like 1,2..4 | |||
| MCAL_YEAR | NUMBER | 4 | Identifies the Fiscal Year in YYYY format | |||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a Fiscal Quarter record. This key is formed by ppending Fiscal Quarter to Fiscal Year | |||
| BUDGETARY_CALENDAR_FLG | VARCHAR2 | 1 CHAR | ||||
| 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 | |||
| FISCAL_CALENDAR_FLG | VARCHAR2 | 1 CHAR | ||||
| FST_QTR_MCAL_YEAR_FLG | VARCHAR2 | 1 CHAR | Indicates whether the Quarter is the First Quarter of the Fiscal Year | |||
| LAST_QTR_MCAL_YEAR_FLG | VARCHAR2 | 1 CHAR | Indicates whether the Quarter is the Last Quarter of the Fiscal Year | |||
| MCAL_CAL_CLASS | VARCHAR2 | 20 CHAR | Identifies the category of calendar. Valid values are 'Generated', ''File Sourced','OLTP Sourced' | |||
| MCAL_CAL_ID | VARCHAR2 | 80 CHAR | Identifies the accounting calendar | |||
| MCAL_CAL_NAME | VARCHAR2 | 30 CHAR | Identifies the name of the accounting calendar | |||
| MCAL_CAL_WID | NUMBER | 38 | ID assigned within the warehouse to uniquely identify a calendar | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| MCAL_DIM_QTR_NUM | NUMBER | 10 | Identifies the Cumulative quarter number for the years in the table | |||
| MCAL_DIM_YEAR_NUM | NUMBER | 10 | Identifies the Cumulative year number for the years in the table | |||
| MCAL_FST_QTR_FR_KEY | NUMBER | 10 | Identifies the julian date of the first day of the First Fiscal Quarter of the same fiscal year, this fiscal quarter belongs to | |||
| MCAL_FST_QTR_TO_KEY | NUMBER | 10 | Identifies the julian date of the last day of the First Fiscal Quarter of the same fiscal year, this fiscal quarter belongs to | |||
| MCAL_HALF | NUMBER | 2 | Identifies the Fiscal Half this fiscal quarter belongs to like 1 or 2. | |||
| MCAL_PERIOD_TYPE | VARCHAR2 | 50 CHAR | Identifies the accounting period type | |||
| MCAL_PER_NAME_HALF | VARCHAR2 | 50 CHAR | Identifies the Fiscal Half Period Name | |||
| MCAL_PER_NAME_QTR | VARCHAR2 | 50 CHAR | Identifies the Fiscal Quarter Period Name | |||
| MCAL_PER_NAME_YEAR | VARCHAR2 | 50 CHAR | Identifies the Fiscal Year Period Name | |||
| MCAL_PRIOR_QTR_WID | NUMBER | 38 | The ROW_WID of the previous fiscal quarter | DW_EB_X_EBS_COMMON_W_MCAL_QTR_D | ||
| MCAL_PRIOR_YEAR_WID | NUMBER | 38 | The ROW_WID of the previous fiscal year | DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D | ||
| MCAL_QTR_AGO_WID | NUMBER | 38 | Thw ROW_WID of the same quarter in the previous year, e.g. the Q1 2007 prior period is Q1 2006 | |||
| MCAL_QTR_END_DAY_WID | NUMBER | 38 | This is the MCAL_QTR_END_DT formatted in the same format as the ROW_WID of a regular period in DW_EB_X_EBS_COMMON_W_MCAL_QTR_D. This is used by Project Analytics to calculate ITD measures. | |||
| MCAL_QTR_END_DT | TIMESTAMP | 6 | Identifies the Fiscal Quarter End Date | |||
| MCAL_QTR_END_DT_KEY | NUMBER | 10 | Identifies the Julian date of the last day of Fiscal Quarter. | |||
| MCAL_QTR_END_DT_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the last day of Fiscal Quarter. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| MCAL_QTR_KEY | NUMBER | 10 | Fiscal Quarter Key | |||
| MCAL_QTR_LAST_DAY_OF_YEAR | NUMBER | 10 | Identifies which day of year the last day of this fiscal quarter is | |||
| MCAL_QTR_START_DAY_WID | NUMBER | 38 | This is the MCAL_QTR_START_DT formatted in the same format as the ROW_WID of a regular period in DW_EB_X_EBS_COMMON_W_MCAL_QTR_D. This is used by Project Analytics to calculate ITD measures. | |||
| MCAL_QTR_START_DT | TIMESTAMP | 6 | Identifies the date of first day of fiscal quarter | |||
| MCAL_QTR_START_DT_KEY | NUMBER | 10 | Identifies the Julian date of the first day of Fiscal Quarter | |||
| MCAL_QTR_START_DT_WID | NUMBER | 38 | surrogate key (date in YYYYMMDD) of the first day of Fiscal Quarter | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| MCAL_YEAR_END_DAY_WID | NUMBER | 38 | This is the MCAL_YEAR_END_DT formatted in the same format as the ROW_WID of a regular period in DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D. This is used by Project Analytics to calculate ITD measures. | |||
| MCAL_YEAR_END_DT | TIMESTAMP | 6 | "Identifies the End Date of the Fiscal Year." | |||
| MCAL_YEAR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the Fiscal Year | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| MCAL_YEAR_START_DAY_WID | NUMBER | 38 | This is the MCAL_YEAR_START_DT formatted in the same format as the ROW_WID of a regular period in DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D. This is used by Project Analytics to calculate ITD measures. | |||
| MCAL_YEAR_START_DT | TIMESTAMP | 6 | Identifies the Date of first day of the Fiscal Year | |||
| MCAL_YEAR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the Fiscal Year | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| MCAL_YEAR_START_QTR_WID | NUMBER | 38 | This is the ROW_WID of the first quarter in the year. | |||
| MCAL_YEAR_TOTAL_DAYS | NUMBER | 10 | Total number of days in this fiscal year | |||
| MCAL_YEAR_TOTAL_WEEKS | NUMBER | 10 | Total number of weeks in this fiscal year | |||
| MCAL_YEAR_WID | NUMBER | 38 | Surrogate key to DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D | DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D | ||
| 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_MCAL_QTR_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous quarter depending on whether the period is in previous, current or next quartet with respect to the current date. Default value is '__NOT_APPLICABLE__'. | |||
| W_CURRENT_MCAL_YEAR_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous year depending on whether the period is in previous , current or next year with respect to the current date. 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 |