Tables [dbo].[MedicalDevice_Header]
Medical device Header table
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Primary Key PK_MedicalDevice_Header_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the MedicalDevice_Header table
Cluster Key CIX_MedicalDevice_Header_PatientID: PatientIDForeign Keys FK_MedicalDevice_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
CurrentMedicalDeviceID[dbo].[uniqueid]9NOT NULLCurrent instance of the medical device. Link to MedicalDevice.ID
EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
CreatedByID[dbo].[uniqueid]9NOT NULLProvider who added the Medical device into the patient Chart
CreateDTTMdatetime8NOT NULLDate and time of Medical device added into the patient Chart
LastUpdateDTTMdatetime8NOT NULLLast updated date and time
ItemTypechar(2)2NOT NULL('MD')Item type 'MD' for medical device
HasAnnotationFLAG[dbo].[BOOL]1NOT NULL('N')Has Annotation present for the Medical device?