Skip to main content
U.S. flag

An official website of the United States government

Permanent Civil Service (PCS) Appointments

Published by data.sf.gov | City of San Francisco | Catalog Last Checked: November 11, 2026 at 07:16 PM | Dataset Last Updated: November 11, 2026
A. SUMMARYThis dataset contains information about all Permanent Civil Service (PCS) appointments in the City and County of San Francisco, excluding Police Officers (Class Code Q002), since October 15, 2018. Each row represents an appointment, including job class, department, rank on the list, and date of appointment. B. HOW THE DATASET IS CREATEDThe data is pulled from the City's source system of record (PeopleSoft) and distributed via a Snowflake share. C. UPDATE PROCESSThe data is refreshed daily via an scheduled, automated process.D. HOW TO USE THIS DATASETTo use this dataset, analysts should be aware that each row represents a single appointment. The data can be filtered by department, job class, and date of appointment. The rank on the list is also included, which can be used to analyze appointment trends. Learn more about careers with the City and the Permanent Civil Service position type here. E. RELATED DATASETSReference: Department Code List (CON-0027)Employee Compensation (CON-0007)City Employment Classification Definitions (HRD-0007)City Employment Compensation Plan (HRD-0008)Classification Specifications and Pay Ranges (HRD-0004) F. KNOWN USESThis will be used as the mandatory (per Civil Service Commission rules) public posting of PCS appointments. G. RELATED LINKSJob Classification and Compensation Lookup Tool

Resources

3 resources available

Find Related Datasets

Search by Tags

Click any tag below to search for similar datasets

data.gov

An official website of the GSA's Technology Transformation Services

Looking for U.S. government information and services?
Visit USA.gov