Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Medical Device table |
 ![Foreign Keys FK_MedicalDevice_MedicalDeviceHeaderID_MedicalDevice_Header_ID: [dbo].[MedicalDevice_Header].MedicalDeviceHeaderID Foreign Keys FK_MedicalDevice_MedicalDeviceHeaderID_MedicalDevice_Header_ID: [dbo].[MedicalDevice_Header].MedicalDeviceHeaderID](../../../../Images/fk.png) | MedicalDeviceHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | Header. Link to MedicalDevice_Header.ID. |
| DeviceID | varchar(30) | 30 | NOT NULL | | Device ID. Link to FDAMedicalDevices.DeviceID. |
| DeviceUDI | varchar(255) | 255 | NULL allowed | | Unique device ID |
| DeviceName | varchar(255) | 255 | NOT NULL | | Device Name |
| ImplantedFuzzyWhen | varchar(50) | 50 | NULL allowed | | Device implanted fuzzy date |
| ImplantedFuzzySortAs | datetime | 8 | NULL allowed | | Device implanted date |
| ImplantedFuzzySpecificity | char(1) | 1 | NULL allowed | | Device implanted date specificity |
| SerialNumber | varchar(30) | 30 | NULL allowed | | Serial number of the device implanted |
| ExpirationDate | date | 3 | NULL allowed | | Device Expiration date |
| ManufacturedDate | date | 3 | NULL allowed | | Device Manufactured date |
| DeviceType | tinyint | 1 | NULL allowed | | Device type. 1- FDA Device 2 - NON FDA Device |
![Foreign Keys FK_MedicalDevice_MedicalDeviceStatusDE: [dbo].[MedicalDevice_Status_DE].MedicalDeviceStatusDE Foreign Keys FK_MedicalDevice_MedicalDeviceStatusDE: [dbo].[MedicalDevice_Status_DE].MedicalDeviceStatusDE](../../../../Images/fk.png) | MedicalDeviceStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Device status. Link to MedicalDevice_Status_DE.ID |
| RemovedFuzzyWhen | varchar(50) | 50 | NULL allowed | | Device removed fuzzy date |
| RemovedFuzzySortAs | datetime | 8 | NULL allowed | | Device removed date |
| RemovedFuzzySpecificity | char(1) | 1 | NULL allowed | | Device removed date specificity |
| LOT | varchar(30) | 30 | NULL allowed | | Lot number |
| DonationID | varchar(30) | 30 | NULL allowed | | Donation Identifier |
| DeviceDescription | varchar(1024) | 1024 | NULL allowed | | Device description |
| WhoDiditID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who added/modified the Medical devices information to the Patient Chart |
| ManagedByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who is managing the implanted device |
| ManagedByProviderType | char(1) | 1 | NULL allowed | | Managed by Provider type - 'P' - for Provider 'R' for referring provider |
| ManagedByProviderFreeText | varchar(100) | 100 | NULL allowed | | Free text - Managed by provider name |
| ImplantedByProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who implanted the device |
| ImplantedByProviderType | char(1) | 1 | NULL allowed | | Implanted by Provider type - 'P' - for Provider 'R' for referring provider |
| ImplantedByProviderFreeText | varchar(100) | 100 | NULL allowed | | Free text - Implanted provider name |
| ImplantedFacility | varchar(255) | 255 | NULL allowed | | Implanted Facility Name |
| RecordedDTTM | datetime | 8 | NOT NULL | | Medical device instance recorded date and time |
| SiteDE | [dbo].[dict_id] | 5 | NOT NULL | | Provider logged-in site. Link to Site_DE.ID |
| BrandName | varchar(255) | 255 | NULL allowed | | Brand name of the device |
| GMDNName | varchar(1024) | 1024 | NULL allowed | | Global Medical Device Nomenclature |
![Foreign Keys FK_MedicalDevice_MRISafetyDE: [dbo].[MRISafety_DE].MRISafetyDE Foreign Keys FK_MedicalDevice_MRISafetyDE: [dbo].[MRISafety_DE].MRISafetyDE](../../../../Images/fk.png) | MRISafetyDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | MRI Safety. Link to MRISafety_DE.ID |
| SNOMEDCode | varchar(18) | 18 | NULL allowed | ('') | SNOMED Code |