vrpt_CEEquipmentWOWizard

Updated December 19, 2025 16:29

Field Name	Field Description	Data Type	FK Join
cc_description	Biomed Equipment Type Description	nvarchar
ccs_description	Biomed Equipment SubType Description	nvarchar
ce_altTag	Biomed Equipment Alternate Tag	nvarchar
ce_bmp	Indicates if the biomed record is on a building maintenance program	bit
ce_controlNumber	Biomed Equipment Control Number	nvarchar
ce_criticalAlarm	Indicates if the biomed record has a critical alarm	bit
ce_fb_fk	Building Id	int	vr_building
ce_fd_fk	Facility Id	int	vr_Facility
ce_fu_fk	Area Record Id	int	vr_area
ce_modelNumber	Biomed Equipment Model Number	nvarchar
ce_pk	Biomed Equipment Id	int	vr_CEEquipment
ce_riskFactor	Biomed Equipment Risk Factor	int
ce_serialNumber	Biomed Equipment Serial Number	nvarchar
ce_warrantyExpiration	Biomed Equipment Warranty Expiration Date	datetime
cefd_name	Facility Name	nvarchar
de_code	Device Code	nvarchar
de_description	Device Description	nvarchar
departmentCode	Department Code	nvarchar
departmentName	Department Name	nvarchar
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
fu_description	Area Description	nvarchar
fu_unitID	Area Location Id	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
id	Biomed Equipment Id	int	vr_CEEquipment
mfg_name	Manufacturer Name	nvarchar
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
ven_name	Vendor Name	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wk_fullname	Technician Full Name	nvarchar
wo_actionRequested	Action Requested	nvarchar
wo_completionDate	Completion (Closed) Date	datetime
wo_dp_fk	Department Id	int	vr_Department
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_fu_fk	Area Record Id	int	vr_area
wo_itemType_fk	Item Type Id	int
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_Workorder
wo_ReferenceNumber	Reference Number	nvarchar
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_status	Work Order Status Note	nvarchar
wo_tag_fk	Item Id	int
wos_duration	Work Order Task Schedule Duration	decimal
woTask_failedPM	Indicates if the PM Failed	bit
woTask_notLocated	Not Located	bit

Articles in this section