Code Table Definitions

This topic provides a description and sample code values for each code table used in the reference data.

ACCEPTANCEMETHOD – Acceptance Method

The codes in this code table represent values indicating the procedure by which the sample is to be accepted.

Example code table values and descriptions follow:

CERT – Certificate of Compliance

IAS – Independent Assurance

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ActionRelationship	AcceptanceMethod	Acceptance Method
SampleRecord	AcceptanceMethod	Acceptance Method
DwrAcceptanceRecord	AcceptanceMethod	Acceptance Method

ACTIONTYPE – Acceptance Action Type

The codes in this code table represent values indicating the kind of action that may exist for materials or items.

Example code table values and descriptions follow:

Cert – Certification

MaterialTest – Material Test

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ActionRelationship	ActionType	Action Type
DwrAcceptanceRecord	ActionType	Action Type

ADDRTYP – Address Type

Each vendor can have multiple addresses, including e-mail and street addresses. The system uses the codes in the ADDRTYP code table to identify the type or purpose of a given vendor address.

Example code table values and descriptions follow:

SHIP - Shipping address (headquarters)

BILL - Billing address

DIST - District office address

FLD - Field trailer address

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Address	AddressType	Address Type
OutboxUnifiedAddress	AddressType	Address Type
RefVendorAddress	AddressType	Address Type

ADJTYP – Adjustment Type

The codes in this code table represent values indicating the kind of price adjustment being applied to the item.

Example code table values and descriptions follow:

Fuel – Fuel Adjustment

Price – Price Adjustment

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefPriceIndexAdjustment	AdjustmentType	Adjustment Type

ADTLSTATUS – Contract Claim Additional Status

The codes in this code table represent values indicating the supplemental status of the claim.  

Example code table values and descriptions follow:

Research – Additional research required

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractClaim	AdditionalStatus	Additional Status

AGENCY – Agency

The codes in this code table represent values indicating the transportation agency associated with the reference item for whom the UIC code is being defined.

Example code table values and descriptions follow:

ALDOT – Alabama Department of Transportation

AKDOT - Alaska Department of Transportation & Public Facilities

AZDOT - Arizona Department of Transportation

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ItemClassification	Agency	Agency

AGENCYTIME – Agency Time

The codes in this code table represent values indicating the type of contract time as classified by the agency.

Example code table values and descriptions follow:

CRIT – Critical Dates

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefContractTime	AgencyType	Agency Type
ContractTime	AgencyType	Agency Type

ANNUALGROSSRECEIPT – Annual Gross Receipt

The codes in this code table represent values indicating the monetary range of work performed by the vendor.

Example code table values and their descriptions are as follows:

1 - Less than $1 Million

2 - Between $1 and 5 Million

3 - Between $5 and 10 Million

4 - Between $10 and 15 Million

5 - More than $15 Million

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	RangeAnnualGrossReceipt	Range Annual Gross Receipt

APPRLEVELTYPE – Approval Level Type

The codes in this code table represent values indicating the type of approval level for a source.

Example code table values and descriptions follow:

1 – Type 1 Approval

2 – Type 2 Approval

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Source	ApprovalLevelType	Approval Level Type

APPROVALSTATUS – Approval Status

The codes in this code table represent values indicating the approval status of the material from the source.

Example code table values and descriptions follow:

Approved - Approved

Suspended - Suspended

The following table lists the system fields that access this code table.

 

Entity	Column	Label
SourceMaterial	ApprovalStatus	Approval Status
SourceMaterialCategory	ApprovalStatus	Approval Status
FacilityMaterial	ApprovalStatus	Approval Status
FacilityMaterialCategory	ApprovalStatus	Approval Status

BIDCLS – Bid Classification Code Values

The codes in this code table represent values indicating why a vendor's bid was deemed irregular.

Example code table values and their descriptions are as follows:

1 - Proposal Form Altered

2 - Unauthorized Additions

3 - Unauthorized Deletions

4 - Unbalanced Bid

5 - Exceeds Max. Bid Price

The following table lists the system fields that access this code table.

 

Entity	Column	Label
BidClass	BidClassificationCode	Bid Classification Code

BIDSTAT – Status of Bid

Use the codes in the BIDSTAT code table to identify the status of a vendor's bid on a particular proposal.

Example code table values and descriptions follow:

L - Loser

W - Winner

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Proposal Vendor	BidStatus	Bid Status

BIDTYPE – Status of Bid Received

The codes in this code table are used to identify the type or status of each bid received.  

Example code table values and their descriptions are as follows:

ORIG - Original Bid

LATE - Late Bid

NONQ - Not Qualified

A000 - Original Bid

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ProposalVendor	BidType	Bid Type

BRDGTYP – Bridge Type

The codes in this code table are used to identify the type of bridge or bridge structure under construction.  

Example code table values and their descriptions are as follows:

CONC - Concrete Bridge

STEL - Steel Bridge

120 - Concrete slab hollow - rehab

360 - Steel girder rolled beam - new

The following table lists the system fields that access this code table.

 

Entity	Column	Label
BridgeSegment	BridgeType	Bridge Type

BUDCLASS – Budget Class

The codes in this code table represent values indicating a high-level budget group to which the item belongs.  

Example code table values and descriptions follow:

Class 1 – First Budget Class

Class 2 – Second Budget Class

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimateItem	BudgetClass	Budget Class
Concept	BudgetClass	Budget Class
BudgetClassMapping	BudgetClass	Budget Class
CostEstimate	BudgetClass	Budget Class

BUYUSAREQUIREMENTS – Buy USA Requirements Type

The codes in this code table represent values indicating documentation required to accept materials for the Buy American Act.

Example code table values and descriptions follow:

Buy America - Buy American iron, steel, and manufactured goods

Waiver 1 - Inconsistent with public interest

The following table lists the system fields that access this code table.

 

Entity	Column	Label
SampleRecord	BuyUSARequirements	Buy USA Requirements

CAPACITYUNITS – Capacity Units

The codes in this code table are used to identify the units of measure used for the supplies being hauled by this truck type.

Example code table values and their descriptions are as follows:

Cubic Yards - Cubic Yards

Loads - Loads

Tons - Tons

The following table lists the system fields that access this code table.

 

Entity	Column	Label
EOMTruckType	CapacityUnits	Capacity Units

CERTTYP – Type of Vendor Certification

The codes in this code table are used to identify the type(s) of certification a vendor possesses.

Example code table values and their descriptions are as follows:

CERT - Certified

WBE - Woman Business Enterprise

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	CertificationType	Certification Type

CHRG – Cash/Charge

The codes in this code table are used to identify the method a planholder will use to pay for a set of plans being purchased.  

Example code table values and their descriptions are as follows:

CHRG - Charge

CASH - Cash

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Purchase	CashChargeCode	Cash/Charge Code

CITIZENSTATUS – Citizenship Status

The codes in this code table are used to identify the employee’s citizenship or immigration status that establishes his right to work in the United States.

Example code table values and their descriptions are as follows:

1 - US

2 - Non US

3 - Other

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorOfficer	CitizenshipStatus	Citizenship Status
RefEmployee	CitizenshipStatus	Citizenship Status

CLAIMCAT – Contract Claim Category

The codes in this code table represent values indicating the category of claim as classified by the agency.

Example code table values and descriptions follow:

General – General Claim

Insurance – Insurance Claim

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractClaim	Category	Contract Claim Category

CNAWDRS – Reason for Non-Processing

The codes in this code table are used to identify the reason for not processing or continuing with a particular letting.  

Example code table values and their descriptions are as follows:

ERRB - Errors in bids

HIGH - Over percentage limit

NONR - Nonresponsive bids

WITH - Letting withdrawn

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Proposal	NPR	Reason for Non-Processing

CNCPTSTAT – Concept Status

The codes in this code table represent values indicating the relative phase of the concept.

Example code table values and descriptions follow:

Conceptual – Conceptual

Programmed - Programmed

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimateSnapshot	Status	Status Indicator
Concept	Status	Status Indicator

CONSTSTKPILETRNSTYPE – Construction Stockpile Transaction Type

The codes in this code table represent values indicating the type of construction stockpile transaction.

Example code table values and descriptions follow:

Initial – Initial Delivery

Reduction – Reduction of Stockpile

Replenish – Replenish Stockpile

The following table lists the system fields that access this code table.

 

Entity	Column	Label
StockpileTransaction	Type	Transaction Type

CONTCLS – Contracting Classification

The codes in this code table are used to identify the possible types or classifications of contracts in which you can use an item.  

Example code table values and their descriptions are as follows:

BCS - Bituminous Concrete Surface

CRE - Common Roadway Excavation

URE - Unclassified Roadway Excavation

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefItem	ContractClass	Contract Classification

CONTROLTYPE – Control Type

The codes in this code table represent values indicating an identifier for a sample.

Example code table values and descriptions follow:

A – Control Type A

B – Control Type B

The following table lists the system fields that access this code table.

 

Entity	Column	Label
SampleRecord	ControlType	Control Type

CONTTYP – Type of Contract

The codes in this code table are used to identify the type or classifications of contract that a proposal will become.  

Example code table values and their descriptions are as follows:

BID - Biddable Contract

SAFE - Safety Contract

PRIM - Prime Contract

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Proposal	ContractType	Contract Type
Contract	ContractType	Contract Type

COREASON – Change Order Reason

The codes in this code table represent values indicating the general reason for the entire change order.

Example code table values and descriptions follow:

Balance comp Item – Balance the remaining completed items

Increase/Decrease – Item IID

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ChangeOrder	Reason	Reason

COTYPE – Change Order Type

The codes in this code table represent values indicating the change order’s type classification.

Example code table values and descriptions follow:

Extra Work – New items required for contract

Plan Sheet Error – Original plan sheet was wrong

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ChangeOrder	Type	Type
RefChangeOrderApprovalRule	ChangeOrderType	Change Order Type

CORPTYP – Corporation Type

The codes in this code table are used to identify the type of legal structure under which a Vendor's company is organized.  

Example code table values and their descriptions are as follows:

PRIV - Private Corporation

PUBL - Public Corporation

PART - Partnership

CORP - Corporation

UNK - Unknown type

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	CorporationType	Corporation Type

CRAFTCODE – Craft Code

The codes in this code table are used to identify each craft in the Wage Decision Craft list.

Example code table values and their descriptions are as follows:

10 - Laborers

15 - Power Equipment Operators

20 - Splty Craft-Carpenters

25 - Splty Craft-Piledrivers

30 - Splty Craft-Cement Mason (finishers)

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefEmployee	ApprenticeCraftCode	Apprentice Craft Code
RefWageDecisionCraft	CraftCode	Wage Craft Code
PayrollEmployeeLabor	CraftCode	Craft Code
OjtProgramSkillSet	OjtCraftId	OJT Craft ID
OjtProgramEnrollment	HighestPriorityOjtCraft	Highest Priority OJT Craft

CURRASGN – Current Assignment

The codes in this code table represent values indicating the use of test equipment, such as on a contract or in a lab.

Example code table values and descriptions follow:

Contract – Equipment assigned to Contract

Field Office – Field office on contract site

The following table lists the system fields that access this code table.

 

Entity	Column	Label
TestEquipment	CurrentAssignment	Current Assignment

CWRKCLS – Category Work Class

The codes in this code table are used to identify the classification of work for a category within a project.  

Example code table values and their descriptions are as follows:

0200 - Roadway Construction

0300 - Structures

1050 - Right-of-way

1100 - Indirect Costs

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Category	CATEGORYWORKCLASS	CATEGORYWORKCLASS
ContractProjectCategory	CATEGORYWORKCLASS	CATEGORYWORKCLASS

DBECERTENTITY – DBE Certification Entity

The codes in this code table are used to identify the government agencies that issues the vendor’s certification.

Required code table values and their descriptions are as follows:

Migration - Unknown Entity (used for migration of client/server data where a certification date is present)

• Caution: Do not change this code value. You can change the descriptions for the code if necessary. Additional values can be entered.

Example code table values and their descriptions are as follows:

AERO - Department of Aeronautics

DOT - Department of Transportation

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	DBECertEntity	DBE Certifying Entity

DBENOTE – Proposal DBE Goals

The codes in this code table are used to identify which DBE or MBE percentage goals apply to a proposal.  These values should not be changed.  

Example code table values and their descriptions are as follows:

DBE - Underutilized DBE Goal (UDBE)

MBE - MBE type of goal

WBE - Women’s Business Enterprise

NONE - No goals (No UDBE)

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Proposal	DBEGOAL	DBE Goal
Contract	DBEGOAL	DBE Goal

DBETYPE – DBE/WBE Code

The codes in this code table are used to identify a vendor's minority status type.  

Example code table values and their descriptions are as follows:

BOTH - Both DBE and WBE

DBE - Only DBE

MBE - Only MBE

WBE - Only WBE

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	PrimaryDbeWbe	Primary DBE WBE

DOCCAT – Document Category

The codes in this code table are used to indicate the broad category of document.  

Example code table values and their descriptions are as follows:

Contractual - Contractual Documentation

Inspection - Inspection Documentation

Materials - Materials Documentation

Payment - Payment Documentation

Status - Status Documentation

The following table lists the system fields that access this code table.

 

Entity	Column	Label
DocumentSubmission	Category	Category

DOCREC – Document Record

The codes in this code table are used to indicate the document reviewer's suggested course of action for the document.  

Example code table values and their descriptions are as follows:

Approve - Approve

NA - No recommendation necessary

Reject - Reject

Research - Research and/or follow-up required

The following table lists the system fields that access this code table.

 

Entity	Column	Label
DocumentSubmissionReview	Recommendation	Recommendation

DOCTYPE – Contract Documentation

The codes in this code table are used to indicate the primary topic of the document.

Example code table values and their descriptions are as follows:

Agency - Agency

Contractor - Contractor

Public - Public

The following table lists the system fields that access this code table.

 

Entity	Column	Label
DocumentSubmissionReview	Type	Type

DSRINSPECTYPE – Source Inspection Type

The codes in this code table represent values indicating the kind of inspection performed/observed at the

source/facility for the Daily Source Report.

Example code table values and descriptions follow:

MIXER – Mobile Mixer Inspection

MOBILE – Mobile Plant Inspection

PLANT – Plant Inspection

The following table lists the system fields that access this code table.

 

Entity	Column	Label
DsrInspection	InspectionType	Inspection Type

ECTGPCT – Additional Category Percentage

The codes in this code table are used to define a percentage adjustment made to a category.  May be used to apply sales tax or contingencies.  This adjustment percentage acts the same as construction engineering percent.  

Example code table values and their descriptions are as follows:

DEFA - 10.0

ST - 6.0

CNTY - 2.5

CONT - 5.00

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Category	ADJUSTMENT	ADJUSTMENT
ContractProjectCategory	ADJUSTMENT	ADJUSTMENT

ELECTRODEUNIT – Electrode Unit

The codes in this code table represent values indicating the unit of measure for the electrode used for the welding qualification.

Example code table values and descriptions follow:

A – Amperes

[micro]A - Microamperes

The following table lists the system fields that access this code table.

 

Entity	Column	Label
WelderQualification	ElectrodeUnit	Electrode Unit

ESTMETH - Estimation Methodology

The codes in this code table represent values indicating the primary methodology typically utilized in performing estimates containing this risk factor.

Example code table values and descriptions follow:

BID – Bid Based

COST – Cost Based

MIXED – Mixed Methodology

REF – Reference Based

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefRiskFactor	EstimationMethodology	Estimation Methodology

ESTTYPE – Estimation Type

The codes in this code table represent values indicating the type of cost estimate.

Example code table values and descriptions follow:

Agency – Agency Estimate

Cons – Consultant Estimate

Muni – Municipal Estimate

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimate	Type	Estimate Type

ESTPHASE – Estimate Phase

The codes in this code table represent values indicating an incremental value and description of the relative phase of the cost estimate in terms of the improvements' design life cycle.

Example code table values and descriptions follow:

1 – Design

