DW_GL_SEGMENT4_RF_DH

This is stage table, contains information about GL segment4 row flattened hierarchy

Details

Module:

Key Columns

TREE_VERSION_NAME, SEGMENT_CODE, ANCESTOR_SEGMENT_CODE, TREE_NAME, HIERARCHY_VALUESET_CODE, ANCESTOR_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SEGMENT_CODE VARCHAR2 128 True Tree node primary key identifier.
ANCESTOR_SEGMENT_CODE VARCHAR2 128 True Primary key of the ancestor tree node.
TREE_VERSION_NAME VARCHAR2 128 True Tree Version Name
HIERARCHY_VALUESET_CODE VARCHAR2 128 True Tree node primary key identifier.
TREE_NAME VARCHAR2 128 True
ANCESTOR_ID VARCHAR2 512 True ancestor ID.
SOURCE_RECORD_ID VARCHAR2 999 This column is for Oracle Internal use only. Source record identifier.
RELATIONSHIP_DISTANCE NUMBER 38 0 Distance between the tree node and the ancestor tree node.
MEMBER_ID VARCHAR2 512 Member ID.
IS_LEAF VARCHAR2 16 Identifies if the tree node is a child or parent.
IS_LEAF_INDICATOR NUMBER 38 0 Identifies if the tree node is a child or parent. Valid values 0 or 1.