Tables [dbo].[MedicalDevice]
Medical device instance
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_MedicalDevice_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the Medical Device table
Indexes NIX_MedicalDevice_MedicalDeviceHeaderIDForeign Keys FK_MedicalDevice_MedicalDeviceHeaderID_MedicalDevice_Header_ID: [dbo].[MedicalDevice_Header].MedicalDeviceHeaderIDMedicalDeviceHeaderID[dbo].[uniqueid]9NOT NULLHeader. Link to MedicalDevice_Header.ID.
DeviceIDvarchar(30)30NOT NULLDevice ID. Link to FDAMedicalDevices.DeviceID.
DeviceUDIvarchar(255)255NULL allowedUnique device ID
DeviceNamevarchar(255)255NOT NULLDevice Name
ImplantedFuzzyWhenvarchar(50)50NULL allowedDevice implanted fuzzy date
ImplantedFuzzySortAsdatetime8NULL allowedDevice implanted date
ImplantedFuzzySpecificitychar(1)1NULL allowedDevice implanted date specificity
SerialNumbervarchar(30)30NULL allowedSerial number of the device implanted
ExpirationDatedate3NULL allowedDevice Expiration date
ManufacturedDatedate3NULL allowedDevice Manufactured date
DeviceTypetinyint1NULL allowedDevice type.
1- FDA Device
2 - NON FDA Device
Foreign Keys FK_MedicalDevice_MedicalDeviceStatusDE: [dbo].[MedicalDevice_Status_DE].MedicalDeviceStatusDEMedicalDeviceStatusDE[dbo].[dict_id]5NOT NULLDevice status. Link to  MedicalDevice_Status_DE.ID
RemovedFuzzyWhenvarchar(50)50NULL allowedDevice removed fuzzy date
RemovedFuzzySortAsdatetime8NULL allowedDevice removed date
RemovedFuzzySpecificitychar(1)1NULL allowedDevice removed date specificity
LOTvarchar(30)30NULL allowedLot number
DonationIDvarchar(30)30NULL allowedDonation Identifier
DeviceDescriptionvarchar(1024)1024NULL allowedDevice description
WhoDiditID[dbo].[uniqueid]9NOT NULLProvider who added/modified the Medical devices information to the Patient Chart
ManagedByProviderID[dbo].[uniqueid]9NOT NULLProvider who is managing the implanted device
ManagedByProviderTypechar(1)1NULL allowedManaged by Provider type - 'P' - for Provider 'R' for referring provider
ManagedByProviderFreeTextvarchar(100)100NULL allowedFree text - Managed by provider name
ImplantedByProviderID[dbo].[uniqueid]9NOT NULLProvider who implanted the device
ImplantedByProviderTypechar(1)1NULL allowedImplanted by Provider type - 'P' - for Provider 'R' for referring provider
ImplantedByProviderFreeTextvarchar(100)100NULL allowedFree text - Implanted provider name
ImplantedFacilityvarchar(255)255NULL allowedImplanted Facility Name
RecordedDTTMdatetime8NOT NULLMedical device instance recorded date and time
SiteDE[dbo].[dict_id]5NOT NULLProvider logged-in site. Link to Site_DE.ID
BrandNamevarchar(255)255NULL allowedBrand name of the device
GMDNNamevarchar(1024)1024NULL allowedGlobal Medical Device Nomenclature
Foreign Keys FK_MedicalDevice_MRISafetyDE: [dbo].[MRISafety_DE].MRISafetyDEMRISafetyDE[dbo].[dict_id]5NOT NULL((0))MRI Safety. Link to MRISafety_DE.ID
SNOMEDCodevarchar(18)18NULL allowed('')SNOMED Code