EMR_ENCOUNTERS_MEDICAL_ASSESSMENT · 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.

02References

ENCOUNTER_ID → EMR_ENCOUNTERS.ENCOUNTER_ID

03Columns

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	TEMP	string	varchar(10)	yes
3	PULSE	string	varchar(10)	yes
4	RES	string	varchar(10)	yes
5	BP	string	varchar(10)	yes
6	HEIGHT	string	varchar(10)	yes
7	WEIGHT	string	varchar(10)	yes
8	EYE_COLOR	string	varchar(10)	yes
9	HAIR_COLOR	string	varchar(10)	yes
10	VISION	string	varchar(10)	yes
11	GLASSES_CONTACT	string	varchar(20)	yes
12	HEARING	string	varchar(20)	yes
13	BRUISES	string	varchar(20)	yes
14	LACERATIONS	string	varchar(20)	yes
15	RASHES	string	varchar(20)	yes
16	PHAYSICAL_ABNORMALITY	string	varchar(30)	yes
17	MOBILITY_AMBULATION	string	varchar(30)	yes
18	CURRENT_MEDICATION	string	varchar(max)	yes
19	ADVANCED_DIRECTIVES	string	varchar(3)	yes
20	SIGNIFICANT_ILLNESS_HISTORY	string	varchar(max)	yes
21	SURGICAL_HISTORY	string	varchar(max)	yes
22	COMMUNICALBE_DISEASE_HISTORY	string	varchar(max)	yes
23	ALLERGY_FUNCTION	string	varchar(max)	yes
24	BLADDER_FUNCTION	string	varchar(30)	yes
25	BOWEL_FUNCTION	string	varchar(30)	yes
26	SMOKES	string	varchar(3)	yes
27	SMOKE_AMOUNT	string	varchar(50)	yes
28	LAST_MENSTRUAL_PERIOD	string	varchar(60)	yes
29	FIFTEEN_POUND_LOSS	string	varchar(3)	yes
30	DIETARY_RESTRICTIONS	string	varchar(max)	yes
31	FOODL_ALLERGIES	string	varchar(max)	yes
32	DENTITION	string	varchar(max)	yes
33	SPECIAL_NEEDS	string	varchar(max)	yes
34	DATE_OF_LAST_TB	datetime	datetime	yes
35	TB_RESULT	string	varchar(50)	yes
36	DATE_OF_LAST_TETANUS	datetime	datetime	yes
37	HOUS_OF_NOC	string	varchar(10)	yes
38	USUAL_HOURS_OF_SLEEP	string	varchar(10)	yes
39	SLEEP_DISTRUBANCES	string	varchar(max)	yes
40	OTC_OR_RX_SLEEP_AIDS	string	varchar(max)	yes
41	DATE_OF_LAST_DRINK	datetime	datetime	yes
42	TREMORS	string	varchar(3)	yes
43	FLUSHED	string	varchar(3)	yes
44	VAUSEA_VOMITING	string	varchar(3)	yes
45	ANXIOUS	string	varchar(3)	yes
46	DIAPHORESIS	string	varchar(3)	yes
47	DATE_OF_MOST_RECENT_DRUG	datetime	datetime	yes
48	DESCRIBE_DRUG	string	varchar(max)	yes
49	IV_DRUG_USE	string	varchar(3)	yes
50	SEIZURE_HISTORY	string	varchar(3)	yes
51	ALCOHOL_RELATED	string	varchar(3)	yes
52	LAST_SEIZURE	string	varchar(30)	yes
53	TYPE	string	varchar(30)	yes
54	ONSET	string	varchar(30)	yes
55	PATTERN	string	varchar(max)	yes
56	PRECIPITATING_FACTORS	string	varchar(max)	yes
57	TENDENCY_FOR_INJURY	string	varchar(max)	yes
58	AURA	string	varchar(max)	yes
59	MEDICATIONS	string	varchar(max)	yes
60	MOOD	string	varchar(40)	yes
61	AFFECT	string	varchar(40)	yes
62	ORIENTED	string	varchar(3)	yes
63	CONCENTRATION	string	varchar(4)	yes
64	MEMORY	string	varchar(4)	yes
65	ATTENSION_SPAN	string	varchar(4)	yes
66	LEARNING_DIFFICULTIES	string	varchar(3)	yes
67	PSYCHIATRIC_HISTORY	string	varchar(3)	yes
68	SUICIDE_HISTORY	string	varchar(3)	yes
69	HISTORY_OF_VIOLENCE	string	varchar(3)	yes
70	COMMENT_MOOD	string	varchar(max)	yes
71	COMMENT_AFFECT	string	varchar(max)	yes
72	COMMENT_ORIENTED	string	varchar(max)	yes
73	COMMENT_CONCENTRATION	string	varchar(max)	yes
74	COMMENT_MEMORY	string	varchar(max)	yes
75	COMMENT_ATTENTION_SPAN	string	varchar(max)	yes
76	COMMENT_LEARNING_DIFFICULTIES	string	varchar(max)	yes
77	COMMENT_PSYCHIATRIC_HISTORY	string	varchar(max)	yes
78	COMMENT_SUICIDE_HISTORY	string	varchar(max)	yes
79	COMMENT_HISTORY_OF_VIOLENCE	string	varchar(max)	yes
80	GENERAL_HEALTH	string	varchar(max)	yes
81	HEALTH_CONCERNS_PROBLEMS	string	varchar(max)	yes
82	IS_IN_NEED_MEDICAL_HISTORY	boolean	bit	yes
83	IS_NOT_IN_NEED_OF_MEDICAL	boolean	bit	yes
84	OBTAIN_HISTORY_FROM	string	varchar(max)	yes
85	REFERRAL_DATE_TIME	string	varchar(max)	yes
86	DESC1	string	varchar(70)	yes
87	DESC2	string	varchar(70)	yes
88	AXIS1_1	string	varchar(9)	yes
89	AXIS1_2	string	varchar(9)	yes
90	NONE	boolean	bit	yes
91	ONE	boolean	bit	yes
92	TWO	boolean	bit	yes
93	THREE	boolean	bit	yes
94	MORE_THAN_TRHEE	boolean	bit	yes
95	HAD_SEX_WHILE_HIGH	string	varchar(5)	yes
96	HAD_SEX_TO_GET_	string	varchar(5)	yes
97	PAID_FOR_SEX_	string	varchar(5)	yes
98	HAD_SEX_WITH_AN_	string	varchar(5)	yes
99	HAD_UNPROTECTED_SEX	string	varchar(5)	yes
100	WHO_HAS_HIV	string	varchar(5)	yes
101	WHOSE_HIV_STATUS	string	varchar(5)	yes
102	HAD_SEX_AGAINST_YOUR_WILL	string	varchar(5)	yes
103	DO_YOU_USE_CONDOMS	string	varchar(5)	yes
104	NEW	string	varchar(5)	yes
105	BLEACHED	string	varchar(5)	yes
106	SHARED_SOMEONE_	string	varchar(5)	yes
107	SHARED	string	varchar(5)	yes
108	REUSED_	string	varchar(5)	yes
109	ORIGIN_UNKNOWN	string	varchar(5)	yes
110	NEW1	string	varchar(5)	yes
111	BLEACHED1	string	varchar(5)	yes
112	HAVE_YOU_EVER_HAD_A_TB_TEST	string	varchar(5)	yes
113	DATE	datetime	datetime	yes
114	RESULTS	string	varchar(10)	yes
115	RESULTS_OF_YOUR_LAST_CHEST_XRAY	string	varchar(50)	yes
116	HAVE_YOU_EVER_BEEN_TESTED_FOR_HEP	string	varchar(4)	yes
117	IF_YES_WHAT_WAS_THE_OUTCOME	string	varchar(20)	yes
118	IF_POSITIVE	string	varchar(6)	yes
119	HAVE_YOU_EVER_BEEN_GIVEN	string	varchar(6)	yes
120	HAVE_YOU_EVER_BEEN_TESTED_FOR_HIV	string	varchar(6)	yes
121	IF_YES_DATE_OF_LAST_TEST	string	varchar(20)	yes
122	RESULTS1	string	varchar(20)	yes
123	NO_PHYSICAL_EXAM_WITHIN_THE_PAST_12_MONTHS	boolean	bit	yes
124	HAVE_A_PHYSICAL_EXAM	boolean	bit	yes
125	HAVE_A_FACE_TO_FACE	boolean	bit	yes
126	BE_REFERRED	boolean	bit	yes
127	PHYSICAL_EXAM_WITHIN_THE_PAST	boolean	bit	yes
128	CLINICAL_OR_MEDICAL	boolean	bit	yes
129	MEDICAL_STAFF_MEMBER	boolean	bit	yes
130	WAS_LAST_PHYSICAL	string	varchar(4)	yes
131	IF_YES_DOCUMENT_REFERRAL_BELOW	string	varchar(max)	yes
132	INDIVIDUAL	boolean	bit	yes
133	INDIVIDUAL_DOES	boolean	bit	yes
134	DATED	string	varchar(12)	yes
135	NARCAN_TRAINING_OFFERED	string	varchar(8)	yes
136	NARCAN_KIT_OFFERED	string	varchar(8)	yes
137	NARCAN_KIT_OFFERED_TEXT	string	varchar(max)	yes
138	NURSING_HEALTH_ASSESSMENT_RECOMMENDATIONS_CONCERNS	string	varchar(max)	yes
139	MEDICATION_1	string	varchar(100)	yes
140	MEDICATION_2	string	varchar(100)	yes
141	MEDICATION_3	string	varchar(100)	yes
142	MEDICATION_4	string	varchar(100)	yes
143	MEDICATION_5	string	varchar(100)	yes
144	DOSAGE_1	string	varchar(20)	yes
145	DOSAGE_2	string	varchar(20)	yes
146	DOSAGE_3	string	varchar(20)	yes
147	DOSAGE_4	string	varchar(20)	yes
148	DOSAGE_5	string	varchar(20)	yes