Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP AWARD TERMS DETAIL Table


View exposing terms and conditions detail associated with sponsored awards including special requirements, compliance obligations, administrative constraints, and restrictions used for contract management and sponsor requirement compliance reporting.


Field Name

Description

Data Type

Length

MIT_AWARD_KEY

Surrogate key identifying the mit award.

VARCHAR2

12

MIT_AWARD_NUMBER

Mit award number associated with the record.

VARCHAR2

12

OSP_AWARD_TERMS_TYPE_KEY

Surrogate key identifying the osp award terms type.

VARCHAR2

9

RECORD_COUNTER

Record counter associated with the record.

NUMBER

28

UPDATE_TIMESTAMP

Timestamp associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

60

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE