Budget Banners_No Adv Date_FV_Region 3

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

This dataset has the following 43 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
REGION_NAMEregion_nametextSelf-explanatory
REGIONregiontextRegion code 1, 2, 3, 4, etc.
PINpinnumberProject Identification Number
PROJECT_REF_NUMBERproject_ref_numbernumberThe Project cross reference number: used as a primary and foreign key to link various data tables
PIN_STATUSpin_statustextThe description of the PIN Status code
PROJECT_IDproject_idnumberThe PDBS project ID
PROJECT_NUMBERproject_numbertextThe ePM project number
PIN_DESCRIPTIONpin_descriptiontextTextual description of the PIN
PROJECT_MANAGERproject_managertextResponsible project manager
RESIDENT_ENGINEERresident_engineertextResponsible resident engineer
LOCAL_GOVTlocal_govttextLocal gov't project; Y or N
AWARD_DATEaward_datecalendar_dateDate project contract was awarded
PROJECT_VALUEproject_valuenumberValue expensed against a project
DASHBOARDdashboardtextWhich banner does this section of the query belong to
FMIS_NUMBERfmis_numbertextFederal ID assigned to the transaction
ADVERTISE_DATEadvertise_datecalendar_dateSelf-explanatory
SUBMITTED_ADVERTISE_DATEsubmitted_advertise_datecalendar_dateSelf-explanatory
CONSTRUCTION_DATEconstruction_datecalendar_dateSelf-explanatory
CURRENT_YEAR_PLANNED_FUNDScurrent_year_planned_fundsnumberWhat is planned to be obligated in the current Federal FY
FUTURE_YEAR_PLANNED_FUNDSfuture_year_planned_fundsnumberWhat is planned to be obligated in the next three Federal FY
PRIOR_OBLIGATIONSprior_obligationsnumberAll funds obligated in prior Federal Fiscal Years
CURRENT_OBLIGATIONScurrent_obligationsnumberAll funds actually obligated in current Federal FY
CURRENT_ACcurrent_acnumberValue of Advances Construction funds obligated in current Federal FY
WILL_ADVERTISE_FLAGwill_advertise_flagtextProject will advertise: Y or N
STIP_STATUSstip_statustextSelf-explanatory
DELIVERY_METHODdelivery_methodtextSelf-explanatory
CURRENT_YEAR_FUNDScurrent_year_fundsnumberExtracted, but no longer used
PROJECT_DESCRIPTIONproject_descriptiontextSame as PIN description
COST_ESTIMATE_AMOUNTcost_estimate_amountnumberUDOT estimate of what a project will cost
COMMITTED_ADVERTISE_DATEcommitted_advertise_datecalendar_dateSelf-explanatory
SCHEDULEschedulenumberCalculated code that indicates where the committed advertise date falls, with respect to the current date
BUDGETbudgetnumberCalculated code that indicates whether a project is over or under budget
DIFFERENCEdifferencenumberNot used
LABEL2label2textNot used
PERCENT_OF_VALUEpercent_of_valuetextText that whether a project is over or under budget
STATUSstatustextProject status, pulled from ePM
PRIORITYprioritytextIs this a priority project: Y or N
CONSTRUCTION_BUDGETconstruction_budgetnumberCreated in R for comparisons
CONSTRUCTION_EXPENDITURESconstruction_expendituresnumberCreated in R for comparisons
PDLpdltextIs PDL: Y or N
EXPENSE_TO_CONTR_BUDGETexpense_to_contr_budgettextCreated in R for comparisons
EXPENSE_TO_PROJ_VALUEexpense_to_proj_valuetextCreated in R for comparisons
AS_OF_DTGas_of_dtgcalendar_dateAs of date of the dataset