vrpt_FailureAnalysisforAsset

Updated December 22, 2025 16:25

Field Name	Field Description	Data Type	FK Join
ac_code	Asset Type Code	nvarchar
ac_description	Asset Type Description	nvarchar
fa_code	Failure Code	nvarchar
fa_description	Failure Description	nvarchar
fb_code	Building Code	nvarchar
fb_name	Building Name	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	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
p_description	Asset Description	nvarchar
p_modelNumber	Asset Model Number	nvarchar
p_tagNumber	Asset Tag Number	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