Supplier Contracts

The San Francisco Controller's Office maintains a database of contracts and payments made to Suppliers (vendors, contractors and grantees). The Supplier Contracts shown here include all fully executed, expenditure-only contracts, including City contracts for commodities, professional and general services, and construction from fiscal year 2018 forward, based upon the contracting departments' inputs. This data set includes both departmental and citywide contracts.

This data is presented on the Supplier Contracts report hosted at http://openbook.sfgov.org, and is also available in CSV format, which lists summary data by contract. We have removed sensitive contracts and information from this data in order to balance disclosure requirements and protected/confidential data. For example, we have removed contracts related to certain legal proceedings that are exempt from disclosure. New data is added on a weekly basis.

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 SF Open Book. For more information about Revenue Contracts, please contact the respective City Department that awards the contract, e.g. for Airport Concession Contracts, contact the San Francisco Airport Commission which maintains these records.

City Department spending may occur three ways: 1) from Contract to Purchase Order (i.e. a PO with an accounting Encumbrance) to Payment (i.e. an accounting Voucher), AKA On-Contract spending, 2) direct-to-Purchase Order (no contract, only a PO agreement and accounting Encumbrance) to Payment, and 3) Direct Voucher Payment (for limited one-time, non-recurring payments, e.g. a membership or a subscription). Therefore, it is helpful to use both the Supplier Contracts and Supplier Payments reports on SFOpenBook, as well as on DataSF.

The data included in the Supplier Contracts dataset reflects supplier expenditure contracts that were awarded by City Departments after 7/1/2017, the date the City & County of San Francisco implemented the PeopleSoft Financial & Procurement System, as well as the remaining not-to-exceed contract authority for all supplier expenditure contracts that were still active along with their associated purchase order (PO) available, unexpended balances as of 7/1/2017. For partially used contract authority, the Contract Award Amount only includes the portion that was unutilized and available as of 7/1/2017, unless the Contract Award Amount was updated by the department after July 1, 2017. Contracts that were expired before 7/1/2017 as well as contracts that had no remaining contracting authority from which to issue new purchase orders were not converted or loaded into PeopleSoft. For information requests regarding the latter as well as for the portion of contract of authority used prior to 7/1/2017 for otherwise unexpired contract balances that were converted and still active as of 7/1/2017, please contact the City department(s) that issued the contract.

旧金山财政总监办公室维护着一个供应商（供应商、承包商和受托人）的合同和付款数据库。此处展示的供应商合同包括所有已完全执行的、仅涉及支出的合同，涵盖从2018财年开始的城市商品、专业和一般服务以及建筑合同，这些数据基于各合同部门的输入。该数据集包含部门级和全市范围的合同。

此数据在http://openbook.sfgov.org上提供的供应商合同报告中呈现，并以CSV格式提供，列出了按合同汇总的数据。为了在披露要求与受保护/机密数据之间取得平衡，我们已从数据中移除了敏感合同和信息。例如，我们移除了某些免于披露的法律诉讼相关的合同。新数据每周定期更新。

收入合同，包括特许经营和租赁收入合同，不包括在本数据集中；它们在部门子系统中进行追踪，目前不在SF Open Book中提供。如需了解收入合同的相关信息，请联系授予合同的相应市政府部门，例如，对于机场特许经营合同，请联系维护这些记录的旧金山机场委员会。

市政府部门的支出可能以三种方式发生：1）从合同到采购订单（即带会计预留的采购订单）到付款（即会计凭证），称为合同内支出，2）直接到采购订单（无合同，仅有采购订单协议和会计预留）到付款，以及3）直接凭证付款（适用于有限的、非重复的一次性支付，例如会员费或订阅费）。因此，使用SFOpenBook和DataSF上的供应商合同和供应商付款报告将十分有益。

供应商合同数据集中的数据反映了市政府部门于2017年7月1日之后授予的供应商支出合同，以及截至2017年7月1日的所有仍处于有效状态的供应商支出合同的剩余未用合同授权额度及其相关采购订单（PO）的未使用余额。对于部分使用的合同授权额度，合同授予金额仅包括截至2017年7月1日未使用的、可用的部分，除非该部门在2017年7月1日之后更新了合同授予金额。2017年7月1日之前已过期的合同以及无剩余合同授权额度以发放新采购订单的合同未被转换或加载到PeopleSoft中。如需查询有关上述信息以及2017年7月1日之前使用的合同授权额度（对于2017年7月1日之前已转换并仍处于有效状态的未到期合同余额）的相关信息，请联系签发合同的市政府部门。