DW_EB_X_EBS_COMMON_W_MCAL_CAL_D
This table stores multiple calendar related information ex; Mcal_id, Mcal_name, Mcal_type etc
Details
Module: Common Tables (EBS_COMMON)
Business Name: Fiscal Calendar Dimension
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 of Multiple calender dimension table | ||
| 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 | ||||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | Unique Source Record Identifier | |||
| 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 | |||
| 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)" | |||
| 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 |