Table · dataset · 2019
Purchase Order Data
Listed in California Open 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.
Description
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.
Read the rest (4 more)
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 dgs.ca.gov/pd/Resources/publications/SCM2.aspx State Contract Manual (SCM) vol. 3 dgs.ca.gov/pd/Resources/publications/SCM3.aspx Buying Green dgs.ca.gov/buyinggreen/Home.aspx United Nations Standard Products and Services Code, unspsc.org/
Links
Get the data
- Purchase Order Acquisition Methods data.ca.gov/dataset/ae343670-f827-4bc8-9d44-2af937d60190/resource/5e902af0… ↗
download · from data ca gov
- Data Dictionary data.ca.gov/dataset/ae343670-f827-4bc8-9d44-2af937d60190/resource/748ba069… ↗
download · from data ca gov
- Purchase Order Data 2012-2015 data.ca.gov/dataset/ae343670-f827-4bc8-9d44-2af937d60190/resource/bb82edc5… ↗
download · from data ca gov
Where it is published
- California Open Data dataset page data.ca.gov/dataset/purchase-order-data ↗
landing page · from data ca gov
Catalogue records · 1
- CKAN API data.ca.gov/api/3/action/package_show?id=ae343670-f827-4bc8-9d44-2af937d60… ↗
metadata API · from data ca gov
Topics
- Stated by source
- Government
- From keywords
- Medicine & Health · Social Science
- Inferred from text
- Tabular 65%
Provenance · 1 source records, 9 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| California Open Data | ae343670-f827-4bc8-9d44-2af937d60190 | 13 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| concepts[field].local:field:medicine-health | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[field].local:field:social-science | mapping · data ca gov | connector:data_ca_gov@1.0.0 | |
| concepts[modality].local:modality:tabular | enrichment · data ca gov | keyword-concept-rules@1.0.0 | title+description (65%) |
| concepts[topic].ckan_group:data_ca_gov:government | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| created_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| description | source · data ca gov | connector:data_ca_gov@1.0.0 | /notes |
| publication_date | source · data ca gov | connector:data_ca_gov@1.0.0 | |
| title | source · data ca gov | connector:data_ca_gov@1.0.0 | /title |
| updated_date | source · data ca gov | connector:data_ca_gov@1.0.0 |