DW_DMD_EXT_TABLE_COLUMNS

Contains Enrichment Table Column Information

Details

Module:

Key Columns

TABLE_NAME, DATASOURCE_CODE, COLUMN_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    
COLUMN_NAME VARCHAR2 128   True Column name    
SOURCE_RECORD_ID VARCHAR2 512     This column is for Oracle Internal use only. Source record identifier    
COLUMN_TYPE VARCHAR2 64     Column type    
CONTAINER_DOMAIN_CODE VARCHAR2 128     Set of columns explaining the given domain    
COLUMN_DOMAIN_CODE VARCHAR2 128     Container domain code which this column refers to    
AGGREGATION_LOGIC VARCHAR2 999     Column aggregation logic Default NULL if there is no aggregation logic    
FUNCTIONAL_AREA_CODE VARCHAR2 256     Functional area code    
CLASS_CODE VARCHAR2 256     Represents the custom object generation source application.    

Copyright © 2019, 2024, Oracle and/or its affiliates.