Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP SUBAWARD STATUS Table


View exposing subaward status tracking including active, pending, closed status indicators and effective dates used for subaward lifecycle management.


Field Name

Description

Data Type

Length

STATUS_DESCRIPTION

Description of status.

VARCHAR2

200

SUBAWARD_STATUS_CODE

Code identifying subaward status.

NUMBER

SUBAWARD_STATUS_KEY

Surrogate key identifying the subaward status.

NUMBER

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE