MIT Data & Reporting Services

 

data warehouse logo Funds Reporting


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

TIME_MONTH

Monthly calendar information. For use in joining tables to include a time dimension to the report. Use the Time_Month_Key to join.

Dimension

Data Warehouse

PUBLIC

As Needed

14-JUN-2003

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

29-SEP-2009

FUNDS_REPORTING

Departmental funds reporting data

Fact

SAP Financial

SENSITIVE

Monthly

10-NOV-2009

COST_COLLECTOR_HISTORY

Contains the history of Cost Collector Data by fiscal period and fiscal year.

Dimension

SAP Financial

MIT ONLY

Daily

01-DEC-2009