EMR_ENCOUNTERS_EDU_DETAILS · Accumedic EHI Export Format

01Relates to the patient

ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient

Single-patient export: the patient's rows.

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	EDUCATION_LEVEL	string	varchar(max)	yes
3	AGE_STARTED_FIRST_GRADE	integer	int	yes
4	INFANT_DAY_CARE	boolean	bit	yes
5	PRE_SCHOOL	boolean	bit	yes
6	KINDERGARTEN	boolean	bit	yes
7	LD_ADHD	boolean	bit	yes
8	MR	boolean	bit	yes
9	HEARING_IMPAIRED	boolean	bit	yes
10	ED	boolean	bit	yes
11	VISUALLY_IMPAIRED	boolean	bit	yes
12	OTHER_SCHOOL_CLASSIFICATION	boolean	bit	yes
13	SCHOOL_CLASSIFIACTION_DETIAILS	string	varchar(max)	yes
14	REGULAR_CLASSES	boolean	bit	yes
15	HONORS_CLASSES	boolean	bit	yes
16	SPECIAL_ED	boolean	bit	yes
17	HOME_STUDY	boolean	bit	yes
18	CLASS_PLACEMENT_DETAILS	string	varchar(max)	yes
19	ADJUSTMENT_PROBLEMS	string	varchar(max)	yes
20	BEHAVIORAL_PROBLEMS	string	varchar(max)	yes
21	REPEATED_GRADES	string	varchar(max)	yes
22	SUSPENSIONS_EXPULSIONS	string	varchar(max)	yes
23	PERFORMANCE_ACHIEVEMENT	string	varchar(max)	yes
24	ATTITUDES_TOWARD_SCHOOL	string	varchar(max)	yes
25	STRENGTHS_WEAKNESSES	string	varchar(max)	yes
26	OTHER_EDUCATIONAL_NOTES	string	varchar(max)	yes
27	EDU_DET_REVIEWED	boolean	bit	yes