DW_DMD_EXT_TABLE_COLUMNS

Contains Enrichment Table Column Information

Details

Module:

Key Columns

DATASOURCE_CODE, TABLE_NAME, 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.