2 – Preliminary

3 – Contractual

4 – Final Estimate

5 - Obsolete

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimate	Phase	Estimate Phase
CAPPhase	PhaseName	Cost Estimation Phase
RefRiskFactor	CostEstimatePhase	Cost Estimation Phase
CostEstimateCAPPhase	PhaseName	Phase

EQPRATECLS – Equipment Rate Class

The codes in this code table represent values indicating the class of the equipment rate.

Example code table values and descriptions follow:

EQRATE1 – Equipment Rate Class 1

EQRATE2 – Equipment Rate Class 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimate	EquipmentRateClass	Equipment Rate Class
CostSheetRefEquipmentRate	EquipmentRateClass	Equipment Rate Class
CostSheet	EquipmentRateClass	Equipment Rate Class

ETHNIC – Ethnic Orientation

The codes in this code table represent values indicating the ethnic group to which the person or vendor associated with this record belongs.

Example code table values and descriptions follow:

A-IN – ASIAN INDIAN

A-PF - ASIAN/PACIFIC ISLANDER

AS-AM - SUBCONT. ASIAN AMERICAN

AS-P - ASIAN-PACIFIC AMERICAN

BLK – BLACK AMERICAN

CAUC – CAUCASIAN

HISP – HISPANIC AMERICAN

HNDC – HANDICAPPED

N-AM – NATIVE AMERICAN

NMWM – NON-MINORITY

OTH - OTHER

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	EthnicGroup	Ethnic Group
RefVendorOfficer	EthnicGroup	Ethnic Group
RefEmployee	EthnicGroup	Ethnic Group
FieldInterviewEmployee	EthnicGroup	Ethnic Group
PayrollEmployee	EthnicGroup	Ethnic Group

EXPLTYPE – Reference Explanation Type

The codes in this code table represent values indicating a type classification for a reference change order explanation.   

Example code table values and descriptions follow:

1 – General

2 – Incr/Decr

3 – New Work

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefChangeOrderExplanation	Type	Explanation Type

FACILITYTYPE – Facility Type

The codes in this code table represent values indicating the type of facility.

Example code table values and descriptions follow:

Distributor – Distributor of Material

Manufacturer – Manufacturer of Material

Quarry – Material Quarry

The following table lists the system fields that access this code table.

 

Entity	Column	Label
FacilityType	Name	Facility Type

FEDAPPR – Federal Appropriations

The codes in this code table are used to identify the type(s) of federal appropriation available for a prime project.  

Example code table values and their descriptions are as follows:

HIGH - Federal highway appropriation

The following table lists the system fields that access this code table.

 

Entity	Column	Label
PrimeProject	FederalAppropriationCode1	Federal Appropriation Code 1
PrimeProject	FederalAppropriationCode2	Federal Appropriation Code 2
PrimeProject	FederalAppropriationCode3	Federal Appropriation Code 3

FEDCCLS – Federal Class

The codes in this code table are used to identify the type of construction in a project category.  

Example code table values and their descriptions are as follows:

GEN - General

RDWY - Roadway

4001 - Water main construction

8500 - Painting

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Category	FEDCONSTRUCTIONCLASS	FEDCONSTRUCTIONCLASS
ContractProjectCategory	FEDCONSTRUCTIONCLASS	FEDCONSTRUCTIONCLASS

FEDSUPP – Supplementary Work Codes

The codes in this code table are used to identify the federal supplementary work for a project category.

Example code table values and their descriptions are as follows:

EVAC - Emergency Evacuation Routing

REST - Rest Areas

Y030 - Highway lighting

PENG - Preliminary engineering

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Category	SUPPWORKCLASS	SUPPWORKCLASS
ContractProjectCategory	SUPPWORKCLASS	SUPPWORKCLASS

FEDWTYP – Federal Work Type

The codes in this code table are used to identify the federal work defined for a project category.

Example code table values and their descriptions are as follows:

FLOW - Federal Wildflower Project

LITR - Federal AntiLitter Campaign

FRDC - Federal Roadway Construction

FBRC - Federal Bridge Construction

SOIL - Soil Surface

RGTW - RightOfWay

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Category	FEDWORKCLASS	FEDWORKCLASS
ContractProjectCategory	FEDWORKCLASS	FEDWORKCLASS

FIELDINSP – Field Inspection

The codes in this code table represent values necessary to complete the action for the entity.

Example code table values and descriptions follow:

F1 – Field One

The following table lists the system fields that access this code table.

 

Entity	Column	Label
DwrAcceptanceRecord	FieldInspectionValue	Field Inspection Value
ActionRelationship	FieldInspectionValue	Field Inspection Value

FUELTYP – Fuel Adjustment Type

The codes in this code table are used to identify the type of fuel price adjustment being made to an item.

Example code table values and their descriptions are as follows:

PTRL - Petrol

GAS - Gasoline

GHOL - Gasohol

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefItem	FUELADJUSTMENTTYPE	FUELADJUSTMENTTYPE

FUNDTYP – Proposal Fund Type

The codes in this code table are used to identify the type(s) of funds available for a proposal.  

Example code table values and their descriptions are as follows:

ST1 - State Fund 1

FED1 - Federal Fund 1

MUNI - Municipal Fund

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Proposal	FundType	Type of Funding
Contract	TypeofFunding	Type of Funding

GEOAREA – Geographic Area

The codes in this code table represent values indicating a physical location.

Example code table values and descriptions follow:

East – East District

North – North District

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Lab	GeographicArea	Geographic Area
PersonInfo	GeographicArea	Geographic Area
TestEquipment	GeographicArea	Geographic Area
Source	GeographicArea	Geographic Area
Facility	GeographicArea	Geographic Area
SampleRecord	GeographicArea	Geographic Area

GOODFAITHEFFORT – Good Faith Effort

The codes in this code table are used to define the status of the agency’s ruling on the contractor’s effort in satisfying the contract’s DBE goal.

Example code table values and their descriptions are as follows:

No - No

Pending - Pending

Waiver - Waiver

Yes - Yes

The following table lists the system fields that access this code table.

 

Entity	Column	Label
DbeCommitmentSummary	GoodFaithEffort	Good Faith Effort
ContractCurrDbeCommitSummary	GoodFaithEffort	Good Faith Effort
ContractApprDbeCommitSummary	GoodFaithEffort	Good Faith Effort

GRADING – Project Grade Code

The codes in this code table are used to identify the type of grading for a project.

Example code table values and their descriptions are as follows:

ASPH - Asphalt

GVL - Gravel

FLAT - Flat terrain

HILL - Hilly terrain

ROLL - Rolling terrain

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Project	PROJECTGRADE	PROJECTGRADE
ContractProject	PROJECTGRADE	PROJECTGRADE

GROUPING_CODE – Grouping Code

Agency defined code used to be able to search for things at a later date that a user might want to merge into a Planning Group or perform reporting against.

Example code table values and descriptions follow:

1 – Group 1

2 – Group 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefItem	GroupingCode	Grouping Code
Project	GroupingCode	Grouping Code
CostEstimateSnapshot	GroupingCode	Grouping Code
Concept	GroupingCode	Grouping Code
CostEstimateCategory	GroupingCode	Grouping Code

HOLIDAYTYPE – Holiday Type

The codes in this code table are used to identify whether a holiday is used as a Payroll Holiday or an Agency Holiday. A Payroll Holiday is used by the agency to control when the contractor is required to pay holiday pay rates; an Agency Holiday is a day when agency personnel is given a scheduled official holiday. The Vendor is not required to pay Holiday pay rates on Agency Holidays.

Example code table values and their descriptions are as follows:

1 - Agency

2 - Payroll

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Refholiday	HolidayType	Holiday Type

HWYTYPE – Highway Type

The codes in this code table represent values indicating the type of highway.

Example code table values and descriptions follow:

INTS – Interstate State Highway

LOCAL – Local Road

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Project	HighwayType	Highway Type
Proposal	HighwayType	Highway Type
CostEstimateSnapshot	HighwayType	Highway Type
Concept	HighwayType	Highway Type
BidBasedWorksheet	HighwayType	Highway Type
ItemBidHistoryProfile	HighwayType	Highway Type

