Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Summary Statement Detail


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

GL_ACCOUNT_REPORT

GL Account and Cost Element Dimension with built-in mechanism for organizing in preset Cost Element (GL Account) groups, derived from Cost Element Hierarchies (groups) in SAP. The value in the field Report-Type describes the type of grouping as it is defined in SAP. IMPORTANT: "REPORT TYPE" MUST BE SPECIFIED as a limit, for the query to return correct results. For more details see: GL Account Overview

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

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

PUBLIC

As Needed

14-JUN-2003

SUMMARY_STATEMENT_DETAIL

Summary Statement reporting table which contains data from July 1999 through the current fiscal period. It is similar to Balances by Fiscal Period, except that it contains calculated overhead for those fiscal period(s) where costing sheets have not been run yet. Field RECORD_TYPE contains values "Posted" or "Calculated" and should be used in reports to clarify what the entries are.

Fact

SAP Financial

SENSITIVE

Daily

05-MAR-2009

COST_COLLECTOR_HISTORY

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

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

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

08-JAN-2020