Financial Data Sets

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 Service Center. An ITS Financial consultant will contact them to provide assistance.

Financial data sets are:

M-Pathways Financial Data Set

Contents

Contains General Ledger, Budget, and Procurement data as of July 1, 1998, and Accounts Receivable and Billing data as of November 2003.

Availability

The data set is generally available noon Sunday–11 p.m. Saturday, except when the data is being refreshed. Refer to the Refresh Schedule for specific refresh times.

Resources

Legacy Financial Data Set

Contents

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.

Usage

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).

Resources

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