DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D
Has Fiscal Period both Generated and Sourced From OLTP
Details
Module: Common Tables (EBS_COMMON)
Business Name: Fiscal Period Dimension Table
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| 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 | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| ADJUSTMENT_PERIOD_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the adjustment period for the fiscal year | |||
| BUDGETARY_CALENDAR_FLG | VARCHAR2 | 1 CHAR | ||||
| FISCAL_CALENDAR_FLG | VARCHAR2 | 1 CHAR | ||||
| FST_PERIOD_MCAL_QTR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the first period of the fiscal quarter. | |||
| FST_PERIOD_MCAL_YEAR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the first period of the fiscal year. | |||
| LAST_PERIOD_MCAL_QTR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the last period of the fiscal quarter. | |||
| LAST_PERIOD_MCAL_YEAR_FLG | VARCHAR2 | 1 CHAR | This flag indicates whether this period is the last period 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_MNTH_NUM | NUMBER | 10 | Cumulative Month Number getting added up through the years. | |||
| MCAL_DIM_QTR_NUM | NUMBER | 10 | Cumulative Quarter Number getting added up through the years. | |||
| MCAL_DIM_WEEK_NUM | NUMBER | 10 | Cumulative Week Number getting added up through the years. | |||
| MCAL_DIM_YEAR_NUM | NUMBER | 10 | Cumulative Year Number getting added up through the years. | |||
| MCAL_HALF | NUMBER | 2 | Identifies the half of Fiscal Year that this period belongs. Possible values are 1 or 2. | |||
| MCAL_JULIAN_PERIOD_NUM | NUMBER | 10 | ||||
| MCAL_PERIOD | NUMBER | 4 | Accounting Period Number | |||
| MCAL_PERIOD_AGO_WID | NUMBER | 38 | Identifies the Row_wid of same Period in the previous year | |||
| MCAL_PERIOD_END_DAY_WID | NUMBER | 38 | This is the MCAL_PERIOD_END_DT formatted in the same format as the ROW_WID of a regular period in DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D. This is used by Project Analytics to calculate ITD measures | |||
| MCAL_PERIOD_END_DT | TIMESTAMP | 6 | Identifies the Last Date of the mcal Period. | |||
| MCAL_PERIOD_END_DT_WID | NUMBER | 38 | Identifies the Last Date of the mcal Period | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| MCAL_PERIOD_NAME | VARCHAR2 | 240 CHAR | Name of the mcal period | |||
| MCAL_PERIOD_OF_QTR | NUMBER | 10 | Identifies the fiscal period in the fiscal quarter | |||
| MCAL_PERIOD_OF_YEAR | NUMBER | 10 | Identifies the fiscal period in the fiscal year | |||
| MCAL_PERIOD_START_DAY_WID | NUMBER | 38 | This is the MCAL_PERIOD_START_DT formatted in the same format as the ROW_WID of a regular period in DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D. This is used by Project Analytics to calculate ITD measures. | |||
| MCAL_PERIOD_START_DT | TIMESTAMP | 6 | Identifies the First Date of the Fiscal Period. | |||
| MCAL_PERIOD_START_DT_WID | NUMBER | 38 | Identifies the Date surrogate key in YYYYMMDD of the first day of the Fiscal Period | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| MCAL_PERIOD_TOTAL_DAYS | NUMBER | 10 | Total number of days in the fiscal period | |||
| MCAL_PERIOD_TOTAL_WEEKS | NUMBER | 10 | Total number of weeks in the fiscal period | |||
| MCAL_PERIOD_TYPE | VARCHAR2 | 50 CHAR | Identifies the accounting period type | |||
| MCAL_PER_NAME_HALF | VARCHAR2 | 50 CHAR | Identifies the Fiscal Half year Period Name. For example, 1980 Half1, 1980 Half2, etc. | |||
| MCAL_PER_NAME_MNTH | VARCHAR2 | 50 CHAR | Month Period Name in YYYY/MM format. For example, ""1980 / 01"", ""1980 / 10"", etc. | |||
| MCAL_PER_NAME_QTR | VARCHAR2 | 50 CHAR | Identifies the Fiscal Quarter Period Name. For example, ""1980 Q 1"". | |||
| MCAL_PER_NAME_TER | VARCHAR2 | 50 CHAR | Identifies the Fiscal Trimester Period Name. For example, ""1980T1"". | |||
| MCAL_PER_NAME_WEEK | VARCHAR2 | 50 CHAR | Identifies the Fiscal Week Period Name. For example, ""1980 Week01"". | |||
| MCAL_PER_NAME_YEAR | VARCHAR2 | 50 CHAR | Identifies the Fiscal Year Period Name in YYYY format. For example, ""1980"". | |||
| MCAL_PRIOR_PERIOD_WID | NUMBER | 38 | Identifies the Row_wid of Period prior to present period | |||
| 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 | NUMBER | 2 | Identifies which Mcal Quarter this period belongs to like 1,2..4. | |||
| 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 | DW_EB_X_EBS_COMMON_W_MCAL_QTR_D | ||
| 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 End Date of the Fiscal Quarter. | |||
| MCAL_QTR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the Fiscal Quarter | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| 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 Start Date of the Fiscal Quarter | |||
| MCAL_QTR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the Fiscal Quarter | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| MCAL_QTR_WID | NUMBER | 38 | Surrogate key to DW_EB_X_EBS_COMMON_W_MCAL_QTR_D | DW_EB_X_EBS_COMMON_W_MCAL_QTR_D | ||
| MCAL_TRIMESTER | NUMBER | 2 | Identifies the Fiscal trimester this period belongs to. Possible values are 1, 2 and 3. | |||
| MCAL_YEAR | NUMBER | 4 | Identifies the fiscal year in YYYY Format | |||
| 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_MCAL_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 Start Date 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_MCAL_DAY_D | ||
| MCAL_YEAR_START_PERIOD_WID | NUMBER | 38 | This is the Row_wid for first period of 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 | ||
| PERIOD_CLASSIFICATION_CODE | VARCHAR2 | 80 CHAR | ||||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a Fiscal Period record. This key is formed by ppending Fiscal Period to Fiscal 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_MCAL_MONTH_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous month depending on whether the period is previous , current or next month with respect to the current date. Default value is '__NOT_APPLICABLE__'. | |||
| W_CURRENT_MCAL_PERIOD_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous period depending on whether the period is previous , current or next period with respect to the current date. Default value is '__NOT_APPLICABLE__'. | |||
| 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 previous , current or next quarter 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 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 |