Tables [dbo].[Education_Header]
Patient Education Header level table
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Education_Header_ID: IDID[dbo].[uniqueid]9NOT NULLKey to the Education_Header table
CurrentEducationID[dbo].[uniqueid]9NOT NULLCurrent version Identifier. Link to Education.ID
ItemID[dbo].[uniqueid]9NOT NULLItemID of the each clinical item (for Ex: for non med orders Item_Plan.ID).
ClinicalItemDictEntryID[dbo].[dict_id]5NOT NULLItemDE ( Dictionary Entry ID of the each clinical item - for ex: QO_Classification_DE.ID for the orders & Medication_DE.ID for the medication).
ItemTypechar(2)2NOT NULLClinical item type - Order - PL, Medication - ME, Immun Admin - IM, Care Guide - CG
Indexes NIX_Education_Header_PatientID_INC_LastUpdatedDTTMForeign Keys FK_Education_Header_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient Identifier. Link to Person.ID
Indexes NIX_Education_Header_EncounterIDForeign Keys FK_Education_Header_EncounterID: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Check Constraints CK_Education_Header_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')IsErrorFLAG[dbo].[BOOL]1NOT NULLWas this entered in Error (Y/N)?
CreatedDTTMdatetime8NULL allowedEducation recorded for the first time
Indexes NIX_Education_Header_PatientID_INC_LastUpdatedDTTMLastUpdatedDTTMdatetime8NULL allowedDatetime last education item updated
FreeTextNamevarchar(255)255NOT NULL('')Education Item name. Only populated for InfoButton Education.
CodeSystemvarchar(50)50NOT NULL('')Code System used to get Education via InfoButton
Codevarchar(50)50NOT NULL('')Code used to get Education via InfoButton