vr_ITEquipment

Updated November 25, 2025 16:21

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountID	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ACIActualPercent	Asset Condition Index Actual Percent	decimal
ACIReplaceCost	Asset Condition Index Replace Cost	decimal
ACITargetPercent	Asset Condition Index Target Percent	decimal
AcquisitionCost	Acquistion Cost	decimal
Active	Indicates if the Record is Active or Not	bit
ActiveComputed	Active Computed	bit
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
AssignedToCode	Assigned Technician Code	nvarchar
AssignedToId	Technician Id	int	vrpt_Technician
AssignedToLastFirst	Assigned Technician Last First Name	nvarchar
AssignedToName	Assigned Technician Name	nvarchar
BMP	Indicates if the record is using the Building Maintenance Program	bit
BuildingActive	Indicates if the Building is Active or Not	bit
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CalibratedThrough	Calibrated Through	datetime
CEEquipmentControlNumber	Biomed Equipment Control Number	nvarchar
CEEquipmentId	Biomed Equipment Id	int	vr_CEEquipment
CEEquipmentName	Biomed Equipment Name	nvarchar
Comments	Comments	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CreatorName	Creator Name	nvarchar
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	IT Equipment Description	nvarchar
Disposed	Indicates if this IT Equipment has been Disposed or Not	bit
DistrictId	District Id	int	vr_district
DivisionId	Division Id	int
FacilityActive	Indicates if the Facility is Active or Not	bit
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FinalUsageFlatRate	Final Usage Flat Rate	decimal
FinalUsageUnit	Final Usage Unit	nvarchar
FinalUsageUnitCost	Final Usage Unit Cost	decimal
FloorActive	Indicates if the Floor is Active or Not	bit
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
FullLocation	Full Location	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
HasPopupMessage	Indicates if the IT Equipment Record has a Popup Message or Not	int
Id	IT Equipment Id	int
Image	Image	nvarchar
InventoryConditionCode	Inventory Condition Code	nvarchar
InventoryConditionDescription	Inventory Condition Description	nvarchar
InventoryConditionId	Inventory Condition Id	int
IPAddress	IP Address	nvarchar
ItemDescription	Item Description	nvarchar
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemTypeId	Item Type Id	int
ITEquipmentSubTypeCode	IT Equipment SubType Code	nvarchar
ITEquipmentSubTypeDescription	IT Equipment SubType Description	nvarchar
ITEquipmentSubTypeId	IT Equipment SubType Id	int
ITEquipmentTypeCode	IT Equipment Type Code	nvarchar
ITEquipmentTypeDescription	IT Equipment Type Description	nvarchar
ITEquipmentTypeId	IT Equipment Type Id	int	vr_ITEquipmentType
itfm_pk	IT Equipment Id	int
LastCalibrationDate	Last Calibration Date	datetime
LastInventoryDate	Last Inventory Date	datetime
LastInventoryLocation	Last Inventory Location	nvarchar
Latitude	Latitude	float
Leased	Indicates if the IT Equipment is Leased or Not	bit
LifeExpectancy	Life Expectancy	int
Longitude	Longitude	float
MACAddress	MAC Address	nvarchar
MajorTag	Major Tag #	nvarchar
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ModifierName	Modifier Name	nvarchar
OutofService	Indicates if the IT Equipment is Out of Service	bit
ParentId	IT Equipment Parent Id	int	vr_ITEquipment
ParentTagNumber	IT Equipment Parent Tag #	nvarchar
PartVendorCode	Part Vendor Code	nvarchar
PartVendorId	Part Vendor Id	int	vr_Vendor
PartVendorName	Part Vendor Name	nvarchar
PONumber	Purchase Order #	nvarchar
PopupMessage	Popup Message	nvarchar
PreferredRepairCenterCode	Repair Center Code	nvarchar
PreferredRepairCenterId	Repair Center Id	int	vr_RepairCenter
PreventArchival	Indicates if the Prevent Archival Checkbox is Checked or Not	bit
PurchaseDate	Purchase Date	datetime
RegionId	Region Id	int	vr_region
RegisteredDate	Registered Date	datetime
RiskFactor	Risk Factor	int
SerialNumber	Serial Number	nvarchar
ServiceContract	Indicates if the IT Equipment Record is Tied to a Service Contract	bit
ServiceContractExpires	Service Contract Expiration Date	datetime
ServiceContractPhone	Service Contract Phone #	nvarchar
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
SubLocation	Sub Location	nvarchar
TagNumber	Tag Number	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
UsageFlatRate	Usage Flate Rate	decimal
UsageUnit	Usage Unit	nvarchar
UsageUnitCost	Usage Unit Cost	decimal
VehicleActive	Indicates Whether the Vehicle is Active or Not	bit
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