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

02Columns

#	Column	Type	Source type	Null
1	ENCOUNTER_ID	integer	int	no
2	GEN_DEVELOPMENT	boolean	bit	yes
3	GEN_NOURISHMENT	boolean	bit	yes
4	GEN_CONSCIOUSNESS	boolean	bit	yes
5	GEN_APPEARANCE	boolean	bit	yes
6	GEN_ATTITUDE	boolean	bit	yes
7	SKN_TEXTURE	boolean	bit	yes
8	SKN_HAIR	boolean	bit	yes
9	SKN_LESIONS	boolean	bit	yes
10	SKN_COLOR	boolean	bit	yes
11	SKN_NAILS	boolean	bit	yes
12	SKN_NODULES_OR_MASSES	boolean	bit	yes
13	SKN_ELASTICITY	boolean	bit	yes
14	SKN_RASHES	boolean	bit	yes
15	LYM_FACIAL	boolean	bit	yes
16	LYM_EPITROCHLEAR	boolean	bit	yes
17	LYM_FEMORAL	boolean	bit	yes
18	LYM_CERVICAL	boolean	bit	yes
19	LYM_AXILLARY	boolean	bit	yes
20	LYM_SUPRACLAVICULAR	boolean	bit	yes
21	LYM_INGUINAL	boolean	bit	yes
22	EYE_LIDS	boolean	bit	yes
23	EYE_CONJUNCTIVAE	boolean	bit	yes
24	EYE_LACRIMAL_GLANDS	boolean	bit	yes
25	EYE_SCLERA	boolean	bit	yes
26	EYE_CORNEA	boolean	bit	yes
27	EYE_ANTERIOR_CHAMBERS	boolean	bit	yes
28	EYE_LENS	boolean	bit	yes
29	EYE_PUPILLARY_REFLEXES	boolean	bit	yes
30	EYE_FUNDUS	boolean	bit	yes
31	EYE_EXTERNAL_OCCULAR_MOVEMENT	boolean	bit	yes
32	EYE_VISUAL_ACUITY	boolean	bit	yes
33	ENT_EAR_CANALS	boolean	bit	yes
34	ENT_TYMPANIC_MEMBRANES	boolean	bit	yes
35	ENT_NASAL_MUCOSA	boolean	bit	yes
36	ENT_SINUSES	boolean	bit	yes
37	ENT_ORAL_MUCOSA	boolean	bit	yes
38	ENT_SALIVARY_GLANDS	boolean	bit	yes
39	ENT_TONGUE	boolean	bit	yes
40	ENT_TONSILS	boolean	bit	yes
41	ENT_PHARYNX	boolean	bit	yes
42	ENT_GAG_REFLEX	boolean	bit	yes
43	HNN_HEAD	boolean	bit	yes
44	HNN_NECK	boolean	bit	yes
45	HNN_TRACHEA	boolean	bit	yes
46	HNN_THYROID	boolean	bit	yes
47	HNN_CAROTID_PULSES	boolean	bit	yes
48	HNN_CAROTID_BRUITS	boolean	bit	yes
49	HNN_JUGULARS	boolean	bit	yes
50	RSP_BONY_THORAX	boolean	bit	yes
51	RSP_EXPANSION	boolean	bit	yes
52	RSP_RATE_OR_PATTERN	boolean	bit	yes
53	RSP_PERCUSSION	boolean	bit	yes
54	RSP_TACTILE_FREMITUS	boolean	bit	yes
55	RSP_BREATH_SOUNDS	boolean	bit	yes
56	RSP_RALES	boolean	bit	yes
57	RSP_RHONCHI	boolean	bit	yes
58	RSP_WHEEZES	boolean	bit	yes
59	RSP_PLEURITIC_RUB	boolean	bit	yes
60	CDV_PRECORDIUM	boolean	bit	yes
61	CDV_CARDIAC_SIZE_OR_APEX	boolean	bit	yes
62	CDV_CARDIAC_RYTHM	boolean	bit	yes
63	CDV_HEART_RATE	boolean	bit	yes
64	CDV_HEART_SOUNDS	boolean	bit	yes
65	CDV_PERIPHERAL_PULSES	boolean	bit	yes
66	CDV_BRUITS	boolean	bit	yes
67	CDV_MURMURS	boolean	bit	yes
68	CDV_GALLOP	boolean	bit	yes
69	CDV_PERICARDIAL_RUB	boolean	bit	yes
70	CDV_CLICKS	boolean	bit	yes
71	RCT_SPHINCTER	boolean	bit	yes
72	RCT_HEMORRHOIDSS	boolean	bit	yes
73	RCT_PROSTATE	boolean	bit	yes
74	RCT_FISSURES	boolean	bit	yes
75	RCT_FISTULAS	boolean	bit	yes
76	RCT_MASSES	boolean	bit	yes
77	RCT_PAIN_OR_TENDERNESS	boolean	bit	yes
78	RCT_HEMOCCULT	boolean	bit	yes
79	BCK_CERVICAL_SPINE	boolean	bit	yes
80	BCK_THORACIC_SPINE	boolean	bit	yes
81	BCK_LUMBAR_SPINE	boolean	bit	yes
82	BCK_SACRUM	boolean	bit	yes
83	BCK_COCCYX	boolean	bit	yes
84	BCK_SACROILIAC_JOINTS	boolean	bit	yes
85	EXT_SHOULDERS	boolean	bit	yes
86	EXT_ELBOWS	boolean	bit	yes
87	EXT_HANDS_OR_WRISTS	boolean	bit	yes
88	EXT_HIPS	boolean	bit	yes
89	EXT_KNEES	boolean	bit	yes
90	EXT_ANKLES_OR_FOOT	boolean	bit	yes
91	NRG_MENTAL_STATUS	boolean	bit	yes
92	NRG_CRANIAL_NERVES	boolean	bit	yes
93	NRG_REFLEXES	boolean	bit	yes
94	NRG_MOTOR	boolean	bit	yes
95	NRG_SENSORY	boolean	bit	yes
96	GEN_MOBILITY	boolean	bit	yes
97	SKN_HEAD_OR_NECK	boolean	bit	yes
98	SKN_TRUNK	boolean	bit	yes
99	SKN_PELVIS_OR_SACRUM	boolean	bit	yes
100	SKN_EXTREMITIES	boolean	bit	yes
101	MUS_BONY_THORAX	boolean	bit	yes
102	MUS_COSTOCHONDRAL_JOINTS	boolean	bit	yes
103	MUS_C_SPINE_GUARDING	boolean	bit	yes
104	MUS_C_SPINE_SPINOUS_STABILITY	boolean	bit	yes
105	MUS_C_SPINE_EDEMA	boolean	bit	yes
106	MUS_C_SPINE_SPASMS	boolean	bit	yes
107	MUS_C_SPINE_TRIGGER_POINTS	boolean	bit	yes
108	MUS_SPLENIUS_CAPITIS_MUSCULATURE	boolean	bit	yes
109	MUS_OCCIPITAL_MUSCULATURE	boolean	bit	yes
110	MUS_C_SPINE_ROM	boolean	bit	yes
111	MUS_TRAPEZIUS_MUSCULATURE	boolean	bit	yes
112	MUS_TRAPEZIUS_HYPERTONICALLY	boolean	bit	yes
113	MUS_TRAPEZIUS_TRIGGER_POINTS	boolean	bit	yes
114	MUS_TRAPEZIUS_GUARDING	boolean	bit	yes
115	MUS_TRAPEZIUS_EDEMA	boolean	bit	yes
116	MUS_TRAPEZIUS_SPASMS	boolean	bit	yes
117	MUS_T_SPINE_TENDERNESS	boolean	bit	yes
118	MUS_T_SPINE_GUARDING	boolean	bit	yes
119	MUS_T_SPINE_SPASMS	boolean	bit	yes
120	MUS_T_SPINE_EDEMA	boolean	bit	yes
121	MUS_T_SPINE_TRIGGER_POINTS	boolean	bit	yes
122	MUS_T_SPINE_ROM	boolean	bit	yes
123	MUS_L_SPINE_GENERAL	boolean	bit	yes
124	MUS_L_SPINE_GUARDING	boolean	bit	yes
125	MUS_L_SPINE_EDEMA	boolean	bit	yes
126	MUS_L_SPINE_SPASMS	boolean	bit	yes
127	MUS_L_SPINE_SPINOUS_STABILITY	boolean	bit	yes
128	MUS_L_SPINE_TRIGGER_POINTS	boolean	bit	yes
129	MUS_L_SPINE_STRAIGHT_LEG_TEST	boolean	bit	yes
130	MUS_L_SPINE_ROM	boolean	bit	yes
131	MUS_SI_JOINT_TENDERNESS	boolean	bit	yes
132	MUS_SI_JOINT_SYMMETRY	boolean	bit	yes
133	MUS_SI_JOINT_EDEMA	boolean	bit	yes
134	MUS_SI_JOINT_ROM	boolean	bit	yes
135	MUS_SI_JOINT_FIXATION	boolean	bit	yes
136	MUS_SI_JOINT_MANIPULATION	boolean	bit	yes
137	MUS_BONY_PELVIC_EXAM	boolean	bit	yes
138	MUS_COCCYX	boolean	bit	yes
139	MUS_HIP_TENDERNESS	boolean	bit	yes
140	MUS_HIP_DEFORMITY	boolean	bit	yes
141	MUS_HIP_ASYMMETRY	boolean	bit	yes
142	MUS_RHIP_ROM_RESTRICTION_OR_PAIN	boolean	bit	yes
143	MUS_LHIP_ROM_RESTRICTION_OR_PAIN	boolean	bit	yes
144	RUE_MUSCULAR_ATROPHY	boolean	bit	yes
145	RUE_ECCHYMOSIS	boolean	bit	yes
146	RUE_SHOULDER_PALPATION	boolean	bit	yes
147	RUE_SHOULDER_DEFORMITY	boolean	bit	yes
148	RUE_SHOULDER_ROM	boolean	bit	yes
149	RUE_ADSONS_TEST	boolean	bit	yes
150	RUE_ELBOW_PALPATION	boolean	bit	yes
151	RUE_ELBOW_DEFORMITY_OR_SWELLING	boolean	bit	yes
152	RUE_ELBOW_ROM	boolean	bit	yes
153	RUE_TINEL_TEST_OF_ELBOW	boolean	bit	yes
154	RUE_WRIST_PALPATION	boolean	bit	yes
155	RUE_WRIST_DEFORMITY	boolean	bit	yes
156	RUE_WRIST_ROM	boolean	bit	yes
157	RUE_PHALENS_TEST_OF_WRIST	boolean	bit	yes
158	RUE_TINELS_TEST_OF_WRIST	boolean	bit	yes
159	RUE_HAND_PALPATION	boolean	bit	yes
160	RUE_HAND_DEFORMITY	boolean	bit	yes
161	RUE_HAND_ROM	boolean	bit	yes
162	LUE_MUSCULAR_ATROPHY	boolean	bit	yes
163	LUE_ECCHYMOSIS	boolean	bit	yes
164	LUE_SHOULDER_PALPATION	boolean	bit	yes
165	LUE_SHOULDER_DEFORMITY	boolean	bit	yes
166	LUE_SHOULDER_ROM	boolean	bit	yes
167	LUE_ADSONS_TEST	boolean	bit	yes
168	LUE_ELBOW_PALPATION	boolean	bit	yes
169	LUE_ELBOW_DEFORMITY_OR_SWELLING	boolean	bit	yes
170	LUE_ELBOW_ROM	boolean	bit	yes
171	LUE_TINEL_TEST_OF_ELBOW	boolean	bit	yes
172	LUE_WRIST_PALPATION	boolean	bit	yes
173	LUE_WRIST_DEFORMITY	boolean	bit	yes
174	LUE_WRIST_ROM	boolean	bit	yes
175	LUE_PHALENS_TEST_OF_WRIST	boolean	bit	yes
176	LUE_TINELS_TEST_OF_WRIST	boolean	bit	yes
177	LUE_HAND_PALPATION	boolean	bit	yes
178	LUE_HAND_DEFORMITY	boolean	bit	yes
179	LUE_HAND_ROM	boolean	bit	yes
180	RLE_MUSCULAR_ATROPHY	boolean	bit	yes
181	RLE_ECCHYMOSIS	boolean	bit	yes
182	RLE_KNEE_PALPATION	boolean	bit	yes
183	RLE_KNEE_ROM	boolean	bit	yes
184	RLE_ANTERIOR_DRAWER_TEST_KNEE	boolean	bit	yes
185	RLE_POSTERIOR_DRAWER_TEST_KNEE	boolean	bit	yes
186	RLE_ANKLE_OR_FOOT_PALPATION	boolean	bit	yes
187	RLE_ANKLE_OR_FOOT_DEFORMITY	boolean	bit	yes
188	RLE_ANKLE_OR_FOOT_SWELLING	boolean	bit	yes
189	RLE_ANKLE_OR_FOOT_ROM	boolean	bit	yes
190	RLE_ANTERIOR_DRAWER_TEST_ANKLE	boolean	bit	yes
191	RLE_POSTERIOR_DRAWER_TEST_ANKLE	boolean	bit	yes
192	LLE_MUSCULAR_ATROPHY	boolean	bit	yes
193	LLE_ECCHYMOSIS	boolean	bit	yes
194	LLE_KNEE_PALPATION	boolean	bit	yes
195	LLE_KNEE_ROM	boolean	bit	yes
196	LLE_ANTERIOR_DRAWER_TEST_KNEE	boolean	bit	yes
197	LLE_POSTERIOR_DRAWER_TEST_KNEE	boolean	bit	yes
198	LLE_ANKLE_OR_FOOT_PALPATION	boolean	bit	yes
199	LLE_ANKLE_OR_FOOT_DEFORMITY	boolean	bit	yes
200	LLE_ANKLE_OR_FOOT_SWELLING	boolean	bit	yes
201	LLE_ANKLE_OR_FOOT_ROM	boolean	bit	yes
202	LLE_ANTERIOR_DRAWER_TEST_ANKLE	boolean	bit	yes
203	LLE_POSTERIOR_DRAWER_TEST_ANKLE	boolean	bit	yes
204	EXAM_REVIEWED	boolean	bit	yes
205	ABD_ABDOMINAL_AORTA	boolean	bit	yes
206	ABD_BOWEL_SOUNDS	boolean	bit	yes
207	ABD_CONTOUR	boolean	bit	yes
208	ABD_DISTENTION	boolean	bit	yes
209	ABD_GALBLADDER	boolean	bit	yes
210	ABD_GUARDING	boolean	bit	yes
211	ABD_HERNIATIONS	boolean	bit	yes
212	ABD_KIDNEYS	boolean	bit	yes
213	ABD_LIVER	boolean	bit	yes
214	ABD_MASSES	boolean	bit	yes
215	ABD_PAIN	boolean	bit	yes
216	ABD_RIGIDITY	boolean	bit	yes
217	ABD_SCARS	boolean	bit	yes
218	ABD_SPLEEN	boolean	bit	yes
219	BST_AXILLARY_LYMPH_NODES	boolean	bit	yes
220	BST_BREAST_SIZE_OR_POSITION	boolean	bit	yes
221	BST_MASSES	boolean	bit	yes
222	BST_NIPPLES	boolean	bit	yes
223	BST_NODULES	boolean	bit	yes
224	BST_PAIN_OR_TENDERNESS	boolean	bit	yes
225	BST_SKIN	boolean	bit	yes
226	BST_GYNECOMASTIA	boolean	bit	yes
227	GNT_ADNEXA	boolean	bit	yes
228	GNT_CERVIX	boolean	bit	yes
229	GNT_GROIN_LYMPH_NODES	boolean	bit	yes
230	GNT_LABIA	boolean	bit	yes
231	GNT_URETHRA	boolean	bit	yes
232	GNT_UTERUS	boolean	bit	yes
233	GNT_VAGINA	boolean	bit	yes
234	GNT_HERNIAS	boolean	bit	yes
235	GNT_TESTICLES	boolean	bit	yes
236	GNT_SPERMATIC_CORDS	boolean	bit	yes
237	GNT_SCROTUM	boolean	bit	yes
238	GNT_PENIS	boolean	bit	yes
239	NRG_BABINSKIS_SIGN	boolean	bit	yes
240	NRG_CEREBELLAR_TEST	boolean	bit	yes
241	NRG_COGNITION	boolean	bit	yes
242	NRG_FACIAL_SYMMETRY	boolean	bit	yes
243	NRG_GAIT	boolean	bit	yes
244	NRG_HEEL_OR_TOE_WALK	boolean	bit	yes
245	NRG_MOOD_AND_EFFECT	boolean	bit	yes
246	NRG_ROMBERG_TEST	boolean	bit	yes
247	NRG_SPEECH	boolean	bit	yes
248	NRG_TONGUE	boolean	bit	yes