Tables [dbo].[Patient_Education_Provided]
Audit of when patient education was provided
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Patient_Education_Provided: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_Education_Provided table.
Indexes NIX_Patient_Education_Provided_EncounterIDForeign Keys FK_Patient_Education_Provided_Encounter_ID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Key to the Encounter table
Indexes NIX_PatientEducationProvided_PatientIDForeign Keys FK_Patient_Education_Provided_Patient_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Key to the Person Table
ItemID[dbo].[uniqueid]9NOT NULLItem identifier
Indexes NIX_Patient_Education_Provided_UserIDForeign Keys FK_Patient_Education_Provided_User_ID: [dbo].[Person].UserIDUserID[dbo].[uniqueid]9NULL allowedUser. Key to the Person Table
Foreign Keys FK_Patient_Education_Provided_EducationTypeDE: [dbo].[Education_Type_DE].EducationTypeDEEducationTypeDE[dbo].[dict_id]5NOT NULLEducation Type. Key to the Education_Type_DE table
Foreign Keys FK_Patient_Education_Provided_PatientCommunizationDE: [dbo].[Patient_Communication_DE].PatientCommunicationDEPatientCommunicationDE[dbo].[dict_id]5NOT NULLPatient Communication type. Key to the PatientCommunication_DE table.
ItemTypechar(2)2NOT NULLItem Type (PL, ME, IM, etc.)
OrderTypechar(2)2NOT NULLOrder Type
ProvidedDTTMdatetime8NOT NULLTime Education Provided
CreatedDTTMdatetime8NOT NULL(getdate())Creation Time