DW_DMD_EXT_TABLE_SUBJECT_AREA_MAP

Contains enrichment tables and subject area relationship

Details

Module:

Key Columns

SUBJECT_AREA_NAME, 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    
SUBJECT_AREA_NAME VARCHAR2 256   True Subject Area name    
SOURCE_RECORD_ID VARCHAR2 512     Source record identifier.    
FUNCTIONAL_AREA_CODE VARCHAR2 256     Functional area code    
CLASS_CODE VARCHAR2 256     Represents the custom object generation source application.    

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