vrpt_FailureAnalysisforVehicle

Updated December 22, 2025 16:37

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
fv_description	Vehicle Description	nvarchar
fv_modelYear	Vehicle Model Year	nvarchar
fv_tagNumber	Vehicle Tag Number	nvarchar
Id	Work Order Task Id	int	vr_WorkOrderTask
tv_code	Vehicle Type Code	nvarchar
tv_description	Vehicle 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