vrpt_BaseEquipmentRequlatory

Updated December 19, 2025 16:04

Field Name	Field Description	Data Type	FK Join
departmentcode	Department Code	nvarchar
departmentname	Department Name	nvarchar
equip_dp_code	Equipment Department Code	nvarchar
equip_dp_name	Equipment Department Name	nvarchar
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fc_code	Equipment Type Code	nvarchar
fc_description	Equipment Type Description	nvarchar
fcs_code	Equipment Sub Type Code	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_active	Indicates if the Record is Active or Not	bit
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_riskFactor	Equipment Risk Factor	int
fm_serialNumber	Equipment Serial Number	nvarchar
fm_tagNumber	Equipment Tag Number	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
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