DW_DMD_EXT_SUBJECT_AREA_FOLDERS

Contains enrichment tables and subject area folder relationship

Details

Module:

Key Columns

CHILD_FOLDER, 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
CHILD_FOLDER VARCHAR2 128 True Subject Area Child Folder
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier.
PARENT_FOLDER VARCHAR2 128 Subject Area Parent Folder
FOLDER_ORDER NUMBER 38 0 Child Folder Order
FUNCTIONAL_AREA_CODE VARCHAR2 256 Functional area code
CLASS_CODE VARCHAR2 256 Represents the custom object generation source application.