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
| 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.