PROJECT WBS HIERARCHY Table
View exposing project work breakdown structure hierarchy records used to organize and report project accounting activity.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Surrogate key identifying the cost collector. |
VARCHAR2 |
12 |
MASTER_PROJECT_NAME |
Master project name associated with the record. |
VARCHAR2 |
40 |
MASTER_PROJECT_NUMBER |
Master project number associated with the record. |
VARCHAR2 |
7 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WBS_ELEMENT_ID_LEVEL1 |
Wbs element id level1 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL10 |
Wbs element id level10 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL2 |
Wbs element id level2 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL3 |
Wbs element id level3 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL4 |
Wbs element id level4 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL5 |
Wbs element id level5 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL6 |
Wbs element id level6 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL7 |
Wbs element id level7 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL8 |
Wbs element id level8 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL9 |
Wbs element id level9 associated with the record. |
VARCHAR2 |
7 |
WBS_ELEMENT_NAME_LEVEL1 |
Wbs element name level1 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL10 |
Wbs element name level10 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL2 |
Wbs element name level2 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL3 |
Wbs element name level3 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL4 |
Wbs element name level4 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL5 |
Wbs element name level5 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL6 |
Wbs element name level6 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL7 |
Wbs element name level7 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL8 |
Wbs element name level8 associated with the record. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL9 |
Wbs element name level9 associated with the record. |
VARCHAR2 |
40 |