vr_CPWorkElement

Updated November 21, 2025 16:37

Field Name	Field Description	Data Type	FK Join
ActionEstimate	Action Estimate	decimal
ActionEstimateInflated	Action Estimate Inflated	decimal
Active	Indicates if the Record is Active or Not	bit
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AreaTypeCode	Area Type Code	nvarchar
AreaTypeDescription	Area Type Description	nvarchar
AreaTypeId	Area Type Id	int	vr_areaType
AssetDescription	Asset Description	nvarchar
AssetId	Asset Id	int	vr_asset
AssetTagNumber	Asset Tag Number	nvarchar
AssociationCode	Association Code	nvarchar
AuditRequestLogId	Request Log Id	int	vr_Request
AuditRequestLogNumber	Request Log Number	nvarchar
Backlog	Back Log	bit
Base	Base	bit
BaseCostDate	Base Cost Date	datetime
BaseOption	Base Option	int
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CEEquipmentControlNumber	Biomed Equipment Control Number	nvarchar
CEEquipmentId	Biomed Equipment Id	int	vr_CEEquipment
CEEquipmentName	Biomed Equipment Name	nvarchar
ClosedDate	Closed Date	datetime
CoiIndex	COI Index	decimal
Comments	Comments	nvarchar
Coordination	Coordination	nvarchar
CPAppropriationCode	Appropriation Code	nvarchar
CPAppropriationDescription	Appropriation Description	nvarchar
CPAppropriationId	Appropriation Id	int
CPAuditId	Audit Id	int	vrpt_cpAudit
CPAuditNumber	Capital Planning Audit Number	int
CPCapitalRequestRevisionId	Capital Request Revision Id	int
CPCapitalRequestRevisionNumber	Capital Request Revision Number	int
CPCyclicRenewalFrequency	Cyclic Renewal Frequency	int
CPCyclicRenewalId	Cyclic Renewal Id	int	vrpt_cpCyclicRenewal
CPCyclicRenewalNumber	Cyclic Renewal Number	int
CPElement1Code	UniFormat Level 1 Code	nvarchar
CPElement1CodeDescription	UniFormat Level 1 Code-Description	nvarchar
CPElement1Description	UniFormat Level 1 Description	nvarchar
CPElement1Id	UniFormat Level 1 Id	int	vr_cpElement
CPElement2Code	UniFormat Level 2 Code	nvarchar
CPElement2Description	UniFormat Level 2 Description	nvarchar
CPElement2Id	UniFormat Level 2 Id	int	vr_cpElement
CPElement3Code	UniFormat Level 3 Code	nvarchar
CPElement3Description	UniFormat Level 3 Description	nvarchar
CPElement3Id	UniFormat Level 3 Id	int	vr_cpElement
CPElement4Code	UniFormat Level 4 Code	nvarchar
CPElement4Description	UniFormat Level 4 Description	nvarchar
CPElement4Id	UniFormat Level 4 Id	int	vr_cpElement
CPElmCode	UniFormat Code (Highest Level)	nvarchar
CPElmDescription	UniFormat Description (Highest Level)	nvarchar
CPEstimateModelCode	Estimate Model Code	nvarchar
CPEstimateModelDescription	Estimate Model Description	nvarchar
CPEstimateModelId	Estimate Model Id	int
CPFundingRequestId	Funding Request Id	int	vr_cpFundingRequest
CPFundingRequestNumber	Funding Request Number	int
CPFundingRequestWorkElementLinkFundedDate	Work Element Funded Date	datetime
CPFundingRequestWorkElementLinkIsFunded	Indicates Whether or Not the Work Element is Funded	bit
CPFundingSourceCode	Funding Source Code	nvarchar
CPFundingSourceDescription	Funding Source Description	nvarchar
CPFundingSourceId	Funding Source Id	int
CPImpactCode	Impact Code	nvarchar
CPImpactDescription	Impact Description	nvarchar
CPImpactId	Impact Id	int
CPImpactLevel	Impact Level	int
CPJustificationCode	Justification Code	nvarchar
CPJustificationDescription	Justification Description	nvarchar
CPJustificationId	Justification Id	int
CPJustificationLevel	Justification Level	int
CPMasterItemCode	Master Item Code	nvarchar
CPMasterItemDescription	Master Item Description	nvarchar
CPMasterItemId	Master Item Id	int
CPProjectRequestCode	Work Element Group Code	int
CPProjectRequestId	Capital Planning Project Request Id	int	vrpt_cpProjectRequest
CPProjectRequestPhaseIsFunded	Work Element Group is Funded	bit
CPProjectRequestReferenceNumber	Work Element Group Reference Number	nvarchar
CPProjectRequestTitle	Work Element Group Title	nvarchar
CPSetupCode	Capital Setup Code	nvarchar
CPSetupDescription	Capital Setup Description	nvarchar
CPSetupId	Captial Setup Id	int	vrpt_cpSetup
CPSetupWorkElementFormulaId	Risk Formula Id	int
CPSourceCode	Source Code	nvarchar
CPSourceDescription	Source Description	nvarchar
CPSourceId	Source Id	int
CPWorkElementActionEstimateInflated	Action Estimate Inflated Total	decimal
CPWorkElementSubtypeCode	Work Element SubType Code	nvarchar
CPWorkElementSubtypeDescription	Work Element SubType Description	nvarchar
CPWorkElementSubtypeId	Work Element SubType Id	int
CPWorkElementTypeCode	Work Element Type Code	nvarchar
CPWorkElementTypeDescription	Work Element Type Description	nvarchar
CPWorkElementTypeDesignated	Work Element Type Designation	nvarchar
CPWorkElementTypeId	Work Element Type Id	int
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CreatorName	Creator Name	nvarchar
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
Deficiency	Deficiency	nvarchar
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
DesignDate	Design Date	datetime
EntityCode	Entity Code	nvarchar
EntityDescription	Entity Description	nvarchar
EntityId	Entity Id	int	vr_Entity
EquipmentBuildingFixture	Indicates Whether or Not the Equipment Record is a Building Asset or Not	bit
EquipmentDescription	Equipment Description	nvarchar
EquipmentId	Equipment Id	int	vr_equipment
EquipmentTagNumber	Equipment Tag Number	nvarchar
EstimateNotes	Estimate Notes	nvarchar
EstimatorTechnicianCode	Estimator Technician Code	nvarchar
EstimatorTechnicianId	Estimator Technician Id	int	vrpt_Technician
EstimatorTechnicianName	Estimator Technician Name	nvarchar
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
HasEnergyAssessment	Indicates Whether or Not the Work Element has an Energy Assessment or Not	bit
Id	Work Element Id	int
InactionEstimate	Inaction Estimate Total	decimal
InactionEstimateInflated	Inaction Estimate Inflated Total	decimal
InflationDate	Inflation Date	datetime
IsClientRequest	Indicates if the Work Element is a Client Reqeust or Not	bit
IsOptionA	H20 Conser.	bit
IsOptionB	Preservation	bit
IsOptionC	ADA	bit
IsOptionD	Environmental	bit
IsOptionE	Energy Savings	bit
IsOptionF	Other	bit
ItemDescription	Item Description	nvarchar
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemTypeId	Item Type Id	int
LocationCode	Location Code	nvarchar
LocationId	Location Id	int
LocationName	Location Name	nvarchar
LocationTypeId	Location Type Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Work Element Number	int
ParentId	Work Element Parent Id	int	vr_CPWorkElement
ParentNumber	Work Element Parent Number	int
Priority	Priority	int
ProjectActivityId	Project Activity Id	int	vrpt_ProjectTask
ProjectReference	Project Reference	varchar
Rank	Rank	int
ReferenceNumber	Reference Number	nvarchar
RequestLogId	Request Log Id	int	vr_Request
RequestLogNumber	Request Log Number	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RiskDescription	Risk Description	nvarchar
RiskFactor	Risk Factor	int
RiskLevelSource	Risk Level Source	nvarchar
RiskRawScore	Risk Raw Score	int
ScheduleDate	Schedule Date	datetime
ScheduledDate	Scheduled Date	datetime
ScheduleYear	Schedule Year	int
Solution	Solution	nvarchar
StartDate	Start Date	datetime
StatusAllowNote	Indicates if this record allows a status note	bit
StatusCode	Status Code	nvarchar
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
StudyDate	Study Date	datetime
SubLocation	Sub Location	nvarchar
SubTotal	Sub Total	decimal
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
Title	Title	nvarchar
TransactionDate	Transaction Date	datetime
VendorCode	Vendor Code	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
WorkFlowId	Work Flow Id	int
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar

Articles in this section