Proposal data fields table

Last updated: 2023-07-19

Field

Required

Description

Proposal ID

Yes, entered at proposal creation

The proposal ID is the project number with an uppercase C as the first character. The format is C####-##-## where ####-##-## is the controlling project ID. If there is more than one project associated to the proposal, select the lowest project number for the proposal number. A proposal must still be created even if there is only one project for the contract.

Examples: Projects 1234-01-74 and 1311-01-72 will be associated to proposal C1234-01-74.

Warning: If the proposal ID is entered incorrectly (e.g., missing the "C" prefix, missing hyphens, etc.), contact the AWP System Administrators for assistance.

Proposal Description

Yes

The Proposal Description defaults to the project description of the controlling project. The controlling project description is imported from and must match FIIPS. Must be entered in camel case and limited to 72 characters based on the FIIPS field size limitations (35 character project title + 2 characters for the semi colon and space + 35 character project limits).

Proposal Type of Work Summary

BPD Proposal Management Section staff will enter the type of work summary for this proposal. This information will appear on the Proposal Cover Sheet.

Federal Project Number

Yes

Imported from and must match FIIPS. Based on what appears in FIIPs, enter the following information:

WISC prefix followed by the federal project number.
WISC prefix without the federal project number if it does not appear in FIIPS.
If this field is blank in FIIPS, enter “N/A”. This project may not be federally funded.

BPD Proposal Management Section staff will update this field during the PS&E plan review process.

State Project Number

Yes

Enter the proposal’s lowest Construction Project ID (controlling project ID).

Primary County

Yes

Select the appropriate county from the drop-down list. MUST match FIIPS.

Primary Region

Yes

Select the appropriate region from the drop-down list. MUST match FIIPS.

Design Firm

Imported

If this is a WisDOT in-house design, select WDT000 - WisDOT. If this is a consultant designed project, select the design firm name from the Reference Vendor list. If there are multiple design firms, select the primary design firm. This value is passed to the Construction Contract Project Design Evaluation Report (DQI).

Construction Region Office

Yes

Enter either the region office city or prefix (e.g. GRE, MAD, etc) to locate the region office in the table. The construction region office selected should match the information found in the Plan Letter. See FDM 19-10-15 for information on the Plan Letter. (Code Table: REGOFF)

DBE Goals

BPD Proposal Management Section staff will select the correct code:

BOTH	MBE & WBE GOALS
DBE	Use for federally funded projects.
NONE	Use for projects without any federal funding.

(Code Table: DBENOTE)

DBE Goal Percent

This percentage is determined by BPD Proposal Management Section staff after all the proposals for the letting are compiled.

WBE Goal Percent

Advertisement Date

BPD Proposal Management Section staff will update this field when the advertisement process takes place.

Previous Proposal ID

The previous ID for a proposal that is assigned a new ID so it can be LET a second time.

Contract Type

Yes

Select the appropriate contract type from the drop-down list:

EM	Emergency
LET	LET Contract
LFA	Local Force Account
PBM	Performance Based Maintenance

(Code Table: CONTTYP)

Proposal Type

BPD Proposal Management staff will update this field.

(Code Table: PROPTYP)

Contract Work Type

BPD Proposal Management staff will update this field.

(Code Table: WRKTYP)

Proposal Item Total

System generated

The total estimated cost of all proposal items, calculated by the system as the sum of all low-cost item extended amounts in the proposal.

Contract ID

Yes

Confirm that the contract ID matches the proposal ID.

Type of Funding

Yes

Select a funding type from the drop-down list that represents the highest percentage funding source. If the proposal contains a project with a Federal Project Number, select "FED" for the funding type.

BOND	State Bond
CITY	City Funded
FED	Federal Fund
STAT	State Funds
TOWN	Town Funded
VIL	Village

(Code Table: FUNDTYP)

Proposal Status

This field will be completed by BPD Proposal Management Section staff and shows the current status of the proposal.

Status Date

This date field that will be completed by BPD Proposal Management Section staff and shows the date the status of the proposal was changed.

Proposal Comments

This field is to be used only by BPD Proposal Management Section staff to record special comments about the proposal.

Guaranty

This field is entered by BPD Proposal Management Section staff. It is the amount that a contractor must pay WisDOT if they are awarded a contract and for some reason decide that they cannot fulfill their obligation.

Federal Oversight

This field is entered by BPD Proposal Management Section staff. Select an option from the drop-down list to determine if the contract is to be overseen by FHWA.
D=Design oversight
C=Construction oversight
DC= Design and Construction oversight

Historical 1

Historical information from AASHTOWare Project Proposal and Estimates System (PES)

Historical 2

Historical information from AASHTOWare Project Proposal and Estimates System (PES)

Contract Qualification Class 1

Contract Qualification Class 2

Contract Qualification Class 3

OJT Goal

This field will be used once the Civil Rights and Labor (CRL) module is implemented.

OJT Goal Units

This field will be used once the Civil Rights and Labor (CRL) module is implemented.

On Call Proposal

Proposal Funding Total