vrpt_WorkOrderBuilding

Updated January 27, 2026 14:58

Field Name	Field Description	Data Type	FK Join
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Work Order Id	int	vr_WorkOrder
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
wo_ActionRequested	Action Requested	nvarchar
wo_actionRequiredByDepartment	Action Required by Department	bit
wo_buildingServicesSignoff	Building Service Signoff Date	datetime
wo_charge	Indicates Whether the Work Order is Chargeable or Not	bit
wo_completiondate	Completion (Closed) Date	datetime
wo_createddate	Record Creation Date	datetime
wo_creator_fk	User Id (Record Creator)	int	vr_users
wo_cst_fk	Account Id	int	vr_account
wo_departmentAction	Department Action	nvarchar
wo_departmentHead	Department Head	nvarchar
wo_departmentSignoff	Department Signoff	datetime
wo_dp_fk	Department Id	int	vr_Department
wo_estimatedenddate	Estimated End Date	datetime
wo_estimatedstartdate	Estimated Start Date	datetime
wo_fb_fk	Building Id	int	vr_building
wo_fd_fk	Facility Id	int	vr_Facility
wo_ff_fk	Floor Record Id	int	vr_floor
wo_finishDate	Finish Date	datetime
wo_fu_fk	Area Record Id	int	vr_area
wo_itemType_fk	Item Type Id	int
wo_log_fk	Request Log Id	int	vr_Request
wo_modifiedDate	Last Modified Date	datetime
wo_modifier_fk	User Id (Record Modifier)	int	vr_users
wo_number	Work Order Number	nvarchar
wo_operatorError	Operator Error	bit
wo_outofservice	Indicates if the work order's item is out of service	bit
wo_pk	Work Order Id	int	vr_WorkOrder
wo_potentialRiskToOperator	Indicates if the work order's item is a potential risk to the operator	bit
wo_potentialRiskToPatient	Indicates if the work order's item is a potential risk to the patient	bit
wo_pri_fk	Priority Id	int	vr_Priority
wo_printDate	Last Print Date	datetime
wo_proj_fk	Project Id	int	vr_Project
wo_rc_fk	Repair Center Id	int	vr_RepairCenter
wo_referencenumber	Reference Number	nvarchar
wo_RequestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_RequestorEmail	Requestor Email	nvarchar
wo_RequestorPhone	Requestor Phone #	nvarchar
wo_SLPostDate	Sub Ledger Post Date	datetime
wo_status	Work Order Status Note	nvarchar
wo_supervisor	Work Order Supervisor	nvarchar
wo_tag_fk	Item Id	int
wo_techcomments	Tech Comments	nvarchar
wo_wc_fk	Work Order Type Id	int	vr_WorkOrderType
wo_wcs_fk	Work Order Sub Type Id	int

Articles in this section