1 / 18

O ffice of P ersonnel M anagement O ffice of M erit S ystems O versight and E ffectiveness O ffice of W orkforce I nform

Presents. Summer 2000. O n L ine A nalytic P rocessing. C entral P ersonnel D ata F ile. O ffice of P ersonnel M anagement O ffice of M erit S ystems O versight and E ffectiveness O ffice of W orkforce I nformation. Agenda. Who we are and what we do…. Fed Scope

Audrey
Download Presentation

O ffice of P ersonnel M anagement O ffice of M erit S ystems O versight and E ffectiveness O ffice of W orkforce I nform

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Presents Summer 2000 On Line Analytic Processing Central Personnel Data File OfficeofPersonnelManagement Office ofMeritSystemsOversight andEffectiveness Office ofWorkforceInformation

  2. Agenda • Who we are and what we do…. • FedScope • Coming attractions….

  3. OPM’sOffice of Workforce Information • We provide statistical information about the Federal workforce to the White House, Congress, Federal agencies, media, and interested organizations and individuals. • In order to do that, we establish guidelines for human resource recordkeeping and maintain the Central Personnel Data File (CPDF) System.

  4. CPDF • Government-wide HR MIS since 1972 • Civilian, Executive Branch coverage (1.8 million employees) • Approximately 70 data elements

  5. CPDF (continued) • Data is updated quarterly • Status and Dynamics files • Confidentiality

  6. OWI’s Statistical Products • Seven formal publications • Recurring reports and analyses • 1,000s of ad-hoc information requests each year • Focusing on the World Wide Web

  7. Common Themes from Our Customers • Like our publications, but want data • Ability to customize statistical analysis without waiting for us • Want current and historical data • Need better explanations of the data elements

  8. FedScope • Our response to customer themes: A web-based query and analytical tool to access the most in-demand workforce data • Combines CPDF extract data, a help-rich interface, and an OLAP tool • Individual employee privacy remains fully protected

  9. CPDF Status Data inFedScope • Extract from CPDF • 13 High use data elements • Easy to understand • Protect employee privacy • Who, what, and where of Federal employment

  10. CPDF Status Data inFedScope Who: • Gender • Age (5 year interval) • Length of service (5 year interval)

  11. CPDF Status Data inFedScope(continued) What: • Occupation • Occupation category (PATCO) • Pay plan and grade • Pay level ($10,000 interval) • Work schedule • Type of appointment

  12. CPDF Status Data inFedScope(continued) Where: • Agency • Geographic location (foreign and U.S. state and county) • Metropolitan statistical area (MSA)

  13. CPDF Status Data inFedScope(continued) Measures: • Employment counts • Average salary • Average length of service

  14. CPDF Status Data inFedScope(continued) Extent of Data: • Most current quarterly data as default • Quarterly data for current and prior year • End of fiscal year (FY) data back to 1994

  15. Data Cube Concept • Fast and efficient • Logical top-down exploration • Familiar spreadsheet format

  16. FedScope Let’s go to the FedScope demo...

  17. Coming Attractions…. • Initial FedScope going live soon • FedScopeexpansion • Disclosure avoidance solution • More web-based statistical products

  18. Communicating with Us OPM Office of Workforce Information Website: http://www.OPM.GOV/Feddata E-mail: OWI@OPM.GOV Phone: 202-606-2704

More Related