Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
DeviceObjectID | int | NOT NULL | Unique Identifier of the object. |
ProcedureOID | int | NOT NULL | ObjectID of HProcedure table. Links the procedure definition with the Device. |
UDI | varchar(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. |
UDIIssuer | varchar(12) | NULL | The standard found in the scanned bar code; |
| | | Possible values: GS1/HIBCC/ICCBBA. |
DeviceIdentifier | varchar(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. |
ManufactureDate | smalldatetime | NULL | 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. |
ExpirationDate | smalldatetime | NULL | 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. |
BatchLotNumber | varchar(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. |
SerialNumber | varchar(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. |
DonationIdentificationCode | varchar(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. |
|
DeviceDescription | varchar(2000) | NULL | Device description. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system. |
BrandName | varchar(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. |
CompanyName | varchar(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. |
Model | varchar(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. |
HasNaturalRubberLatex | bit | NULL | 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. |
MRISafetyStatus | varchar(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. |
DevicePublishDate | smalldatetime | NULL | The publish date of the device. This is supplied by the external GUDID(Global UDI Database) through a web service call from the system. |
|
LastCngDTime | datetime | NULL | When this record was last changed, this is Universal Time Coordinate(UTC) |
SystemSource | varchar(8) | NULL | Where this information is filled from; |
| | | Allowed values will be mnemonics: SOARIAN |
ActiveIndicator | varchar(8) | NOT NULL | Whether the device is still used(active) for the specified patient. |
| | | Allowable values: ACTIVE, INACTIVE; default will be ACTIVE. |
ImplantExplantIndicator | varchar(12) | NULL | How the device is applied to the patient. |
| | | Allowable values : IMPLANT, EXPLANT, REPAIR |
IsProtectedInfo | bit | NOT NULL | Whether the device information is protected. |
| | | Allowable values: 0=no, 1=yes; default value 0. |
IsDeleted | bit | NOT NULL | Whether the device information is soft deleted; |
| | | Allowable values: 0=no, 1=yes; default value 0. |
PatientOID | int | NOT NULL | Internal Patient Identifier. ObjectID of Patient(HPatient table) |
PatientVisitOID | int | NULL | Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table) |
GMDNPTName | varchar(256) | NULL | The Global Medical Device Nomenclature name for this device. |
ProductClassCodeSet | varchar(8) | NULL | The product classification code set(FDA, SNOMED, etc.) used for this device's product code. |
ProductClassCode | varchar(32) | NULL | The product classification code for this particular device |
ProductClassCodeName | varchar(256) | NULL | The product classification code name for this particular device |
GudidException | varchar(40) | NULL | Whether last Gudid WebService call resulted in an exception or not and stores the exception(format: errorCode + "-" + errorDesc) |
ChangeNo | smallint | NULL | The number of times the order has changed. Used to properly sequence the history information |
LastUpdatedDTime | datetime | NULL | The last time this device was modified. |
TranscriptionReason | varchar(64) | NULL | The reason device information was transcribed at the keyboard and not scanned by the barcode reader. |
BarCode | varchar(250) | NULL | The raw scanned bar code. |
SnomedCode | varchar(32) | NULL | The SNOMED code for the device retrieved from Global Unique Device Identification Database(GUDID) |
SnomedDesc | varchar(256) | NULL | The SNOMED description for the device retrieved from GUDID |
CreationTime | datetime | NULL | When the Device was created(added to a Procedure) |