Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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