Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PROJECT HISTORY FLAG Table


View exposing project history flag reference values used to identify historical project accounting conditions and reporting states.


Field Name

Description

Data Type

Length

BUD_NOT_EQUAL_CUMEXP_FLAG

Indicator identifying whether bud not equal cumexp (Y/N).

VARCHAR2

1

COST_COLLECTOR_FY_KEY

Surrogate key identifying the cost collector fy.

VARCHAR2

12

FISCAL_YEAR

Fiscal year associated with the record.

VARCHAR2

4

FY_EXPENSES_FLAG1

Fy expenses flag1 associated with the record.

VARCHAR2

1

FY_EXPENSES_FLAG2

Fy expenses flag2 associated with the record.

VARCHAR2

1

IS_IN_TERMINATD_MASTER_PROJECT

Indicator identifying whether in terminatd master project (Y/N).

VARCHAR2

1

PROJECT_WBS_ID

Business identifier for the project wbs.

VARCHAR2

7

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE