SF OpenBook
Supplier Contracts Help

The City implemented a new financial and procurement system (PeopleSoft) in July 2017, which provided for additional contract information to be available to the public through SF OpenBook and DataSF.  The Supplier Contracts shown here include new expenditure contracts executed since July 1, 2017 as well as previously executed expenditure contracts where the Contract End Date extended past July 1, 2017.  For contracts that were executed prior to July 1, 2017, only the remaining Contract Authority available balances were converted and are reflected here, unless updated by the Contracting City Department after go-live in July 2017.  For more information regarding any contracts executed prior to July 1, 2017 and for any further details pertaining to individual contracts, please contact the Contracting City Department directly, since they maintain those departmental records.

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

  • * Titled filters indicate mandatory selections.
  • To reduce run time, narrow your results by selecting Fiscal Year(s), Department(s), or Supplier(s).
  • Replace the text "All Supplier Values" with the required supplier value in Supplier filter and click outside the prompt or enter button. The matching supplier results will be displayed in the "Results" filter
  • City Department Spending occurs in three ways:
    1. Department and Supplier agree to a written contract and then Purchase Order is created for all or a discrete set of work. The Purchase Order creates the encumbrance.
    2. Department goes directly to a Purchase Order to establish both terms of agreement and encumbrance.
    3. As an exception to general rule, Department does a direct payment without a contract or purchase order, for non-recurring, one-time expenditures.
  • "Prime Contractors Only" displays each contract with only prime suppliers indicated, whereas "Primes and Subcontractors" lists all known and reported subcontractors participating in the contract with their respective award allocations.
  • Please note that some procurement transactions are structured as direct purchase orders and do not utilize a supplier contract. To review these purchase orders, please use the "Encumbrance Level" view of the Supplier Payments report.
  • Revenue Contracts, including concessions and rental income contracts, are not included in this data set; they are tracked in departmental subsystems and currently are not available in SFOpenBook. For more information about Revenue Contracts, please contact the City department that awards the contract, e.g. for Airport Concession Contracts, contact the San Francisco Airport Commission which maintains these records.
  • The City implemented a new financial and procurement system (PeopleSoft) in July 2017, which provided for additional contract information to be available to the public through SF OpenBook and DataSF.  The Supplier Contracts shown here include new expenditure contracts executed since July 1, 2017 as well as previously executed expenditure contracts where the Contract End Date extended past July 1, 2017.  For contracts that were executed prior to July 1, 2017, only the remaining Contract Authority available balances were converted and are reflected here, unless updated by the Contracting City Department after go-live in July 2017.  For more information regarding any contracts executed prior to July 1, 2017 and for any further details pertaining to individual contracts, please contact the Contracting City Department directly, since they maintain those departmental records.
  • Departments periodically update contract information, such as process contract amendments, update project team subcontractors, liquidate purchase orders to make payment for completed work and do contract amendments and reconciliation. For more information regarding specific contracts and these types of contract activities, please contact the Contracting City Department.
  • Download the full dataset from DataSF.
  • Use browser ← and → to see previous results.

 

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
of0
Word
Excel
PowerPoint
PDF
TIFF file
MHTML (web archive)
CSV (comma delimited)
XML file with report data
Data Feed
Find|Next

Print

Cancel

Done

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