vrpt_cpProjectRequestPhase

Updated April 06, 2026 15:22

Field Name	Field Description	Data Type	FK Join
ai_code	Impact Priority Code	nvarchar
ai_description	Impact Priority Description	nvarchar
ar_code	Justification Code	nvarchar
ar_description	Justification Description	nvarchar
cfg_cipt_fk	Capital Planning Project Request Type Id	int
cfg_closeDate	Closed Date	datetime
cfg_code	Capital Planning Project Request Code	int
cfg_cps_fk	Capital Planning Setup Id	int	vrpt_cpSetup
cfg_date	Capital Planning Project Request Date	datetime
cfg_fb_fk	Building Id	int	vr_building
cfg_fd_fk	Facility Id	int	vr_Facility
cfg_pk	Capital Planning Project Request Id	int	vrpt_cpProjectRequest
cfg_title	Capital Planning Project Request Title	nvarchar
cfg_wkfl_fk	WebTMA Workflow Id	int
cpem_code	Capital Planning Estimate Model Code	nvarchar
cpem_description	Capital Planning Estimate Model Description	nvarchar
cpf_code	Capital Planning Funding Source Code	nvarchar
cpf_description	Capital Planning Funding Source Description	nvarchar
cpht_code	Capital Planning Phase Type Code	nvarchar
cpht_description	Capital Planning Phase Type Description	nvarchar
cpprp_ar1_fk	Capital Planning Justification 1 Id	int
cpprp_ar2_fk	Capital Planning Justification 2 Id	int
cpprp_baseCostDate	Capital Planning Project Request Phase Base Cost Date	datetime
cpprp_budget	Capital Planning Project Request Phase Budget	numeric
cpprp_budgetYear	Capital Planning Project Request Phase Budget Year	int
cpprp_cfg_fk	Capital Planning Project Request Id	int	vrpt_cpProjectRequest
cpprp_closedDate	Capital Planning Project Request Phase Closed Date	datetime
cpprp_cpem_fk	Capital Planning Estimate Model Id	int
cpprp_cpf_fk	Capital Planning Funding Source Id	int
cpprp_cpht_fk	Capital Planning Phase Type Id	int
cpprp_curr_fk	Currency Id	int	vrpt_Currency
cpprp_description	Capital Planning Project Request Phase Description	nvarchar
cpprp_exch_date	Currency Exchange Date	datetime
cpprp_exch_fk	Currency Exchange Id	int
cpprp_fundedDate	Capital Planning Project Request Phase Funded Date	datetime
cpprp_isFunded	Indicates if the record is funded	bit
cpprp_name	Capital Planning Project Request Phase Name	nvarchar
cpprp_parent_fk	Capital Planning Project Request Phase Parent Id	int
cpprp_pk	Capital Planning Project Request Phase Id	int
cpprp_proj_fk	Project Id	int	vr_Project
cpprp_scheduleDate	Capital Planning Project Request Phase Schedule Date	datetime
cpprp_wkfl_fk	WebTMA Workflow Id	int
database_wkfl_fk	WebTMA Workflow Id	int
enactedAmount	Enacted Amount	decimal
estimatedAmount	Estimated Amount	decimal
fb_code	Building Code	nvarchar
fb_fbt_fk	Building Type Id	int	vr_buildingType
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_fdt_fk	Facility Type Id	int	vr_facilityType
fd_name	Facility Name	nvarchar
Id	Capital Planning Project Request Phase Id	int
proj_number	Project Number	nvarchar
unfundedAmount	Unfunded Amount	decimal
wkfl_code	Workflow Code	nvarchar
wkfl_description	Workflow Description	nvarchar

Articles in this section