MAIS Home

Data Reports

Data Sets in the U-M Data Warehouse

Financial Data Sets

Financial Data Sets for Ad Hoc Reporting

The Financial data sets contain reformatted data from the M-Pathways Financials System and the legacy administrative data systems.

• Financial data can be obtained from user-defined ad hoc queries as well as from predefined reports.
• For training and access requirements, see the Online Access Request System (OARS).
• BusinessObjects users who need help with Financial data set reporting should contact the MAIS Help Desk (dial 734-936-7000, and select option 3). A MAIS Financial consultant will contact them to provide assistance.

Financial data sets are:

• M-Pathways Financial Data Set
• Legacy Financial Data Set

M-Pathways Financial Data Set: Contains General Ledger, Budget, and Procurement data as of July 1, 1998, and Accounts Receivable and Billing data as of November 2003. The data set is generally available Sunday, noon - Saturday, 11:00 p.m., except when the data is being refreshed. Refer to the Refresh Information for specific refresh times.

• M-Pathways Financial Data Dictionary (October 2007)
• General Ledger Tables Enhancements (October 2007)
• U-M Data Warehouse Enhancements (April 2007)
• M-Pathways Accounts Receivable and Billing Data Dictionary
  (October 2007)
• Endowment Distribution Information
  • Revenue Expense Endowment Folders Predefined Conditions (March 2006)

Legacy Financial Data Set: Contains five years of revenue and expenditure data through June 1998, summarized at the account balance and account/financial class levels, with drill-down capability into Statement of Account detail and Service Unit Billing detail data. Used, for example, to compute trends in expenditures over time for a school/college, view and reconcile detail behind expenditures on the Statement of Account and Service Unit Billing reports, roll up financial class dollars to support Value-Centered Management, and replicate common hard copy reports (Organization Report, Statement of Account, Service Unit Billing, Class Summary).

• Legacy Financial Data Dictionary (April 2006)
• Information in the General Ledger Conversion Tables Data Dictionary Addendum is now available in the Legacy Financial Data Dictionary.