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     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, 2023, Oracle and/or its affiliates.