Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP Proposal IDC Rate


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

OSP Proposals

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

28-MAR-2024

COST_COLLECTOR

Contains Master data information about all three types of cost collectors (Cost Centers, Internal Orders, & Projects/WBS Elements). It only contains the fields common to all three. Cost Collector is a term synonymous with Cost Object.

Dimension

SAP Financial

MIT ONLY

Daily

28-MAR-2024

OSP_IDC_RATE_TYPE

XXX

Dimension

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

28-MAR-2024

OSP_PROPOSAL_IDC_RATE_DETAIL

OSP Proposal Inderect Cost Detail: on- and off-campus rates, source and destination cost collectors by fiscal year.

Fact

OSP - MIT Office of Sponsored Programs

SENSITIVE

Daily

28-MAR-2024