Employee Compensation

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.sfgov.org
Id 88g8-5mnd
Name Employee Compensation
Attribution SF Controller’s Office
Category City Management and Ethics
Tags spending, fte, staffing, sfopenbook, open book, openbook, employee, compensation, salary, salaries, benefits
Created 2014-08-05T19:50:44Z
Publication Date 2014-10-06T15:32:09Z

Description

The San Francisco Controller’s Office maintains a database of the salary and benefits paid to City employees since fiscal year 2013. This data is summarized and presented on the Employee Compensation report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on a bi-annual basis when available for each fiscal and calendar year.

Columns

| Included | Schema Type    | Field Name              | Name                    | Data Type | Render Type |
| ======== | ============== | ======================= | ======================= | ========= | =========== |
| Yes      | series tag     | year_type               | Year Type               | text      | text        |
| Yes      | time           | year                    | Year                    | number    | text        |
| Yes      | series tag     | organization_group_code | Organization Group Code | text      | text        |
| Yes      | series tag     | organization_group      | Organization Group      | text      | text        |
| Yes      | series tag     | department_code         | Department Code         | text      | text        |
| Yes      | series tag     | department              | Department              | text      | text        |
| Yes      | series tag     | union_code              | Union Code              | text      | text        |
| Yes      | series tag     | union                   | Union                   | text      | text        |
| Yes      | series tag     | job_family_code         | Job Family Code         | text      | text        |
| Yes      | series tag     | job_family              | Job Family              | text      | text        |
| Yes      | series tag     | job_code                | Job Code                | text      | text        |
| Yes      | series tag     | job                     | Job                     | text      | text        |
| Yes      | series tag     | employee_identifier     | Employee Identifier     | text      | text        |
| Yes      | numeric metric | salaries                | Salaries                | number    | number      |
| Yes      | numeric metric | overtime                | Overtime                | number    | number      |
| Yes      | numeric metric | other_salaries          | Other Salaries          | number    | number      |
| Yes      | numeric metric | total_salary            | Total Salary            | number    | number      |
| Yes      | numeric metric | retirement              | Retirement              | number    | number      |
| Yes      | numeric metric | health_dental           | Health/Dental           | number    | number      |
| Yes      | numeric metric | other_benefits          | Other Benefits          | number    | number      |
| Yes      | numeric metric | total_benefits          | Total Benefits          | number    | number      |
| Yes      | numeric metric | total_compensation      | Total Compensation      | number    | number      |

Time Field

Value = year
Format & Zone = yyyy

Data Commands

series e:88g8-5mnd d:2016-01-01T00:00:00.000Z t:department_code=MTA t:job_family="Information Systems" t:union_code=021 t:organization_group="Public Works, Transportation & Commerce" t:job_family_code=1000 t:year_type=Calendar t:organization_group_code=02 t:union="Prof & Tech Engineers - Miscellaneous, Local 21" t:job_code=1094 t:employee_identifier=17958 t:department="Municipal Transportation Agency" t:job="IT Operations Support Admin IV" m:salaries=117510.21 m:total_benefits=45214.66 m:other_salaries=0 m:total_salary=117510.21 m:overtime=0 m:total_compensation=162724.87 m:retirement=21644.26 m:health_dental=13890.29 m:other_benefits=9680.11

series e:88g8-5mnd d:2013-01-01T00:00:00.000Z t:department_code=SHF t:job_family="Correction & Detention" t:union_code=498 t:organization_group="Public Protection" t:job_family_code=8300 t:year_type=Fiscal t:organization_group_code=01 t:union="Deputy Sheriffs' Association" t:job_code=8304 t:employee_identifier=52828 t:department=Sheriff t:job="Deputy Sheriff" m:salaries=86639.89 m:total_benefits=32978.45 m:other_salaries=12053.91 m:total_salary=100733.67 m:overtime=2039.87 m:total_compensation=133712.12 m:retirement=19154.26 m:health_dental=12178.5 m:other_benefits=1645.69

