Proposal Data Fields Table

Last updated: 2020-07-13

 

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-15-01 and 1311-01-72 will be associated to proposal C1234-15-01.

 

Warning: If the proposal ID is entered incorrectly (e.g., missing the "C" prefix, missing hyphens, etc.), contact the AWP System Administrators immediately so the incorrect proposal ID can be deleted.

Proposal Description Yes The Proposal Description defaults to the project description of the controlling project. The proposal cannot be saved if the proposal description is over 60 characters. Designers may need to edit this field.
Proposal Type of Work Summary No 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 MUST match FIIPS. If this project is federally funded, this ID will be imported from FIIPS. If the field is blank, enter “N/A”. BPD Proposal Management Section staff will update this field during the PSE and plan review stages.
State Project Number Yes Enter the proposal’s lowest 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 No BPD Proposal Management Section staff will select the correct code:
BOTH MBE & WBE GOALS
DBEUse for federally funded projects.
NONE

Use for projects without any federal funding.

(Code Table: DBENOTE)

DBE Goal Percent No

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

WBE Goal Percent No

 

Advertisement Date No BPD Proposal Management Section staff will update this field when the advertisement process takes place.
Previous Proposal ID No

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 No

BPD Proposal Management staff will update this field.

(Code Table: PROPTYP)

Contract Work Type No

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 the funding type that represents the highest percentage funding source from the drop-down list.

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


(Code Table: FUNDTYP)

Proposal Status No This field will be completed by BPD Proposal Management Section staff and shows the current status of the proposal.
Status Date No 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 No This field is to be used only by BPD Proposal Management Section staff to record special comments about the proposal.
Guaranty No 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 No 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 No Historical information from AASHTOWare Project Proposal and Estimates System (PES)
Historical 2 No Historical information from AASHTOWare Project Proposal and Estimates System (PES)
Contract Qualification Class 1 No  
Contract Qualification Class 2 No  
Contract Qualification Class 3 No  
OJT Goal No This field will be used once the Civil Rights and Labor (CRL) module is implemented.
OJT Goal Units No This field will be used once the Civil Rights and Labor (CRL) module is implemented.
On Call Proposal No  
Proposal Funding Total No