Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Education table |
![Foreign Keys FK_Education_EducationHeaderID_Education_Header_ID: [dbo].[Education_Header].EducationHeaderID Foreign Keys FK_Education_EducationHeaderID_Education_Header_ID: [dbo].[Education_Header].EducationHeaderID](../../../../Images/fk.png) | EducationHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Education_Header table |
| EducationGivenDTTM | datetime | 8 | NULL allowed | | Time Education provided |
| MaterialDate | datetime | 8 | NULL allowed | | Material given time |
| Duration | int | 4 | NULL allowed | | Duration in Mins |
| PersonEducatedDEList | varchar(250) | 250 | NOT NULL | | Users or provders who provided Education. Comma separated list of Person.ID. |
| CounselorID | [dbo].[uniqueid] | 9 | NOT NULL | | Counselor Identifier |
| CounselingMethodDEList | varchar(250) | 250 | NOT NULL | | Counseling Methods. Comma separated list of Counseling_Method_DE.ID. |
| CounselingHandoutDEList | varchar(250) | 250 | NOT NULL | | Handouts given. Comma separated list of Counseling_Handout_DE.ID. |
| CounselingEvaluationDEList | varchar(250) | 250 | NOT NULL | | Counseling Evaluatioms. Comma separated list of Counseling_Evaluation_DE.ID. |
| WhoDiditID | [dbo].[uniqueid] | 9 | NOT NULL | | User who entered. Link to IDX_User.ID. |
| EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | | Encounter. Link to Encounter.ID |
| SiteDE | [dbo].[dict_id] | 5 | NOT NULL | | Site. Link to Site_DE.ID |
 | RecordedDTTM | datetime | 8 | NULL allowed | | Recorded time |
| EducationDocumentID | [dbo].[uniqueid] | 9 | NOT NULL | ((0)) | Education Document. Link to PatientEdDocuments.ID |
![Foreign Keys fk_Education_VaccineCategoryDE: [dbo].[Vaccine_Category_DE].VaccineCategoryDE Foreign Keys fk_Education_VaccineCategoryDE: [dbo].[Vaccine_Category_DE].VaccineCategoryDE](../../../../Images/fk.png) | VaccineCategoryDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Vaccine Category. Link to Vaccine_Category_DE.ID. |
| EducationDocumentName | varchar(255) | 255 | NULL allowed | | This is to add the document name |