DW_EB_X_EBS_COMMON_W_PROD_CAT_DH
DW_EB_X_EBS_COMMON_W_PROD_CAT_DH is a snowflake table that stores the Product Category Hierarchies as defined in the source system. Upto ten hierarchies are carried over from the source into the Analytics.
Details
Module: Common Tables (EBS_COMMON)
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 | System generated key column. | ||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System Field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System Field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System Field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Oracle System Field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| BASE_LVL_PRODCAT_ID | VARCHAR2 | 255 CHAR | The lowest or the base level product hierarchy code. | |||
| CATALOG_CREATION_DATE | TIMESTAMP | 6 | Creation date | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| 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. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | ||||
| ETL_PROC_WID | NUMBER | 38 | System Column | |||
| FIXED_HIER_LEVEL | NUMBER | 10 | ||||
| HIERARCHY_CODE | VARCHAR2 | 80 CHAR | A pre-defined hierarchy code to identify the current hierarchy. | |||
| HIERARCHY_TYPE_CODE | VARCHAR2 | 80 CHAR | A type code of current hierarchy. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | 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. | |||
| LEVEL_NAME | VARCHAR2 | 40 CHAR | Name of the current Level | |||
| LVL1ANC_PRODCAT_ID | VARCHAR2 | 255 CHAR | Level 1 product hierarchy code. | |||
| LVL2ANC_PRODCAT_ID | VARCHAR2 | 255 CHAR | Level 2 product hierarchy code. | |||
| LVL3ANC_PRODCAT_ID | VARCHAR2 | 255 CHAR | Level 3 product hierarchy code. | |||
| LVL4ANC_PRODCAT_ID | VARCHAR2 | 255 CHAR | Level 4 product hierarchy code. | |||
| LVL5ANC_PRODCAT_ID | VARCHAR2 | 255 CHAR | Level 5 product hierarchy code. | |||
| LVL6ANC_PRODCAT_ID | VARCHAR2 | 255 CHAR | Level 6 product hierarchy code. | |||
| LVL7ANC_PRODCAT_ID | VARCHAR2 | 255 CHAR | Level 7 product hierarchy code. | |||
| LVL8ANC_PRODCAT_ID | VARCHAR2 | 255 CHAR | Level 8 product hierarchy code. | |||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available). | |||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available). | |||
| 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) model. | |||
| TOP_LVL_PRODCAT_ID | VARCHAR2 | 255 CHAR | Top Level product hierarchy code. | |||
| 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 |