PROJECT HISTORY FLAG Table
This table contains Project WBS activity summary flags which specify whether there was expense activity for the wbs during the fiscal year or not
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BUD_NOT_EQUAL_CUMEXP_FLAG |
This flag is set to "Y" if the Project WBS element fiscal year budget is not equal to the cumulative expenses. Otherwise the field is set to "N". |
VARCHAR2 |
1 |
COST_COLLECTOR_FY_KEY |
Key used to join historical Cost Collector tables and a fact table (Balances, Balances by Fiscal Period, Summary Statement Detail) when you want to bring in cost collector data as it was at the end of fiscal year of the fact data. For the current fiscal year, the most recent data will be brought in. |
VARCHAR2 |
12 |
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 |
FY_EXPENSES_FLAG1 |
Flag (Y or N) specifying whether these was any expense account activity against the project wbs based on the Balances table |
VARCHAR2 |
1 |
FY_EXPENSES_FLAG2 |
Flag (Y or N) specifying whether there was any expense account activity against the project wbs based on Financial Detail table |
VARCHAR2 |
1 |
IS_IN_TERMINATD_MASTER_PROJECT |
This field is set to "Y" if the Project WBS element is part of the Master Project where every WBS element is terminated (has term code "3"). Otherwise the field is set to "N". This field is populated only starting with fiscal year 2003. |
VARCHAR2 |
1 |
PROJECT_WBS_ID |
Project work breakdown structure element identifier. |
VARCHAR2 |
7 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |