Return to search results
Purchase Order Data
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 http://www.dgs.ca.gov/pd/Resources/publications/SCM2.aspx
State Contract Manual (SCM) vol. 3 http://www.dgs.ca.gov/pd/Resources/publications/SCM3.aspx
Buying Green http://www.dgs.ca.gov/buyinggreen/Home.aspx
United Nations Standard Products and Services Code, http://www.unspsc.org/
Resources
3 resources available
-
Purchase Order Data 2012-2015
CSV -
Purchase Order Acquisition Methods
DOCX -
Data Dictionary
PDF
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "admin",
"@type": "vcard:Contact",
"hasEmail": "mailto:opencalifornia@govops.ca.gov"
}
|
| description | <p>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</p> <p><strong>Data Limitations:</strong><br /> 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.</p> <p><strong>Data Collection Methodology:</strong></p> <p>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.</p> <p><strong>Secondary/Related Resources:</strong></p> <ul> <li>State Contract Manual (SCM) vol. 2 <a href="http://www.dgs.ca.gov/pd/Resources/publications/SCM2.aspx">http://www.dgs.ca.gov/pd/Resources/publications/SCM2.aspx</a></li> <li>State Contract Manual (SCM) vol. 3 <a href="http://www.dgs.ca.gov/pd/Resources/publications/SCM3.aspx">http://www.dgs.ca.gov/pd/Resources/publications/SCM3.aspx</a></li> <li>Buying Green <a href="http://www.dgs.ca.gov/buyinggreen/Home.aspx">http://www.dgs.ca.gov/buyinggreen/Home.aspx</a></li> <li>United Nations Standard Products and Services Code, <a href="http://www.unspsc.org/">http://www.unspsc.org/</a></li> </ul> |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "Purchase Order Data 2012-2015",
"format": "CSV",
"mediaType": "text/csv",
"describedBy": "https://data.ca.gov/api/action/datastore_search?resource_id=bb82edc5-9c78-44e2-8947-68ece26197c5&limit=0",
"downloadURL": "https://data.ca.gov/dataset/ae343670-f827-4bc8-9d44-2af937d60190/resource/bb82edc5-9c78-44e2-8947-68ece26197c5/download/purchase-order-data-2012-2015-.csv",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"title": "Purchase Order Acquisition Methods",
"format": "DOCX",
"mediaType": "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
"downloadURL": "https://data.ca.gov/dataset/ae343670-f827-4bc8-9d44-2af937d60190/resource/5e902af0-0e21-4e07-b65f-bdf1c709d00f/download/purchase-order-acquisition-methods.docx"
},
{
"@type": "dcat:Distribution",
"title": "Data Dictionary",
"format": "PDF",
"mediaType": "application/pdf",
"downloadURL": "https://data.ca.gov/dataset/ae343670-f827-4bc8-9d44-2af937d60190/resource/748ba069-54a3-46cd-830c-0230a977ccc5/download/data-dictionary.pdf"
}
]
|
| identifier | ae343670-f827-4bc8-9d44-2af937d60190 |
| issued | 2019-08-10T10:28:34.983612 |
| keyword |
[
"Commodity Title",
"DVBE",
"Department",
"Desktop Computers",
"Gasoline",
"IT Goods",
"IT Services",
"Ink Cartridges",
"Item Description",
"Item Name",
"Medical Training Services",
"Non-IT Goods",
"Non-IT Services",
"Notebook Computers",
"Paper",
"Photocopiers",
"Public Health Administration",
"SB",
"Statewide Contracts",
"Supplier Name",
"Toner",
"UNSPSC"
]
|
| modified | 2019-10-23T17:49:54.864004 |
| publisher |
{
"name": "California Department of General Services",
"@type": "org:Organization"
}
|
| theme |
[
"Government"
]
|
| title | Purchase Order Data |
