Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP Proposal Investigator


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_UNIT

OSP Proposal Unit Investigator

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

08-JAN-2020

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

OSP_INVESTIGATOR

OSP Proposal Investigator information

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

02-MAY-2015

OSP_INVESTIGATOR_DETAIL

XXX

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

02-MAY-2015

OSP_PROPOSAL

OSP Proposals

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

08-JAN-2020