This is a Non-Federal dataset covered by different Terms of Use than

Purchase Order Data

Metadata Updated: September 17, 2019

The State Contract and Procurement Registration System (SCPRS) was established in 2003, as a centralized database of information on State contracts and purchases over $5000. eSCPRS represents the data captured in the State's eProcurement (eP) system, Bidsync, as of March 16, 2009. The data provided is an extract from that system for fiscal years 2012-2013, 2013-2014, and 2014-2015 Data Limitations: Some purchase orders have multiple UNSPSC numbers, however only first was used to identify the purchase order. Multiple UNSPSC numbers were included to provide additional data for a DGS special event however this affects the formatting of the file. The source system Bidsync is being deprecated and these issues will be resolved in the future as state systems transition to Fi$cal. Data Collection Methodology: The data collection process starts with a data file from eSCPRS that is scrubbed and standardized prior to being uploaded into a SQL Server database. There are four primary tables. The Supplier, Department and United Nations Standard Products and Services Code (UNSPSC) tables are reference tables. The Supplier and Department tables are updated and mapped to the appropriate numbering schema and naming conventions. The UNSPSC table is used to categorize line item information and requires no further manipulation. The Purchase Order table contains raw data that requires conversion to the correct data format and mapping to the corresponding data fields. A stacking method is applied to the table to eliminate blanks where needed. Extraneous characters are removed from fields. The four tables are joined together and queries are executed to update the final Purchase Order Dataset table. Once the scrubbing and standardization process is complete the data is then uploaded into the SQL Server database. Secondary/Related Resources:

State Contract Manual (SCM) vol. 2 State Contract Manual (SCM) vol. 3 Buying Green United Nations Standard Products and Services Code,

Access & Use Information

Public: This dataset is intended for public access and use. Non-Federal: This dataset is covered by different Terms of Use than License: No license information was provided.

Downloads & Resources


Metadata Created Date September 17, 2019
Metadata Updated Date September 17, 2019

Metadata Source

Harvested from State of California

Additional Metadata

Resource Type Dataset
Metadata Created Date September 17, 2019
Metadata Updated Date September 17, 2019
Publisher California Department of General Services
Unique Identifier ae343670-f827-4bc8-9d44-2af937d60190
Maintainer Email
Public Access Level public
Metadata Context
Schema Version
Catalog Describedby
Harvest Object Id 2468644c-a2eb-4d61-be9e-c2f65766b7bd
Harvest Source Id 653cc362-70fc-46e1-9fb1-e76815ee1c88
Harvest Source Title State of California
Data Last Modified 2019-08-10T10:29:18.775799
Source Datajson Identifier True
Source Hash 0e86b3e0c2dc994a873e98970b5602a72975228c
Source Schema Version 1.1
Category Government

Didn't find what you're looking for? Suggest a dataset here.