Discoverer was a reporting tool used for all PeopleSoft Databases for many years, it has been retired. Many of the Tables and Views built for Discoverer (Prefix UM_D_) are still in use and accurate as noted in CSPRD - Campus Solutions Production and CSRPT - Campus Solution Reporting.
Detailed Information
Tables and Views Currently available in the Campus Solutions Databases
Discoverer had a long history of providing operational reporting to UMS employees in finance, human resources, and student records; however, Discoverer was no longer being upgraded by Oracle, and support for the product ended. The Discoverer Migration Project was launched to migrate users away from Discoverer.
The Migration and Retirement of Discoverer Project was completed on November 21, 2023
Most reports that existed in Discoverer were recreated in other reporting tools (PS Query or the Power BI tool) so that users across the UMS retained access to the data and reports that they needed for various job functions. This project was not envisioned as an enhancement, but rather as an essential continuation of service.
The project served an enhancing role; namely, if a needed report was more analytical than operational in nature, the report was identified as better suited for a new reporting tool. The project also aimed to develop a more comprehensive understanding of reporting needs across the University of Maine System.
Environment
- PeopleSoft Campus Solutions CSPRD
- PeopleSoft Campus Solutions Reporting CSRPT