vr_Equipment

Updated December 22, 2025 14:47

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ACIActualPercent	ACI Actual Percent	decimal
ACIReplaceCost	ACI Replace Cost	decimal
ACITargetPercent	ACI Target Percent	decimal
AcquisitionCost	Acquistion Cost	decimal
Active	Indicates if the Record is Active or Not	bit
ActiveComputed	Active Computed	bit
AmperageDraw	Amperage Draw	decimal
AmperageRating	Amperage Rating	decimal
AreaActive	Indicates if the Area is Active or Not	bit
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AssignedTechnicianCode	Assigned Technician Code	nvarchar
AssignedTechnicianId	Assigned Technician Id	int	vrpt_Technician
AssignedTechnicianName	Technician Name	nvarchar
BasePMDate	Base PM Date	datetime
Belt1Name	Belt 1 Name	nvarchar
Belt1Quantity	Belt 1 Quantity	int
Belt1Size	Belt 1 Size	nvarchar
Belt2Name	Belt 2 Size	nvarchar
Belt2Quantity	Belt 2 Quantity	int
Belt2Size	Belt 2 Size	nvarchar
BIMUniqueId	BIM Unique Id	nvarchar
Bmp	BMP	bit
BTUOut	BTU Out	decimal
BTUPerHour	BTU Per Hour	decimal
BuildingActive	Indicates if the Building is Active or Not	bit
BuildingCode	Building Code	nvarchar
BuildingFixture	Building Fixture	bit
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CalibratedThrough	Calibrated Through	datetime
CertificationExpires	Certification Expires	datetime
Code	Equipment Code (Tag Number)	nvarchar
ColdWater	Cold Water	nvarchar
Comments	Comments	nvarchar
CompressedAir	Compressed Air	nvarchar
CPSetupCode	Capital Setup Code	nvarchar
CPSetupDescription	Capital Setup Description	nvarchar
CPSetupId	Capital Setup Id	int	vrpt_cpSetup
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
CurrentMeter	Current Meter	decimal
DeliveryCode	Delivery Code	nvarchar
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Equipment Description	nvarchar
DeviceNumber	Device Number	nvarchar
DeviceTypeCode	Device Type Code	nvarchar
DeviceTypeDescription	Device Type Description	nvarchar
DeviceTypeId	Device Type Id	int	vr_DeviceType
DisableMakeModelPMUpdate	Indicates if the Disable Make Model PM Update Checkbox is Checked or Not	bit
DISP	DISP Date	datetime
Disposed	Indicates if this Equipment has been Disposed or Not	bit
DistrictId	District Id	int	vr_district
DrawingName	Drawing Name	nvarchar
ECRICode	ECRI Code	nvarchar
Electrical1	Electrical 1	nvarchar
Electrical2	Electrical 2	nvarchar
Electrical3	Electrical 3	nvarchar
EquipmentSubTypeCode	Equipment Sub Type Code	nvarchar
EquipmentSubTypeDescription	Equipment Sub Type Description	nvarchar
EquipmentSubTypeId	Equipment Sub Type Id	int	vr_equipmentSubType
EquipmentTypeCode	Equipment Type Code	nvarchar
EquipmentTypeDescription	Equipment Type Description	nvarchar
EquipmentTypeId	Equipment Type Id	int	vr_equipmentType
EquipmentTypeRiskLevel	Equipment Type Risk Level	int
FAAPaperworkRequired	Indicates if FAA Paperwork is Required or Not	bit
FacilityActive	Indicates if the Facility is Active or Not	bit
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FilterInfo	Filter Info	nvarchar
FilterOther	Filter Other	nvarchar
FilterQuantity	Filter Quantity	nvarchar
FilterSize	Filter Size	nvarchar
FloorActive	Indicates if the Floor is Active or Not	bit
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
FM_LST_OP_ER	Obsolete Column (No Longer Used)	datetime
FM_LST_PAT_RISK	Obsolete Column (No Longer Used)	datetime
FreshAir	Fresh Air	nvarchar
FullLocation	Full Location	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Gas	Gas	nvarchar
GISLatitude	GIS Latitude	float
GISLongitude	GIS Longitude	float
GISUniqueId	GIS Unique Id	uniqueidentifier
HasCyclicRenewal	Indicates if the Equipment is tied to a Cyclic Renewal or Not	bit
HasPopupMessage	Indicates if the Equipment Record has a Pop Up Message or Not	int
HotWater	Hot Water	nvarchar
Id	Equipment Id	int
Image	Image	nvarchar
InspectedBy	Inspected By	nvarchar
InspectionDate	Inspection Date	datetime
InventoryConditionCode	Inventory Condition Code	nvarchar
InventoryConditionDescription	Inventory Condition Description	nvarchar
InventoryConditionId	Inventory Condition Id	int
IsCalibratable	Indicates if the Equipment is Calibratable or Not	bit
JointCommissionCategoryCode	Joint Commission Category Code	nvarchar
JointCommissionCategoryDescription	Joint Commission Category Description	nvarchar
JointCommissionCategoryId	Joint Commission Category Id	int
LastCalibrationDate	Last Calibration Date	datetime
LastCertificationDate	Last Certification Date	datetime
LastInventoryDate	Last Inventory Date	datetime
LastInventoryLocation	Last Inventory Location	nvarchar
Latitude	Latitude	float
Lbs	Pounds	int
Leased	Indicates if the Equipment is Lease or Not	bit
LifeExpectancy	Life Expectancy	int
LockoutCode	Lockout Code	nvarchar
LockoutId	Lockout Id	int
LockoutName	Lockout Name	nvarchar
Longitude	Longitude	float
LubeExtra1	Lube Extra 1	nvarchar
MajorTag	Major Tag	nvarchar
Make	Make	nvarchar
MakeModelId	Make Model Id	int	vr_equipmentMakeModel
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
MeterDigits	Meter Digits	int
MeterRolloverCounter	Meter Rollover Counter	int
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Equipment Name	nvarchar
NextCertificationDate	Next Certification Date	datetime
ObjectId	Object Id	int
OriginalCost	Original Cost	decimal
OutOfService	Indicates if the Equipment is Out of Service or Not	bit
OwnerDepartmentCode	Owner Department Code	nvarchar
OwnerDepartmentId	Owner Department Id	int	vr_Department
OwnerDepartmentName	Owner Department Name	nvarchar
Ozs	Ounces	decimal
ParentId	Equipment Parent Id	int	vr_equipment
ParentTagNumber	Equipment Parent Tag Number	nvarchar
Part1MFG	Part 1 MFG	nvarchar
Part1Model	Part 1 Model #	nvarchar
Part1Name	Part 1 Name	nvarchar
Part1Serial	Part 1 Serial	nvarchar
Part1Type	Part 1 Type	nvarchar
Part2MFG	Part 2 MFG	nvarchar
Part2Model	Part 2 Model #	nvarchar
Part2Name	Part 2 Name	nvarchar
Part2Serial	Part 2 Serial	nvarchar
Part2Type	Part 2 Type	nvarchar
Part3MFG	Part 3 MFG	nvarchar
Part3Model	Part 3 Model #	nvarchar
Part3Name	Part 3 Name	nvarchar
Part3Serial	Part 3 Serial	nvarchar
Part3Type	Part 3 Type	nvarchar
Part4MFG	Part 4 MFG	nvarchar
Part4Model	Part 4 Model	nvarchar
Part4Name	Part 4 Name	nvarchar
Part4Serial	Part 4 Serial	nvarchar
Part4Type	Part 4 Type	nvarchar
PartsVendor	Part Vendor	nvarchar
PartVendorCode	Part Vendor Code	nvarchar
PartVendorId	Part Vendor Id	int	vr_Vendor
PartVendorName	Part Vendor Name	nvarchar
PONumber	Purchaser Order Number	nvarchar
PopupMessage	Popup Message	nvarchar
PowerUsage	Power Usage	decimal
PreferredRepairCenterId	Repair Center Id	int	vr_RepairCenter
PreventArchival	Indicates if the Prevent Archival Checkbox is Checked	bit
PurchaseDate	Purchase Date	datetime
PurgeDate	Purge Date	datetime
RatingDate	Rating Date	datetime
RatingValue	Rating Value	int
RefrigerantId	Refrigerant Id	int	vr_Refrigerant
RefrigerantLbs	Refrigerant Pounds	decimal
RefrigerantOunces	Refrigerant Ounces	decimal
RefrigerantPounds	Refirgerant or Ibs (to 2dps)	decimal
RefrigerantTypeCode	Refirgerant Type Code	nvarchar
RefrigerantTypeDescription	Refrigerant Type Description	nvarchar
RefrigerantTypeId	Refrigerant Type Id	int	vr_RefrigerantType
RegisteredDate	Registered Date	datetime
RiskFactor	Risk Factor	int
RiskLevelSource	Risk Score Level	nvarchar
SecondaryId	Alternate Tag #	nvarchar
SerialNumber	Serial Number	nvarchar
ServiceContract	Service Contract	bit
ServiceContractExpires	Service Contract Expiration Date	datetime
ServiceContractPhone	Service Contract Phone #	nvarchar
ServiceInterruptionArea	Service Interruption Area	nvarchar
ServicePrecautions	Service Precaustions	nvarchar
Sewer	Sewer	nvarchar
SOPCode	Standard Operating Procedure Code	nvarchar
SOPId	Standard Operating Procedure Id	int	vr_SOP
SOPName	Standard Operating Procedure Name	nvarchar
StartingHours	Starting Hours	decimal
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
Steam	Steam	nvarchar
SubLocation	Sub Location	nvarchar
Supplies	Supplies	nvarchar
SystemSubTypeCode	System Sub Type Code	nvarchar
SystemSubTypeDescription	System Sub Type Description	nvarchar
SystemSubTypeId	System Sub Type Id	int
SystemTypeCode	System Type Code	nvarchar
SystemTypeDescription	System Type Description	nvarchar
SystemTypeId	System Type Id	int	vr_SystemType
TagNumber	Tag Number	nvarchar
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
UsageFlatRate	Usage Flat Rate	decimal
UsageUnit	Usage Unit	nvarchar
UsageUnitCost	Usage Unit Cost	decimal
Vacuum	Vaccum	nvarchar
VehicleDescription	Vehicle Description	nvarchar
VehicleId	VehicleId	int	vr_Vehicle
VehicleTagNumber	Vehicle Tag Number	nvarchar
VendorCode	Vendor Code	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
WarrantyDate	Warranty Date	datetime

Articles in this section