IMPROVEMENTTYPE – Improvement Type

The codes in this code table represent values indicating the classification for the type of improvement represented.

Example code table values and descriptions follow:

MAJRECON – Major Reconstruction

MINRECON – Minor Reconstruction

NEW – New Construction

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Project	ImprovementType	Improvement Type
CostEstimateSnapshot	ImprovementType	Improvement Type
Proposal	ImprovementType	Improvement Type
Concept	ImprovementType	Improvement Type
BhpImprovementType	Name	Name
BidBasedWorksheet	ImprovementType	Improvement Type
ItemBidHistoryProfile	ImprovementType	Improvement Type
RefRiskFactor	ImprovementType	Improvement Type

INSSTAT – Insurance Status

The codes in this code table are used to identify the status of a given insurance policy of a vendor.

Example code table values and their descriptions are as follows:

ACTIVE - Active

BINDER - Binder

CANCELLED - Cancelled

EXPIRED - Expired

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorInsurance	InsuranceStatus	Insurance Status

INSTYPE – Insurance Type

The codes in this code table are used to identify the type of a given insurance policy of a vendor.  

Example code table values and their descriptions are as follows:

CGL - Contractor General Liability

OP - Owner's Protective

UMB - Umbrella

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorInsurance	InsuranceType	Insurance Type

IRREG – Invalid Bid Code

The codes in this code table represent values indicating the reason that a proposal vendor's bid has been marked invalid.

Example code table values and descriptions follow:

I – Missing Information

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ProposalVendor	InvalidBidCode	Invalid Bid Code

ISSUETYPE – Reference Issue Type

The codes in this code table represent values indicating the kind or category of reference issues.

Example code table values and descriptions follow:

COAN – Change Order Approval Notification

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefIssue	IssueType	Type

ITEMCLS – Item Classification

The codes in this code table are used to identify the classification or group to which an item belongs.  

The ITEMCLS values will be aggregated to determine the Project Type of Work (PWRKTYP) in Preconstruction.  Then further aggregation will occur to determine the Contract Work Type (WRKTYPE) in Construction.  The three codes together should be designed to attract a specific group of people that wish to perform them.

Example code table values and their descriptions are as follows:

201 - Clearing and Grubbing

202 - Removal

P200 - Pipe work - sewer

T000 - Miscellaneous

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefItem	ItemClass	Item Classification

ITEMREASON - Item Reason

The codes in this code table represent values indicating the reason for the item.

Example code table values and descriptions follow:

CO – Change Order

EA – Adjustment

MC - Miscellaneous

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ChangeOrderNewItem	ItemType	Item Reason
ContractItem	Item Type	Item Reason
ContractProjectItem	Item Type	Item Reason

ITEMTYP – Material Type of Item

The codes in this code table are used to identify an item's type or material.  

Example code table values and their descriptions are as follows:

MOBL - Mobilization Item

ERTH - Earthwork

H000 - Painting

M300 - Subgrade work

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefItem	ItemType	ItemType

JOURNALTYPE – Issue Journal Type

The codes in this code table represent values indicating the type of journal entry for a reference issue as defined by the agency.

Example code table values and descriptions follow:

Blog – A blogging journal

The following table lists the system fields that access this code table.

 

Entity	Column	Label
IssueDiaryEntry	Type	Type

LBRRATECLS – Labor Rate Class

The codes in this code table represent values indicating the class of the labor rate.

Example code table values and descriptions follow:

LR1 – Labor Rate Class 1

LR2 – Labor Rate Class 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimate	LaborRateClass	Labor Rate Class
CostSheetRefLaborRate	LaborRateClass	Labor Rate Class
CostSheet	LaborRateClass	Labor Rate Class

LEASEUNITS – Lease Units

The codes in this code table are used to denote the time unit by which lease charges are calculated per truck.

Example code table values and their descriptions are as follows:

Day - Day

Hour - Hour

Month - Month

Year - Year

The following table lists the system fields that access this code table.

 

Entity	Column	Label
TruckingTruckType	LeaseUnit	Lease Unit
EOMTruckType	FlatRateUnits	Flat Rate Units

LETSTAT – Status of Letting

The codes in this code table are used to identify the status of a bid letting (and all calls/proposals under the bid letting).  

Example code table values and their descriptions are as follows:

POST - Postponed

SCHD - Scheduled

CANC - Cancelled

MSCH - Modified Schedule

DEFR - Work deferred from this letting

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Letting	LettingStatus	Letting Status

LOC_METHOD - Location Method

The codes in this code table are used to identify the process used to collect the spatial coordinate values.  

Example code table values and their descriptions are as follows:

F1 - Field Survey Grade GPS

F2 - Field Mapping Grade GPS

F3 - Field Map Notation

Q1 - Office Heads up digitizing from Maps/Imagery in a GIS environment

Q2 - Office location recording from a web base mapping source (e.g. Google/Bing Maps)

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractProjectBridgeSegment	StartingLocMethod	Start Location Method
ContractProjectBridgeSegment	EndingLocMethod	End Location Method
ContractProjectRoadSegment	StartingLocMethod	Start Location Method
ContractProjectRoadSegment	EndingLocMethod	End Location Method
ContractProjectLocationPoint	LocMethod	Location Method
Point	LocationMethod	Location Method
BridgeSegment	StartLocationMethod	Start Location Method
BridgeSegment	EndLocationMethod	End Location Method
RoadSegment	StartLocationMethod	Start Location Method
RoadSegment	EndLocationMethod	End Location Method
DwrItemPosting	StartingLocMethod	Start Location Method
DwrItemPosting	EndingLocMethod	End Location Method
SampleRecord	StartingLocMethod	Start Location Method
SampleRecord	EndingLocMethod	End Location Method

LOC_QUALITY - Location Quality

The codes in this code table are used to identify the accuracy of the value recorded in the spatial coordinate system.  

Example code table values and their descriptions are as follows:

A - 3D Survey Grade

B - 2D Survey Grade

C - Sub Meter 2D Grade

D - 1-10 Meter 2D Grade

E - 11-20 Meter 2D Grade

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractProjectBridgeSegment	StartingLocQuality	Start Location Quality
ContractProjectBridgeSegment	EndingLocQuality	End Location Quality
ContractProjectRoadSegment	StartingLocQuality	Start Location Quality
ContractProjectRoadSegment	EndingLocQuality	End Location Quality
ContractProjectLocationPoint	LocQuality	Location Quality
Point	LocationQuality	Location Quality
BridgeSegment	StartLocationQuality	Start Location Quality
BridgeSegment	EndLocationQuality	End Location Quality
RoadSegment	StartLocationQuality	Start Location Quality
RoadSegment	EndLocationQuality	End Location Quality
DwrItemPosting	StartLocationQuality	Start Location Quality
DwrItemPosting	EndLocationQuality	End Location Quality
SampleRecord	StartLocationQuality	Start Location Quality
SampleRecord	EndLocationQuality	End Location Quality

LOC_QLT_UNIT - Location Quality Unit

The codes in this code table are used to identify the unit of measure used in the spatial coordinate system.  

Example code table values and their descriptions are as follows:

FT - Feet

M - Meter (=3.281 Feet)

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractProjectBridgeSegment	StartingLocQualUnit	Start Location Quality Unit
ContractProjectBridgeSegment	EndingLocQualUnit	End Location Quality Unit
ContractProjectRoadSegment	StartingLocQualUnit	Start Location Quality Unit
ContractProjectRoadSegment	EndingLocQualUnit	End Location Quality Unit
ContractProjectLocationPoint	LocQualUnit	Location Quality Unit
Point	LocationQualityUnit	Location Quality Unit
BridgeSegment	StartLocationQualityUnit	Start Location Quality Unit
BridgeSegment	EndLocationQualityUnit	End Location Quality Unit
RoadSegment	StartLocationQualityUnit	Start Location Quality Unit
RoadSegment	EndLocationQualityUnit	End Location Quality Unit
DwrItemPosting	StartLocationQualityUnit	Start Location Quality Unit
DwrItemPosting	EndLocationQualityUnit	End Location Quality Unit
SampleRecord	StartLocationQualityUnit	Start Location Quality Unit
SampleRecord	EndLocationQualityUnit	End Location Quality Unit

