DW_EB_X_EBS_COMMON_W_MCAL_WEEK_D
This table has generated fiscal weeks.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Fiscal Week Dimension Table
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 Fiscal Week record. | ||
| 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_WK_MCAL_MNTH_FLG | VARCHAR2 | 1 CHAR | Identifies if the week is the first week of the Fiscal Month or not. | |||
| FST_WK_MCAL_QTR_FLG | VARCHAR2 | 1 CHAR | Identifies if the week is the first week of the Fiscal Quarter or not. | |||
| FST_WK_MCAL_YEAR_FLG | VARCHAR2 | 1 CHAR | Identifies if the week is the first week of the Fiscal Year or not. | |||
| LAST_WK_MCAL_MNTH_FLG | VARCHAR2 | 1 CHAR | Identifies if the week is the last week of the Fiscal Month or not. | |||
| LAST_WK_MCAL_QTR_FLG | VARCHAR2 | 1 CHAR | Identifies if the week is the last week of the Fiscal Quarter or not. | |||
| LAST_WK_MCAL_YEAR_FLG | VARCHAR2 | 1 CHAR | Identifies if the week is the first week of the Fiscal Year or not. | |||
| 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_FST_WK_FR_KEY | NUMBER | 10 | Identifies the julian date of the first day of the first Fiscal Week of the same fiscal year this fiscal week belongs to. | |||
| MCAL_FST_WK_TO_KEY | NUMBER | 10 | Identifies the julian date of the last day of the first Fiscal Week of the same fiscal year this fiscal week belongs to. | |||
| MCAL_HALF | NUMBER | 2 | Identifies the half of Fiscal Year that this week belongs. Possible values are 1 or 2. | |||
| MCAL_MONTH | NUMBER | 2 | Identifies the Fiscal Month this week belongs to. Possible values are 1 through 12. | |||
| MCAL_PERIOD_AGO_WID | NUMBER | 38 | ROW_WID from DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D from the same period in the previous year. | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | ||
| 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 End Date of the Fiscal Year. | |||
| MCAL_PERIOD_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_PERIOD_NAME | VARCHAR2 | 240 CHAR | Name of the fiscal period | |||
| MCAL_PERIOD_NUM | NUMBER | 10 | Fiscal Period Number | |||
| MCAL_PERIOD_OF_QUARTER | NUMBER | 10 | Identifies the fiscal period of the quarter to which this week belongs to | |||
| MCAL_PERIOD_OF_YEAR | NUMBER | 10 | Identifies the fiscal period of the year to which this week belongs to | |||
| 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_PERIOD_WID | NUMBER | 38 | Surrogate key to DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | ||
| 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 | Row_wid from DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D of the previous period | DW_EB_X_EBS_COMMON_W_MCAL_PERIOD_D | ||
| MCAL_PRIOR_QTR_WID | NUMBER | 38 | ROW_WID from DW_EB_X_EBS_COMMON_W_MCAL_QTR_D of the previous quarter | DW_EB_X_EBS_COMMON_W_MCAL_QTR_D | ||
| MCAL_PRIOR_WEEK_WID | NUMBER | 38 | ROW_WID of the previous week | |||
| MCAL_PRIOR_YEAR_WID | NUMBER | 38 | ROW_WID from DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D of the previous year | DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D | ||
| MCAL_QTR | NUMBER | 2 | Identifies the Quarter of Fiscal Year this week belongs to. Possible values are 1, 2, 3 and 4. | |||
| MCAL_QTR_AGO_WID | NUMBER | 38 | ROW_WID from DW_EB_X_EBS_COMMON_W_MCAL_QTR_D of the same quarter in the previous year | 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_NUM | NUMBER | 10 | Fiscal Quarter Number | |||
| 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 week belongs to. Possible values are 1, 2 and 3. | |||
| MCAL_WEEK | NUMBER | 2 | Week this week belongs to. Possible values are 1 through 52 . | |||
| MCAL_WEEK_AGO_WID | NUMBER | 38 | ROW_WID of the same week in the previous year | |||
| MCAL_WEEK_END_DAY_WID | NUMBER | 38 | This is the MCAL_WEEK_END_DT formatted in the same format as the ROW_WID of a regular period in DW_EB_X_EBS_COMMON_W_MCAL_WEEK_D. This is used by Project Analytics to calculate ITD measures. | |||
| MCAL_WEEK_END_DT | TIMESTAMP | 6 | Identifies the End Date of the Fiscal Week. | |||
| MCAL_WEEK_END_DT_KEY | NUMBER | 10 | Identifies the Julian Date of the last day of the Fiscal Week. | |||
| MCAL_WEEK_END_DT_WID | NUMBER | 38 | Identifies the Date surrogate key in YYYYMMDD format of the last day of the Fiscal Week | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| MCAL_WEEK_KEY | NUMBER | 10 | Fiscal Week Key | |||
| MCAL_WEEK_OF_PERIOD | NUMBER | 10 | Fiscal week of the period | |||
| MCAL_WEEK_OF_QTR | NUMBER | 10 | Fiscal week of the quarter | |||
| MCAL_WEEK_OF_YEAR | NUMBER | 10 | Week this week belongs to. Possible values are 1 through 52. | |||
| MCAL_WEEK_START_DAY_WID | NUMBER | 38 | This is the MCAL_WEEK_START_DT formatted in the same format as the ROW_WID of a regular period in DW_EB_X_EBS_COMMON_W_MCAL_WEEK_D. This is used by Project Analytics to calculate ITD measures. | |||
| MCAL_WEEK_START_DT | TIMESTAMP | 6 | Identifies the First Date of the Fiscal Week. | |||
| MCAL_WEEK_START_DT_KEY | NUMBER | 10 | Identifies the Julian Date of the first day of the Fiscal Week. | |||
| MCAL_WEEK_START_DT_WID | NUMBER | 38 | Identifies the Date surrogate key in YYYYMMDD of the first day of the Fiscal Week | DW_EB_X_EBS_COMMON_W_MCAL_DAY_D | ||
| MCAL_YEAR | NUMBER | 4 | Identifies the Fiscal Year this week belongs to 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_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_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_WEEK_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next orPrevious month depending on whether the week is previous ,current or next week 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 asa generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |