# DW_ORGANIZATION_CF_DH

It stores organization hierarchy information in column flattened format.

## Details

Module:

## Key Columns

TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, ORGANIZATION_ID, ENTERPRISE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ENTERPRISE_ID | NUMBER | 38 | 0 | True | Enterprise Identifier |  |
TREE_STRUCTURE_CODE | VARCHAR2 | 32 |  | True | Code for the Organization Tree Structure #1 |  |
TREE_CODE | VARCHAR2 | 32 |  | True | Code for the Organization Tree |  |
TREE_VERSION_ID | VARCHAR2 | 64 |  | True | Tree version Identifier | DW_TREE_VERSION_D_TL | TREE_VERSION_ID
ORGANIZATION_ID | NUMBER | 38 | 0 | True | Organization Id of the hierarchy node. |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
TREE_VERSION_END_DATE | DATE |  |  |  | indicates the date at the beginning of the date range within which the tree version is effective. |  |
TREE_VERSION_START_DATE | DATE |  |  |  | indicates the date at the end of the date range within which the tree version is effective. |  |
TREE_VERSION_STATUS | VARCHAR2 | 32 |  |  | Tree Version Status, Possible Value is ACTIVE, as only Active Trees are stored in this table. |  |
LEVEL0_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 0, this is the bottom most level. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL1_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 1. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL2_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 2. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL3_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 3. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL4_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 4. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL5_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 5. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL6_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 6. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL7_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 7. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL8_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 8. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL9_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 9. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL10_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 10. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL11_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 11. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL12_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 12. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL13_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 13. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL14_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 14. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL15_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 15. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL16_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 16. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL17_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 17. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL18_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 18. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL19_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 19. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL20_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 20. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL21_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 21. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL22_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 22. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL23_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 23. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL24_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 24. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL25_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 25. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL26_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 26. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL27_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 27. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL28_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 28. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL29_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 29. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL30_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 30. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
LEVEL31_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier at the level 31. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
NODE_DISTANCE | NUMBER | 38 | 0 |  | Distance between the Node and its Ancestor. |  |

## 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, TREE_NODE_ID

ENTERPRISE_ID.

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