Enterprise Reporting & Data Systems
Enterprise Reporting and Departmental Systems (ERDS) is a group within ITS that manages the data warehouses, reporting tools and data access for administrative systems reporting at the UNC-Chapel Hill. Our mission is to implement a comprehensive robust method for reporting and analytics across the University. These reporting capabilities will enable users to access data and present it in the form that is most useful for student, financial and human resources information.
Enterprise Reporting & Data Systems Service Areas
Oracle’s PeopleSoft is the system on which much of ConnectCarolina is built. The PeopleSoft database will contain a wealth of University information that is entered, maintained and secured for the ultimate purpose of generating timely and meaningful reports. PeopleSoft provides thousands of delivered reports and inquiry screens for real-time reporting. The tools nVision and PSQuery will be used for reporting from the PeopleSoft database.
The enterprise data warehouse at UNC-Chapel Hill is a comprehensive integrated database used for longitudinal reporting and data analysis. It is a central repository of data which is created by integrating data from ConnectCarolina and other systems, including RAMSeS, eCert and SPOTS.
The SAS Business Intelligence (BI) toolset known as the SAS Enterprise Intelligence Suite for Education is being implemented at UNC-Chapel Hill. This will serve as the underlayment for data warehouses and longitudinal reporting for ConnectCarolina.
The SAS BI toolset will be implemented for Campus Solutions reporting in spring 2014 and for Finance and HR/Payroll when those components go live in October 2014.
A number of departments use side systems, referred to as “departmental systems,” to meet reporting and information management needs not currently met by the University’s enterprise systems. Examples of departmental systems include InfoPorte, MIS and ITWorks.
Implementing PeopleSoft will change how data is made available to departmental systems, and it may change the type of data available. Since departmental systems are important to your processes, it’s important to be aware of all changes that affect your systems and to plan for how you will address them.
Authorized departmental systems will have continuous, “near real time” access to PeopleSoft data. Access will be provided through standard data structures, which means access to data will not be tailored to individual departmental systems.
PeopleSoft is the system of record, and departmental systems may not serve may not serve as a “front-end” to PeopleSoft.
Infoporte provides multiple functions for users including an information center; portal to other applications; departmental accounting capabilities; and a variety of other features. The purpose of Infoporte is to allow a variety of users a simplified way to access and store the data and information they need to perform their job functions on a day-to-day basis. New features are added and improvements to the current services are made continually by the Infoporte team.
Legacy Data Warehouses
The legacy Human Resources and Finance data warehouses will experience significant changes with the installation of ConnectCarolina as the University’s new administrative system in October 2014.
Historical data will continue to be housed in a separate warehouse. Because of changes to the chartfields and department numbers, ERDS will provide assistance in bridging between the non-converted historical data and the current data for longitudinal reporting exceeding the conversion data.
As the new data warehouse structure is developed, the legacy data warehouses will be phased out.