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
- Financial data can be obtained from user-defined
ad hoc queries as well as from predefined
- Information about data
training and access requirements for specific data sets is
- 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.