vrpt_BaseCEEquipmentRegulatory

Updated December 19, 2025 16:02

Field Name	Field Description	Data Type	FK Join
cc_code	Biomed Equipment Type Code	nvarchar
cc_description	Biomed Equipment Type Description	nvarchar
ccs_code	Biomed Equipment SubType Code	nvarchar
ccs_description	Biomed Equipment SubType Description	nvarchar
ce_active	Indicates if the Record is Active or Not	bit
ce_bmp	Indicates if the biomed equipment record is on a building maintenance program	bit
ce_controlnumber	Biomed Equipment Control Number	nvarchar
ce_modelnumber	Biomed Equipment Model Number	nvarchar
ce_name	Biomed Equipment Name	nvarchar
ce_riskFactor	Biomed Equipment Risk Factor	int
ce_serialnumber	Biomed Equipment Serial Number	nvarchar
de_code	Device Code	nvarchar
de_description	Device Description	nvarchar
departmentcode	Department Code	nvarchar
departmentname	Department Name	nvarchar
equip_dp_code	Biomed Equipment Department Code	nvarchar
equip_dp_name	Biomed Equipment 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
fu_description	Area Description	nvarchar
fu_roomNumber	Area Room Number	nvarchar
fu_unitid	Area Location Id	nvarchar
Id	Work Order Task Id	int	vr_WorkOrderTask
pm_daystocomplete	PM Days to Complete	int
pm_interval	PM Interval	int
pm_interval_name	PM Interval Name	nvarchar
pm_lastdate	PM Last Date	datetime
pm_nextdate	PM Next Date	datetime
pm_pri_code	PM Priority Code	nvarchar
pm_pri_description	PM Priority Description	nvarchar
pm_rc_code	Repair Center Code	nvarchar
pm_rc_name	Repair Center Name	nvarchar
pm_tech_firstName	PM Technician First Name	nvarchar
pm_tech_id	PM Technician Id	nvarchar
pm_tech_lastname	PM Technician Last Name	nvarchar
pm_trade_code	PM Trade Code	nvarchar
pm_trade_desc	PM Trade Description	nvarchar
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
wo_completiondate	Completion (Closed) Date	datetime
wo_itemtype_fk	Item Type Id	int
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_requestdate	Request Date	datetime
wo_status	Work Order Status Note	nvarchar
wo_tag_fk	Item Id	int
wotask_completiondate	Completion Date (Closed Date)	datetime
wotask_failedpm	Indicates if the PM Failed	bit
wotask_finishdate	Finish Date	datetime
wotask_fo_fk	Task Id	int	vrpt_task
wotask_notlocated	Not Located	bit
wotask_pk	Work Order Task Id	int	vr_WorkOrderTask
wotask_pm_fk	PM Schedule Id	int	vr_PMSchedule
wotask_worknotdone	Work Not Done	bit

Articles in this section