Commitment History
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 codes and descriptions of material groups used in categorizing items ordered through Purchase Orders. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
A dimension table to be used with commitment fact tables, to identify types of commitments, such as blanket orders or LDS. Also includes commitment type codes and descriptions. |
Dimension |
SAP Financial |
MIT ONLY |
As Needed |
03-JAN-2021 |
|
Cointains commitment information to create views "as of" a certain date, available for dates from July 1999 to present. This table must be joined to the TIME_DAY table, joining the Record_Value_From_Date (use a simple join and select Greater than or Equal) *AND* the Record_Value_Thru_Date (use a simple join and select Less than or Equal) to the Calendar_Date field. |
Fact |
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 |
|
Sub set of cost collectors which represent balance sheet accounts. |
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 |
|
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 |
|
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 |
|
Internal Order Dimension. Contains Master data about all Internal Orders |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
01-JAN-2025 |
|
Daily calendar information. For use in joining tables to include a time dimension to the report. |
Dimension |
PUBLIC |
As Needed |
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 |
|
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 |
|
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 both Project information from SAP and additional information from COEUS |
Dimension |
OSP - MIT Office of Sponsored Programs |
MIT ONLY |
Daily |
01-JAN-2025 |
|
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 |
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 |