# DW_ORG_HIERARCHY_DENORM_DH (Preview)

This table requires activation of Grants Management functional area. This table stores deflated structure of organization hierarchy.

## Details

Module: Grants Management

## Key Columns

TREE_STRUCTURE_CODE, TREE_CODE, TREE_VERSION_ID, PARENT_ORGANIZATION_ID, CHILD_ORGANIZATION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PARENT_ORGANIZATION_ID | NUMBER |  |  | True | Identifier of the parent organization |  |
CHILD_ORGANIZATION_ID | NUMBER |  |  | True | Identifier of the child organization |  |
TREE_STRUCTURE_CODE | VARCHAR2 | 32 |  | True | TREE_STRUCTURE_CODE |  |
TREE_CODE | VARCHAR2 | 32 |  | True | TREE_CODE |  |
TREE_VERSION_ID | VARCHAR2 | 64 |  | True | SponsorBasePEOLocNumber |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System |  |
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 |  | Used to implement optimistic locking. |  |
PARENT_LEVEL | NUMBER | 38 | 0 |  | Stores the level of the parent organization |  |
CHILD_LEVEL | NUMBER | 38 | 0 |  | Stores the level of the child organization |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |

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