sfgov/purchasing-commodity-data-ebsh-uavg

  • amount
  • commodity
  • procurement
  • purchase order
  • purchasing
  • + 2

Purchasing Commodity Data

Purchasing Commodity Data

The San Francisco Controller's Office maintains a database of purchasing activity from fiscal year 2007 forward. This data is presented on the Purchasing Commodity Data report in CSV format, and represents detailed commodity-level data by purchase order. Additional lines have been added to this dataset to reconcile some document totals from the City's purchasing system to the totals from the City's accounting system in cases when the two amounts are different, which sometimes occurs due to adjustments entered into the accounting system but not the purchasing system. We have removed sensitive information from this data – this is intended to show payments made to entities providing goods and services to the City and County and to protect individuals. For example, we have removed payments to employees (reimbursements, garnishments) and jury members, revenue refunds, payments for judgments and claims, witnesses, relocation and rehousing, and a variety of human services payments. New data is added on a weekly basis.

Supplier payments represent payments to City contractors and vendors that provide goods and/or services to the City. Certain other non-supplier payee payments, which are made to parties other than traditional City contractors and vendors, are also included in this dataset, These include payments made for tax and fee refunds, rebates, settlements, etc.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Encumbered Amountencumbered_amountencumbered_amountTextThe dollar amount of goods or services to be purchased under the terms of the Purchase Order.
Encumbered Quantityencumbered_quantityencumbered_quantityTextThe quantity of goods or services to be purchased under the terms of the Purchase Order. For some non-discrete purchases, like professional service contracts, the Encumbered Quantity is zero.
Supplier Phonevendor_phonevendor_phoneTextThe contact phone number address that the City has on file for the vendor
Supplier Emailvendor_emailvendor_emailTextThe contact email address that the City has on file for the vendor
Supplier Cityvendor_cityvendor_cityTextThe city that the City has on file for the vendor
Commodity Titlecommodity_titlecommodity_titleTextCommodity is a highly detailed descriptor used to define types of goods and services procured by the City and County of San Francisco. It is unrelated to the Object hierarchy used in other datasets in that Commodity is more detailed and is used only for purchasing activities, whereas Object is more general and is used for accounting purposes.
Post Date - Currentpost_date_currentpost_date_currentTextPost Date – Current represents the most recent date on which the document posted to the City and County of San Francisco’s accounting system. This may be the same as Post Date – Original, or it may be a later date in cases where the document is changed and reposted subsequent to the original posting.
Post Date - Originalpost_date_originalpost_date_originalTextPost Date – Original represents the date on which the document first posted to the City and County of San Francisco’s accounting system.
Purchasing Department Titlepurchasing_department_titlepurchasing_department_titleTextPurchasing department represents an organizational unit used by the City and County of San Francisco for purchasing activities. It differs from the Department field used in other datasets in that Department is used for accounting purposes and conforms to the Organization hierarchy, whereas Purchasing Department is used only for purchasing and may have a different naming convention or unstandardized level of detail.
Contract Titleagreement_titleagreement_titleTextThe title of the contract associated with the purchase order.
Contract Numberagreement_noagreement_noTextThe unique identifier of the contract associated with the purchase order
Purchase Order Linepurchase_order_linepurchase_order_lineTextA Purchase Order line is used to allocate a portion of the money reserved by the Purchase Order for a specific type of good or service. Each Purchase Order Line is associated with a Commodity, and each Purchase Order may have one or more Purchase Order Lines.
Purchase Orderpurchase_orderpurchase_orderTextA Purchase Order is a document that reserves a specific amount of money for payment to a vendor for a specific purpose.
Purchase Order Datepo_dtpo_dtTextThe date on which the purchase order was issued.
Fiscal Yearfiscal_yearfiscal_yearTextAn accounting period of 12 months. The City and County of San Francisco operates on a fiscal year that begins on July 1 and ends on June 30 the following year. The Fiscal Year ending June 30, 2012 is represented as FY2011-2012.
Supplier ZIP Codevendor_zip_codevendor_zip_codeTextThe zip code that the City has on file for the vendor
Supplier & Other Non-Supplier Payeesvendor_namevendor_nameTextAn organization that the City pays in return for goods or services.
Purchasing Departmentpurchasing_departmentpurchasing_departmentTextPurchasing department represents an organizational unit used by the City and County of San Francisco for purchasing activities. It differs from the Department field used in other datasets in that Department is used for accounting purposes and conforms to the Organization hierarchy, whereas Purchasing Department is used only for purchasing and may have a different naming convention or unstandardized level of detail.
Supplier Streetvendor_streetvendor_streetTextThe street address that the City has on file for the vendor
Commodity Codecommodity_codecommodity_codeTextCommodity is a highly detailed descriptor used to define types of goods and services procured by the City and County of San Francisco. It is unrelated to the Object hierarchy used in other datasets in that Commodity is more detailed and is used only for purchasing activities, whereas Object is more general and is used for accounting purposes.
Supplier Contactvendor_contactvendor_contactTextThe contact person that the City has on file for the vendor
Supplier Statevendor_statevendor_stateTextThe state that the City has on file for the vendor

Upstream Metadata