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

LANGUAGE, BASE_ELEMENT_ID

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