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

This set of cubes provides trend data on the employee population.  Like our Employment cubes, the numbers reflect the actual number of employees as of a specific point in time.  Two Employment Trend cubes are available:

1. "Year-to-Year" (Five most recent end of fiscal year (September) files)
2. "Quarter-to-Quarter" (Five most recent quarters)

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

1. Who (about the employees)
   • Gender
   • Age (5 year interval)
     
     
2. What (about their positions)
   • Occupation
   • Occupation Category
   • Pay Plan
     • Used in place of  the Pay Plan and Grade dimension from the Employment cube
   • General Schedule and Related Grade
   • Work Status (Limited to "Non-Seasonal Full Time Permanent" and "Other Employees")
     • Used in place of  the Work Schedule and Type of Appointment dimensions from the Employment cube
       
       
3. Where
   • Agency
   • Area (Limited to "Inside DC Metropolitan Area", "Outside DC Metropolitan Area", and "Unspecified")
     • Used in place of the Location dimension from the Employment cube
       
       
4. When
   • Most Current Quarter
     • Latest five September quarters ("Year-to-Year" cube)
     • Latest five quarters ("Quarter-to-Quarter" cube)

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

1. Employment counts (default measure)
2. Average Salary

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 (Agency and Most Current Quarter) are displayed as your rows and columns within your data display (crosstab).  You can easily customize your own view for each Employment 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 

Employment Trend Cube Interfaces: Enhanced | Generic