LOCATIONTYPE – Location Type

The codes in this code table represent values indicating the type of the source location, such as GIS or Point Geodetic Coordinates.

Example code table values and descriptions follow:

GIS – Geographic Information System

PGC – Point Geodetic Coordinates

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Source	LocationType	Location Type
Facility	LocationType	Location Type

MARKUPS – Markups

The codes in this code table represent values indicating the type of markup added to a cost estimate.

Example code table values and their descriptions are as follows:

OTH - Other

STAX - Sales Tax

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimateMarkup	CostEstimateMarkup_NM	Markup

METHODOFPAYMENT – Method of Payment

The codes in this code table represent values indicating the method of payment provided by the field

interview employee.

Example code table values and descriptions follow:

Cash – Paid in Cash

Check – Paid by Check

EFT – Paid by Electronic Funds Transfer

The following table lists the system fields that access this code table.

 

Entity	Column	Label
FieldInterviewEmployee	PaymentMethod	Method of Payment

MOBILETESTERLINKS – Mobile Tester Links

The values in this code table are used to identify website links made accessible in the Mobile Tester application. 

Example code table values and descriptions follow:

Name – Readable name of the link (e.g., Google)

Desc – The actual link (e.g., https://www.google.com)

This code table will only generate in AASHTOWare Project once the Bridge to Mobile Tester process has been run. For more information, see Running the Bridge to Mobile Tester. 

MTNGTYP – Meeting Type

The codes in this code table represent values indicating the type of meeting.

Example code table values and descriptions follow:

Status – Random Status Check

Weekly – Weekly Meetings

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Meeting	Type	Meeting Type

MTRRATECLS – Material Rate Class

The codes in this code table represent values indicating the class of the material rate.

Example code table values and descriptions follow:

MRATE1 – Material Rate Class 1

MRATE2 – Material Rate Class 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimate	MaterialRateClass	Material Rate Class
CostSheetRefEquipmentRate	MaterialRateClass	Material Rate Class
CostSheet	MaterialRateClass	Material Rate Class

NAICSCODE – NAICS Code

The codes in this code table are used to uniquely identify each NAICS work classification code associated to a vendor.

Example code table values and their descriptions are as follows:

1 - Bridge

2 - Pavement

3 - Structure

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorNAICS	NAICSId	NAICS Code

NAICSSTATUS – NAICS Status

The codes in this code table are used to denote the status of the associated work classification row.

Example code table values and their descriptions are as follows:

1 - Active

2 - Inactive

3 - Suspended

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorNAICS	Status	Status Code
RefVendorSpecialtyCode	Status	Status Code
RefVendorSICCode	Status	Status Code

NONCONGROUP – Non Construction Group

The codes in this code table represent values indicating non-construction cost items to facilitate reporting and data exchange.  

Example code table values and descriptions follow:

1 – Group 1

2 – Group 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
NonConstructionCost	NonConstructionCostGroup	Non Construction Cost Group

NONCONTYPE – Non Construction Type

The codes in this code table represent values indicating the type of non-construction cost that is being associated with the estimate.  

Example code table values and descriptions follow:

1 – Type 1

2 – Type 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
NonConstructionCost	NonConstructionCostType	Non Construction Cost Type

OFFICER – Title of Officer

The codes in this code table are used to identify a vendor officer's job title.  

Example code table values and their descriptions are as follows:

PRES - President

VP - Vice President

SEC - Secretary

CHMN - Chairman

OFFR - Officer

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorOfficer	OfficerTitle	Officer Title

OFFSET – Offset Direction

The codes in this code table represent values indicating the direction of where the sample was taken in reference to the centerline.  

Example code table values and descriptions follow:

Center – On Centerline

Left – Left of Centerline

Right – Right of Centerline

The following table lists the system fields that access this code table.

 

Entity	Column	Label
SampleRecord	Offset	Offset Direction

OJTPROGRAMSPONSOR – OJT Program Sponsor

The codes in this code table are used to denote the organization sponsoring the on-the-job training program.

Example code table values and their descriptions are as follows:

AGC - Association of General Contractors

DOT - State DOT sponsored training program

FHWA - Federal Highway Approved Program

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefOjtProgram	OJTProgramSponsor	OJT Program Sponsor

OTHRCADJ – Other Contract Adjustment Type

The codes in this code table represent values indicating agency defined contract adjustments.

Example code table values and descriptions follow:

OCNTADJ1 – Other Contract Adjustment One

OCNTADJ2 – Other Contract Adjustment Two

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractAdjustment	OtherType	Other Contract Adjustment Type
PaymentEstimateContractOtherAdjustmentType	Name	Other Contract Adjustment Type

OTHRIADJ – Other Item Adjustment Type

The codes in this code table represent values indicating agency defined item adjustments for this contract on the current estimate.  

Example code table values and descriptions follow:

OITMADJ1 – Other Item Adjustment One

OITMADJ2 – Other Item Adjustment Two

The following table lists the system fields that access this code table.

 

Entity	Column	Label
PayEstimateItemAdjustmentSummary	OtherType	Other Item Adjustment Type
PayEstimateItemAdjustment	OtherType	Other Item Adjustment Type

PAID – Payment Frequency

The codes in this code table represent values indicating how often the field interview employee is paid.

Example code table values and descriptions follow:

Weekly – Paid Weekly

Monthly – Paid Monthly

Bi-Weekly – Paid Bi-Weekly

The following table lists the system fields that access this code table.

 

Entity	Column	Label
FieldInterviewEmployee	Paid	Paid By

PERMITTYPE – Permit Type

The codes in this code table represent values indicating the type of permit.

Example code table values and descriptions follow:

CWA NPDES – Federa – CWA Stormwater

CWA Section 401 – Federal – CWA Quality

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractPermit	PermitType	Permit Type

PHONETYP – Phone Type

The codes in this code table represent values indicating the type or location of the phone this number reaches.

Example code table values and descriptions follow:

FAX – Fax

PHONE – Office Phone

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorPhone	PhoneType	Type
Phone	PhoneType	Type

PREQUAL – Prequalification Work Type

The codes in this code table represent values indicating the type of work for the item for calculating prequalification requirements.

Example code table values and descriptions follow:

1 – Prequalification work type 1

2 – Prequalification work type 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimateItem	PrequalWorkType	Prequalification Work Type
RefItem	PrequalWorkType	Prequalification Work Type

PRJSTAT – Project Status

The codes in this code table are used to identify the current status of a project.  

Example code table values and their descriptions are as follows:

CMPL - Completed

CNST - Construction

ACTV - Active Construction

WAIT - Awaiting Award

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Project	ProjectStatus	Project Status

PROBLEMFOUND – Problem Found

The codes in this code table represent values indicating the problem found during the review.

Example code table values and descriptions follow:

P1 – Problem 1

P2 – Problem 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ComplianceFinding	ProblemFound	Problems Found

PROGRAM – Program

The codes in this code table are used to define programs that provide equal opportunity for the training and upgrading of individuals in the skilled or semi-skilled construction trade classifications.

Example code table values and their descriptions are as follows:

FAA - Federal Aviation Adminiatration

FHWA - Federal highway Adminsitration

FTA - Federal Transit Authority

OJT - On Job Training

OTHER - Other

The following table lists the system fields that access this code table.

 

Entity	Column	Label
PercentGoal	Program	Program
OjtGoal	Program	Program

PROJTYP – Project Type

The codes in this code table are used to identify the type of project.  

Example code table values and their descriptions are as follows:

FEDR - Federal

NONF - Non-federal

BHAB - Bridge rehab

MISC - Miscellaneous

URMJ - Major urban

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Project	ProjectType	Project Type
ContractProject	ProjectType	Project Type

PROPTYP – Proposal Type

The codes in this code table are used to define a proposal's type or classification.

Example code table values and their descriptions are as follows:

SMLB - Small business

COMM - Commercial contractor

FEDR - Federal

2 - State and federal

5 - Federal/local

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Proposal	ProposalType	Proposal Type
Contract	ProposalType	Proposal Type

PROVTYP – Special Provision Types

The codes in this code table are used to identify the types of special provisions that may be included in a proposal.

Example code table values and their descriptions are as follows:

AFF - Affirmative Action

MINW - Minimum Wage

OJT - On the Job Training

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefSpecialProvision	Type	Special Provision Type

PRPSTAT – Letting Status of Proposal

The codes in this code table are used to identify the current status of a let¬ting.  

Example code table values and their descriptions are as follows:

A - Awarded

R - Rejected

C - Cancelled

F - Final

CA - Conditionally Awarded

CR - Conditionally Rejected

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Proposal	ProposalStatus	Proposal Status

PWRKTYP – Project Type of Work

The codes in this code table are used to identify the type of work performed on a project. They should represent high level WRKTYPE descriptions and must have the same values as WRKTYP. Limit the Project Type of Work codes to 8 to 12 high-level work type descriptions. Using too many codes dilutes the BAMS/DSS analyses that group by Project Type of Work. You can store lower-level codes in one of the generic code columns.

The PWRKTYP values are aggregated for the Item Class (ITEMCLS) values.  Then they are aggregated further to determine the Contract Work Type (WRKTYP).  The three codes together should be designed to attract a specific group of people that wish to perform them.

Example code table values and their descriptions are as follows:

CNST - General construction

GRAD - Grading

WIDN - Widening

OVLY - Overlay

BRDG - Bridge work

BHAB - Bridge rehabilitation

ENGN - Engineering

LAND - Landscaping

URMN - Urban minor

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Project	ProjectWorkType	Project Work Type
ContractProject	ProjectWorkType	Project Work Type

QUALAUTHORITY – Qualification Authority

The codes in this code table represent values indicating the governing body or other authority by which this qualification is judged.  

Example code table values and descriptions follow:

APA1 – Asphalt Pavement Assoc.

CA – Concrete Assoc.

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Qualification	Authority	Qualification Authority

QUALLEVEL – Qualification Level

The codes in this code table represent values indicating the level of skill or proficiency of the qualification for the qualification type.

Example code table values and descriptions follow:

1 – Level 1 Authority

2 – Level 2 Authority

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Qualification	Level	Qualification Level

QUALMETHOD – Qualification Method

The codes in this code table represent values indicating the means or procedure by which this qualification is obtained.

Example code table values and descriptions follow

Certification – Certification

Exp - Experience

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Qualification	Method	Qualification Method

QUALPOSITION – Qualification Position

The codes in this code table represent values indicating the position the welder is qualified to perform on the given process.

Example code table values and descriptions follow:

1 – Position 1

2 – Position 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
WelderQualification	Position	Qualification Position

QUALPROCESS – Qualification Process

The codes in this code table represent values indicating the process the welder is qualified to perform.

Example code table values and descriptions follow:

1 – Process 1

2 – Process 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
WelderQualification	Process	Qualification Process

QUALTYPE – Qualification Type

The codes in this code table represent values indicating the discrete type of the qualification within the qualification category.

Example code table values and descriptions follow:

CMA – Cold Mix Asphalt

HMA – Hot Mix Asphalt

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Qualification	Type	Qualification Type

REASONCODE – Reason for Good Faith Effort

The codes in this code table represent values indicating the reason the DBE vendor's quote was not used in the bid.

Example code table values and descriptions follow:

1 – Reason 1

2 – Reason 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractApprGoodFaithEffort	ReasonCode	Reason Code
ContractCurrGoodFaithEffort	ReasonCode	Reason Code
DbeGoodFaithEffort	ReasonCode	Reason Code

REASONSHOWCAUSE – Reason to issue Show Cause

The codes in this code table represent values indicating the reason the show cause order was issued.

Example code table values and descriptions follow:

1 – Reason One

2 – Reason Two

The following table lists the system fields that access this code table.

 

Entity	Column	Label
LaborComplianceReview	ReasonShowCause	Reason for Show Cause
ComplianceFinding	ShowCauseReason	Reason for Show Cause
DBEOJTComplianceReview	ShowCauseReason	Reason for Show Cause

REFSEC – Reference Security Code

The codes in this code table represent values indicating the name of the company providing the security account to the vendor.

Example code table values and descriptions follow:

Prudential – Prudential Securities

The following table lists the system fields that access this code table.

 

Entity	Column	Label
SecurityAccount	Name	Name

RELAT – Relationship to Vendor

The codes in this code table are used to identify the relationship between a vendor and an affiliated company or another vendor.  

Example code table values and their descriptions are as follows:

JOIN - Joint

PARN - Parent

PART - Partnership

AF - Attorney-in-fact

PK - Personal knowledge

SUB - Subsidiary

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorAffiliat	VendorRelation	Vendor Relation

RELLNITM – Related Item Groupings

The codes in this code table represent values indicating the item group to which this item belongs.

Example code table values and descriptions follow:

G1 – Grouping 1

G2 – Grouping 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractProjectItem	RelatedLineItem	Related Line Item

REMARKTYPE – Remark Type

The codes in this code table represent values indicating the kind of remark being recorded.

Example code table values and descriptions follow:

Cancelled – Cancelled

Test Result Value – Test Result Value

WEA – Weather

DWRComment – DWR Comment

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RemarkModelMapping	Type	Type

RISKCAT – Risk Category

The codes in this code table represent values indicating a set of categories with which reference risk factors can be associated.   

Example code table values and descriptions follow:

Environmental – Environmental Issue

Geological – Geological Issue

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefRiskFactor	Category	Risk Category

RISKTYPE – Risk Type

The codes in this code table represent values indicating the type of risk.

Example code table values and descriptions follow:

CS – Cost & Schedule

S - Schedule

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefRiskFactor	RiskType	Risk Type

ROADTYPE – Type of Road

The codes in this code table are used to identify the type of road which has been contracted out for work or construction.

Example code table values and their descriptions are as follows:

FHWY - Federal Highway

INTR - Interstate

SHWY - State Highway

CHWY - County Highway

TRL - Trails (hiking and biking)

URBN - Urban System

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RoadSegment	RoadType	Type

RSCNDEDSHOWCAUSE – Reason to rescind Show Cause

The codes in this code table represent values indicating the reason the show cause order was rescinded.

Example code table values and descriptions follow:

1 – Reason One

2 – Reason Two

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ComplianceFinding	ShowCauseRescindReason	Show Cause Rescinded Reason
LaborComplianceReview	ShowCauseRescindedReason	Show Cause Rescinded Reason
DBEOJTComplianceReview	ShowCauseRescindedReason	Show Cause Rescinded Reason

SALESTX – Sales Tax Code

The codes in this code table are used to identify the sales tax that may apply to a planholder purchasing proposals.  

Example code table values and their descriptions are as follows:

NONE - No Sales Tax

5 5% - Sales Tax

999 - State Only

339 - Nebraska City

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorAddress	SalesTax	Sales Tax
Purchase	SalesTaxCode	Sales Tax Code

SCOPE – Scope Stability

The codes in this code table represent values indicating an incremental value/description depicting the relative stability of the design scope for the planned improvement.   

Example code table values and descriptions follow:

S – Stable

U - Unstable

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefRiskFactor	ScopeStability	Scope Stability Level

SETASID – Reason to Set Aside a Proposal

The codes in this code table are used to identify the reason a proposal has been set aside.  

Example code table values and their descriptions are as follows:

STND - Standard

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Proposal	SETASIDE	SETASIDE
Contract	SETASIDE	SETASIDE

SICCODE – SIC Code

The codes in this code table are unique identifiers assigned to each SIC work classification code that can be assigned to a vendor.

Example code table values and their descriptions are as follows:

1 - Paving

2 - Removing

3 - Grading

4 - Sanding

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorSICCode	SICCode	SIC Code

SMPLRESP – Sample Responsibility

The codes in this code table represent values indicating the person responsible for the sampled material.   

Example code table values and descriptions follow:

1 – First Person

2 – Second Person

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ActionRelationship	SampleResponsibility	Sample Responsibility

SMPLTYPE – Sample Type

The codes in this code table represent values indicating the type of sample taken.  

Example code table values and descriptions follow:

CERT – Certification

QCQA – Quality Control Quality Assurance

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ProductGroupAssignment	SampleType	Sample Type
ActionRelationship	SampleType	Sample Type
TestAssignmentInfo	SampleType	Sample Type
SampleRecord	SampleType	Sample Type
AlternateTestWorkflow	SampleType	Sample Type
TestTriggeredEvent	SampleType	Sample Type
DwrAcceptanceRecord	SampleType	Sample Type

SMPLUNITS – Sample Units

The codes in this code table represent values indicating the unit of measure for the sample to be taken.   

Example code table values and descriptions follow:

1 – Unit 1

2 – Unit 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ActionRelationship	SampleUnits	Sample Units

SNAPSHOTREASON – Snapshot Reason

The codes in this code table represent values indicating the reason for the snapshot.

Example code table values and descriptions follow:

Scope Change – Change in Scope

User-defined – User-defined reason

The following table lists the system fields that access this code table.

 

Entity	Column	Label
CostEstimateSnapshot	Reason	Snapshot Reason

SOURCEINSP – Source Inspection Value

The codes in this code table represent values indicating that the material was inspected for the source.

Example code table values and descriptions follow:

SIV1 – Source Inspection Value 1

SIV2 – Source Inspection Value 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ActionRelationship	SourceInspectionValue	Source Inspection Value
DsrMaterialSmfmi	InspectionValue	Inspection Value

SOURCETYPE – Source Type

The codes in this code table represent values indicating the type of material source.

Example code table values and descriptions follow:

Distributor – Distributor

Manufacturer – Manufacturer

Supplier - Supplier

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Source	Type	Source Type

SPECIALTYCODE – Specialty Code

The codes in this code table are an agency-specific classification code for the vendor.

Example code table values and their descriptions are as follows:

1 - Paving

2 - Removing

3 - Grading

4 - Sanding

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorSpecialtyCode	SpecialtyCode	Specialty Code

STAFF – Staff

The codes in this code table are used to represent the staffpersons responsible for designing projects, revising prices, engineering, and planholder purchasing.  

Example code table values and their descriptions are as follows:

DST1 - District 1 Staff Member

ABC - Abraham Benjamin Callahan

CAJ - Casey Allen Jones

173 - Wesley W. Wahlgren

889 - Dewey J. Prongratz

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorDbeCertificationEvent	AssignedTo	Assigned To
ContractCurrDbeCommitSummary	ApprovedBy	Approved By
ContractCurrDbeCommitSummary	RevisedGoalAppBy	Revised Goal Approved By
ContractCurrDbeCommitSummary	RevisedCommitAppBy	Revised Commitment Approved By
ContractCurrDbeCommitment	ReviewedBry	Reviewed By
ContractApprDbeCommitment	ReviewedBy	Reviewed By
ContractApprDbeCommitSummary	ApprovedBy	Approved By
ContractApprDbeCommitSummary	RevisedGoalAppBy	Revised Goal Approved By
ContractApprDbeCommitSummary	RevisedCommitAppBY	Revised Commitment Approved By
Purchase	ClerkWritingOrder	Clerk Writing Order
Project	Revised By	Revised By
Project	Designer	Designer
Project	PRICEDBY	PRICEDBY
DbeCommitment	Reviewed By	Reviewed By
DbeCommitmentSummary	ApprovedBy	Approved By
DbeCommitmentSummary	RevisedGoalApprovedBy	Revised Goal Approved By
DbeCommitmentSummary	RevisedCommitmentApprovedBy	Revised Commitment Approved By
ContractProject	PRICEDBY	PRICEDBY
RefDistrict	ENGINEERNAME	ENGINEERNAME

STATE – State Name Abbreviations

The codes in this code table are used to identify the state or province for an address. By default, this code table includes the two-letter postal codes for each U.S. state and the District of Columbia. You can add two-letter codes for states, provinces, and regions outside the United States. See Changing a Reference Code Table.See Changing a Reference Code Table.

Example code table values and their descriptions are as follows:

AB - Alberta

CO - Colorado

FL - Florida

IN - Indiana

ME - Maine

NE - Nebraska

NM - New Mexico

OH - Ohio

QC - Québec

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	StateOfIncorporation	State of Incorporation
RefVendorAddress	State	State/Province
RefEmployee	State	State/Province
RefWageDecision	State	State/Province
PayrollEmployee	State	State/Province

STATUSCONTRACTACTION – Contract Action Status

The codes in this code table represent values indicating the current state of the contract action as classified by the agency.

Example code table values and descriptions follow:

CLOSED – Closed

OPEN – Open

RESOLVED – Resolved

REVIEW – Under Review

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractAction	ActionStatus	Action Status

STATUSTYPE – Acceptance Status Type

The codes in this code table represent values indicating the status of the action relationship.

Example code table values and descriptions follow:

Accepted – Accepted

Failed - Failed

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ActionRelationship	StatusType	Action Relationship Status Type

STORMQUALTYPE – Stormwater Qualification Type

The codes in this code table represent values indicating the type of qualification, as classified by the agency.  

Example code table values and descriptions follow:

CESSWI – Certified Erosion, Sediment and Storm Water Inspection

CMS4S – Certified Municipal Separate Storm Sewer System Specialist

CPESC – Certified Professional in Erosion and Sediment Control

CPSWQ – Certified Professional in Storm Water Quality

The following table lists the system fields that access this code table.

 

Entity	Column	Label
StormwaterInspectorQualification	QualificationType	Qualification Type

STORMINSPCYCLE – Stormwater Inspection Cycle

The codes in this code table represent values indicating the unit of measurement used to categorize a length of the stormwater period, as classified by the agency.  

Example code table values and descriptions follow:

Bi-Weekly – Once every two weeks

Daily – Every Day

Monthly – Once a month

The following table lists the system fields that access this code table.

 

Entity	Column	Label
StormwaterPeriod	InspectionCycle	Inspection Cycle

STORMMEANSOFCOMM – Stormwater Means of Contractor Notification

The codes in this code table represent values indicating the means of communication used to notify the contractor, as classified by the agency.  

Example code table values and descriptions follow:

Email – Electronic Mail

InPerson – Spoken to in person

The following table lists the system fields that access this code table.

 

Entity	Column	Label
StormwaterPeriod	MeansContrNotification	Means of Contractor Notification

STORMCERTSTATUS – Stormwater Compliance Certification Status

The codes in this code table represent values indicating the current state of environmental compliance for the contractor, as classified by the agency.  

Example code table values and descriptions follow:

Approved – Approved

Pending - Pending

The following table lists the system fields that access this code table.

 

Entity	Column	Label
StormwaterPeriod	ComplianceCertificationStatus	Compliance Certification Status

STORMDEFTYPE – Stormwater Deficiency Type

The codes in this code table represent values indicating the type of deficiency or issue, as defined by the agency.

Example code table values and descriptions follow:

Emergency – Immediate Fix

Major – Major Impact, Fix within 2 days

Minor – Low Impact, Fix within 7 days

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefStormwaterDeficiency	Type	Type

STORMCNTLTYPE – Stormwater Control Type

The codes in this code table represent values indicating the type of control used at a stormwater location, as classified by the agency.

Example code table values and descriptions follow:

Check Dam – Check Dam

Compost FS – Compost Filter Sock

Silt Fence – Silt Fence

The following table lists the system fields that access this code table.

 

Entity	Column	Label
StormwaterPeriodLocation	ControlType	Control Type

SUBMITTALTYPE – Net Worth Submittal Type

The codes in this code table are used to define the kind of row submitted.

Example code table values and their descriptions are as follows:

Annual – Annual Submittal

Initial – Initial Submittal

Update 1 – Update 1 Submittal

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorOfficerPNW	SubmittalType	Submittal Type
RefVendorAnnualData	SubmittalType	Submittal Type

SUBTYPE – Subcontract Work Type

The codes in this code table are used to identify the type of subcontract.  

Example code table values and their descriptions are as follows:

A - Asphalt

AGG - Aggregate, Gravel

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Subcontract	SubcontractType	Subcontract Type

SUPPORTIVESERVICES – Support Services

The codes in this code table represent values indicating if the vendor is eligible for additional resources.  

Example code table values and their descriptions are as follows:

FHWA - FHWA Eligible

NON-FHWA - Not Eligible for FHWA

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	SupportServices	Supportive Services

SYSTEMEVENTTYPE - Issue System Event Type

The codes in this code table represent values indicating the type of system event.

Example code table values and descriptions follow:

COAN – Change Order Approval Notification

HRPT – Historical Report

The following table lists the system fields that access this code table.

 

Entity	Column	Label
SystemEventTrigger	Type	Type

STATUS – Entity Status

The codes in this code table represent values indicating the active status of an entity.

Example code table values and descriptions follow:

ACTIVE – Active

INACTIVE – Inactive

PENDING – Pending

RESEARCH - Research

This code table is used by all entities listed in the BusinessMetadata.xml file that have the <IActivatable> tag.

TERRAIN – Terrain

The codes in this code table represent values indicating the type of terrain or natural land features used.

Example code table values and descriptions follow:

Level – Level

Rolling – Rolling

Mountainous - Mountainous

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Project	Terrain	Terrain
Proposal	Terrain	Terrain
CostEstimateSnapshot	Terrain	Terrain
Concept	Terrain	Terrain
BidBasedWorksheet	Terrain	Terrain
ItemBidHistoryProfile	Terrain	Terrain

TESTSTATUS – Test Status

The codes in this code table are used to indicate the status of a sample record test.  

Example code table values and their descriptions are as follows:

0   - Test Cancelled

05 - Test Assigned

10 - Test in Queue

11 - Test Requested

20 - Being Retested

21 - Retest

40 - Test Complete

50 - Test Reviewed by Level 1

60 - Test Approved by Level 2

81 - Test Referred back to Lab

The following table lists the system fields that access this code table.

 

Entity	Column	Label
TestAssignmentInfo	StartTestStatus	Start Test Status
SampleRecordTest	Status	Test Status
AlternateTestWorkflow	FromTestStatus	From Test Status
AlternateTestWorkflow	ToTestStatus	To Test Status
TestTriggeredEvent	FromTestStatus	From Test Status
TestTriggeredEvent	ToTestStatus	To Test Status
TestTriggeredEventTrigger	TriggerFromTestStatus	From Test Status
TestTriggeredEventTrigger	TriggerToTestStatus	To Test Status

TRUCKTYPE – Truck Type

The codes in this code table are used to identify the truck classification based on the number of total axles on the vehicle (including trailer) based on the wage decisions for the state.

Example code table values and their descriptions are as follows:

Quad-axle - Quad-axle

Semi - Semi

Tanker - Tanker

The following table lists the system fields that access this code table.

 

Entity	Column	Label
TruckingTruckType	TypeOfTruck	Type of Truck
EOMTruckType	TruckType	Truck Type

TSTRESP – Test Responsibility

The codes in this code table represent values indicating the group responsible for testing the sample to be taken.

Example code table values and descriptions follow:

T1 – Tester 1

T2 – Tester 2

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ActionRelationship	TestResponsibility	Test Responsibility

TYPECONTRACTACTION – Contract Action Type

The codes in this code table represent values indicating the current type of the contract action as classified by the agency.

Example code table values and descriptions follow:

BOND – Bond

CLAIM – Claim

NOTICE – Notice of Intent

The following table lists the system fields that access this code table.

 

Entity	Column	Label
ContractAction	ActionType	Action Type

UNITS – Units of Measure

The codes in this code table are used to identify the unit of measure used for each item.  

Required code table values and their descriptions are as follows:

LS - Lump sum

Additional example code table values and their descriptions are as follows:

ACRE - Acre

CF - Cubic Foot

DAY - Day

DLR - Dollar

EA - Each

EACH - Each

GAL - Gallon

HOUR - Hour

LB - Pound

MILE - Mile

• Caution: Do not change the code LS. You can add codes and change all other codes and descriptions for the codes if necessary

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefItem	Unit	Unit of Measure
RefItem	CommonUnit	Common Unit of Measure
SubcontractItem	Unit	Unit of Measure

URBRUR – Urban/Rural Class

The codes in this code table are used to identify whether a project is classified as an urban or rural work site.  

Example code table values and their descriptions are as follows:

RURL - Rural

URBN - Urban

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Project	UrbanRural	Urban/Rural
ContractProject	UrbanRural	Project Urban/Rural

VENDTYP – Type of Vendor

For each vendor in the Vendor master file, the codes in this code table are used to identify the vendor's type.  

Example code table values and their descriptions are as follows:

BROKER - Broker

CONSULTANT - Consultant

DEBARRED - Debarred

ITO TRUCKING FIRM - Independent Truck Owner/Operator

UTILITY - Utility

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendor	VendorType	Vendor Type
RefVendorAdditionalType	Name	Additional Vendor Type ID

VWRKCLS – Contract Qualification Class

The codes in this code table are used to identify the possible types of work a vendor may be qualified to perform, and are also used to classify the corresponding type of work in a proposal.  

Example code table values and their descriptions are as follows:

BRDS - Build steel bridge

BRDC - Build concrete bridge

COMM - Commercial Contractor

LAND - Landscaping

ENGN - Engineering

FLAG - Flagging

10 - General (all classes)

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefVendorWorkClass	Name	Work Class ID
Subcontract	WorkClassification	Work Classification
Proposal	ContractQual1	Contract Qualification Class 1
Proposal	ContractQual2	Contract Qualification Class 2
Proposal	ContractQual3	Contract Qualification Class 3

WAGECONSTTYPE – Wage Construction Type

The codes in this code table are used to define the kind of construction applicable to a wage decision.

Example code table values and their descriptions are as follows:

1 - Heavy

2 - Highway

3 - Building

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefWageDecision	WageConstructionType	Wage Construction Type

WAGEZONECODE – Wage Zone Code

The codes in this code table are used to uniquely identify each wage zone in the Wage Zone list.

Example code table values and their descriptions are as follows:

1 - Zone 1

MN BRMN0001-015 - Benton & Stearns Counties

ZA1 - Area 1

The following table lists the system fields that access this code table.

 

Entity	Column	Label
RefWageZoneArea	RefWageZoneCode	Wage Zone Code

WELDERQUALTYPE – Welder Qualification Type

The codes in this code table represent values indicating the discrete type of the qualification within the qualification category.

Example code table values and descriptions follow:

PERM – Permanent

TEMP - Temporary

The following table lists the system fields that access this code table.

 

Entity	Column	Label
WelderQualification	Type	Welder Qualification Type

WORKLOCATION – Work Location

The codes in this code table represent values indicating the location where work is performed.

Example code table values and descriptions follow:

Center – Center

Left – Left

Right – Right

The following table lists the system fields that access this code table.

 

Entity	Column	Label
AccActionOptionRateFreq	WorkLocation	Work Location
DwrAcceptanceRecord	WorkLocation	Work Location
SampleRecordContractMaterialSetAssociation	WorkLocation	Work Location

WRKTYP – Contract Type of Work

The codes in this code table are used to identify the type of work to be performed on a contract. They should represent a few (8-12) work type descriptions and values must be the same as in PWRKTYP. Using too many codes dilutes the BAMS/DSS analyses that group by Contract Type of Work. You can store lower-level codes in a generic code column. The entries in the WRKTYP code table should match the entries in the PWRKTYP code table for web-based AASHTOWare Project Cost Estimation parametric estimation methods.

Example code table values and their descriptions are as follows:

BRDG - Bridge work

CNST - General construction

ENGN - Engineering

GRAD - Grading

LAND - Landscaping

MISC - Miscellaneous

The following table lists the system fields that access this code table.

 

Entity	Column	Label
Contract	ContractWorkType	Contract Work Type
Proposal	ContractWorkType	Contract Work Type

Related topics:

Code Tables