[an error occurred while processing this directive]
[an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive]
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.
  • Information about data training and access requirements for specific data sets is available.
  • 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: Contains General Ledger, Budget, and Procurement data as of July 1, 1998. 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.

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.