vrpt_cpCyclicRenewal

Updated December 22, 2025 15:26

Field Name	Field Description	Data Type	FK Join
ai_code	Impact Priority Code	nvarchar
ai_description	Impact Priority Description	nvarchar
ai_pk	Impact Priority Id	int
ar_code	Justification Code	nvarchar
ar_description	Justification Description	nvarchar
ar_pk	Justification Id	int
cmi_code	Capital Planning Master Item Code	nvarchar
cmi_description	Capital Planning Master Item Description	nvarchar
cmi_pk	Capital Planning Master Item Id	int
cpem_code	Capital Planning Estimate Model Code	nvarchar
cpem_description	Capital Planning Estimate Model Description	nvarchar
cpem_pk	Capital Planning Estimate Model Id	int
cpf_code	Funding Source Code	nvarchar
cpf_description	Funding Source Description	nvarchar
cps_bi_formula_fk	Work Element Risk Formula Id	int
cps_code	Setup Code	nvarchar
cps_description	Setup Description	nvarchar
cps_pk	Setup Id	int	vrpt_cpSetup
cyi_actionEstimate	Action Estimate	decimal
cyi_actionEstimateInflated	Action Estimate Inflated	decimal
cyi_active	Indicates if the Record is Active or Not	bit
cyi_age	Age	decimal
cyi_ai_fk	Capital Planning Audit Id	int	vrpt_cpAuidt
cyi_annualEstimate	Annual Estimate	decimal
cyi_ar_fk	Capital Planning Justification Id	int
cyi_averageEstimate	Average Estimate	decimal
cyi_baseCostDate	Base Cost Date	datetime
cyi_ce_fk	Biomed Equipment Id	int	vr_CEEquipment
cyi_cmi_fk	Capital Planning Master Item Id	int
cyi_coiIndex	Coil Index	decimal
cyi_comments	Comments	nvarchar
cyi_coordination	Coordination	nvarchar
cyi_cpem_fk	Capital Planning Estimate Model Id	int
cyi_cpf_fk	Funding Source Id	int
cyi_cps_fk	Setup Id	int	vrpt_cpSetup
cyi_createdDate	Record Creation Date	datetime
cyi_creator_fk	User Id (Record Creator)	int	vr_users
cyi_curr_fk	Currency Id	int	vrpt_Currency
cyi_deficiency	Deficiency	nvarchar
cyi_deteriorationRate	Deterioration Rate	decimal
cyi_elm_fk	Element Id	int	vr_cpElement
cyi_estimateNotes	Estimate Notes	nvarchar
cyi_exch_date	Currency Exchange Date	datetime
cyi_exch_fk	Currency Exchange Id	int
cyi_extension	Extension	int
cyi_fb_fk	Building Id	int	vr_building
cyi_fd_fk	Facility Id	int	vr_Facility
cyi_ff_fk	Floor Record Id	int	vr_floor
cyi_fm_fk	Equipment Id	int	vr_equipment
cyi_frequency	Frequency	int
cyi_fu_fk	Area Record Id	int	vr_area
cyi_inactionEstimate	Inaction Estimate	decimal
cyi_inactionEstimateInflated	Inaction Estimate Inflated	decimal
cyi_inflationDate	Inflation Date	datetime
cyi_isFloating	Indicates if the Record is floating or not	bit
cyi_item_fk	Item Id	int
cyi_itemCode	Item Code	nvarchar
cyi_itemDescription	Item Description	nvarchar
cyi_itemType_fk	Item Type Id	int
cyi_lastCycleDate	Last Cycle Date	datetime
cyi_levelCycleDate	Level Cycle Date	datetime
cyi_lifeExpectancy	Life Expectancy	int
cyi_modifiedDate	Last Modified Date	datetime
cyi_modifier_fk	User Id (Record Modifier)	int	vr_users
cyi_nextBudgetYear	Next Budget Year	int
cyi_nextCycleDate	Next Cycle Date	datetime
cyi_ns_fk	Entity Id	int	vr_Entity
cyi_number	Cyclic Renewal Number	int
cyi_p_fk	Asset Id	int	vr_asset
cyi_pk	Cyclic Renewal Id	int
cyi_riskDescription	Risk Description	nvarchar
cyi_riskFactor	Risk Factor	int
cyi_riskLevelSource	Risk Level Source	nvarchar
cyi_riskRawScore	Risk Raw Score	int
cyi_tagType_fk	Tag Type Id	int
cyi_wet_fk	Work Element Type	int
cyi_wk_fk	Technician Id	int	vrpt_Technician
elm_code	Element Code	nvarchar
elm_levelDescription	Element Level Description	nvarchar
elm_pk	Element Id	int	vr_cpElement
fb_code	Building Code	nvarchar
fb_fbt_fk	Building Type Id	int	vr_buildingType
fb_name	Building Name	nvarchar
fb_pk	Building Id	int	vr_building
fd_code	Facility Code	nvarchar
fd_fdt_fk	Facility Type Id	int	vr_facilityType
fd_name	Facility Name	nvarchar
fd_pk	Facility Id	int	vr_Facility
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
ff_pk	Floor Id	int	vr_floor
fu_description	Area Description	nvarchar
fu_pk	Area Record Id	int	vr_area
fu_roomNumber	Area Room Number	nvarchar
fu_unitID	Area Location Id	nvarchar
Id	Cyclic Renewal Id	int
lastClosedDate	Last Closed Date	datetime
level1Code	Level 1 Code	nvarchar
level1Description	Level 1 Description	nvarchar
level1PK	Level 1 PK	int
level2Code	Level 2 Code	nvarchar
level2Description	Level 2 Description	nvarchar
level2PK	Level 2 PK	int
level3Code	Level 3 Code	nvarchar
level3Description	Level 3 Description	nvarchar
level3PK	Level 3 PK	int
level4Code	Level 4 Code	nvarchar
level4Description	Level 4 Description	nvarchar
level4PK	Level 4 PK	int
nextScheduleDate	Next Schedule Date	datetime
ScheduleCycle	Schedule Cycle	datetime
wet_code	Work Element Type Code	nvarchar
wet_description	Work Element Type Description	nvarchar
wet_pk	Work Element Type Id	int
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar
wk_pk	Technicain Id	int	vrpt_Technician

Articles in this section