# DW_PROJECT_TASK_HIERARCHY_DH

This table defines a column-flattened representation of the value-based trees of task hierarhcy. It contains key, name and description of each column-flattened level. It will have 20 levels of task hierarchy plus strcuture level.

## Details

Module: Project Costing

## Key Columns

BASE_ELEMENT_ID, LANGUAGE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
BASE_ELEMENT_ID | NUMBER | 38 | 0 | True | Element ID of Base Element |  |
LANGUAGE | VARCHAR2 | 16 |  | True | Indicates the code of the language into which the contents of the translatable columns are translated |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. The system generated number that uniquely identifies the row. |  |
TREE_STRUCTURE_CODE | VARCHAR2 | 32 |  |  | TREE_STRUCTURE_CODE |  |
TREE_CODE | VARCHAR2 | 256 |  |  | Tree name For projects |  |
TREE_VERSION_ID | VARCHAR2 | 256 |  |  | Tree version |  |
CFTREE_NODE_ID | VARCHAR2 | 256 |  |  | Unique identifier of the current node of tree |  |
BASE_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name. |  |
BASE_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence. |  |
BASE_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
BASE_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
DISTANCE | NUMBER | 38 | 0 |  | Distance of the current node of the tree from its ancestral root node |  |
LVL1_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL1_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL1_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL1_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL1_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL2_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL2_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL2_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL2_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL2_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL3_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL3_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL3_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL3_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL3_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL4_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL4_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL4_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL4_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL4_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL5_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL5_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL5_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL5_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL5_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL6_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL6_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL6_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL6_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL6_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL7_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL7_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL7_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL7_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL7_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL8_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL8_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL8_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL8_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL8_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL9_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL9_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL9_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL9_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL9_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL10_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL10_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL10_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL10_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL10_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL11_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL11_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL11_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL11_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL11_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL12_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL12_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL12_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL12_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL12_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL13_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL13_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL13_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL13_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL13_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL14_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL14_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL14_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL14_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL14_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL15_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL15_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL15_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL15_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL15_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL16_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL16_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL16_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL16_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL16_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL17_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL17_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL17_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL17_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL17_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
LVL18_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
LVL18_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
LVL18_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
LVL18_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
LVL18_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |
TOP_ELEMENT_ID | NUMBER | 38 | 0 |  | Element ID |  |
TOP_ELEMENT_NAME | VARCHAR2 | 256 |  |  | Element Name |  |
TOP_DENORM_DISPLAY_SEQ | NUMBER | 38 | 0 |  | Elment display sequence |  |
TOP_DENOM_WBS_LVL | NUMBER | 38 | 0 |  | The level of the task in the work breakdown structure |  |
TOP_ELEMENT_NUMBER | VARCHAR2 | 128 |  |  | Element Number |  |

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