Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MITX CO FY ACTIVITY FLAG Table


View exposing MITx fiscal-year activity flags by cost collector and fiscal year.


Field Name

Description

Data Type

Length

COST_COLLECTOR_KEY

Surrogate key identifying the cost collector.

VARCHAR2

12

FISCAL_YEAR

Fiscal year associated with the record.

VARCHAR2

4

FY_ACTIVITY_FLAG

Indicator identifying whether fy activity (Y/N).

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE