DW_EB_X_EBS_COMMON_W_MCAL_YEAR_D
This table has fiscal years aggregated from Fiscal periods
Details
Module: Common Tables (EBS_COMMON)
Business Name: Fiscal Year 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 Quarter record. This key is formed by appending 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 | ||||
| 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_YEAR_NUM | NUMBER | 10 | Cumulative Year Number getting added up through the years. | |||
| MCAL_PERIOD_TYPE | VARCHAR2 | 50 CHAR | Identifies the accounting period type | |||
| MCAL_PER_NAME_YEAR | VARCHAR2 | 50 CHAR | Identifies the Fiscal Year period name in string format. for example 1980 | |||
| MCAL_PRIOR_YEAR_WID | NUMBER | 38 | The ROW_WID of the previous fiscal year | |||
| MCAL_YEAR | NUMBER | 4 | Identifies which Fiscal Quarter this quarter belongs to like 1,2..4 | |||
| 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_KEY | NUMBER | 10 | Identifies the End Date of the mcal Year in Julian | |||
| MCAL_YEAR_END_DT_WID | NUMBER | 38 | Identifies the End Date Surrogate key (Date in YYYYMMDD) of the Fiscal Year | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| MCAL_YEAR_KEY | NUMBER | 10 | Reserved for future use | |||
| MCAL_YEAR_LAST_DAY_OF_YEAR | NUMBER | 10 | Identifies the Last Day 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_KEY | NUMBER | 10 | Identifies the Start Date of the mcal Year in Julian. | |||
| MCAL_YEAR_START_DT_WID | NUMBER | 38 | Identifies the Start Date Surrogate key (Date in YYYYMMDD) of the mcal Year | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| 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 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_YEAR_CODE | VARCHAR2 | 50 CHAR | This code gets updated to Current or Next or Previous year depending on whether it is current or next or previous year w.r.t 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 |