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

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