Financial 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 |
|---|---|---|---|---|---|---|
Contains data about sources of revenue (funds & fund centers). |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Contains information about all detail transactions as entered into SAP. This is taken from BSEG. It also contains current open commitment transactions taken from COOI. |
Fact |
SAP Financial |
SENSITIVE |
Daily |
01-JAN-2025 |
|
Sub set of cost collectors which represent balance sheet accounts. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
||
GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Contains both Project information from SAP and additional information from COEUS |
Dimension |
OSP - MIT Office of Sponsored Programs |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Describes the type of document that the data is (internal order, purchase order, invoice, etc.) |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Contains data about vendors: vendor name, address, vendor number in SAP, telephone and fax numbers, and other contact information. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Internal Order Dimension. Contains Master data about all Internal Orders |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Profit Center Dimension. Master data information on Profit Centers including name and id. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Contains a list of all SAP posting key codes and their descriptions. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
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 |
01-JAN-2025 |