Discoverer Migration and Retirement Project

Body

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

Data Systems

PeopleSoft Campus Solutions  CSPRD
PeopleSoft Campus Solutions Reporting CSRPT

Tables and Views Currently available in the Campus Solutions Databases

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

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. 

Details

Details

Article ID: 158679
Created
Fri 5/10/24 4:24 AM
Modified
Fri 9/13/24 8:30 AM
Applies To
Faculty
Staff
Community