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.
Module: Project Costing
LANGUAGE, BASE_ELEMENT_ID
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, 2022, Oracle and/or its affiliates.