Budget Banners_Available Funds_FV_Region 3

dashboard.udot.utah.gov | Last Updated 11 Jan 2019

Tags: pll, projects

This dataset has the following 153 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
REGIONregiontextData Set RPDU_Budget Banners_Data Set RPDU_Budget Charts_Data Set RPDU_Scope_Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set Dashboard and Section RPDU BudgetBanner RPDU Budget Open
PINpinnumberProject Identification Number Data Set RPDU_Schedule_Data Set RPDU_Scope_Data Set RPDU_Budget Banners_Data Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set RPDU Schedule RPDU Scope RPDU BudgetBanner RPDU Budget
PIN_DESCRIPTIONpin_descriptiontextData Set RPDU_Schedule_Data Set RPDU_Scope_Data Set RPDU_Budget Banners_Data Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set RPDU Schedule RPDU Scope RPDU BudgetBanner RPDU Budget
PIN_STATUS_NAMEpin_status_nametextText description of PIN Data Set RPDU_Schedule_Data Set RPDU_Budget Banners_Data Set Dashboard and Section RPDU Schedule RPDU BudgetBanner
PROJECT_MANAGERproject_managertextData Set RPDU_Scope_Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
RESIDENT_ENGINEERresident_engineertextData Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
PROJECT_VALUEprojcet_valuenumber
TOTAL_EXPENDEDtotal_expendednumber
POTENTIAL_AVAIL_FUNDSpotential_avail_fundsnumber
SUBMITTED_ADVERTISE_DATEsubmitted_advertise_datecalendar_dateThe date specified by management that indicates when design work on the improvement should be completed and the bid package sent to Central Construction for advertising. Each project scheduled must have a submit for advertising date. This date is entered on Screen 510 - "Target Completion Dates." Data Set RPDU_Schedule_Data Set RPDU_Budget Banners_Data Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set
COMMITTED_ADVERTISE_DATEcommitted_advertise_datecalendar_dateProjects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
ACTUAL_ADVERTISE_DATEactual_advertise_datecalendar_dateThe date a project is officially advertised for contractor bid for construction. RPDU_Schedule_Data Set RPDU_Scope_Data Set RPDU_Budget Banners_Data Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Projects_Duration_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
WILL_ADVERTISE_FLAGwill_advertise_flagtextAn indicator of whether a project will be advertised for bids in the usual manner. Data Set RPDU_Schedule_Data Set RPDU_Budget Banners_Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set Dashboard and Section RPDU Schedule RPDU BudgetBanner
LOCAL_GOVTlocal_govttextThis field sets a flag that this PIN is a Local Government project. Data Set RPDU_Schedule_Data Set RPDU_Scope_Data Set RPDU_Budget Banners_Data Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set Dashboard and Section RPDU Schedule RPDU Scope RPDU BudgetBanner RPDU Budget
PDLpdltextProject Delivery List Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
FEDERAL_OR_STATE_PROJECTfederal_or_state_projecttextData Set Projects_Base_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
SCHEDULEscheduletextData Set RPDU_Schedule_Data Set RPDU_Budget Banners_Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set Dashboard and Section RPDU Schedule RPDU BudgetBanner
ACTIVE_STATUS_DATEactivie_status_datecalendar_dateData Set Projects_Base_Data_Set
ADVERTISED_DURATIONadvertised_durationnumberData Set Projects_Base_Data_Set
BASELINE_MANAGEMENT_RESERVEbaseline_management_reservenumberData Set Projects_Base_Data_Set
CD_DATEcd_datecalendar_dateData Set Projects_Base_Data_Set
CLOSED_DATEclosed_datecalendar_dateData Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set
CLOSED_STATUS_DATEclosed_status_datecalendar_dateData Set Projects_Base_Data_Set
CLOSEOUT_STATUS_DATEcloseout_status_datecalendar_dateData Set Projects_Base_Data_Set
CONCEPT_FORCE_RECONconcept_force_recontextData Set Projects_Base_Data_Set
CONSTRUCTION_YEARconstruction_yeartextData Set Projects_Base_Data_Set
CONSTRUCTION_BEGIN_QUARTERconstruction_begin_quartertextData Set Projects_Base_Data_Set
CONSTRUCTION_BEGIN_YEARconstruction_begin_yearnumberData Set Projects_Base_Data_Set
CONSTRUCTION_BEGIN_DATEconstruction_begin_datecalendar_dateData Set Projects_Base_Data_Set
CURRENT_CONTRACT_AWARDcurrent_contract_awardtextData Set Projects_Base_Data_Set
DE_CONSUL_MKTde_consul_mkttextData Set Projects_Base_Data_Set
CONSULT_DESIGN_ENGINEER_NAMEdesign_engineer_nametextData Set Projects_Base_Data_Set
POSSIBLE_FED_PROJECTpossible_fed_projecttextData Set Projects_Base_Data_Set
DE_CONS_INDde_cons_indtextData Set Projects_Base_Data_Set
EFFECTIVE_DATEeffective_datecalendar_dateData Set Projects_Base_Data_Set
EFFICIENCY_INDICATORefficiency_indicatortextData Set Projects_Base_Data_Set
EPM300_MASTERepm300_masternumberData Set Projects_Base_Data_Set
FAA_REQ_EMAIL_INDfaa_req_email_indtextData Set Projects_Base_Data_Set
FINAL_VOUCHER_DATEfinal_vourcher_datecalendar_dateData Set Projects_Base_Data_Set
FMIS_END_DATE_CLOSEOUTfmis_end_date_closeoutcalendar_dateData Set Projects_Base_Data_Set
FMIS_END_DATE_PEfmis_end_date_pecalendar_dateData Set Projects_Base_Data_Set
FMIS_END_DATE_ROWfmis_end_date_rowcalendar_dateData Set Projects_Base_Data_Set
FINALIZE_CONCEPT_COMPL_DATEfinalize_concept_compl_datecalendar_dateData Set Projects_Base_Data_Set
MASTER_PINmaster_pinnumberData Set RPDU_Scope_Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Funding_Amendments_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
OSR_DATE_CHECKosr_date_checktextData Set Projects_Base_Data_Set
OSR_DATE_UNCHECKosr_date_unchecktextData Set Projects_Base_Data_Set
OSR_PIN_STATUS_AT_CHECKosr_pin_status_at_checktextData Set Projects_Base_Data_Set
OSR_PIN_STATUS_AT_UNCHECKosr_pin_status_at_unchecktextData Set Projects_Base_Data_Set
OSR_REQUESTosr_requesttextData Set Projects_Base_Data_Set
PDL_TYPEpdl_typenumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
PIN_STATUS_CODEpin_status_codetextThe code that identifies the PIN Status. Data Set RPDU_Schedule_Data Set RPDU_Scope_Data Set RPDU_Budget Banners_Data Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Schedule RPDU Scope RPDU BudgetBanner RPDU Budget
PLANNED_CONSTR_DURATIONplanned_constr_durationnumberEstimated number of days between first and last construction expense. Also used to estimate duration of physical construction. Data Set Projects_Base_Data_Set Projects_Duration_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
PLANNED_CONSTR_END_DATEplanned_constr_end_datecalendar_dateEstimated date that the final construction expense will be incurred. Frequently used to estimate when physical construction will end. Data Set Projects_Base_Data_Set Projects_Duration_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
PLANNED_CONSTR_START_DATEplanned_constr_start_datecalendar_dateEstimated date that the first construction expense will be incurred. Frequently used to estimate when physical construction will begin. Data Set Projects_Base_Data_Set Projects_Duration_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
PMO_ACTIVITY_END_DATE_ROWpmo_activity_end_date_rowcalendar_dateData Set Projects_Base_Data_Set
PMO_ACTIVITY_END_DATE_UTILpmo_activity_end_date_utilcalendar_dateData Set Projects_Base_Data_Set
PREVIOUS_SUBMIT_ADVERTISE_DATEprevious_submit_advertise_datecalendar_dateData Set Projects_Base_Data_Set
PROJECT_DELIVERY_CODEproject_delivery_codenumber
PROJECT_DELIVERY_METHODproject_delivery_methodtextData Set RPDU_Budget Banners_Data Set Projects_Base_Data_Set Dashboard and Section RPDU BudgetBanner
COST_ESTIMATEcost_estimatenumber
PROPOSED_SCOPING_DATEproposed_scoping_datecalendar_dateData Set Projects_Base_Data_Set
SCOPING_START_DATEscoping_start_datecalendar_dateData Set Projects_Base_Data_Set
SCOPING_STATUS_INDICATORscoping_status_indicatortextData Set Projects_Base_Data_Set
STIP_STATUS_DATEstip_status_datecalendar_dateData Set Projects_Base_Data_Set
SUBMIT_ADVERTISE_DATE_BMR_DATEsubmit_advertise_date_bmr_datecalendar_dateData Set Projects_Base_Data_Set
WORK_START_DATEwork_start_datecalendar_dateData Set Projects_Base_Data_Set
ACTIVE_INDICATORactive_indicatortextData Set Projects_Base_Data_Set
ADVANCE_CONSTRUCTION_INDICATORadvance_construction_indicatortextData Set Projects_Base_Data_Set
AUTHORITYauthoritytextData Set Projects_Base_Data_Set
COMMISSION_RPRT_START_DATEcommission_rprt_start_datecalendar_date
COMMISSION_APPROVED_AMOUNTcommission_approved_amountnumberData Set Projects_Base_Data_Set
COMMISSTION_APPROVED_AMOUNT2commisstion_approved_amount2numberData Set Projects_Base_Data_Set
COMMISSTION_APPROVED_AMOUNT3commisstion_approved_amount3numberData Set Projects_Base_Data_Set
COMMISSTION_APPROVED_AMOUNT4commisstion_approved_amount4numberData Set Projects_Base_Data_Set
COMMISSTION_APPROVED_AMOUNT5commisstion_approved_amount5numberData Set Projects_Base_Data_Set
CONSTR_OBLIGATION_INDICATORconstr_obligation_indicatortextData Set Projects_Base_Data_Set
CURRENT_COMMISS_APPROVED_AMTcurrent_commiss_approved_amtnumberData Set Projects_Base_Data_Set Projects_Funding_Amendments_Data_Set
CURRENT_COMMISS_APPROVED_DATEcurrent_commiss_approved_datecalendar_dateData Set Projects_Base_Data_Set
CURRENT_COMMISS_APPROVED_YEARcurrent_commiss_approved_yearnumberData Set Projects_Base_Data_Set
CURRENT_CONSTRUCTION_AMOUNTcurrent_construction_amountnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set
CURRENT_CONTINGENCY_AMOUNTcurrent_contingency_amountnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_ESTIMATORcurrent_estimatortextData Set Projects_Base_Data_Set
CURRENT_EST_CONCEPT_DEVELcurrent_est_concept_develnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_EST_CONSTR_ENGINEERINGcurrent_est_constr_engineeringnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_EST_CST_DATEcurrent_est_cst_datecalendar_dateData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_EST_ENVIRONMENTALcurrent_est_environmentalnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_EST_PRECON_ENGINEERINGcurrent_est_precon_engineeringnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_INCENTIVE_AMOUNTcurrent_incentive_amountnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_MISCELLANEOUS_AMOUNTcurrent_miscellanious_amountnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_RIGHT_OF_WAY_AMOUNTcurrent_right_of_way_amountnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_UTILITIES_AMOUNTcurrent_utilities_amountnumberData Set RPDU_Budget Charts_Data Set Projects_Base_Data_Set Dashboard and Section RPDU Budget
CURRENT_YEARcurrent_yearnumberData Set Projects_Base_Data_Set
ENVIRON_OBLIGATION_INDICATORenviron_obligation_indicatortextData Set Projects_Base_Data_Set
FIRST_COMMISS_APPROVAL_YEARfirst_commiss_approval_yearnumberData Set Projects_Base_Data_Set
FUNCTION_CLASSfunction_classnumberData Set Projects_Base_Data_Set
PROJECT_MILESproject_milesnumberLENGTH OF THE PROJECT Data Set Projects_Base_Data_Set
LOCAL_GOVT_COMMITTED_AMOUNTlocal_govt_committed_amountnumberData Set Projects_Base_Data_Set
LOCAL_GOVT_PARTICIP_AMOUNTlocal_govt_particip_amountnumberData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_SOURCElocal_govt_fund_sourcetextData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_SOURCE2local_govt_fund_source2textData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_SOURCE3local_govt_fund_source3textData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_SOURCE4local_govt_fund_source4textData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_SOURCE5local_govt_fund_source5textData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_YEARlocal_govt_fund_yearnumberData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_YEAR2local_govt_fund_year2numberData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_YEAR3local_govt_fund_year3numberData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_YEAR4local_govt_fund_year4numberData Set Projects_Base_Data_Set
LOCAL_GOVT_FUND_YEAR5local_govt_fund_year5numberData Set Projects_Base_Data_Set
LOW_BIDlow_bidnumberData Set Projects_Base_Data_Set
NATIONAL_HIGHWAYnational_highwaytextData Set Projects_Base_Data_Set
OTHER_OVERSIGHT_DESCother_oversight_desctextData Set Projects_Base_Data_Set
PRECON_ENGINEERING_OBL_INDICprecon_engineering_obl_indictextData Set Projects_Base_Data_Set
PERCENT_LOW_BID_ESTIMATEpercent_low_bid_estimatenumberData Set Projects_Base_Data_Set
PROJECT_OVERSIGHTproject_oversighttextData Set Projects_Base_Data_Set
PROJECT_NUMBERproject_numbertextData Set Projects_Base_Data_Set
PROJECT_TYPEproject_typetextData Set Projects_Base_Data_Set Projects_Duration_Data_Set Projects_Ledger_Refresh_Data_Set
PROJECT_XREF_NUMBERproject_xref_numbernumberData Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
RIGHT_OF_WAY_OBL_INDICATORright_of_way_obl_indicatortextData Set Projects_Base_Data_Set
STIP_PROGRAM_YEARstip_program_yearnumberData Set Projects_Base_Data_Set
STIP_REF_MULT_YRstip_ref_mult_yrtextData Set Projects_Base_Data_Set
STIP_REFERENCE_NUMBERstip_reference_numbernumberData Set Projects_Base_Data_Set
SUBCATEGORY_ENABLEDsubcategory_enabledtextData Set Projects_Base_Data_Set
TERMINATION_DATEtermination_datetextData Set Projects_Base_Data_Set
UDOT_APPROVALudot_approvaltextData Set Projects_Base_Data_Set
STIP_STATUSstip_statustextData Set RPDU_Budget Banners_Data Set Projects_Base_Data_Set
AS_OF_DTGas_of_dtgcalendar_dateData Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
COMMITTED_ADVERTISING_STATUScommitted_advertising_statustextData Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
SUBMITTED_ADVERTISING_STATUSsubmitted_advertising_statustextData Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
HIST_COMMIT_ADVERTISING_STATUShist_commit_advertising_statustextData Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
SUBMIT_CHART_FLAGsubmit_chart_flagnumberData Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
FOR_RPDU_SCHEDULE_HISTORYfor_rpdu_schedule_historycalendar_dateThis column should be used to filter for the Schedule History chart, filtered view, and data lens Data Set Projects_Base_Data_Set Projects_Contract_Details_Data_Set Projects_Duration_Data_Set Projects_Funding_Amendments_Data_Set Projects_Ledger_Refresh_Data_Set Projects_Pin_Status_Data_Set Projects_Project_Expense_Funding_Allocation_Data_Set
CONCEPT_DEVELOPMENT_EXPENDconcept_development_expendnumber
CONSTR_ENGINEERING_EXPENDconstr_engineering_expendnumber
CONSTRUCTION_EXPENDconstruction_expendnumber
ENVIRONMENTAL_EXPENDenvironmental_expendnumber
MISCELLANEOUS_EXPENDmiscellaneous_expendnumber
OVER_NEGOTIATED_HOURS_FLAGover_negotiated_hours_flagtext
PRECON_ENGINEERING_EXPENDprecon_engineering_expendnumber
RIGHT_OF_WAY_EXPENDright_of_way_expendnumber
UTILITIES_EXPENDutilities_expendnumber
PUBLIC_DESCRIPTIONpublic_descriptiontext
PM_EMAILpm_emailtext
PM_PHONEpm_phonetext
PDBS_PLANNED_CONSTR_STRT_DATEpdbs_planned_constr_strt_datecalendar_date
PDBS_CONSTR_START_DATEpdbs_constr_start_datecalendar_date
PDBS_PLAN_CONSTR_END_DATEpdbs_plan_constr_end_datecalendar_date
PDBS_PLANNED_CONSTR_DURATIONpdbs_planned_constr_durationnumber
ENGINEER_ESTIMATEengineer_estimatenumber
ORIGINAL_CONTRACT_AMOUNToriginal_contract_amountnumber
AWARD_DATEaward_datecalendar_date
AVERAGE_BIDaverage_bidnumber
ACTUAL_ADVERTISE_DATE_MONTHactual_advertise_date_monthtext
PEAK_ADVERTISING_FLAGpeak_advertising_flagnumber