Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Overhead Rates


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

GL_ACCOUNT

GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

COST_COLLECTORS_ACCESSIBLE

Contains Master data information about all three types of cost objects (Cost Centers, Internal Orders, & Projects/WBS Elements). It contains the fields common to all three, and additional fields such as surcharge percentage and overrun information. This table will only return information about cost collectors that you have been granted access to.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

SURCHARGE_PERCENTAGES

Contains Overhead, EB, and Lab Allocation rates as they would have been calculated by the SAP costing sheets yesterday.

Fact

SAP Financial

SENSITIVE

Daily

08-JAN-2020