link fedscope external javascript file in head Click here to skip navigation
OPM.gov Home  |  Subject Index  |  Important Links  |  Contact Us  |  Help

U.S. Office of Personnel Management - Ensuring the Federal Government has an effective civilian workforce

Advanced Search

Skip FedScope Banner, Top Navigation Links

FedScope - Federal Human Resources Data

Main  |  Data Definitions  |  Help  |  Employment Statistics  |  Join our ListServ
 

Separations Trend Cubes

 Cube Interfaces:
  1. Enhanced

  2. Generic
 Main
Description

This set of fiscal year trend cubes provides access to separation data. The numbers reflect the actual number of personnel actions ("Transfer-Outs" and "Separations from the Federal Service") that have taken place within a given fiscal year. Separations trend cubes are available for:

  1. Latest 6 Fiscal Years to date
  2. Prior history trends starting with Fiscal Year 2005

The following dimensions (workforce characteristics) are available for analysis in these cubes:

  1. Who (about the employees)
    • Age (5 year interval)
    • Gender
    • Length of Service (5 year interval)

  2. What (about their positions)
    • General Schedule and Equivalent Grade
    • Occupation
    • Occupation Category
    • Pay Plan and Grade
    • Salary Level ($10,000 interval)
    • Type of Appointment
    • Work Schedule

  3. Where
    • Agency
    • Location (U.S. State, U.S. Territories, and Foreign Countries)
      • U.S. county excluded starting in Fiscal Year 2004 (2nd Quarter)
    • Metropolitan Statistical Area
      • MSA excluded starting in Fiscal Year 2004 (2nd Quarter)

  4. When
    • Date
      • 12 months in fiscal year

The following three measures (statistics) are available in these cubes:

  1. Count (default measure)
  2. Average Salary
  3. Average Length of Service

Note:  Ethnicity and Race Indicator (ERI) is now available via our new Diversity Cube.

Please read our

[This script opens a new browser window to FedScope Data Definitions; Alternate link to Data Definitions] Data Definitions for each dimension (data element) and measure (statistic) contained within these data cubes.

By default, the first two dimensions (Separation and Date) are displayed as your rows and columns within your data display (crosstab).  You can easily customize your own view for each Separations trend data cube.

Visit our

[This script opens a new browser window to FedScope Help; Alternate link to Help] Help and/or FAQs section(s) for information on "How to use our tool" (e.g. change rows/columns, change measures, filter data, export data to excel, print data (crosstab) to Adobe PDF, and much more).

"Help" available in Adobe Acrobat PDF Format  |  Get Plug-In  Adobe Icon - Link to Adobe Web Site (Acrobat Reader - Download)


Separations Trend Cube Interfaces: Enhanced | Generic

 

Skip bottom navigation, Link to FedScope Main Page Main  | 

[This script opens a new browser window to FedScope Data Definitions; Alternate link to Data Definitions] Data Definitions  | 

[This script opens a new browser window to FedScope Help; Alternate link to Help] Help  |  Employment Statistics  |  Join our ListServ

FAQs  |  About EHRI-SDM  |  Glossary  |  Contact Us  |  OPM.gov Home