Data Systems Improvement Initiatives

The Data Systems Improvement Initiatives seek to improve data integrity through development of data management standards and processes to promote data quality as well as implement projects to centralize certain back office financial operations.  Data integrity is critical given the integrated nature of the Banner ERP systems in place at 15 of the system campuses.  

The Human Resources/Payroll project was launched to implement the Banner HR/Payroll module in a standard model across the nine campuses that previously used the State of North Carolina Central Payroll.  These nine campuses transitioned to a Shared Services Center at General Administration for their back office payroll processing.  

It is anticipated that future projects will take advantage of the shared services framework for other financial operations as resources become available.

Data Analysis & Management

Background and Purpose

Data Integrity is critical given the integrated nature of the Banner ERP systems in place at fifteen of the University campuses.  Successful implementation of a standard HR and Payroll model and utilization of a Shared Services Center for back payroll processing is directly related to the quality of data within the existing Banner systems at each of the nine central payroll university entities.  It is the intent of this Standard to assure the quality and correctness of biographic and demographic information associated with HR/PY processes.  The current environment of “data silos” in the various Banner modules has led to questionable data quality which has, in turn led to invalid data, inefficient data management processes, and confusion in the utilization of information.  The UNC FIT project has developed a Data Analysis and Management strategy to guide the development of a data quality and correction plan for the Banner campuses.  Once the data quality and correction plan is implemented for the nine central campuses and the HR/Payroll project is completed, the data analysis and management processes and standards will be implemented in the remaining Banner campuses.

Baseline Standard

The UNC General Administration defined the following baseline standards for Data Quality and Correction to assure the accuracy of data within the Banner systems as part of the Finance Improvement and Transformation project.

  1. Make all corrections to the data within the appropriate data source system.
  2. Assign a data custodian to be responsible for each data element.
  3. Identify, in the case of multiple resources using the same data, a system of official record in which a primary record "feeds" other systems requiring the data element.
  4. Establish a process to ensure the accuracy and quality of data. 

HR Data Mart

Background and Purpose

In June 2009, a University-Wide HR Reporting Task Force was formed. This committee was charged with developing a proposal for the University reporting of required statewide HR information, to replace PMIS. Pursuant to this effort, campuses were asked to recommend changes that would make existing policies and practices more efficient and effective. The resulting inquiry revealed that duplicate data entry into the PMIS was identified as an area that strongly required efficiency review. In April 2010 a proposal was presented to the Office of State Personnel for UNC General Administration to present consolidated reporting of HR data on behalf of all campuses by providing regular snapshots of SPA personnel data.

Over the course of June, July, and August 2011, the HR Data Mart was implemented on all UNC campuses. The HR Data Mart creates a clearinghouse of HR information that will eliminate duplicate entry into the PMIS system, as well as provide constant, timely, and accurate feedback to campuses and GA. Phase 1 targeted SPA employees, followed later this year by Phase 2 for EPA employees.

The HR Data Mart project is sponsored by Jeff Davies, William Fleming, and Gwen Canady. A copy of the project’s organization is attached here. For a general background on the project, along with specific questions on security, procedure, and data elements, please feel free to view our HR Data Mart FAQ. The FAQ is a dynamic document, and will grow as issues arise. 

Authorized university personnel, click here to access the Data Mart ActiveCollab site.  To request access or ask content questions, please contact Keith Dupuis at kedupuis@northcarolina.edu.

Human Resource/Payroll

In April 2011 UNC FIT completed implementation of a new payroll system at nine campuses, transitioning them off the State's Central Payroll system. 

Following a careful assessment, a joint decision was made to move the campuses to an integrated system that would allow the University to centrally process payrolls for all nine campuses using a unified set of best practices to process payroll in a consistent manner. 

The nine UNC campuses served by this initiative are:

  • Elizabeth City State University
  • Fayetteville State University
  • NC Agricultural and Technical State University
  • NC Central University
  • UNC Asheville
  • UNC Pembroke
  • UNC School of the Arts
  • Western Carolina University
  • Winston-Salem State University