OPM through its Data Analysis Group (DAG) provides OPM management, the President, Congress, and many other customers such as, the Government Accountability Office, the Merit Systems Protection Board, the Congressional Research Service, the media, educational institutions, and many agencies with data and analysis from its Enterprise Human Resources Integration-Statistical Data mart (EHRI-SDM) and other data sources (113 process, Work Years and Personnel Costs). This generally takes the form of sending customers raw data, summaries of the raw data, or special reports. Data available to OPM through its EHRI-SDM covers over 2 million Federal civilian employees and has information concerning occupations, agency of employment, salaries, promotions, awards, and many other transactions concerning Federal civilian employees. The Data Analysis Group produces special and recurring reports on a variety of subjects and those reports are available on this website. DAG also processes certain Freedom of Information Requests and customized requests received through its email boxes. DAG uses EHRI-SDM data to provide analysis of policy options (direct hiring authorities, accelerated promotions available to certain occupations, various aspects of hiring reform, veteran hiring, diversity information), legislative changes, and trends in Federal employment.

The Enterprise Human Resources Integration-Statistical Data Mart (EHRI-SDM), was established in FY 2010 and uses data from the Enterprise Human Resources Integration (EHRI), and is the Federal Government's primary source of detailed information about its civilian employees.

The EHRI-SDM is an automated system covering about 96 percent of all Federal civilian non-Postal Executive Branch employees. The data elements in the EHRI-SDM include those reflected on the employee's Standard Form 50, Notification of Personnel Action. The EHRI-SDM system includes information about individuals such as date of birth, sex, race/ethinicity and race, service computation date, tenure, educational level, veterans preference, geographic location of duty, pay plan, grade, salary, occupational series, and supervisory status.  These data elements are maintained and released under strict precautions in adherence with Freedom of Information Act and Privacy Act guidelines.

The EHRI-SDM is comprised of two files, status and dynamics data.  Each are described below.

The Status File records demographic information, job information, the agency of employment and location of employees, and other aspects of the on-board Federal workforce. 

The Dynamics File records personnel actions such as the hiring and separating of employees.

The EHRI-SDM covers most of the non-Postal Federal Executive Branch. Specifically, agency coverage is as below.

Executive Branch coverage includes all agencies except the following:

• Board of Governors of the Federal Reserve
• Central Intelligence Agency
• Defense Intelligence Agency
• Foreign Service personnel at the State Department (included until March 2006)
• National Geospatial-Intelligence Agency
• National Security Agency
• Office of the Director of National Intelligence
• Office of the Vice President
• Postal Regulatory Commission
• Tennessee Valley Authority
• U.S. Postal Service
• White House Office

Other exclusions include:

• Foreign Nationals Overseas
• Public Health Service's Commissioned Officer Corps
• Non-appropriated fund employees

Legislative Branch coverage is limited to the following:

• Dwight D. Eisenhower Memorial Commission
• Financial Crisis Inquiry Commission
• Government Printing Office 
• Medicare Payment Advisory Commission 
• Ronald Reagan Centennial Commission 
• U.S. - China Economic and Security Review Commission 
• U.S. Commission on International Religious Freedom 
• U.S. Tax Court

Judicial Branch is entirely excluded.

The coverage above represents the current coverage of the EHRI-SDM. This coverage is subject to change over time.

Recent significant changes include:

• The Bureau of Consumer Financial Protection, a Federal Reserve component, began reporting in March 2011. 
• The Federal Bureau of Investigation did not report data on personnel actions (dynamics data) until Fiscal Year 2007.
• The State Department stopped providing data on Foreign Service Personnel in March 2006.

EHRI-SDM coverage can differ from that of other Office of Personnel Management (OPM) data sources.

* Hearing impaired users may utilize the Federal Relay Service by dialing 1-800-877-8339** to reach a Communications Assistant (CA). The CA will dial the requested number and relay the conversation between a standard (voice) telephone user and text telephone (TTY) user.

** Visiting the Federal Relay Service website will provide access to additional Toll-Free and Toll Access Numbers.

This document is produced annually and serves as an overview of the size and characteristics of the Federal civilian workforce, enabling reporters, external analysts, and the general public access to commonly requested descriptive information.

The report covers the limitations and nature of OPM data, and uses the data to describe common ways to look at the Federal civilian workforce and how those definitions impact commonly requested facts.

Senior Executive Service Report

The Senior Executive Service Report for Fiscal Year 2010 provides a brief summary of federal employees in Senior Executive Service.

Demographic Profile

The 2006 Demographic Profile of the Federal Workforce publication presents statistical tables and narrative on race and national origin (RNO), gender, disability status, veterans status, age, and years of service characteristics of the Federal civilian non-postal workforce in the Executive Branch of Government.  The data are displayed by agency, major pay plans, general schedule and related grades and occupations.  Data sources, coverage, definitions of terms, and highlights of this survey are presented in the narrative.

Work Years

The Work Years and Personnel Costs publication contains Executive Branch statistics on work years expended, payroll costs by pay system, premium pay costs, fringe benefit expenses, types of leave used and its value, and other compensation items.

This quarterly publication presents data on the Federal civilian workforce by branch, agency, and geographic area. Current information and trends of employment, payroll, and turnover are summarized in detailed statistical tables. Employment and Trends published four times a year (December, March, June, and September).  Previous versions of this publication may be obtained upon request at Fedstats@opm.gov.

The following editions are available:

• December 2011
• September 2011
• June 2011
• March 2011
• December 2010
• September 2010
• June 2010
• March 2010
• September 2009
• July 2009
• May 2009
• March 2009
• January 2009

The three tables are adjusted annually as data becomes available and represent a historical snapshot of the Federal workforce and retirements over time. The three tables include:

Executive Branch Civilian Employment Since 1940 shows employment within the Executive Branch over time excluding uniformed military personnel, the Postal Service, and and intelligence agencies.

Total Government Employment Since 1962 shows employment across the Federal government and includes the Postal Service, uniformed military personnel, the Legislative Branch, and the Judicial Branch.

Executive Branch Retirements of NSFTP Federal Civilian Employees 2000 to present represent the retirement of non-seasonal, full-time permanent employees of the Executive Branch only, and does not include U. S. Postal Service, Legislative or Judicial branches, or intelligence agencies.