vrpt_CEEquipmentPMWizard

Updated December 19, 2025 16:25

Field Name	Field Description	Data Type	FK Join
apply	Apply	varchar
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
con_endDate	Contract End Date	datetime
con_number	Contract Number	nvarchar
cont_code	Contractor Code	nvarchar
cst_code	Account Code	nvarchar
de_code	Device Code	nvarchar
de_description	Device Description	nvarchar
dp_code	Department Code	nvarchar
dp_name	Department Name	nvarchar
fd_name	Facility Name	nvarchar
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
fo_averageTime	Task Average Time	decimal
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
ftr_code	Trade Code	nvarchar
ftr_description	Trade Description	nvarchar
groupID	Group Id	nvarchar
id	Biomed Equipment Id	int	vr_CEEquipment
interval_name	Interval Name	nvarchar
isGroup	Is Group	varchar
meter_name	Meter Name	nvarchar
mfg_name	Manufacturer Name	nvarchar
pm_active	Indicates if the Record is Active or Not	bit
pm_averageMeter	Average Meter	decimal
pm_con_fk	Contract Id	int	vr_contract
pm_cont_fk	Contractor Id	int	vr_Vendor
pm_createddate	Record Creation Date	datetime
pm_creator_fk	User Id (Record Creator)	int	vr_Users
pm_cst_fk	Account Id	int	vr_account
pm_daysToComplete	Days To Complete	int
pm_dp_fk	Department Id	int	vr_Department
pm_estimatedTime	Estimated Time	decimal
pm_fixedDay	Fixed Day	bit
pm_Floating	Floating	bit
pm_floatStatus	Float Status	bit
pm_fo_fk	Task Id	int	vrpt_task
pm_ftr_fk	Trade Id	int	vr_Trade
pm_interval	Interval	int
pm_interval_fk	Interval Id	int
pm_item_fk	Item Id	int
pm_itemType_fk	Item Type Id	int
pm_lastDate	Last Date	datetime
pm_lastPMMeter	Last PM Meter	decimal
pm_meter_fk	Meter Id	int	vr_meter
pm_meterMarginPercentage	Meter Margin Percentage	decimal
pm_modifiedDate	Last Modified Date	datetime
pm_modifier_fk	User Id (Record Modifier)	int	vr_users
pm_nextDate	Next Date	datetime
pm_nextMeter	Next Meter	decimal
pm_pk	PM Schedule Id	int	vr_PMSchedule
pm_pri_fk	Priority Id	int	vr_Priority
pm_projNextDate	Projected Next Date	datetime
pm_rc_fk	Repair Center Id	int	vr_RepairCenter
pm_riskLevel	Risk Level	decimal
pm_rts_fk	Rate Schedule Id	int	vr_rateSchedule
pm_seasonEnd	Season End	datetime
pm_seasonStart	Season Start	datetime
pm_startDate	Start Date	datetime
pm_startMeter	Start Meter	decimal
pm_wc_fk	Work Order Type Id	int	vr_WorkOrderType
pm_wh_fk	Warehouse Id	int	vr_warehouse
pm_wk_fk	Technician Id	int	vrpt_Technician
pm_workorderCharge	Work Order Charge	bit
pri_code	Priority Code	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
rts_code	Rate Schedule Code	nvarchar
rts_description	Rate Schedule Description	nvarchar
ven_name	Vendor Name	nvarchar
wc_code	Work Order Type Code	nvarchar
wc_description	Work Order Type Description	nvarchar
wh_code	Warehouse Code	nvarchar
wh_name	Warehouse Name	nvarchar
wk_fullName	Technician Full Name	nvarchar
wk_id	Technician Record Id	nvarchar

Articles in this section