DW_DMD_EXT_TABLES

Contains data enrichment table information

Details

Module:

Key Columns

TABLE_NAME, DATASOURCE_CODE

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     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.