vr_MonitoredCondition

Updated November 26, 2025 17:17

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
CheckTypeCode	Check Type Code	nvarchar
CheckTypeDescription	Check Type Description	nvarchar
CheckTypeId	Check Type Id	int	vr_checkType
Code	Monitored Condition Code	nvarchar
ConsecutivePoint	Consecutive Point	int
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DailyAverage	Indicates if the record utilizes Daily Average	bit
DateRange	Indicates if the record utilizes Date Range	bit
Description	Description	nvarchar
EndDate	End Date	datetime
EstimatedLabor	Estimated Labor	decimal
FreeUnitMeasure	Free Unit Measure	nvarchar
HighAlarm	High Alarm	decimal
HighWarning	High Warning	decimal
Id	Monitored Condition Id	int
LowAlarm	Low Alarm	decimal
LowWarning	Low Warning	decimal
MaxValue	MaxValue	decimal
MfgSpec	Indicates if the record has Manufacturer Specifications	bit
MinValue	Minimum Value	decimal
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
StartDate	Start Date	datetime
StdDev1	Indicates if the record is using Standard Deviation 1	bit
StdDev2	Indicates if the record is using Standard Deviation 2	bit
StdDev3	Indicates if the record is using Standard Deviation 3	bit
UnitMeasureCode	Unit Measure Code	nvarchar
UnitMeasureDescription	Unit Measure Description	nvarchar
UnitMeasureId	Unit of Measure Id	int	vr_UnitMeasure