vrpt_FailureAnalysisforArea

Updated December 22, 2025 16:23

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
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
wa_code	Area Type Code	nvarchar
wa_description	Area Type Description	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