EMR_ENCOUNTERS_PATIENT_HEALTH_HISTORY1 · 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	RECEIVING_MEDICAL_CARE	string	varchar(3)	yes
3	DATE_OF_LAST_PHYSICAL	datetime	datetime	yes
4	NAME_OF_MEDICAL_DOCTOR	string	varchar(63)	yes
5	MEDICAL_DOCTORS_ADDRESS	string	varchar(55)	yes
6	STATE	string	varchar(2)	yes
7	ZIP	string	varchar(10)	yes
8	WHY_ARE_YOU_RECEIVING_MEDICAL_CARE	string	varchar(max)	yes
9	IF_MEDICAL_TREATMENT_INVOLVES_USE_OF_DRUGS	string	varchar(max)	yes
10	LENGTH_OF_USAGE	string	varchar(max)	yes
11	PENICILLIN	string	varchar(3)	yes
12	SULFONAMIDES	string	varchar(3)	yes
13	ASPIRIN	string	varchar(3)	yes
14	OTHER_ANTIBOTICS	string	varchar(3)	yes
15	ANY_FOODS	string	varchar(max)	yes
16	OTHER	string	varchar(max)	yes
17	ANY_FOOD_YES_NO	string	varchar(3)	yes
18	OTHER_YES_NO	string	varchar(3)	yes
19	HAY_FEVER_OR_ASTHMA	string	varchar(20)	yes
20	CASE#	string	varchar(20)	yes
21	CITY	string	varchar(30)	yes
22	IF_OTHER	string	varchar(30)	yes
23	ADHD	boolean	bit	yes
24	TYPHOID_FEVER	boolean	bit	yes
25	SCARLET_FEVER	boolean	bit	yes
26	RHEUMATIC_FEVER	boolean	bit	yes
27	ANEMIA	boolean	bit	yes
28	DIABETES	boolean	bit	yes
29	EPILEPSY	boolean	bit	yes
30	HEPATITIS	boolean	bit	yes
31	SYPHILIS	boolean	bit	yes
32	GONORRHEA	boolean	bit	yes
33	MALARIA	boolean	bit	yes
34	TUBERCULOSIS	boolean	bit	yes
35	OVERDOSE	boolean	bit	yes
36	SICKLE_CELL_ANEMIA	boolean	bit	yes
37	GALL_BLADDER_DISEASE	boolean	bit	yes
38	THYROID_DISEASE	boolean	bit	yes
39	CANCER	boolean	bit	yes
40	INFECTED_VEIN	boolean	bit	yes
41	BLEEDING_TENDENCY	boolean	bit	yes
42	HIGHLOW_BLOOD_PRESSURE	boolean	bit	yes
43	ULCERS	boolean	bit	yes
44	AGE1	string	varchar(3)	yes
45	AGE2	string	varchar(3)	yes
46	AGE3	string	varchar(3)	yes
47	AGE4	string	varchar(3)	yes
48	AGE5	string	varchar(3)	yes
49	AGE6	string	varchar(3)	yes
50	AGE7	string	varchar(3)	yes
51	AGE8	string	varchar(3)	yes
52	AGE9	string	varchar(3)	yes
53	AGE10	string	varchar(3)	yes
54	AGE11	string	varchar(3)	yes
55	AGE12	string	varchar(3)	yes
56	AGE13	string	varchar(3)	yes
57	AGE14	string	varchar(3)	yes
58	AGE15	string	varchar(3)	yes
59	AGE16	string	varchar(3)	yes
60	AGE17	string	varchar(3)	yes
61	AGE18	string	varchar(3)	yes
62	AGE19	string	varchar(3)	yes
63	AGE20	string	varchar(3)	yes
64	AGE21	string	varchar(3)	yes
65	INSULIN_TYPE_AND_DOSAGE	string	varchar(max)	yes
66	DIET	string	varchar(max)	yes
67	MEDICATION_TAKEN	string	varchar(max)	yes
68	WHERE_TREATED	string	varchar(max)	yes
69	WHERE_TESTED	string	varchar(max)	yes
70	WHERE_TREATED2	string	varchar(max)	yes
71	WHERE_TREATED3	string	varchar(max)	yes
72	DATE_OF_TB_TEST	datetime	datetime	yes
73	NUMBER_OF_TIMES	string	varchar(5)	yes
74	WHERE_TREATED4	string	varchar(max)	yes
75	DATE_OF_XRAY	datetime	datetime	yes
76	AGE	integer	int	yes
77	PATIENT_NAME	string	varchar(63)	yes
78	DATE_OF_BIRTH	datetime	datetime	yes
79	SEX	string	varchar(1)	yes
80	PREVIOUS_HOSPITALIZATION	string	varchar(max)	yes
81	HOW_MANY_PREGNANCIES	string	varchar(2)	yes
82	LIVE_BIRTHS	string	varchar(2)	yes
83	ABORTIONS	string	varchar(2)	yes
84	MISCARRIAGES	string	varchar(2)	yes
85	LAST_MENSTRUAL_CYCLE	datetime	datetime	yes
86	LAST_GYN_EXAM	datetime	datetime	yes
87	HOW_MANY_PREGNANCIES_HAVE_YOU_FATHERED	string	varchar(2)	yes
88	TERMINATED_IN_ABORTION	string	varchar(2)	yes
89	FAMILY_HEALTH_HISTORY	string	varchar(max)	yes
90	MEDICAL_PROBLEMS	string	varchar(3)	yes
91	IF_YES_INDICATE_NATURE_OF_PROBLEM	string	varchar(max)	yes