Tables [dbo].[Education]
Patient Education details (versioned table)
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Education_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the Education table
Foreign Keys FK_Education_EducationHeaderID_Education_Header_ID: [dbo].[Education_Header].EducationHeaderIDEducationHeaderID[dbo].[uniqueid]9NOT NULLKey to the Education_Header table
EducationGivenDTTMdatetime8NULL allowedTime Education provided
MaterialDatedatetime8NULL allowedMaterial given time
Durationint4NULL allowedDuration in Mins
PersonEducatedDEListvarchar(250)250NOT NULLUsers or provders who provided Education. Comma separated list of Person.ID.
CounselorID[dbo].[uniqueid]9NOT NULLCounselor Identifier
CounselingMethodDEListvarchar(250)250NOT NULLCounseling Methods. Comma separated list of Counseling_Method_DE.ID.
CounselingHandoutDEListvarchar(250)250NOT NULLHandouts given. Comma separated list of Counseling_Handout_DE.ID.
CounselingEvaluationDEListvarchar(250)250NOT NULLCounseling Evaluatioms. Comma separated list of Counseling_Evaluation_DE.ID.
WhoDiditID[dbo].[uniqueid]9NOT NULLUser who entered. Link to IDX_User.ID.
EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
SiteDE[dbo].[dict_id]5NOT NULLSite. Link to Site_DE.ID
Indexes Portal_Education_RecordedDTTMRecordedDTTMdatetime8NULL allowedRecorded time
EducationDocumentID[dbo].[uniqueid]9NOT NULL((0))Education Document. Link to PatientEdDocuments.ID
Foreign Keys fk_Education_VaccineCategoryDE: [dbo].[Vaccine_Category_DE].VaccineCategoryDEVaccineCategoryDE[dbo].[dict_id]5NOT NULL((0))Vaccine Category. Link to Vaccine_Category_DE.ID.
EducationDocumentNamevarchar(255)255NULL allowedThis is to add the document name