Financial

Business area which contains all Institute financial data, including records from transactional systems such as SAP, information about cost collectors, Coeus data, and telecom.

Follow the links in the Tables in Group column to see a list of all the tables used in the star/group, together with information on how to combine the tables in a query.

Follow the links in the Data Model Diagram column (if available) to see a pictorial representation of the star.

Star/Table Group	Description	Tables in Group	Data Model Diagram
Balance Sheet Balances	This contains summary financial information relating to MIT's assets, liabilities, and net assets (also called "net worth" or "fund balance". Data on MIT's revenues, expenses, and operations is available though Balances or Balances_by_fiscal_period.	Balance Sheet Balances tables
Balances	This is good for looking at summary financial information as of yesterday. Balances, budgets, and commitments are included. This is also good for year to year comparisons.	Balances tables
Balances by Fiscal Period	This gives summary point in time financial information. It includes Balances & Budgets. If asking for more than one Fiscal Period, you must be careful using the fields FYTD_AMOUNT & CUM_AMOUNT. This star can also be used to view financial information using an alternative Fiscal Year.	Balances by Fiscal Period tables
Commitment History	This allows for the reporting of commitments as they were at a particular point in time. The history starts with July of 1998.	Commitment History tables
Credit Card	PROTOTYPE: Details about MIT Credit Card transactions.	Credit Card tables
Current Commitments	This shows current open commitments, and allows for distinguishing between LDS, Manual Reservations, Blanket Orders, Requisition Commitments, and PO Commitments.	Current Commitments tables
Financial Detail	This area encompasses all the detailed financial transactions for the institute. Actual and committed dollar amounts can be reported and grouped by various categories such as GL Account, Cost Object, Fiscal Period etc. You will automatically be limited to viewing only those accounts you are authorized to see.	Financial Detail tables
Funds Reporting	This is specific to all funds reporting, by FY only	Funds Reporting tables
OSP Award Costshare	Information about OSP Award Cost Sharing	OSP Award Costshare tables	OSP Award Costshare data model
OSP Award Indirect Cost	Information about OSP Award Indirect Costs	OSP Award Indirect Cost tables	OSP Award Indirect Cost data model
OSP Award Special Review	Information about Osp Award Special Review	OSP Award Special Review tables	OSP Award Special Review data model
OSP Award Terms and Conditions	Information about OSP Award Terms and Conditions	OSP Award Terms and Conditions tables	OSP Award Terms and Conditions data model
OSP Proposal Cost Sharing	Information about OSP Proposal Cost Sharing	OSP Proposal Cost Sharing tables	OSP Proposal Cost Sharing data model
OSP Proposal IDC Rate	Information about OSP Proposal Inderect Cost Rate	OSP Proposal IDC Rate tables	OSP Proposal IDC Rate data model
OSP Proposal Investigator	Information about OSP Proposal Investigator	OSP Proposal Investigator tables	OSP Proposal Investigator data model
OSP Proposals	Information about OSP Proposals	OSP Proposals tables	OSP Proposals data model
OSP Proposals to Award MAP	Information about connection between Proposals and Awards	OSP Proposals to Award MAP tables	OSP Proposals to Award MAP data model
Overhead Rates	PROTOTYPE: Overhead, EB and Lab Allocation rates, as they would have been calculated using the Sap costing sheets.	Overhead Rates tables
Purchasing Detail	This area provides a detailed view of purchase order data down to the account distribution level. In addition, summarized invoiced dollar amounts are included. Information can be limited and grouped by such categories as GL Account, Cost Object, Fiscal Period, Purchase Order Type. You will automatically be limited to viewing only those accounts you are authorized to see.	Purchasing Detail tables
Summary Statement Detail	This shows monthly statement information for a point in time. It includes Authorized Totals, Balances, Budgets and Commitments.	Summary Statement Detail tables
Telephone Detail	This area contains information about all telephone charges.	Telephone Detail tables