DW_EB_X_EBS_COMMON_W_MCAL_DAY_D
Has Fiscal days enumerated formt he Fiscal PEriods and gregorian days.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Fiscal Day Dimension Table
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | True | 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 | 11 CHAR | This flag indicates whether this period is an adjustment period for the Mcal year | |||
| BUDGETARY_CALENDAR_FLG | VARCHAR2 | 11 CHAR | ||||
| CAL_DAY_AGO_DT | TIMESTAMP | 6 | Previous Day Date | |||
| CAL_DAY_AGO_KEY | NUMBER | 10 | Date Key of Previous Day | |||
| CAL_DAY_AGO_WID | NUMBER | 38 | Surrogate key of previous day | |||
| CAL_DAY_OF_MONTH | NUMBER | 10 | Identifies the day number in the calendar month | |||
| CAL_DAY_OF_QTR | NUMBER | 10 | Identifies the day number in the calendar quarter | |||
| CAL_DAY_OF_THE_WEEK_ABBR | VARCHAR2 | 11 CHAR | Identifies the abbreviation of the day of the week | |||
| CAL_DAY_OF_THE_WEEK_CODE | VARCHAR2 | 18 CHAR | Identifies the code of the day of the week | |||
| CAL_DAY_OF_YEAR | NUMBER | 10 | Identifies the day number in the calendar year | |||
| CAL_HALF | NUMBER | 2 | Identifies the calendar half-year this day belongs to. Possible values are 1 and 2. | |||
| CAL_JULIAN_DAY_NUM | NUMBER | 10 | Identifies the date in Julian format | |||
| CAL_JULIAN_MONTH_NUM | NUMBER | 10 | Identifies the Julian month number this day belongs to | |||
| CAL_JULIAN_TER_NUM | NUMBER | 10 | Identifies the Julian trimester number this day belongs to | |||
| CAL_JULIAN_WEEK_NUM | NUMBER | 10 | Identifies the Julian week number this day belongs to | |||
| CAL_JULIAN_YEAR_NUM | NUMBER | 10 | Identifies the Julian year this day belongs to. | |||
| CAL_MONTH | NUMBER | 2 | Identifies the name of of the gregorian calendar month | |||
| CAL_MONTH_ABBR | VARCHAR2 | 40 CHAR | Identifies the abbevaiation of the gregorian calendar month | |||
| CAL_MONTH_AGO_WID | NUMBER | 38 | Identifies the surroate key of the same month in the previous gregorian calendar year | |||
| CAL_MONTH_END_DT | TIMESTAMP | 6 | Identifies the End Date of the gregorian calendar month | |||
| CAL_MONTH_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the gregorian calendar month | |||
| CAL_MONTH_OF_QTR | NUMBER | 10 | Identifies the name of the gregorian calendar month | |||
| CAL_MONTH_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the gregorian calendar month | |||
| CAL_MONTH_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the gregorian calendar month | |||
| CAL_MONTH_TOTAL_DAYS | NUMBER | 10 | Identifies the month in the gregorian calendar quarter | |||
| CAL_MONTH_WID | NUMBER | 38 | Identifies the name of the Mcal year | |||
| CAL_PRIOR_MONTH_WID | NUMBER | 38 | Identifies the surrogate key of the previous gregorian calendar month | |||
| CAL_PRIOR_QTR_WID | NUMBER | 38 | Identifies the surrogate key of the sequential prior calendar quarter | |||
| CAL_PRIOR_WEEK_WID | NUMBER | 38 | Identifies the previous calendar week | |||
| CAL_PRIOR_YEAR_WID | NUMBER | 38 | Identifies the surrogate key of the previous gregorian calendar year | |||
| CAL_QTR | NUMBER | 1 | Identifies the name of the gregorian calendar quarter | |||
| CAL_QTR_ABBR | VARCHAR2 | 40 CHAR | Identifies the abbreviation of the gregorian calendar quarter | |||
| CAL_QTR_AGO_WID | NUMBER | 38 | Identifies the surrogate key of the same quarter in the previous calendar quarter | |||
| CAL_QTR_END_DT | TIMESTAMP | 6 | Identifies the End Date of the gregorian calendar quarter | |||
| CAL_QTR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the gregorian calendar quarter | |||
| CAL_QTR_NAME | VARCHAR2 | 50 CHAR | Identifies the name of the gregorian calendar quarter | |||
| CAL_QTR_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the gregorian calendar quarter | |||
| CAL_QTR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the gregorian calendar quarter | |||
| CAL_QTR_TOTAL_DAYS | NUMBER | 10 | Identifies the total number of days in the gregorian calendar quarter | |||
| CAL_QTR_WID | NUMBER | 38 | Identifies the surrogate key of the gregorian calendar quarter | |||
| CAL_TRIMESTER | NUMBER | 10 | Identifies the calendar trimester this day belongs to. Possible values are 1, 2 and 3. | |||
| CAL_WEEK | NUMBER | 2 | Identifies the week number of the calendar week | |||
| CAL_WEEK_ABBR | VARCHAR2 | 40 CHAR | Identifies the abbreviation of the calendar week | |||
| CAL_WEEK_AGO_WID | NUMBER | 38 | Identifies the calendar week corresponding to the current week in the previous year | |||
| CAL_WEEK_END_DT | TIMESTAMP | 6 | Identifies the End Date of the calendar week | |||
| CAL_WEEK_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the calendar week | |||
| CAL_WEEK_NAME | VARCHAR2 | 50 CHAR | Identifies the name of the calendar week | |||
| CAL_WEEK_OF_QTR | NUMBER | 10 | Identifies the week number in the calendar quarter | |||
| CAL_WEEK_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the calendar week | |||
| CAL_WEEK_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the calendar week | |||
| CAL_WEEK_TOTAL_DAYS | NUMBER | 10 | Identifies the total number of days in the calendar week | |||
| CAL_WEEK_WID | NUMBER | 38 | Identifies the surrogate key of the calendar week | |||
| CAL_YEAR | NUMBER | 38 | Identifies the name of the gregorian calendar year | |||
| CAL_YEAR_END_DT | TIMESTAMP | 6 | Identifies the End Date of the gregorian calendar year | |||
| CAL_YEAR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the gregorian calendar year | |||
| CAL_YEAR_NAME | VARCHAR2 | 50 CHAR | Identifies the name of the gregorian calendar year | |||
| CAL_YEAR_START_DT | TIMESTAMP | 6 | Identifies the Start Date of the gregorian calendar year | |||
| CAL_YEAR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the gregorian calendar year | |||
| CAL_YEAR_TOTAL_DAYS | NUMBER | 10 | Identifies the total number of days in the gregorian calendar quarter | |||
| CAL_YEAR_WID | NUMBER | 38 | Identifies the surrogate key of the gregorian calendar 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 | |||
| FISCAL_CALENDAR_FLG | VARCHAR2 | 11 CHAR | ||||
| FISCAL_DATE_WID | NUMBER | 38 | ||||
| FST_DAY_MCAL_PER_FLG | VARCHAR2 | 11 CHAR | This flag indicates whether this day is the first day of the Mcal period. | |||
| FST_DAY_MCAL_QTR_FLG | VARCHAR2 | 11 CHAR | This flag indicates whether this day is the first day of the Mcal quarter. | |||
| FST_DAY_MCAL_WEEK_FLG | VARCHAR2 | 11 CHAR | This flag indicates whether this day is the first day of the Mcal week. | |||
| FST_DAY_MCAL_YEAR_FLG | VARCHAR2 | 11 CHAR | This flag indicates whether this day is the first day of the Mcal year. | |||
| LAST_DAY_MCAL_PER_FLG | VARCHAR2 | 11 CHAR | This flag indicates whether this day is the last day of the Mcal period. | |||
| LAST_DAY_MCAL_QTR_FLG | VARCHAR2 | 11 CHAR | This flag indicates whether this day is the last day of the Mcal quarter. | |||
| LAST_DAY_MCAL_WEEK_FLG | VARCHAR2 | 11 CHAR | This flag indicates whether this day is the last day of the Mcal week. | |||
| LAST_DAY_MCAL_YEAR_FLG | VARCHAR2 | 11 CHAR | This flag indicates whether this day is the last day of the Mcal 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 | |||
| MCAL_DAY_CODE | VARCHAR2 | 50 CHAR | Identifies the name of the Mcal day | |||
| MCAL_DAY_DT | TIMESTAMP | 6 | Identifies the date of the Mcal day | |||
| MCAL_DAY_DT_WID | NUMBER | 38 | Identifies the Mcal day Surrogate key in YYYYMMDD format | |||
| MCAL_DAY_OF_PERIOD | NUMBER | 10 | Identifies the day number in the Mcal period | |||
| MCAL_DAY_OF_QTR | NUMBER | 10 | Identifies the day number in the Mcal quarter | |||
| MCAL_DAY_OF_WEEK | NUMBER | 10 | Identifies the day number in the Mcal week | |||
| MCAL_DAY_OF_YEAR | NUMBER | 10 | Identifies the day number in the Mcal year | |||
| MCAL_JULIAN_PERIOD_NUM | NUMBER | 10 | ||||
| MCAL_PERIOD | NUMBER | 38 | Accounting Period Number | |||
| MCAL_PERIOD_AGO_WID | NUMBER | 38 | Row Wid of the previous period | |||
| 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 Date surrogate key in YYYYMMDD of the last day of the Mcal Period | |||
| MCAL_PERIOD_NAME | VARCHAR2 | 50 CHAR | Identifies the name fo the Mcal period | |||
| MCAL_PERIOD_NAME_WEEK | VARCHAR2 | 50 CHAR | Identifies the name of the mcal week | |||
| MCAL_PERIOD_OF_QTR | NUMBER | 10 | Identifies the mcal period in the mcal quarter | |||
| MCAL_PERIOD_OF_YEAR | NUMBER | 10 | Identifies the mcal period in the mcal quarter | |||
| 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 Mcal Period. | |||
| MCAL_PERIOD_START_DT_WID | NUMBER | 38 | Identifies the Date surrogate key in YYYYMMDD of the first day of the Mcal 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 | |||
| MCAL_PER_NAME_HALF | VARCHAR2 | 50 CHAR | Identifies the Mcal Half year Period Name. For example, 1980 Half1, 1980 Half2, etc. | |||
| MCAL_PER_NAME_QTR | VARCHAR2 | 50 CHAR | Identifies the Mcal Quarter Period Name. For example, "1980 Q1". | |||
| MCAL_PER_NAME_TER | VARCHAR2 | 50 CHAR | Identifies the Mcal Trimester Period Name. For example, "1980T1". | |||
| MCAL_PER_NAME_YEAR | VARCHAR2 | 50 CHAR | Identifies the name of the Mcal year | |||
| MCAL_PRIOR_PERIOD_WID | NUMBER | 38 | Row Wid for the Period in the Previous year | |||
| MCAL_PRIOR_QTR_WID | NUMBER | 38 | The ROW_WID from DW_EB_X_EBS_COMMON_W_MCAL_QTR_D of the same quarter in the previous year, e.g. the Q1 2007 prior period is Q1 2006 | |||
| MCAL_PRIOR_WEEK_WID | NUMBER | 38 | The Row Wid of the previous week | |||
| MCAL_PRIOR_YEAR_WID | NUMBER | 38 | The ROW_WID of the previous Mcal year | |||
| MCAL_QTR | NUMBER | 2 | Identifies the Quarter of Mcal Year this week belongs to. Possible values are 1, 2, 3 and 4. | |||
| MCAL_QTR_AGO_WID | NUMBER | 38 | The ROW_WID from DW_EB_X_EBS_COMMON_W_MCAL_QTR_D of the previous quarter | |||
| 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 Mcal Quarter. | |||
| MCAL_QTR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the Mcal Quarter | |||
| MCAL_QTR_OF_YEAR | NUMBER | 10 | Identifies the Mcal quarter in the Mcal year 1,2,3,4 | |||
| 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 Mcal Quarter. | |||
| MCAL_QTR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the Mcal Month | |||
| MCAL_QTR_WID | NUMBER | 38 | Surrogate key to DW_EB_X_EBS_COMMON_W_MCAL_QTR_D | |||
| MCAL_WEEK_AGO_WID | NUMBER | 38 | The Row Wid of the same week in the previous year | |||
| MCAL_WEEK_END_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_END_DT | TIMESTAMP | 6 | Identifies the End Date of the Mcal Week. | |||
| MCAL_WEEK_END_DT_KEY | NUMBER | 10 | Identifies the Julian Date of the last day of the Mcal Week. | |||
| MCAL_WEEK_END_DT_WID | NUMBER | 38 | Identifies the Date surrogate key in YYYYMMDD format of the last day of the Mcal Week | |||
| MCAL_WEEK_OF_PERIOD | NUMBER | 10 | Identifies the Mcal week in the Mcal period. | |||
| MCAL_WEEK_OF_QTR | NUMBER | 10 | Identifies the Mcal weekin the Mcal quarter | |||
| MCAL_WEEK_OF_YEAR | NUMBER | 10 | Identifies the Mcal week in the Mcal year | |||
| 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 Mcal Week. | |||
| MCAL_WEEK_START_DT_KEY | NUMBER | 10 | Identifies the Julian Date of the first day of the Mcal Week. | |||
| MCAL_WEEK_START_DT_WID | NUMBER | 38 | Identifies the Date surrogate key in YYYYMMDD of the first day of the Mcal Week | |||
| MCAL_YEAR | NUMBER | 38 | Identifies the Mcal 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 Mcal Year. | |||
| MCAL_YEAR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key in YYYYMMDD format of the Mcal Year | |||
| 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 Mcal Year. | |||
| MCAL_YEAR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key in YYYYMMDD format of the Mcal Year | |||
| MCAL_YEAR_TOTAL_DAYS | NUMBER | 10 | Total number of days in this Mcal year | |||
| MCAL_YEAR_TOTAL_WEEKS | NUMBER | 10 | Total number of weeks in this Mcal year | |||
| MCAL_YEAR_WID | NUMBER | 38 | Surrogate key to DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D | |||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a Mcal day record. | |||
| 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_CAL_DAY_CODE | VARCHAR2 | 50 CHAR | Identifies the name of the day of the week | |||
| W_CAL_MONTH_CODE | VARCHAR2 | 50 CHAR | Identifies the name of theof the gregorian calendar month | |||
| W_CURRENT_MCAL_DAY_CODE | VARCHAR2 | 50 CHAR | This is the code which indicates whether the Day is Current or Next or Previous to the current day. This code gets updated everyday and the 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. The 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 of Previous monthdepending 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 as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |