Draft Data Points for Demographic Info Portal - HB 2649.xlsx

XLSX spreadsheet 24 KB Posted Aug 28, 2023

Attached to: MASTER PLAN DEVELOPMENT FOR SALMON HARBOR AND WICNHESTER BAY WATERFRONT
Solicitation number: S-C00100-00007954
Issued by: Douglas County, Oregon

About this file

Written by GovTribe AI · Mar 9, 2026

This is a draft data collection specification document for a Demographic Information Portal related to HB 2649, created for an unspecified state agency managing public improvement contracts. The document outlines a comprehensive data collection framework designed to track workforce demographics and apprenticeship participation across construction projects. The portal will capture general project information (project name, number, county, city, contract dates, and awarded amounts), contractor details (name, contact information, prime contractor status, and apprenticeship employment levels), outreach and recruitment efforts, and aggregate workforce information. The system will collect data on total work hours, worker demographics by gender and race/ethnicity categories (including American Indian/Alaska Native, Asian/Asian American, Black/African American, Portuguese/Brazilian, and Hispanic/Latino workers), and veteran status. The portal is designed to track progress toward an aspirational 15 percent workforce participation target for minorities, women, and veterans on public improvement contracts. Individual worker-level data collection is also specified, requiring capture of worker names, apprenticeship and journeyman hours, occupational classifications, gender identity, race/ethnicity (with multiple selection capability), and veteran status. The document notes the need for batch upload functionality via Excel or common platforms for efficient data entry.

The specification includes detailed requirements for form structure and user interface elements, including fill-in fields, radio buttons, dropdown menus, and conditional logic to display questions based on previous answers. The system must support an "Add a Contractor" feature to duplicate all fields for multiple contractors on a single project, along with corresponding tabs for outreach, recruitment, and worker information. Bulk upload capability for individual worker data through Excel spreadsheets is identified as a necessary feature for each contractor. Several unresolved questions remain embedded in the document through threaded comments, including clarification on methodology for calculating the 15 percent representation target, whether non-veteran status tracking is required, and the appropriate occupational classification systems to employ. The PWR Database will aggregate individual worker information across entire projects based on contract data collected through the portal.

View the file

Other files

File	Type	Posted
RFP 204 Master Plan 8 22 23 JZ.pdf	PDF	Aug 28, 2023

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

General Notes

Technical Specification Requirements

May want to allow for a batch upload via Excel, or some commonly used platform for individual worker information.

PWR Database needs ability to pull in worker information into the aggregate for the entire project after we collect it based on the contract.

General Project Information

General Project Information
Question	Answer Option	Type of Question
Agency Name	Blank	Fill in
Your Name	Blank	Fill in
Your Position	Blank	Fill in
Email	Blank	Fill in
Phone	Blank	Fill in
Address	Blank	Fill in
Project Name	Blank	Fill in
Project Number	Blank	Fill in
Project County	Blank	Fill in
Project City	Blank	Fill in
Date Contract Specifications First Adertised for Bid	Blank	Fll in
Total Amount Awarded	Numerical only	Fill in
Date of Final Payment on the Contract	Blank/Date Field	Fill in
Prime Contractor Name	Blank	Fill in
Project Start Date	Blank/Date Field	Fill in
Project End Date	Blank/Date Field	Fill in
Number of subcontracts with price $750,000 or more.	Numerical only	Fill in.

Contractor Information

Contractor Information
Question	Answer Option	Type of Question
Contractor Name	Blank	Fill in
Contractor Email	Blank	Fill in
Contractor Phone	Blank	Fill in
Contractor Address	Blank	Fill in
Contractor City	Blank	Fill in
Contractor State	Blank	Fill in
Contract Amount	Numerical only	Fill in
Is this contractor a prime contractor?	Yes/No	Radio buttons
Did the contractor employ 12% or more of their workers as apprentices?	Yes/No	Radio buttons
NOTES: The person submitting the form will need to provide the outreach and recruitment; aggregate info and individual worker info for each contractor on the project. We need to add include "Add a contractor" feature that will duplicate all of these fields and subequent tabs (outreach and recruitment, aggregate info and individual worker info).

Outreach and Recruitment

	Outreach and Recruitment Plan
	Prime Contractor/Subcontractor advertised employment opportunities available under the public improvement contract in general circulation publications, trade association publications and publications that serve
an audience or readership that consists primarily of minority individuals, women or veterans	Yes/No	Radio Buttons
	Prime Contractor/Subcontractor conducted initial solicitations of interest by contacting minority individuals, women or veterans who expressed interest in or responded to the initial solicitation to determine with certainty whether the minority individual, woman or veteran is interested in the opportunities	Yes/No	Radio Buttons
	Prime Contractor/Subcontractor provided all persons who express continued interest with adequate information about hiring qualifications, pay rates, benefits, the expected duration of employment, work hours and other conditions of employment under the public improvement contract.	Yes/No	Radio Buttons
	Prime Contractor/Subcontractor made efforts to encourage minority individuals, women and veterans to seek employment under the public improvement contract that the contractor may reasonably expect will produce a level of participation that meets the aspirational target of 15%.	Yes/No	Radio Buttons
	Prime Contractor/Subcontractor used the services of minority community organizations, local, state, federal and tribal governments or other organizations that have recruiting, training and otherwise assisting minority individuals, women and veterans as the organization’s primary purpose or mission to assist the contractor with outreach, recruitment and retention.	Yes/No	Radio Buttons
	Prime Contractor/Subcontractor advertised employment opportunities available under the public improvement contract in general circulation publications, trade association publications and publications that serve
an audience or readership that consists primarily of minority individuals, women or veterans	Yes/No	Radio Buttons

Aggregate Info

Worker Information
Question	Answer Option	Type of Question
At least 15% of the workforce under this contract consisted of minorities, women, and/or veterans.

tc={1ACECB82-B9B7-4172-A945-24CE52D38A23}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

I'm not certain about the phrasing here. The bill specifies "an aspirational target of having individuals in one or more of these groups to compose at least 15 percent of the total number of workers"	Yes/No	Radio Button
	Indicate the total number of hours of work that workers performed under this contract.	Numerical only	Fill in
	Indicate the total number of hours of work that workers performed in each apprenticeable trade or craft under this contract.	Numerical only	Fill in
	Indicate the total numbers of minority individuals, women and veterans who performed construction work under this contract.

tc={7B6DFBC0-2E5F-4279-8064-32521FDF4D37}: [Threaded comment]

Comment:

I'm not sure I understand the point of this. Wouldn't we just calculate this from the other information provided? The goal in the statute is to have at least 15% be represented by at least one of these groups, not a combination.

Also, we need the total number of workers somewhere, don't we?	Numerical only	Fill in
	The number of workers under this contract who identify as female.	Numerical only	Fill in
	The number of workers under this contract who identify as male.	Numerical only	Fill in
	The number of workers under this contract who identify as non binary.	Numerical only	Fill in
	The number of workers under this contract who identify as American Indian/Alaska Native.	Numerical only	Fill in
	The number of workers under this contract who identify as Asian/Asian American.	Numerical only	Fill in
	The number of workers under this contract who identify as Black/African American.	Numerical only	Fill in
	The number of workers under this contract who identify as Portugese/Brazilian.	Numerical only	Fill in
	The number of workers under this contract who identify as Hispanic/Latino.

tc={C847DC88-7596-4DA0-B481-B51AA59CB8A2}: [Threaded comment]

Comment:

Under apprentices (below) we offer the option of white. Is the idea to provide all the options for each category?	Numerical only	Fill in
	The number of workers under this contract who identify as a Veteran.

tc={E19E2F64-2C46-47B0-B4E7-613ED38ED1B3}: [Threaded comment]

Comment:

Do we need to have the number for non-veteran?	Numerical only	Fill in
	Apprentice Information
	Question	Answer Option	Type of Question
	Percentage of workforce that was in a registered apprenticeship program under this contract.

tc={AA13E1D8-8C85-48DE-9948-A9CC6AAC4243}: [Threaded comment]

Comment:

Do we need to know this? I think that the apprenticeship utilization questions all pertain to the number of work hours by trade, not the number of workers.

tc={1ACECB82-B9B7-4172-A945-24CE52D38A23}: [Threaded comment]

Comment:

I'm not certain about the phrasing here. The bill specifies "an aspirational target of having individuals in one or more of these groups to compose at least 15 percent of the total number of workers" tc={7B6DFBC0-2E5F-4279-8064-32521FDF4D37}: [Threaded comment]

