PROJECT WBS HIERARCHY Table
Contains information used to represent the WBS hierarchies. Reporting can be done at the top (level 1) level (Master Project) on the entire WBS hierarchy structure, or at lower levels in the hierarchy.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COST_COLLECTOR_KEY |
Key used to join the Cost Collector to the financial transaction, and to get the master data that were current at the time of the transaction. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
MASTER_PROJECT_NAME |
Name (Project Title) of the top level (level 1) WBS Id in a WBS Hierarchy structure. Select this field if a roll-up of the activity on an entire WBS Hierarchy is desired. Colloquially known as the Parent in a Parent-Child hierarchy. |
VARCHAR2 |
40 |
MASTER_PROJECT_NUMBER |
WBS Id of the top level WBS Id (level 1) in a WBS Hierarchy structure. Select this field if a roll-up of the activity on an entire WBS Hierarchy is desired. Colloquially known as the Parent in a Parent-Child hierarchy. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WBS_ELEMENT_ID_LEVEL1 |
WBS Element Id for Level 1 in WBS Hierarchy structure. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL10 |
XXX |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL2 |
WBS Element Id for Level 2 in WBS Hierarchy structure. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL3 |
WBS Element Id for Level 3 in WBS Hierarchy structure. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL4 |
WBS Element Id for Level 4 in WBS Hierarchy structure. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL5 |
WBS Element Id for Level 5 in WBS Hierarchy structure. |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL6 |
XXX |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL7 |
XXX |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL8 |
XXX |
VARCHAR2 |
7 |
WBS_ELEMENT_ID_LEVEL9 |
XXX |
VARCHAR2 |
7 |
WBS_ELEMENT_NAME_LEVEL1 |
WBS Element Name for Level 1 in WBS Hierarchy structure. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL10 |
XXX |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL2 |
WBS Element Name for Level 2 in WBS Hierarchy structure. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL3 |
WBS Element Name for Level 3 in WBS Hierarchy structure. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL4 |
WBS Element Name for Level 4 in WBS Hierarchy structure. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL5 |
WBS Element Name for Level 5 in WBS Hierarchy structure. |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL6 |
XXX |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL7 |
XXX |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL8 |
XXX |
VARCHAR2 |
40 |
WBS_ELEMENT_NAME_LEVEL9 |
XXX |
VARCHAR2 |
40 |