Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP Award Terms and Conditions


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

OSP_AWARD_TERMS_DETAIL

Contains the different OSP award terms and conditions from COEUS. For each award, there are one or multiple award terms and conditions.

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

02-MAY-2015

OSP_AWARD_TERMS_TYPE

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

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

08-JAN-2020

OSP_AWARD

Contains all project data for WBS Elements stored in COEUS.

Dimension

OSP - MIT Office of Sponsored Programs

MIT ONLY

Daily

08-JAN-2020