Enterprise Human Resources Integration (EHRI)



Design and develop an electronic data warehouse for OPM that contains all human resources (HR), payroll and training data for approximately 2.1 million federal employees dating back to 1972. OPM's Enterprise Human Resource Integration (EHRI) database must serve a variety of functions including managing employee folders, analyzing and forecasting the federal government's workforce, hosting web portals, and providing payroll and benefits information. The key requirement was for a central employee records system that gave employees access to their HR records. The objective of the EHRI program is to improve the availability and accuracy of agency and government-wide statistics and to create a central repository of official employee data.

Customer Challenges:

Initially, EHRI was an e-Gov initiative designed to deliver better data services, eliminate system duplication, and provide HR cost savings government-wide. In the past, agencies performed HR analytics, forecasting, and paper-based personnel file functions, all of which required extensive human intervention and often resulted in inaccuracies due to data retrieval from multiple sources. There were no data standards or processes for maintaining consistency, consolidating HR information, or disseminating HR data across the federal government or even within one single agency. The lack of cohesion made it difficult for agencies to accurately project HR requirements and trends. The goals of better service, system integration and cost savings still exist today. However, new challenges have emerged.

There is an increase in demand for government data not only from federal agencies, but also from researchers, media, and the general public (e.g., reporting the number of Veterans hired by federal agencies). This is evidenced by the implementation of the Presidential Innovation Fellow's Open Data Initiative, a program that aims to make government data public in an effort to fuel private sector products, improve government services, and stimulate job growth. Therefore, not only does the information have to be readily available to the masses through online tools such as OPM's FedScope, but due to the increase in visibility, it is absolutely imperative that data be current and accurate.


Working closely with OPM, COE helped conceive, design, build and manage EHRI, the largest federal data warehousing system ever created. COE developed this massively complex system to serve as a common repository for HR data - previously stored in a non-aggregated, non-integrated assortment of legacy systems of varied functionality. COE helped define HR system standards, compliance and security requirements, analytics, and associated tools. EHRI now supports the federal Human Capital (HC) shared service centers, Statistical Data Mart (EHRI-SDM), payroll, retirement, training, e-Clearance, and other major e-Gov initiatives. In addition, COE played a critical role in developing the electronic-based Official Personnel Folder (eOPF). The eOPF allows federal employees, HR staff, and background investigators to access and view employee employment history and personnel documents.

Using state-of-the-art and cost-saving software development methodologies, including Agile, continuous integration and automated testing, COE builds and deploys several applications. Currently, COE is implementing a host of web services so that systems not currently linked to EHRI (i.e. Defense Technical Information Center) can share data while meeting security, encrypting and compliance requirements.

In partnership with OPM, COE maintains and supports the EHRI system while assisting with strategic imperatives to expand EHRI functionality, accessibility, and user base.


The EHRI system streamlines and automates several business processes by enabling the electronic collection of HR information from federal agencies. It also provides all agencies with consistent process and data standards for consolidating HR data. With paper file scanning standards in place, EHRI provides a government-wide information source to both executive and agency level applications as well as analysis and reporting. Since the conversion to the eOPF, EHRI has significantly reduced the costs associated with managing, transferring, and storing physical personnel file folders.

The initial implementation of EHRI was delivered not only on time and within budget, but it also met all quality assurance requirements.