DW_GL_SEGMENT4_RF_D

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

Details

Module:

Key Columns

SEGMENT_CODE, MEMBER_ID, HIERARCHY_VALUESET_CODE, PARENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
HIERARCHY_VALUESET_CODE VARCHAR2 128 True Tree node primary key identifier.
MEMBER_ID VARCHAR2 128 True MEMBER_ID primary key identifier.
PARENT_ID VARCHAR2 128 True Primary key of the PARENT_ID
SEGMENT_CODE VARCHAR2 128 True Segment Code
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier.
HIERARCHY_NAME_HIERARCHY_VERSION_NAME VARCHAR2 512 HIERARCHY_NAME_HIERARCHY_VERSION_NAME
HIERARCHY_VERSION_STATUS VARCHAR2 32 Hierarchy Status
EFFECTIVE_START_DATE DATE Hierarchy start date.
EFFECTIVE_END_DATE DATE Hierarchy end date.