vr_FailureCode

Updated November 24, 2025 16:29

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
Code	Failure Code	nvarchar
CorrectiveAction	Corrective Action	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
DaysToComplete	Days To Complete	int
Description	Failure Code Description	nvarchar
Id	Failure Code Id	int
Manual	Indicates if the Manual Corrective WO checkbox is checked or Not	bit
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ParentId	Failure Code Parent Id	int	vr_failureCode
PriorityCode	Corrective WO Priority Code	nvarchar
PriorityDescription	Corrective WO Priority Description	nvarchar
PriorityDueInterval	Corrective WO Priority Due Date Interval	int
PriorityDueIntervalType	Corrective WO Priority Due Date Interval Type (i.e. Day, Week, Month, Year)	nvarchar
PriorityId	Corrective WO Priority Id	int	vr_Priority
RequireCorrective	Indicates if the Failure Code is setup properly to automatically create a Corrective WO	bit
TaskCode	Corrective WO Task Code	nvarchar
TaskDescription	Corrective WO Task Description	nvarchar
TaskId	Corrective WO Task Id	int	vrpt_Task
TaskTypeCode	Corrective WO Task Type Code	nvarchar
TaskTypeDescription	Corrective WO Task Type Description	nvarchar
TaskTypeId	Corrective WO Task Type Id	int	vr_TaskType
TradeCode	Corrective WO Trade Code	nvarchar
TradeDescription	Corrective WO Trade Description	nvarchar
TradeId	Corrective WO Trade Id	int	vr_Trade
WorkOrderTypeCode	Corrective WO Type Code	nvarchar
WorkOrderTypeDescription	Corrective WO Type Description	nvarchar
WorkOrderTypeId	Corrective WO Type Id	int	vr_WorkOrderType

Articles in this section