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