Attachment I_Available Data_RFP S-DASOBO-00003117_Statewide Disparity Study.xlsx
XLSX spreadsheet 22 KB Posted
- Attached to
- Statewide Disparity Study -Notice of Award
- Solicitation number
- S-DASOBO-00003832
- Issued by
- Marion County, Oregon
About this file
This document is the Attachment I: Available Data for the Statewide Disparity Study RFP S-DASOBO-00003117 issued by the State of Oregon. The study will examine the contracting practices and utilization of minority, women, and disadvantaged business enterprises (MWDBEs) across the state, including at the county and city level for jurisdictions such as Marion County and the City of Salem. The data provided covers various contract types including public improvements under and over $100k, architectural and engineering services, and goods and services contracts under and over $150k. The contract data available spans fiscal years 2017/2019 and 2019/2021. The document outlines the type of information that can be expected to be found in the Oregon Procurement Information System (ORPIN) and through other agency records, including unique contract numbers, industry categories, contract titles, business names, NAICS codes, contract dates, dollar amounts, MWDBE status, and limited subcontractor data.
The document indicates that the quality and completeness of the data will vary across agencies, with the Oregon Department of Transportation (ODOT) likely having the most comprehensive electronic records compared to other state agencies. The state's financial system does not easily cross-reference the contract data in ORPIN, so additional effort may be required to determine total amounts paid on contracts. The study will be used to assess potential disparities in the state's procurement practices and identify any barriers to MWDBE participation.
View the file
Other files
Show all 15
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 .