vr_CEEquipment

Updated November 17, 2025 17:26

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
Active	Indicates if the Record is Active or Not	bit
ActiveComputed	Active Computed	bit
AeroScoutLocation	Aero Scout Location	nvarchar
AltTag	Alternate Tag #	nvarchar
AmpDraw	Amperage Draw	decimal
AmpRating	Amperage Rating	decimal
AnnualRate	Annual Rate	decimal
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
BMP	BMP	bit
BTUOut	BTU Out	decimal
BTUPerHour	BTU Per Hour	decimal
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CalibratedThrough	Calibrated Through	datetime
CEEquipmentSubTypeCode	Biomed Equipment SubType Code	nvarchar
CEEquipmentSubTypeDescription	Biomed Equipment SubType Description	nvarchar
CEEquipmentSubTypeId	Biomed Equipment SubType Id	int
CEEquipmentTypeCode	Biomed Equipment Type Code	nvarchar
CEEquipmentTypeDescription	Biomed Equipment Type Description	nvarchar
CEEquipmentTypeId	Biomed Equipment Type Id	int	vr_CEEquipmentType
Comments	Comments	nvarchar
ContractId	Contract Id	int	vr_contract
ContractNumber	Contract Number	nvarchar
ControlNumber	Control Number	nvarchar
CPSetupCode	Capital Planning Setup Code	nvarchar
CPSetupDescription	Capital Planning Setup Description	nvarchar
CPSetupId	Capital Planning Setup Id	int	vrpt_cpSetup
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CriticalAlarm	Critical Alarm	bit
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DaysDown	Days Down	float
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Biomed Equipment Description	nvarchar
DeviceTypeCode	Device Type Code	nvarchar
DeviceTypeDescription	Device Type Description	nvarchar
DeviceTypeECRICode	Device Type ECRI Code	int
DeviceTypeId	Device Type Id	int	vr_DeviceType
Disposed	Indicates if this Biomed Equipment has been Disposed or Not	bit
DistrictCode	District Code	nvarchar
DistrictId	District Id	int	vr_District
DistrictName	District Name	nvarchar
DivisionCode	Division Code	nvarchar
DivisionId	Division Id	int
DivisionName	Division Name	nvarchar
ECRICode	ECRI Code	nvarchar
ECRIManufacturerCode	ECRI Manufacturer Code	int
ECRIVendorCode	ECRI Vendor Code	int
Environment	Environment	float
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FlatRate	Flat Rate	decimal
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
Frequency	Frequency	nvarchar
FullLocation	Full Location	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
GISUniqueId	GIS Unique Id	uniqueidentifier
HasCyclicRenewal	Has Cyclic Renewal	bit
HasMakeModelLink	Has Model Model Link	bit
HasPopupMessage	Has Popup Message	int
HippaComment	Hippa Comment	nvarchar
HippaCreates	Hippa Creates	bit
HippaCriticalLifeSupport	Hippa Critical Life Support	bit
HippaFrequency	Hippa Frequency	nvarchar
HippaStores	Hippa Stores	bit
HippaTransmits	Hippa Transmits	bit
Id	Biomed Equipment Id	int
Image	Image	nvarchar
InventoryConditionCode	Inventory Condition Code	nvarchar
InventoryConditionDescription	Inventory Condition Description	nvarchar
InventoryConditionId	Inventory Condition Id	int
InventoryTechnicianCode	Inventory Technician Code	nvarchar
InventoryTechnicianId	Inventory Technician Id	int	vrpt_Technician
InventoryTechnicianName	Inventory Technician Name	nvarchar
IPAddress	IP Address	nvarchar
JointCommissionCategoryCode	Joint Commission Category Code	nvarchar
JointCommissionCategoryDescription	Joint Commission Category Description	nvarchar
JointCommissionCategoryId	Joint Commission Category Id	int
LastCalibrationDate	Last Calibration Date	datetime
LastInventoryDate	Last Inventory Date	datetime
LastInventoryLocation	Last Inventory Location	nvarchar
LastPMDate	Last PM Date	datetime
Latitude	Latitude	float
Leased	Indicates if the Biomed Equipment is on a Lease or Not	bit
LeaseExpiration	Lease Expiration Date	datetime
LeaseNumber	Lease Number	nvarchar
Longitude	Longitude	float
MakeModelId	Make Model Id	int
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
Name	Biomed Equipment Name	nvarchar
Notes	Notes	nvarchar
NotLocated	Not Located	bit
NotLocatedDate	Not Located Date	datetime
OriginalPONumber	Original PO Number	nvarchar
OutofService	Indicates if the Biomed 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
ParentControlNumber	Biomed Equipment Parent Control Number	nvarchar
ParentId	Biomed Equipment Parend Id	int	vr_CEEquipment
PopupMessage	Popup Message	nvarchar
PortNumber	Port Number	nvarchar
PowerUse	Power Use	decimal
PreventArchival	Prevent Archival	bit
PropertyId	Property Id	nvarchar
PurchaseDate	Purchase Date	datetime
PurgeDate	Purge Date	datetime
RegionCode	Region Code	nvarchar
RegionId	Region Id	int	vr_Region
RegionName	Region Name	nvarchar
RegisteredDate	Registered Date	datetime
RentalRate	Rental Rate	decimal
RentalType	Rental Type	smallint
RFEmitting	Indicates if this record has Radio Frequency Emitting	bit
RiskFactor	Risk Factor	int
RiskLevelSource	Risk Level Source	nvarchar
SerialNumber	Serial Numer	nvarchar
ServiceContract	Service Contract	nvarchar
SiteNumber	Site Number	nvarchar
SoftwareVersion	Software Version	nvarchar
SOPCode	SOP Code	nvarchar
SOPId	Standard Operating Procedure Id	int	vr_SOP
StatusAllowNote	Indicates if this record allows a status note	bit
StatusCode	Status Code	nvarchar
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vrpt_Status
StatusNote	Status Note	nvarchar
SubLocation	Sub Location	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
TagoutCode	Tagout Code	nvarchar
TagoutId	Tagout Id	int
TagoutName	Tagout Name	nvarchar
UsageFlatRate	Usage Flat 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