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. |
|
|
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 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. |
|
|
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. |
|
|
Current Commitments |
This shows current open commitments, and allows for distinguishing between LDS, Manual Reservations, Blanket Orders, Requisition Commitments, and PO Commitments. |
|
|
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. |
|
|
Funds Reporting |
This is specific to all funds reporting, by FY only |
|
|
Overhead Rates |
PROTOTYPE: Overhead, EB and Lab Allocation rates, as they would have been calculated using the Sap costing sheets. |
|
|
Summary Statement Detail |
This shows monthly statement information for a point in time. It includes Authorized Totals, Balances, Budgets and Commitments. |
|
|
Telephone Detail |
This area contains information about all telephone charges. |
|