vr_MasterCheck

Updated November 26, 2025 17:13

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
CheckSubTypeCode	Check Sub Type Code	nvarchar
CheckSubTypeDescription	Check Sub Type Description	nvarchar
CheckSubTypeId	Check Sub Type Id	int
CheckTypeCode	Check Type Code	nvarchar
CheckTypeDescription	Check Type Description	nvarchar
CheckTypeId	Check Type Id	int	vr_checkType
Code	Master Check Code	nvarchar
Control	Check Control (Description)	varchar
ControlDDL	Check Control (Number)	int
CreateCorrectiveWO	Indicates if the record is set to create a corrective Work Order	bit
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Description	Master Check Description	nvarchar
Id	Master Check Id	int
IsMedTester	Indicates if the record is Med Tester	bit
LastUpdated	Last Updated Date	datetime
LowerLimit	Lower Limit	decimal
MeterTypeCode	Meter Type Code	nvarchar
MeterTypeDescription	Meter Type Description	nvarchar
MeterTypeId	Meter Type Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
PriorityCode	Prioirity Code	nvarchar
PriorityDescription	Priority Description	nvarchar
PriorityId	Priority Id	int	vr_Priority
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
TaskId	Task Id	int	vrpt_Task
TradeCode	Trade Code	nvarchar
TradeDescription	Trade Description	nvarchar
TradeId	Trade Id	int	vr_Trade
UpperLimit	Upper Limit	decimal
WOSubTypeCode	Work Order Sub Type Code	nvarchar
WOSubTypeDescription	Work Order Sub Type Description	nvarchar
WOSubTypeId	Work Order Sub Type Id	int
WOTypeCode	Work Order Type Code	nvarchar
WOTypeDescription	Work Order Type Description	nvarchar
WOTypeId	Work Order Type Id	int	vr_WorkOrderType

Articles in this section