Balances
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 |
|---|---|---|---|---|---|---|
Contains both Project information from SAP and additional information from COEUS |
Dimension |
OSP - MIT Office of Sponsored Programs |
MIT ONLY |
Daily |
08-MAY-2024 |
|
Sub set of cost collectors which represent balance sheet accounts. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
08-MAY-2024 |
|
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-MAY-2024 |
|
Contains a record for each project work breakdown structure element (WBS Element). Can be used for browsing, establishing limits on fact table queries and providing descriptive information about WBS Elements. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
08-MAY-2024 |
|
Contains MIT Cost Center Ids and related information. It can be used for browsing, establishing limits on fact table queries, and providing descriptive information about Cost Centers. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
08-MAY-2024 |
|
Contains financial information, balance & budget data by cost collector ID as of yesterday. Use this table to view a current balance, or to compare several past fiscal years in total. Normally the limit selected for this table is by Fiscal Year. (Taken from SAP tables COSP & COSS.) |
Fact |
SAP Financial |
SENSITIVE |
Daily |
08-MAY-2024 |
|
Contains data about sources of revenue (funds & fund centers). |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
07-MAY-2024 |
|
Subset of cost collectors defined as Sponsored or Non-Sponsored Funds. (This table should not be confused with SAP funds or fund centers.) |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
08-MAY-2024 |
|
Structure for creating reports which rollup by Profit Center or Profit Center Node. Taken from SAP's Profit Center Hierarchy. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
08-MAY-2024 |
|
Internal Order Dimension. Contains Master data about all Internal Orders |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
08-MAY-2024 |
|
GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
08-MAY-2024 |
|
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-MAY-2024 |
|
Profit Center Dimension. Master data information on Profit Centers including name and id. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
08-MAY-2024 |