EMR_ENCOUNTERS_MMT_NOTES · 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	GENERAL_OBSERVATION_NOTES	string	varchar(max)	yes
3	MEDICAL_CONCERNS	string	varchar(max)	yes
4	ACTION_TAKEN	string	varchar(max)	yes
5	INCREASE_NOT_TOLERATED_ACTION	string	varchar(max)	yes
6	PAT_ASSESSMENT_OUTCOME	string	varchar(max)	yes
7	RESPIRATIONS	string	varchar(30)	yes
8	RESPIRATION_RATE	integer	int	yes
9	RESPIRATORY_STATUS	string	varchar(150)	yes
10	IMPAIRMENT_DETERMINATION	string	varchar(150)	yes
11	TRANSPORTATION	string	varchar(30)	yes
12	CURRENT_DOSE_MG	integer	int	yes
13	DOCTOR_NOTIFIED	string	varchar(150)	yes
14	DROWSY	boolean	bit	yes
15	INATTENTIVE	boolean	bit	yes
16	INCOORDINATION	boolean	bit	yes
17	SLURRED_SPEECH	boolean	bit	yes
18	CONSTRICTED_PUPILS	boolean	bit	yes
19	MEMORY_IMPAIRMENT	boolean	bit	yes
20	STUPOR	boolean	bit	yes
21	NO_MEDICAL_COMPLAINTS	boolean	bit	yes
22	GI_DISTRESS	boolean	bit	yes
23	CRAVINGS	boolean	bit	yes
24	IMPAIRED_SLEEP	boolean	bit	yes
25	FATIGUE	boolean	bit	yes
26	TREMOR	boolean	bit	yes
27	ITCHING	boolean	bit	yes
28	SWEATING	boolean	bit	yes