vrpt_FailureAnalysisforEquip

Updated December 22, 2025 16:31

Field Name	Field Description	Data Type	FK Join
fa_code	Failure Code	nvarchar
fa_description	Failure Description	nvarchar
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fc_code	Equipment Type Code	nvarchar
fc_description	Equipment Type Description	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
fm_description	Equipment Description	nvarchar
fm_modelNumber	Equipment Model Number	nvarchar
fm_tagNumber	Equipment Tag Number	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fu_description	Area Description	nvarchar
fu_unitID	Area Location Id	nvarchar
Id	Work Order Task Id	int	vr_WorkOrderTask
syt_code	System Type Code	nvarchar
syt_description	System Type Description	nvarchar
ven_code	Vendor Code	nvarchar
ven_name	Vendor Name	nvarchar
wo_actionRequested	Action Requested	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
woTask_completionDate	Completion Date (Closed Date)	datetime
woTask_pk	Work Order Task Id	int	vr_WorkOrderTask