Financial Data Sets for Ad Hoc Reporting

New! Concur tables are now available in the Financial data set and several new Concur folders and BusinessObjects reports have been added to the associated FN06 Procurement universe to assist U-M employees using the Concur system or conducting M-Pathways SOA econciliation duties. Read more...

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 ITS Help Desk (dial 734-936-7000, and select option 3). An ITS 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 (June 2010)
• Real-Time Financials Enhancements (August 2008)
• Procurement Table Enhancements (June 2008)
• M-Pathways Accounts Receivable and Billing Data Dictionary (July 2009)
• 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.