Stores version details of trees like org, department.
Module:
TREE_VERSION_ID, TREE_CODE, TREE_STRUCTURE_CODE
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 |
#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, 2022, Oracle and/or its affiliates.