DW_DMD_EXT_TABLES

Contains data enrichment table information

Details

Module:

Key Columns

DATASOURCE_CODE, TABLE_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DATASOURCE_CODE VARCHAR2 32 True Datasource code.
TABLE_NAME VARCHAR2 128 True Table name
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Source record identifier.
TABLE_DESCRIPTION VARCHAR2 999 Table description
TABLE_TYPE VARCHAR2 64 Table type
TABLE_ROLE VARCHAR2 64 Table role
AUGMENTATION_NAME VARCHAR2 512 Table augmentation name
ENRICHMENT_ACTION_TYPE VARCHAR2 128 Enrichment action type
ENRICHMENT_OBJECT_TYPE VARCHAR2 128 Enrichment object type
ENRICHMENT_OBJECT_SOURCE VARCHAR2 128 Enrichment object source
EXTENDED_DOMAIN VARCHAR2 128 Extending Domain
BASE_TABLE VARCHAR2 128 Base table for alias.
BASE_TABLE_TYPE VARCHAR2 128 Base table type for alias, possible values are FACTORY or CUSTOM.
FUNCTIONAL_AREA_CODE VARCHAR2 256 Functional area code
CLASS_CODE VARCHAR2 256 Represents the custom object generation source application.