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.
PeopleSoft Campus Solutions CSPRD PeopleSoft Campus Solutions Reporting CSRPT
UM_D_ACAD_PG_VW - DO NOT USE - Please use ACAD_PROG - Student Academic Program UM_D_ACD_PRV_VW - DO NOT USE - Please use ACAD_PROG - Student Academic Program UM_D_ADDRESS_VW - Address Type UM_D_APPL_PG_VW - Admission Applicant Program UM_D_CLASS_VW - Class Session and Student Enrollment UM_D_CLSS_ASC_V - Associated Classes with Student Requirement Status Detail UM_D_CLSS_ATT_V - Course Attributes UM_D_CLSS_INSTV - Instructors with Role Assignments UM_D_COMM_VW - DO NOT USE - Please use COMMUNICATION - Communication Data UM_D_CRSE_OFF_V - Course Catalog and Course Offering Details UM_D_MIN_TERMS - Student Minimum Terms UM_D_PERSCHK_VW - Person Checklist UM_D_PRS_CMT_VW - DO NOT USE - Please use PERSON_COMMENT - Person Comment UM_D_STD_ENR This core table is NOT public UM_D_STD_ENR_VW - Student Enrollment Table UM_D_UNITS_VW - Total Student Credit Hours by Institution
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.
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.