Click here to skip navigation
This website uses features which update page content based on user actions. If you are using assistive technology to view web content, please ensure your settings allow for the page content to update after initial load (this is sometimes called "forms mode"). Additionally, if you are using assistive technology and would like to be notified of items via alert boxes, please follow this link to enable alert boxes for your session profile.
An official website of the United States Government.
Skip Navigation

In This Section

Data, Analysis & Documentation Federal Employment Reports

 

Overview

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.

Statistical Data Mart

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.

Common Characteristics of the Government

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.

 

Reports & Publications

Accessions, Separations, and Pay Periods for the Executive Branch

This document presents an overview of Accessions, Separations and Pay Periods for the Executive Branch of the Federal Government, providing the public and analysts access to commonly requested information about the Federal Workforce. This document presents basic data, in the form of tables and graphs, on Accessions, Separations and Pay Period information for the Executive Branch of the Federal Government.

Sizing Up The Executive Branch

The report, Sizing Up The Executive Branch, presents an overview of the size of the Executive Branch of the Federal Government, providing the public and analysts access to commonly requested information about the size of the Federal Workforce. This document presents basic data, in the form of tables and graphs, on the current and historical size of Executive Branch of the Federal Government.

Senior Executive Service Report

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

Major Work Locations of the Executive Branch

The Major Work Locations of the Executive Branch Report presents an overview of the major work locations of the Executive Branch of the Federal Government within the United States, providing the public and analysts access to commonly requested information about the different work locations of the Federal Workforce.

Demographic Profile

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

Note:

To fully understand and use the data provided in these reports, we strongly recommend you review the EHRI-SDM  information.

Employment & Trends

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:

Historical Tables

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.

Control Panel