Comment:

Also, we need the total number of workers somewhere, don't we?

tc={C847DC88-7596-4DA0-B481-B51AA59CB8A2}: [Threaded comment]

Comment:

Under apprentices (below) we offer the option of white. Is the idea to provide all the options for each category?

tc={E19E2F64-2C46-47B0-B4E7-613ED38ED1B3}: [Threaded comment]

Comment:

Do we need to have the number for non-veteran?	Numerical only	Fill in
	Indicate the total number of hours of work that apprentices performed under this contract.	Numerical only	Fill in
	Indicate the total number of hours of work that apprentices in each trade or craft performed
under this contract.	Numerical only	Fill in
	The total number of hours of work that workers performed in each apprenticeable
trade or craft under this contract.	Numerical only	Fill in
	The number of apprentices on this project who identify as female.	Numerical only	Fill in
	The number of apprentices on this project who identify as male.	Numerical only	Fill in
	The number of apprentices on this project who identify as non binary.	Numerical only	Fill in
	The number of apprentices who identify as American Indian/Alaska Native.	Numerical only	Fill in
	The number of apprentices who identify as Asian/Asian American.	Numerical only	Fill in
	The number of apprentices who identify as Black/African American.	Numerical only	Fill in
	The number of apprentices who identify as Portugese/Brazilian.	Numerical only	Fill in
	The number of apprentices who identify as Hispanic/Latino.	Numerical only	Fill in
	The number of apprentices who identify as White.	Numerical only	Fill in
	The number of apprentices who identify as a Veteran.	Numerical only	Fill in

I'm not certain about the phrasing here. The bill specifies "an aspirational target of having individuals in one or more of these groups to compose at least 15 percent of the total number of workers"

Also, we need the total number of workers somewhere, don't we?

Under apprentices (below) we offer the option of white. Is the idea to provide all the options for each category?

Do we need to have the number for non-veteran?

Do we need to know this? I think that the apprenticeship utilization questions all pertain to the number of work hours by trade, not the number of workers.

Individual Worker Info

Worker Information
Question	Answer Option	Type of Question	Comments/Notes
Worker Name	Blank	Fill in
Indicate the total number of hours the worker performed work as an apprentice.	Blank	Fill in/radio button	Numerical value; and provide a radio button that says "N/A"
Worker Occupation-Apprentice	Blank	Drop down	Only show this question if question above has a number greater than 0 and "N/A" is no selected. Include a note: Select the closest occupation that aligns. We need to provide a list of apprenticeable crafts.
Indicate the total number of hours the worker performed work as a journeyman	Blank	Fill in/radio button	Numerical value; and provide a radio button that says "N/A"
Worker Occupation-Journeyman			Only show this question if question above is "Journeyman." Select the closest occupation that aligns. We need to provide a list of apprenticeable or PWR occupations.
(Gender) Worker identifies as	Blank	Fill in	Options must include: Female; Male; Non-binary
(Race/Ethnicity): Worker identifies as	Drop Down	Select multiple options	Options must include: American Indian/Alaska Native; Portugese/Brazilian; Asian/Asian American; Black/African American; Asian/Asian American; Hispanic/Latinx; White.
(Veteran Status) Worker is a veteran	Blank	Radio Button	Add a note: Veteran is defined as someone who served on active duty with the Armed Forces of the United States for a period of more than 90 consecutive days beginning on or before January 31, 1955, and was discharged or released under honorable conditions; For a period of more than 178 consecutive days beginning after January 31, 1955, and was discharged or released from active duty under honorable conditions; For 178 days or less and was discharged or released from active duty under honorable conditions because of a service-connected disability; For 178 days or less and was discharged or released from active duty under honorable conditions and has a disability rating from the United States Department of Veterans Affairs; or For at least one day in a combat zone and was discharged or released from active duty under honorable conditions;Received a combat or campaign ribbon or an expeditionary medal for service in the Armed Forces of the United States and was discharged or released from active duty under honorable conditions; or

(C)Is receiving a nonservice-connected pension from the United States Department of Veterans Affairs.

NOTES: There should be an option to "bulk upload" individual worker data through an excel spreadsheet for each contractor.

File details come from the government source that posted it. Updated Mar 9, 2026.