Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP AWARD TERMS TYPE Table


View exposing award term-type classifications including categories of contractual obligations, administrative terms, and compliance requirements used to organize and systematically track award conditions and obligations.


Field Name

Description

Data Type

Length

OSP_AWARD_TERMS_CODE

Code identifying osp award terms.

VARCHAR2

3

OSP_AWARD_TERMS_DESC

Description of osp award terms.

VARCHAR2

200

OSP_AWARD_TERMS_TYPE

Osp award terms type associated with the record.

VARCHAR2

20

OSP_AWARD_TERMS_TYPE_KEY

Surrogate key identifying the osp award terms type.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE