vrpt_EquipmentWOWizard

Updated December 22, 2025 16:02

Field Name	Field Description	Data Type	FK Join
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
fc_description	Equipment Type Description	nvarchar
fcs_description	Equipment Sub Type Description	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
fm_bmp	Indicates if the equipment record is on a building maintenance program	bit
fm_description	Equipment Description	nvarchar
fm_modelNumber	Equipment Model Number	nvarchar
fm_pk	Equipment Id	int	vr_Equipment
fm_riskFactor	Equipment Risk Factor	int
fm_secondaryID	Equipment Secondary Id	nvarchar
fm_serialNumber	Equipment Serial Number	nvarchar
fm_tagNumber	Equipment Tag Number	nvarchar
fm_warrantyExpires	Equipment Warranty Expires Date	datetime
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	Equipment Id	int	vr_equipment
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_tag_fk	Item Id	int
wos_duration	Work Order Schedule Duration	decimal
woTask_failedPM	Indicates if the PM Failed	bit
woTask_notLocated	Not Located	bit

Articles in this section