Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP Proposals


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_PROPOSAL_STATUS

Status for OSP Proposals

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

08-JAN-2020

OSP_PROPOSAL_DETAIL

XXX

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

08-JAN-2020

OSP_ACTIVITY_TYPE

Activity type for OSP Proposal

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

02-MAY-2015

OSP_INVESTIGATOR

OSP Proposal Investigator information

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

02-MAY-2015

PROFIT_CENTER_GROUP

Structure for creating reports of grouped Profit Centers taken from SAP. Multiple hierarchies are represented in the groups.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

SPONSOR

Contains data about each sponsor.

Dimension

SAP Financial

MIT ONLY

Daily

02-MAY-2015

OSP_PROPOSAL_TYPE

Type of OSP Proposal

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

08-JAN-2020