vrpt_CPWorkElement

Updated February 03, 2026 17:05

Field Name	Field Description	Data Type	FK Join
ai_code	Impact Priority Code	nvarchar
ai_description	Impact Priority Description	nvarchar
ai_level	Impact Priority Level	int
ai_pk	Impact Priority Id	int
ar_code	Justification Code	nvarchar
ar_description	Justification Description	nvarchar
ar_level	Justification Level	int
ar_pk	Justification Id	int
assessor_id	Assessor Record Id (Technician)	nvarchar
assessor_name	Assessor Name (Technician)	nvarchar
assessor_pk	Technician Id	int	vrpt_Technician
bi_act_fk	Project Activity (Task) Id	int	vrpt_ProjectTask
bi_actionEstimate	Action Estimate	decimal
bi_actionEstimateInflated	Action Estimate Inflated	decimal
bi_active	Indicates Whether the Record is Active or Not	bit
bi_ai_fk	Capital Planning Impact Id	int
bi_ar_fk	Justification Id	int
bi_associationCode	Association Code	nvarchar
bi_backlog	Indicates if the record is a backlog	bit
bi_base	Indicates if the work element record is base	bit
bi_baseCostDate	Work Element Base Cost Date	datetime
bi_ce_fk	Biomed Equipment Id	int	vr_CEEquipment
bi_cmi_fk	Capital Planning Master Item Id	int
bi_coiIndex	Work Element Coil Index	decimal
bi_comments	Work Element Comments	nvarchar
bi_coordination	Work Element Coordination	nvarchar
bi_cpa_fk	Capital Planning Audit Id	int	vrpt_cpAudit
bi_cpap_fk	Capital Planning Appropriation Id	int
bi_cpem_fk	Capital Planning Estimate Model Id	int
bi_cpf_fk	Capital Planning Funding Source Id	int
bi_cps_fk	Capital Planning Setup Id	int	vrpt_cpSetup
bi_cpsr_fk	Capital Planning Source Id	int
bi_createdDate	Record Creation Date	datetime
bi_creator_fk	User Id (Record Creator)	int	vr_Users
bi_curr_fk	Currency Id	int	vrpt_Currency
bi_cyi_fk	Cyclic Renewal Id	int
bi_deficiency	Work Element Deficiency	nvarchar
bi_designDate	Work Element Design Date	datetime
bi_dp_fk	Department Id	int	vr_Department
bi_elm_fk	Capital Planning Element Id	int
bi_estimateNotes	Work Element Estimate Notes	nvarchar
bi_estimator_wk_fk	Estimator Id (Technician)	int	vrpt_Technician
bi_exch_date	Currnecy Exchange Date	datetime
bi_exch_fk	Currency Exchange Id	int
bi_fb_fk	Building Id	int	vr_building
bi_fd_fk	Facility Id	int	vr_Facility
bi_ff_fk	Floor Record Id	int	vr_floor
bi_fm_fk	Equipment Id	int	vr_equipment
bi_fu_fk	Area Record Id	int	vr_area
bi_hasEnergyAssessment	Indicates if the work element record has energy assessment	bit
bi_inactionEstimate	Work Element Inaction Estimate	decimal
bi_inactionEstimateInflated	Work Element Inaction Estimate Inflated	decimal
bi_inflationDate	Work Element Inflation Date	datetime
bi_isClientRequest	Indicates if the work element record is a client request	bit
bi_isOptionA	Indicates if the work element record is Option A	bit
bi_isOptionB	Indicates if the work element record is Option B	bit
bi_isOptionC	Indicates if the work element record is Option C	bit
bi_isOptionD	Indicates if the work element record is Option D	bit
bi_isOptionE	Indicates if the work element record is Option E	bit
bi_isOptionF	Indicates if the work element record is Option F	bit
bi_item_fk	Item Id	int
bi_itemCode	Item Code	nvarchar
bi_itemDescription	Item Description	nvarchar
bi_itemType_fk	Item Type Id	int
bi_modifiedDate	Last Modified Date	datetime
bi_modifier_fk	User Id (Record Modifier)	int	vr_users
bi_ns_fk	Entity Id	int	vr_Entity
bi_number	Work Element Number	int
bi_p_fk	Asset Id	int	vr_asset
bi_parent_fk	Parent Work Element Id	int
bi_pk	Work Element Id	int
bi_priority	Work Element Priority	int
bi_projectReference	Work Element Project Reference	varchar
bi_rank	Work Element Rank	int
bi_referenceNumber	Work Element Reference Number	nvarchar
bi_riskDescription	Work Element Risk Description	nvarchar
bi_riskFactor	Work Element Risk Factor	int
bi_riskLevelSource	Work Element Risk Level Source	nvarchar
bi_riskRawScore	Work Element Risk Raw Score	int
bi_rq_fk	Requestor Id	int	vr_Requestor
bi_scheduleDate	Work Element Schedule Date	datetime
bi_scheduleYear	Work Element Schedule Year	int
bi_solution	Work Element Solution	nvarchar
bi_ss_fk	Status Id	int	vr_Status
bi_startDate	Work Element Start Date	datetime
bi_status	Work Element Status	nvarchar
bi_studyDate	Work Element Studay Date	datetime
bi_subLocation	Work Element Sub Location	nvarchar
bi_title	Work Element Title	nvarchar
bi_ven_fk	Vendor Id	int	vr_Vendor
bi_wa_fk	Area Type Id	int	vr_areaType
bi_wet_fk	Work Element Type Id	int
bi_wk_fk	Technician Id	int	vrpt_Technician
bi_wo_fk	Work Order Id	int	vr_WorkOrder
cfg_closeDate	Project Request Phase Detail Closed Date	datetime
cfg_code	Project Request Phase Detail Code	int
cfg_pk	Project Request Phase Detail Id	int
cfg_referenceNumber	Project Request Phase Detail Reference Number	nvarchar
cfg_title	Project Request Phase Detail Title	nvarchar
cfg_wkfl_fk	Work Flow Id	int
cfr_number	Capital Request Number	int
cfr_pk	Capital Request Id	int
cfrbi_cfr_fk	Capital Request Id	int
cfrbi_fundedDate	Capital Request Work Element Funded Date	datetime
cfrbi_isFunded	Indicates if the capital request work element is funded	bit
cipt_code	Capital Planning Project Request Type Code	nvarchar
cipt_description	Capital Planning Project Request Type Description	nvarchar
cipt_pk	Capital Planning Project Request Type Id	int
cpap_code	Capital Planning Appropriation Code	nvarchar
cpap_description	Capital Planning Appropriation Description	nvarchar
cpap_pk	Capital Planning Appropriation 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	Capital Planning Funding Source Code	nvarchar
cpf_description	Capital Planning Funding Source Description	nvarchar
cpf_pk	Capital Planning Funding Source Id	int
cpht_description	Capital Planning Phase Type Description	nvarchar
cpprp_budget	Capital Planning Project Request Phase Budget	numeric
cpprp_budgetYear	Capital Planning Project Request Phase Budget Year	int
cpprp_isFunded	Indicates if the capital planning project request phase is funded	bit
cpprp_name	Capital Planning Project Request Phase Name	nvarchar
cpprp_pk	Capital Planning Project Request Phase Id	int
cpprp_scheduleDate	Capital Planning Project Request Phase Schedule Date	datetime
cpprp_wkfl_fk	Work Flow Id	int
cps_bi_formula_fk	Work Element Formula Id	int
cps_code	Capital Planning Setup Code	nvarchar
cps_description	Capital Planning Setup Description	nvarchar
cps_pk	Capital Planning Setup Id	int	vrpt_cpSetup
cpsr_code	Capital Planning Source Code	nvarchar
cpsr_description	Capital Planning Source Description	nvarchar
cpsr_pk	Capital Planning Source Id	int
cyi_frequency	Cyclic Renewal Frequency	int
cyi_number	Cyclic Renewal Number	int
cyi_pk	Cyclic Renewal Id	int	vrpt_cpCyclicRenewal
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
dp_pk	Department Id	int	vr_Department
elm_code	Capital Planning Element Code	nvarchar
elm_description	Capital Planning Element Description	nvarchar
elm_level	Capital Planning Element Level	int
elm_levelDescription	Capital Planning Element Level Description	nvarchar
elm_pk	Capital Planning Element Id	int	vr_cpElement
estimator_id	Estimator Record Id	nvarchar
estimator_name	Estimator Name	nvarchar
estimator_pk	Estimator Id	int	vrpt_Technician
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
fm_buildingFixture	Indicates if the equipment record is a part of a building fixture	bit
fu_description	Area Description	nvarchar
fu_pk	Area Id	int	vr_area
fu_roomNumber	Area Room Number	nvarchar
fu_unitID	Area Location Id	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Work Element Id	int
level1Code	Level 1 Code	nvarchar
level1Description	Level 1 Description	nvarchar
level1PK	Level 1 Id	int
level2Code	Level 2 Code	nvarchar
level2Description	Level 2 Description	nvarchar
level2PK	Level 2 Id	int
level3Code	Level 3 Code	nvarchar
level3Description	Level 3 Description	nvarchar
level3PK	Level 3 Id	int
level4Code	Level 4 Code	nvarchar
level4Description	Level 4 Description	nvarchar
level4PK	Level 4 Id	int
parent_number	Parent Work Element Number	int
parent_pk	Parent Work Element Id	int
proj_number	Project Number	nvarchar
proj_pk	Project Record Id	int	vr_Project
proj_requestDate	Project Request Date	datetime
requestorName	Requestor Name	nvarchar
rq_pk	Requestor Id	int	vr_Requestor
ven_code	Vendor Code	nvarchar
ven_name	Vendor Name	nvarchar
ven_pk	Vendor Id	int	vr_Vendor
wa_code	Area Type Code	nvarchar
wa_description	Area Type Description	nvarchar
wet_code	Work Element Type Code	nvarchar
wet_description	Work Element Type Description	nvarchar
wet_designated	Work Element Type Designation	nvarchar
wet_parent_fk	Work Element Type Parent Id	int
wet_pk	Work Element Type Id	int
wets_code	Work Element Sub Type Code	nvarchar
wets_description	Work Element Sub Type Description	nvarchar
wets_pk	Work Element Sub Type Id	int
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder

Articles in this section