DW_EB_X_EBS_COMMON_W_MCAL_CONTEXT_G
This is the context table. It mas the relation between the organization or ledger to a calendar in OLAP.
Details
Module: Common Tables (EBS_COMMON)
Business Name: Fiscal Context Help 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 | Unique Source Record Identifier | |||
| CALENDAR_ID | VARCHAR2 | 80 CHAR | Identifies the accounting calendar | |||
| CALENDAR_NAME | VARCHAR2 | 30 CHAR | Accounting calendar name | |||
| CONTEXT_CLASS | VARCHAR2 | 30 CHAR | Calendar Class | |||
| LEDGER_ID | VARCHAR2 | 30 CHAR | ID that uniquely identifies a ledger | |||
| LEDGER_NAME | VARCHAR2 | 100 CHAR | Ledger Name | |||
| MCAL_CAL_WID | NUMBER | 38 | ID assigned within the warehouse to uniquely identify a calendar | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| ORG_CODE | VARCHAR2 | 50 CHAR | Organization Name | |||
| ORG_ID | VARCHAR2 | 30 CHAR | ID that uniquely identifies an internal organization. | |||
| 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 |