Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HProcedureDevice This table holds the information about various devices which are attached to the patient during clinical procedures.
Column Name Column Datatype Column Null Option Column Comment
DeviceObjectIDintNOT NULL Unique Identifier of the object.
ProcedureOIDintNOT NULL ObjectID of HProcedure table. Links the procedure definition with the Device.
UDIvarchar(250)NULL The scanned barcode found on the device to be attached to a patient(Universal Device Identifier).
The value will be a barcode in one of the three supported bar code standards: GS1, HIBCC or ICCBBA.
UDIIssuervarchar(12)NULL The standard found in the scanned bar code;
Possible values: GS1/HIBCC/ICCBBA.
DeviceIdentifiervarchar(24)NOT NULL The "DeviceIdentifier" field parsed from the scanned bar code; if this information is not available in the scanned bar code, it can be entered manually by the user.
ManufactureDatesmalldatetimeNULL The "ManufactureDate" field parsed from the scanned bar code; if this information is not available in the scanned bar code, it can be entered manually by the user.
ExpirationDatesmalldatetimeNULL The "ExpirationDate" field parsed from the scanned bar code; if this information is not available in the scanned bar code, it can be entered manually by the user.
BatchLotNumbervarchar(22)NULL The "BatchLotNumber" field parsed from the scanned bar code; if this information is not available in the scanned bar code, it can be entered manually by the user.
SerialNumbervarchar(22)NULL The "SerialNumber" field parsed from the scanned bar code; if this information is not available in the scanned bar code, it can be entered manually by the user.
DonationIdentificationCodevarchar(16)NULL The "DonationIdentificationCode" field parsed from the scanned bar code; if this information is not available in the scanned bar code, it can be entered manually by the user.
DeviceDescriptionvarchar(2000)NULL Device description. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system.
BrandNamevarchar(80)NULL Information regarding the brand name of the device. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system.
CompanyNamevarchar(80)NULL Information regarding the company name that produced the device. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system.
Modelvarchar(80)NULL Information regarding the model of the device. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system.
HasNaturalRubberLatexbitNULL Whether device contains or is made of natural rubber latex. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system;
Allowable values: 0=no, 1=yes; default value NULL.
MRISafetyStatusvarchar(48)NULL Information on the MRI safety status of the device. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system.
DevicePublishDatesmalldatetimeNULL The publish date of the device. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system.
LastCngDTimedatetimeNULL when record was last changed, this is Universal Time Coordinate(UTC)
SystemSourcevarchar(8)NULL Where this information is filled from;
Allowed values will be mnemonics: SOARIAN
ActiveIndicatorvarchar(8)NOT NULL Whether the device is still used(active) for the specified patient.
Allowable Values: ACTIVE, INACTIVE; default will be ACTIVE.
ImplantExplantIndicatorvarchar(12)NULL How the device is applied to the patient.
Allowable values : IMPLANT, EXPLANT, REPAIR
IsProtectedInfobitNOT NULL Whether the device information is protected.
Allowable values: 0=no, 1=yes; default value 0.
IsDeletedbitNOT NULL Whether the device information is soft deleted;
Allowable values: 0=no, 1=yes; default value 0.
PatientOIDintNOT NULL Internal Patient Identifier. ObjectID of Patient(HPatient table)
PatientVisitOIDintNULL Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table)
GMDNPTNamevarchar(256)NULL The Global Medical Device Nomenclature name for this device.
ProductClassCodeSetvarchar(8)NULL The product classification code set(FDA, SNOMED, etc.) used for this device's product code.
ProductClassCodevarchar(32)NULL The product classification code for this particular device
ProductClassCodeNamevarchar(256)NULL The product classification code name for this particular device
GudidExceptionvarchar(40)NULL Whether last Gudid WebService call resulted in an exception or not and stores the exception(format: errorCode + "-" + errorDesc)
ChangeNosmallintNULL Indicates the number of times the order has changed. Used to properly sequence the history information
LastUpdatedDTimedatetimeNULL The last time this device was modified.
TranscriptionReasonvarchar(64)NULL The reason device information was transcribed at the keyboard and not scanned by the barcode reader.
BarCodevarchar(250)NULL The raw scanned bar code.
SnomedCodevarchar(32)NULL The SNOMED code for the device retrieved from Global Unique Device Identification Database(GUDID)
SnomedDescvarchar(256)NULL The SNOMED description for the device retrieved from GUDID
CreationTimedatetimeNULL When the Device was created(added to a Procedure)

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates