DW_TREE_VERSION_D

Stores version details of trees like org, department.

Details

Module:

Key Columns

TREE_VERSION_ID, TREE_CODE, TREE_STRUCTURE_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     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.

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