Reporting capabilities are provided to users through the PeopleSoft reporting instance and UM Reports. As of November 2008, EFS is creating a limited number of reports in UM Reports which will also be available in the PeopleSoft reporting instance. The decision to use UM Reports is a result of feedback from users. Click here to read the November 18 announcement regarding UM Reports.

PeopleSoft delivers equivalent financial reporting and information provided by the Data Warehouse, UM Reports, and Financial Reports on the Web. Historical data will continue to be accessible via the Data Warehouse, but post-July 2008 financial data will be available only through the new financial system. (Human resources and student system data will continue to be stored in the Data Warehouse.)

The new financial system has two environments for reporting on financial activities: a production environment and a reporting environment. Operational, transactional reporting requiring real-time data occurs in the production environment. The reporting environment is streamlined and is designed for queries and reporting and will be refreshed nightly.

Access to the production environment is based upon an employee's role. All users with access to the production environment also have access to the reporting environment. Those with no production role may obtain access to the reporting environment by completing an access request form.

An important point to keep in mind is that there is not an apples-to-apples comparison between the financial reporting capabilities provided by current systems and the financial reporting capabilities under PeopleSoft. These are vastly different types of systems. PeopleSoft is a Web-based system with multiple capabilities for generating and creating reports. The number of reports available is nearly endless. Departments will likely use a predetermined set of canned reports.

In the old financial system, transaction information for sponsored and nonsponsored accounts resided in the General Ledger. In the new financial system, sponsored data also is located in the PeopleSoft Projects module. For sponsored accounts, inception-to-date transactions was converted from the CUFS General Ledger to the Projects module for any activity associated with an active award/contract (contracts that have an end date after June 30, 2008 or have not been fully closed out). Summary balances for all sponsored accounts were converted in to the new financial system General Ledger as of FY08. For nonsponsored accounts, summary balances onlywere converted into the new financial system General Ledger as of FY08. Post go-live, detailed historical transactional information will be viewable in the financial Data Warehouse.

Several types of reporting tools will be available to users in the new financial system, based on a user's reporting responsibilities and system access. Follow this link for a brief summary of the reporting tools.