DW_TREE_VERSION_D

Stores version details of trees like org, department.

Details

Module:

Key Columns

TREE_STRUCTURE_CODE, TREE_VERSION_ID, TREE_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TREE_STRUCTURE_CODE VARCHAR2 32 True Tree Structure Code
TREE_CODE VARCHAR2 32 True Tree Code
TREE_VERSION_ID VARCHAR2 64 True Tree Version ID
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System
STATUS VARCHAR2 32 Status
EFFECTIVE_START_DATE DATE Effective Start Date
EFFECTIVE_END_DATE DATE Effective End Date

Notes

#1 Translated tree version name, tree version description and tree version comments are present in DW_TREE_VERSION_D_TL table. Join using TREE_CODE, TREE_STRUCTURE_CODE, TREE_VERSION_ID.