MASTER PROJECT HISTORY Table
A history of master project data. This table is used as a dimension only in those queries that involve MASTER PROJECT HISTORY DETAIL.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FISCAL_PERIOD |
The fiscal year and month. For example: 199709 = March 1997. |
VARCHAR2 |
6 |
FISCAL_YEAR |
The 4 digit year. The fiscal year at MIT runs from July 1st through June 30th. (e.g.: June 30, 1997 would be fiscal year 1997, July 1, 1997 would be fiscal year 1998) |
VARCHAR2 |
4 |
MASTER_PROJECT_FP_KEY |
This key field is used to join MASTER PROJECT HISTORY and MASTER PROJECT HISTORY DETAIL tables. |
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 |