series e:88g8-5mnd d:2015-01-01T00:00:00.000Z t:department_code=POL t:job_family="Airport Operation" t:union_code=790 t:organization_group="Public Protection" t:job_family_code=9200 t:year_type=Fiscal t:organization_group_code=01 t:union="SEIU - Miscellaneous, Local 1021" t:job_code=9209 t:employee_identifier=5834 t:department=Police t:job="Community Police Services Aide" m:salaries=65243.42 m:total_benefits=33396.85 m:other_salaries=6443.63 m:total_salary=71687.05 m:overtime=0 m:total_compensation=105083.9 m:retirement=15899.92 m:health_dental=12285.03 m:other_benefits=5211.9

Meta Commands

metric m:salaries p:double l:Salaries d:"Normal salaries paid to permanent or temporary City employees." t:dataTypeName=number

metric m:overtime p:float l:Overtime d:"Amounts paid to City employees working in excess of 40 hours per week." t:dataTypeName=number

metric m:other_salaries p:double l:"Other Salaries" d:"Various irregular payments made to City employees including premium pay, incentive pay, or other one-time payments." t:dataTypeName=number

metric m:total_salary p:double l:"Total Salary" d:"The sum of all salaries paid to City employees." t:dataTypeName=number

metric m:retirement p:float l:Retirement d:"City contributions to employee retirement plans." t:dataTypeName=number

metric m:health_dental p:float l:Health/Dental d:"City-paid premiums to health and dental insurance plans covering City employees. To protect confidentiality as legally required, pro-rated citywide averages are presented in lieu of employee-specific health and dental benefits." t:dataTypeName=number

metric m:other_benefits p:float l:"Other Benefits" d:"Mandatory benefits paid on behalf of employees, such as Social Security (FICA and Medicare) contributions, unemployment insurance premiums, and minor discretionary benefits not included in the above categories." t:dataTypeName=number

metric m:total_benefits p:float l:"Total Benefits" d:"The sum of all benefits paid to City employees." t:dataTypeName=number

metric m:total_compensation p:double l:"Total Compensation" d:"The sum of all salaries and benefits paid to City employees." t:dataTypeName=number

entity e:88g8-5mnd l:"Employee Compensation" t:attribution="SF Controller's Office" t:url=https://data.sfgov.org/api/views/88g8-5mnd

property e:88g8-5mnd t:meta.view d:2017-09-25T07:22:28.275Z v:averageRating=0 v:name="Employee Compensation" v:attribution="SF Controller's Office" v:attributionLink=http://openbook.sfgov.org v:id=88g8-5mnd v:category="City Management and Ethics"

property e:88g8-5mnd t:meta.view.license d:2017-09-25T07:22:28.275Z v:name="Open Data Commons Public Domain Dedication and License" v:termsLink=http://opendatacommons.org/licenses/pddl/1.0/

property e:88g8-5mnd t:meta.view.owner d:2017-09-25T07:22:28.275Z v:displayName="Alex Levitsky" v:id=9ufn-6bwh v:screenName="Alex Levitsky"

property e:88g8-5mnd t:meta.view.tableauthor d:2017-09-25T07:22:28.275Z v:displayName="Alex Levitsky" v:roleName=editor v:id=9ufn-6bwh v:screenName="Alex Levitsky"

Top Records

