vrpt_cpSetup

Updated December 22, 2025 15:28

Field Name	Field Description	Data Type	FK Join
biFormula_code	Work Element Risk Formula Code	nvarchar
biFormula_description	Work Element Risk Formula Description	nvarchar
biFormula_pk	Work Element Risk Formula Id	int
cfgFormula_code	Capital Planning Project Request Formula Code	nvarchar
cfgFormula_description	Capital Planning Project Request Formula Description	nvarchar
cfgFormula_pk	Capital Planning Project Request Formula Id	int
cps_advanceBudgetYear	Advance Budget Year	bit
cps_averageInflation	Average Inflation	decimal
cps_bi_formula_fk	Work Element Risk Formula Id	int
cps_budgetMidPoint	Budget Mid Point	datetime
cps_budgetYear	Budget Year	int
cps_cfg_formula_fk	Capital Planning Project Request Formula Id	int
cps_code	Setup Code	nvarchar
cps_createdDate	Record Creation Date	datetime
cps_creator_fk	User Id (Record Creator)	int	vr_users
cps_defaultInflationRate	Default Inflation Rate	decimal
cps_description	Setup Description	nvarchar
cps_goal	Goal	decimal
cps_lastBudgetYear	Last Budget Year	int
cps_modifiedDate	Last Modified Date	datetime
cps_modifier_fk	User Id (Record Modifier)	int	vr_users
cps_month	Month	int
cps_nextBudgetYear	Next Budget Year	int
cps_pk	Capital Planning Setup Id	int
cps_projectNumberPrefix	Project Number Prefix	nvarchar
cps_projectNumberStartingPoint	Project Number Starting Point	int
cps_projectNumberSuffix	Project Number Suffix	nvarchar
cps_pt_fk	Project Type Id	int	vr_ProjectType
cps_rc_fk	Repair Center Id	int	vr_RepairCenter
cps_tenYear	Ten year	int
cps_yearSpan	Year Span	int
Id	Capital Planning Setup Id	int
pt_code	Project Type Code	nvarchar
pt_description	Project Type Description	nvarchar
pt_pk	Project Type Id	int	vr_ProjectType
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
rc_pk	Repair Center Id	int	vr_RepairCenter

Articles in this section