vr_EquipmentMakeModel

Updated February 04, 2026 16:00

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
AmpDraw	Amperage Draw	decimal
AmpRating	Amperage Rating	decimal
BtuOut	BTU Out	decimal
BtuPerHour	BTU Per Hour	decimal
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
Description	Make Model Description	nvarchar
DeviceTypeCode	Device Type Code	nvarchar
DeviceTypeDescription	Device Type Description	nvarchar
DeviceTypeId	Device Type Id	int	vr_DeviceType
EquipmentSubTypeCode	Equipment Sub Type Code	nvarchar
EquipmentSubTypeDescription	Equipment Sub Type Description	nvarchar
EquipmentSubTypeId	Equipment Sub Type Id	int
EquipmentTypeCode	Equipment Type Code	nvarchar
EquipmentTypeDescription	Equipment Type Description	nvarchar
EquipmentTypeId	Equipment Type Id	int	vr_equipmentType
Frequency	Frequency	nvarchar
HIPPAComment	HIPPA Comment	nvarchar
HIPPACreate	HIPPA Create	bit
HIPPACriticalLifeSupport	HIPPA Critical Life Support	bit
HIPPAFrequency	HIPPA Frequency	int
HIPPAStore	HIPPA Store	bit
HIPPATransmit	HIPPA Transmit	bit
Id	Equipment Make Model Id	int
InProductionDate	In Production Date	datetime
InServiceDate	In Service Date	datetime
itemType_name	Item Type Name	varchar
ItemTypeId	Item Type Id	int
JCOFKOwned	Joint Commission Id Owned	bit
JointCommissionCategoryCode	Joint Commission Category Code	nvarchar
JointCommissionCategoryDescription	Joint Commission Category Description	nvarchar
JointCommissionCategoryId	Joint Commission Category Id	int
LifeExpectancy	Life Expectancy	int
LifeExpectancyOwned	Life Expectancy Owned	bit
MakeModel	Make Model	nvarchar
MakeName	Make Name	nvarchar
MarketValue	Market Value	decimal
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
OutProductionDate	Out Production Date	datetime
OutServiceDate	Out Service Date	datetime
PowerUse	Power Use	decimal
PurchaseCost	Purchase Cost	decimal
ReplaceCost	Replacement Cost	decimal
ReplaceCostOwned	Replacement Cost Owned	bit
RfEmitting	Radio Frequency Emitting	bit
RiskFactor	Risk Factor	int
RiskFormulaCode	Risk Formula Code	nvarchar
RiskFormulaDefinition	Risk Formula Definition	nvarchar
RiskFormulaDescription	Risk Formula Description	nvarchar
RiskFormulaId	Risk Formula Id	int	vrpt_riskFactor
RiskLevel	Risk Level	int
RiskLevelOwned	Risk Level Owned	bit
riskSource	Risk Score	varchar
SOFKOwned	Standard Operating Procedure Id Owned	bit
SOProcedureCode	Standard Operating Procedure Code	nvarchar
SOProcedureId	Standard Operating Procedure Id	int	vr_SOP
SOProcedureProcedure	Standard Operating Procedure	nvarchar
TagNumber	Tag Number	nvarchar
TypeBased	Indicates if this record is type based	bit
VendorActive	Indicates Whether the Vendor is Active or Not	bit
VendorCode	Vendor Code	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorIsManufacturer	Is Manufacturer	bit
VendorName	Vendor Name	nvarchar

Articles in this section