Attachment I_Available Data_RFP S-DASOBO-00003117_Statewide Disparity Study.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Statewide Disparity Study
- Solicitation number
- S-DASOBO-00003117
- Issued by
- Marion County, Oregon
About this file
This document is an Attachment I_Available Data from the Oregon Statewide Disparity Study RFP S-DASOBO-00003117. The study will examine public contracting, construction, architecture and engineering, and goods and services procurements under $150,000 and over $150,000 across the state. The study will cover data from 2017-2019 and 2019-2021 for the jurisdictions of Marion County and the City of Salem. The available data includes unique contract numbers, industry categories, contract titles, prime contractor business names, NAICS codes, contract start/end dates, original dollar amounts, total amounts paid, descriptions of services, MWBE status, and limited subcontractor information. The state notes that data availability will vary by agency, with the Oregon Department of Transportation (ODOT) likely having the most comprehensive electronic records.
The pricing and contracting information is primarily housed in the state's ORPIN system, with some agencies also tracking data in local databases and hardcopy files. Subcontractor data may be more limited, with only subcontractor names potentially available. The state notes that the financial system does not easily crosswalk to the procurement data, so reconciling total amounts paid may require additional effort. No information is provided on set-asides, incumbents, funding sources, or renewal options.
View the file
Other files
Show all 13
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Descriptor
| Attachment I_Available Data_RFP S-DASOBO-00003117_Statewide Disparity Study |
| The information provided on this spreadsheet is just for contracts in the Oregon Procurement Information System (ORPIN). |
The State does not have centralized data for purchase orders and data points will vary per agency.
| Please note all assumptions listed at the top of each Tab |
| H = Hardcopy |
| E = Electronic |
| N = No or none |
Public Improvements under $100k
| Attachment I_Available Data_RFP S-DASOBO-00003117_Statewide Disparity Study |
| Assumptions: |
Public Improvements under $100k are conducted at the agency level. The contracts should be in ORPIN, but there is history that demonstrates this doesn't always happen. Some work might need to be done to compare the payments out of the financial system to the contracts in ORPIN to determine if there are physical records to explore in each agency. ODOT does the largest amount of construction work, they will have better electronic records than other agencies and this may be included in their disparity study.
| Prime Contract Data | 2017/2019 | 2019/2021 | Name of File Data is in | Comments |
| Unique contract number or identification code prime contract purchase | Mostly E | Mostly E | ORPIN | |
| Industry category variable for contract/purchase | Mostly E | Mostly E | ORPIN | |
| Contract title | Mostly E | Mostly E | ORPIN | |
| Business name of Prime | Mostly E | Mostly E | ORPIN | |
| NAICS code | ORPIN | We use NIGP codes | ||
| Start date of contract/purchase | Mostly E | Mostly E | ORPIN | |
| End date of contract/purchase | Mostly E | Mostly E | ORPIN | |
| Original dollar amount of prime contract/purchase | Mostly E | Mostly E | ORPIN | |
| Total amount paid to date on contract | H | H | There may be some agencies that have this in some sort of database, but overall the state financial system does not crosswalk to ORPIN | |
| Total contract/purchase amount, inclusive of all change orders (Final amount paid to prime) | H | H | The amount of the contract including amendments will be in ORPIN if the original contract is in ORPIN, but the amount paid is the same answer as above | |
| Short descriptions of services performed or goods supplied by prime contractor | Mostly E | Mostly E | ORPIN | |
| MWBE or non-MWBE status of prime | Mostly E | Mostly E | ORPIN | |
| Race and gene of prime firm owner | N | N | ||
| Prime contractor/vendor contact person for project | Mostly E | Mostly E | ORPIN | |
| Prime contractor/vendor address and telephone number | Mostly E | Mostly E | ORPIN | |
| Prime contractor/vendor email address | Mostly E | Mostly E | ORPIN |
| MWBE Subcontract Data | |||
| Prime contract unique contract number or identification code prime contract/purchase | Mostly H | Mostly H | Some agencies may have this in a database or spreadsheet, but most will have this in the Project manager files |
| Industry category variable for contract/purchase | H/N | H/N | |
| Contract title | Mostly H | Mostly H | |
| Business name of subcontractor/vendor | Mostly H | Mostly H | |
| Start date of contract/purchase | H/N | H/N | |
| End date of contract/purchase | H/N | H/N | |
| Original dollar amount of subcontract | Mostly H | Mostly H | |
| Total amount paid to date to subcontractor | Mostly H | Mostly H | |
| Total contract/purchase amount, inclusive of all change orders (final amount paid to subcontractor) | Mostly H | Mostly H | |
| Short description of services performed or goods supplied by subcontractor | Mostly H | Mostly H | |
| NAICS code for work performed by subcontractor | We use NIGP codes | ||
| Race and gene of subcontractor firm owner | N | N | |
| Subcontractor contact person for project | H/N | H/N | |
| Subcontractor/vendor address and telephone number | H/N | H/N | |
| Subcontractor/vendor email address | H/N | H/N |
Public Improvements over $100k
| Attachment I_Available Data_RFP S-DASOBO-00003117_Statewide Disparity Study |
| Assumptions: |
Public Improvements over $100k are conducted at DAS and at the agency level for those who have independent authority (ie Corrections). The contracts will be in ORPIN. ODOT does the largest amount of construction work, they will have better electronic records than other agencies and this may be included in their disparity study.
| Prime Contract Data | 2017/2019 | 2019/2021 | Name of File Data is in | Comments |
| Unique contract number or identification code prime contract purchase | E | E | ORPIN | |
| Industry category variable for contract/purchase | E | E | ORPIN | |
| Contract title | E | E | ORPIN | |
| Business name of Prime | E | E | ORPIN | |
| NAICS code | ORPIN | We use NIGP codes | ||
| Start date of contract/purchase | E | E | ORPIN | |
| End date of contract/purchase | E | E | ORPIN | |
| Original dollar amount of prime contract/purchase | E | E | ORPIN | |
| Total amount paid to date on contract | H | H | There may be some agencies that have this in some sort of database, but overall the state financial system does not crosswalk to ORPIN | |
| Total contract/purchase amount, inclusive of all change orders (Final amount paid to prime) | H | H | The amount of the contract including amendments will be in ORPIN if the original contract is in ORPIN, but the amount paid is the same answer as above | |
| Short descriptions of services performed or goods supplied by prime contractor | E | E | ORPIN | |
| MWBE or non-MWBE status of prime | E | E | ORPIN | |
| Race and gener of prime firm owner | N | N | ||
| Prime contractor/vendor contact person for project | E | E | ORPIN | |
| Prime contractor/vendor address and telephone number | E | E | ORPIN | |
| Prime contractor/vendor email address | E | E | ORPIN |
| MWBE Subcontract Data | |||
| Prime contract unique contract number or identification code prime contract/purchase | Mostly H | Mostly H | Some agencies may have this in a database or spreadsheet, but most will have this in the Project manager files |
| Industry category variable for contract/purchase | H/N | H/N | |
| Contract title | Mostly H | Mostly H | |
| Business name of subcontractor/vendor | Mostly H | Mostly H | |
| Start date of contract/purchase | H/N | H/N | |
| End date of contract/purchase | H/N | H/N | |
| Original dollar amount of subcontract | Mostly H | Mostly H | |
| Total amount paid to date to subcontractor | Mostly H | Mostly H | |
| Total contract/purchase amoun, inclusive of all change orders (final amount paid to subcontractor) | Mostly H | Mostly H | |
| Short description of services performed or goods supplied by subcontractor | Mostly H | Mostly H | |
| NAICS code for work performed by subcontractor | We use NIGP codes | ||
| Race and gener of subcontractor firm owner | N | N | |
| Subcontractor contact person for project | H/N | H/N | |
| Subcontractor/vendor address and telephone number | H/N | H/N | |
| Subcontractor/vendor email address | H/N | H/N |
A&E
| Attachment I_Available Data_RFP S-DASOBO-00003117_Statewide Disparity Study |
| Assumptions: |
A&E and related services are conducted at the agency level. The contracts should be in ORPIN, but there is history that demonstrates this doesn't always happen. Some work might need to be done to compare the payments out of the financial system to the contracts in ORPIN to determine if there are physical records to explore in each agency. ODOT does the largest amount of this work, they will have better electronic records than other agencies and this may be included in their disparity study.
| Prime Contract Data | 2017/2019 | 2019/2021 | Name of File Data is in | Comments |
| Unique contract number or identification code prime contract purchase | Mostly E | Mostly E | ORPIN | |
| Industry category variable for contract/purchase | Mostly E | Mostly E | ORPIN | |
| Contract title | Mostly E | Mostly E | ORPIN | |
| Business name of Prime | Mostly E | Mostly E | ORPIN | |
| NAICS code | ORPIN | We use NIGP codes | ||
| Start date of contract/purchase | Mostly E | Mostly E | ORPIN | |
| End date of contract/purchase | Mostly E | Mostly E | ORPIN | |
| Original dollar amount of prime contract/purchase | Mostly E | Mostly E | ORPIN | |
| Total amount paid to date on contract | H | H | There may be some agencies that have this in some sort of database, but overall the state financial system does not crosswalk to ORPIN | |
| Total contract/purchase amount, inclusive of all change orders (Final amount paid to prime) | H | H | The amount of the contract including amendments will be in ORPIN if the original contract is in ORPIN, but the amount paid is the same answer as above | |
| Short descriptions of services performed or goods supplied by prime contractor | Mostly E | Mostly E | ORPIN | |
| MWBE or non-MWBE status of prime | Mostly E | Mostly E | ORPIN | |
| Race and gener of prime firm owner | N | N | ||
| Prime contractor/vendor contact person for project | Mostly E | Mostly E | ORPIN | |
| Prime contractor/vendor address and telephone number | Mostly E | Mostly E | ORPIN | |
| Prime contractor/vendor email address | Mostly E | Mostly E | ORPIN |
| MWBE Subcontract Data | |||
| Prime contract unique contract number or identification code prime contract/purchase | Mostly H | Mostly H | Some agencies may have this in a database or spreadsheet, but most will have this in the Project manager files |
| Industry category variable for contract/purchase | H/N | H/N | |
| Contract title | Mostly H | Mostly H | |
| Business name of subcontractor/vendor | Mostly H | Mostly H | |
| Start date of contract/purchase | H/N | H/N | |
| End date of contract/purchase | H/N | H/N | |
| Original dollar amount of subcontract | Mostly H | Mostly H | |
| Total amount paid to date to subcontractor | Mostly H | Mostly H | |
| Total contract/purchase amoun, inclusive of all change orders (final amount paid to subcontractor) | Mostly H | Mostly H | |
| Short description of services performed or goods supplied by subcontractor | Mostly H | Mostly H | |
| NAICS code for work performed by subcontractor | We use NIGP codes | ||
| Race and gener of subcontractor firm owner | N | N | |
| Subcontractor contact person for project | H/N | H/N | |
| Subcontractor/vendor address and telephone number | H/N | H/N | |
| Subcontractor/vendor email address | H/N | H/N |
Goods & Services under $150k
| Attachment I_Available Data_RFP S-DASOBO-00003117_Statewide Disparity Study |
| Assumptions: |
Procurements of Goods & Services, including infomration Technology, under $150k are conducted at the agency level. The contracts should be in ORPIN, but there is history that demonstrates this doesn't always happen. Some work might need to be done to compare the payments out of the financial system to the contracts in ORPIN to determine if there are physical records to explore in each agency. Very little subcontracting data will be available, perhaps the names of subcontractors will be noted in the hard copy files.
| Prime Contract Data | 2017/2019 | 2019/2021 | Name of File Data is in | Comments |
| Unique contract number or identification code prime contract purchase | Mostly E | Mostly E | ORPIN | |
| Industry category variable for contract/purchase | Mostly E | Mostly E | ORPIN | |
| Contract title | Mostly E | Mostly E | ORPIN | |
| Business name of Prime | Mostly E | Mostly E | ORPIN | |
| NAICS code | ORPIN | We use NIGP codes | ||
| Start date of contract/purchase | Mostly E | Mostly E | ORPIN | |
| End date of contract/purchase | Mostly E | Mostly E | ORPIN | |
| Original dollar amount of prime contract/purchase | Mostly E | Mostly E | ORPIN | |
| Total amount paid to date on contract | H | H | There may be some agencies that have this in some sort of database, but overall the state financial system does not crosswalk to ORPIN | |
| Total contract/purchase amount, inclusive of all change orders (Final amount paid to prime) | H | H | The amount of the contract including amendments will be in ORPIN if the original contract is in ORPIN, but the amount paid is the same answer as above | |
| Short descriptions of services performed or goods supplied by prime contractor | Mostly E | Mostly E | ORPIN | |
| MWBE or non-MWBE status of prime | Mostly E | Mostly E | ORPIN | |
| Race and gener of prime firm owner | N | N | ||
| Prime contractor/vendor contact person for project | Mostly E | Mostly E | ORPIN | |
| Prime contractor/vendor address and telephone number | Mostly E | Mostly E | ORPIN | |
| Prime contractor/vendor email address | Mostly E | Mostly E | ORPIN |
| MWBE Subcontract Data | |||
| Prime contract unique contract number or identification code prime contract/purchase | H/N | H/N | Some agencies may have this in a database or spreadsheet, but most will have this in the contract administrator files |
| Industry category variable for contract/purchase | H/N | H/N | |
| Contract title | H/N | H/N | |
| Business name of subcontractor/vendor | H/N | H/N | |
| Start date of contract/purchase | H/N | H/N | |
| End date of contract/purchase | H/N | H/N | |
| Original dollar amount of subcontract | H/N | H/N | |
| Total amount paid to date to subcontractor | H/N | H/N | |
| Total contract/purchase amoun, inclusive of all change orders (final amount paid to subcontractor) | H/N | H/N | |
| Short description of services performed or goods supplied by subcontractor | H/N | H/N | |
| NAICS code for work performed by subcontractor | We use NIGP codes | ||
| Race and gener of subcontractor firm owner | N | N | |
| Subcontractor contact person for project | H/N | H/N | |
| Subcontractor/vendor address and telephone number | H/N | H/N | |
| Subcontractor/vendor email address | H/N | H/N |
Goods & Services over $150k
| Attachment I_Available Data_RFP S-DASOBO-00003117_Statewide Disparity Study |
| Assumptions: |
Procurements of Goods & Services over $150k are primarily conducted at DAS. ODOT and DHS/OHA have delegated authority up to $5million, and Forestry has authority delegated up to $1million. The contracts will be in ORPIN. Very little subcontracting data will be available, perhaps the names of subcontractors will be noted in the hard copy files.
| Prime Contract Data | 2017/2019 | 2019/2021 | Name of File Data is in | Comments |
| Unique contract number or identification code prime contract purchase | E | E | ORPIN | |
| Industry category variable for contract/purchase | E | E | ORPIN | |
| Contract title | E | E | ORPIN | |
| Business name of Prime | E | E | ORPIN | |
| NAICS code | ORPIN | We use NIGP codes | ||
| Start date of contract/purchase | E | E | ORPIN | |
| End date of contract/purchase | E | E | ORPIN | |
| Original dollar amount of prime contract/purchase | E | E | ORPIN | |
| Total amount paid to date on contract | H | H | There may be some agencies that have this in some sort of database, but overall the state financial system does not crosswalk to ORPIN | |
| Total contract/purchase amount, inclusive of all change orders (Final amount paid to prime) | H | H | The amount of the contract including amendments will be in ORPIN if the original contract is in ORPIN, but the amount paid is the same answer as above | |
| Short descriptions of services performed or goods supplied by prime contractor | E | E | ORPIN | |
| MWBE or non-MWBE status of prime | E | E | ORPIN | |
| Race and gener of prime firm owner | N | N | ||
| Prime contractor/vendor contact person for project | E | E | ORPIN | |
| Prime contractor/vendor address and telephone number | E | E | ORPIN | |
| Prime contractor/vendor email address | E | E | ORPIN |
| MWBE Subcontract Data | |||
| Prime contract unique contract number or identification code prime contract/purchase | H/N | H/N | Some agencies may have this in a database or spreadsheet, but most will have this in the contract administrator files |
| Industry category variable for contract/purchase | H/N | H/N | |
| Contract title | H/N | H/N | |
| Business name of subcontractor/vendor | H/N | H/N | |
| Start date of contract/purchase | H/N | H/N | |
| End date of contract/purchase | H/N | H/N | |
| Original dollar amount of subcontract | H/N | H/N | |
| Total amount paid to date to subcontractor | H/N | H/N | |
| Total contract/purchase amoun, inclusive of all change orders (final amount paid to subcontractor) | H/N | H/N | |
| Short description of services performed or goods supplied by subcontractor | H/N | H/N | |
| NAICS code for work performed by subcontractor | We use NIGP codes | ||
| Race and gener of subcontractor firm owner | N | N | |
| Subcontractor contact person for project | H/N | H/N | |
| Subcontractor/vendor address and telephone number | H/N | H/N | |
| Subcontractor/vendor email address | H/N | H/N |
File details come from the government source that posted it. Updated .