| year_type | year | organization_group_code | organization_group                       | department_code | department                      | union_code | union                                           | job_family_code | job_family                    | job_code | job                            | employee_identifier | salaries  | overtime | other_salaries | total_salary | retirement | health_dental | other_benefits | total_benefits | total_compensation | 
| ========= | ==== | ======================= | ======================================== | =============== | =============================== | ========== | =============================================== | =============== | ============================= | ======== | ============================== | =================== | ========= | ======== | ============== | ============ | ========== | ============= | ============== | ============== | ================== | 
| Calendar  | 2016 | 02                      | Public Works, Transportation & Commerce  | MTA             | Municipal Transportation Agency | 021        | Prof & Tech Engineers - Miscellaneous, Local 21 | 1000            | Information Systems           | 1094     | IT Operations Support Admin IV | 17958               | 117510.21 | 0        | 0              | 117510.21    | 21644.26   | 13890.29      | 9680.11        | 45214.66       | 162724.87          | 
| Fiscal    | 2013 | 01                      | Public Protection                        | SHF             | Sheriff                         | 498        | Deputy Sheriffs' Association                    | 8300            | Correction & Detention        | 8304     | Deputy Sheriff                 | 52828               | 86639.89  | 2039.87  | 12053.91       | 100733.67    | 19154.26   | 12178.5       | 1645.69        | 32978.45       | 133712.12          | 
| Fiscal    | 2015 | 01                      | Public Protection                        | POL             | Police                          | 790        | SEIU - Miscellaneous, Local 1021                | 9200            | Airport Operation             | 9209     | Community Police Services Aide | 5834                | 65243.42  | 0        | 6443.63        | 71687.05     | 15899.92   | 12285.03      | 5211.9         | 33396.85       | 105083.9           | 
| Fiscal    | 2015 | 01                      | Public Protection                        | JUV             | Juvenile Probation              | 790        | SEIU - Miscellaneous, Local 1021                | 8300            | Correction & Detention        | 8321     | Counselor, Log Cabin Ranch     | 56898               | 66669.06  | 15775.58 | 4647.39        | 87092.03     | 15703.85   | 11282.47      | 1743.62        | 28729.94       | 115821.97          | 
| Calendar  | 2013 | 03                      | Human Welfare & Neighborhood Development | DSS             | Human Services                  | 535        | SEIU - Human Services, Local 1021               | 2900            | Human Services                | 2903     | Eligibility Worker             | 7681                | 31512     | 0        | 0              | 31512        | 5738.33    | 6219.89       | 2478.63        | 14436.85       | 45948.85           | 
| Calendar  | 2013 | 04                      | Community Health                         | DPH             | Public Health                   | 250        | SEIU - Health Workers, Local 1021               | 2300            | Nursing                       | 2303     | Patient Care Assistant         | 17717               | 68391     | 184.28   | 7903.01        | 76478.29     | 14371.57   | 12918.25      | 6274.81        | 33564.63       | 110042.92          | 
| Fiscal    | 2016 | 04                      | Community Health                         | DPH             | Public Health                   | 021        | Prof & Tech Engineers - Miscellaneous, Local 21 | 1000            | Information Systems           | 1054     | IS Business Analyst-Principal  | 46914               | 76377.4   | 1922.25  | 0              | 78299.65     | 13847.17   | 7431.74       | 6290.41        | 27569.32       | 105868.97          | 
| Calendar  | 2016 | 06                      | General Administration & Finance         | CPC             | City Planning                   | 351        | Municipal Executive Association - Miscellaneous | 0900            | Management                    | 0953     | Dep Dir III                    | 22679               | 188098.73 | 0        | 0              | 188098.73    | 33742.71   | 13890.29      | 19286.45       | 66919.45       | 255018.18          | 
| Calendar  | 2013 | 02                      | Public Works, Transportation & Commerce  | HHP             | PUC Hetch Hetchy                | 790        | SEIU - Miscellaneous, Local 1021                | 1400            | Clerical, Secretarial & Steno | 1406     | Senior Clerk                   | 39888               | 47526.62  | 0        | 0              | 47526.62     | 10754.37   | 12918.25      | 3848.48        | 27521.1        | 75047.72           | 
| Calendar  | 2016 | 04                      | Community Health                         | DPH             | Public Health                   | 250        | SEIU - Health Workers, Local 1021               | 2700            | Housekeeping & Laundry        | 2736     | Porter                         | 11388               | 61166.31  | 2982.95  | 4090.65        | 68239.91     | 11268.4    | 13890.29      | 5643           | 30801.69       | 99041.6            |