Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP AWARD TERMS TYPE Table


Dimension table contains the different types of OSP award terms and conditions.


Field Name

Description

Data Type

Length

OSP_AWARD_TERMS_CODE

Award terms code for the different award terms and conditions.

VARCHAR2

3

OSP_AWARD_TERMS_DESC

Description for the award terms code of the different award terms and conditions.

VARCHAR2

200

OSP_AWARD_TERMS_TYPE

This field identifies the types of award terms and conditions (eg. equipment approval, invention, prior approval, property, publication, referenced document, rights in data, subcontract approval, and travel restriction).

VARCHAR2

30

OSP_AWARD_TERMS_TYPE_KEY

Use this field to join the OSP_AWARD_TERMS_DETAIL and the OSP_AWARD_TERMS_TYPE tables for the information of OSP award terms and conditions.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8