SF OpenBook
Employee Compensation Help

After making required and optional filter and output column selections, click "View Report" to proceed.

  • * Titled filters indicate mandatory selections.
  • If we want specific departments, uncheck "Select All" and then select the specific departments.
  • Use either Job Family, Union, or Search and set "Filter Results" to "Y" to narrow the list of Jobs and then select specific jobs from the Job list.
  • To reduce run time, select one or more Job Families or Unions and select Filter Results as "Y" to report on all the jobs in the selected Families or Unions.
  • Use the Employee Name Search prompt for searching SF Open Book using only employee’s name.
    • Type employee’s name (all or part of an employee’s name) in the “Employee Name Search” field then click “View Report”. This prompt is not case sensitive.
  • Use browser ← and → to see previous results.
  • Please note the following definitions of compensation categories listed on the report:
    • Other Pay: Includes various one-time and miscellaneous salary payments, such as wage-based premium adjustments and vacation accrual payouts to separated employees, pursuant to negotiated Labor Agreements.
    • Other Benefits: Includes other employer-paid benefits and costs, such as required, employer-share of Social Security and Medicare taxes, and life and long-term disability insurance premiums, pursuant to negotiated Labor Agreements.
  • City Employee Compensation Reports by Calendar and Fiscal Year are also available on DataSF (https://data.sfgov.org/City-Management-and-Ethics/Employee-Compensation/88g8-5mnd).

Report Viewer Configuration Error

The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file. Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> to the system.web/httpHandlers section of the web.config file, or add <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> to the system.webServer/handlers section for Internet Information Services 7 or later.

Browser not supported

Report Viewer requires a standards compliant browser. Users of Internet Explorer 8 and earlier should switch to a modern browser, or if already using a modern browser target standards mode by adding the <meta http-equiv="X-UA-Compatible" content="IE=edge" > header tag to the host page.

Loading...
Cancel
  • Contact SFGov
  • -
  • Accessibility
  • -
  • Policies
@City and County of San Francisco ©2000-2020