EMR_ENCOUNTERS_DEV_HX · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT; or 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	ACCOUNT	string	varchar(12)	no
2	SEQUENCE_NO	integer	int	no
3	ENCOUNTER_ID	integer	int	yes
4	USER_ID	string	varchar(20)	yes
5	PREGNANCY_DURATION	string	varchar(max)	yes
6	SMOKING	boolean	bit	yes
7	SMOKING_NOS_DAILY	integer	int	yes
8	ALCOHOL	boolean	bit	yes
9	ALCOHOL_TYPE	string	varchar(max)	yes
10	ALCOHOL_AMOUNT	string	varchar(max)	yes
11	DRUGS	boolean	bit	yes
12	DRUG_DETAILS	string	varchar(max)	yes
13	MEDS	boolean	bit	yes
14	MEDS_DETAILS	string	varchar(max)	yes
15	PREGNANCY_COMPLICATIONS	string	varchar(max)	yes
16	LABOR_TYPE	string	varchar(max)	yes
17	LABOR_DURATION	integer	int	yes
18	DELIVERY_TYPE	string	varchar(max)	yes
19	PREMATURE	boolean	bit	yes
20	PREMATURE_WEEKS	integer	int	yes
21	BIRTH_WEIGHT	string	varchar(max)	yes
22	INFANT_DAYS_IN_HOSPITAL	integer	int	yes
23	APGAR	string	varchar(max)	yes
24	DELIVERY_COMPLICATIONS	string	varchar(max)	yes
25	MOTOR_SKILLS	string	varchar(max)	yes
26	LANGUAGE	string	varchar(max)	yes
27	SOCIAL_ATTACHMENT	string	varchar(max)	yes
28	PROBLEMS_INFANCY_CHILDHOOE	string	varchar(max)	yes
29	CHILDHOOD_ILLNESSES	string	varchar(max)	yes
30	OPERATIONS	string	varchar(max)	yes
31	HOSPITALIZATIONS	string	varchar(max)	yes
32	HEAD_INJURIES_W_LOSS_CONSCIENTIOUSMESS	boolean	bit	yes
33	HEAD_INJURIES_W_O_LOSS_CONSCIENTIOUSMESS	boolean	bit	yes
34	LOSS_CONSCIOUSNESS_DURATION	string	varchar(max)	yes
35	HEAD_INJURIY_DETAILS	string	varchar(max)	yes
36	CONVULSIONS_W_FEVER	boolean	bit	yes
37	CONVULSIONS_W_O_FEVER	boolean	bit	yes
38	CONVULSION_DETAILS	string	varchar(max)	yes
39	PHYSICAL_ABUSE	boolean	bit	yes
40	PHYSICAL_ABUSE_RULE_OUT	boolean	bit	yes
41	SEXUAL_ABUSE	boolean	bit	yes
42	SEXUAL_ABUSE_RULE_OUT	boolean	bit	yes
43	ABUSE_PERPETRATOR	string	varchar(max)	yes
44	ABUSE_DURATION	string	varchar(max)	yes
45	ABUSE_AGE	integer	int	yes
46	ABUSE_REPORTED_TO_AUTHORITIES	boolean	bit	yes
47	ABUSE_DETAILS	string	varchar(max)	yes
48	PHYSICAL_ABUSE_WITNESS	boolean	bit	yes
49	SEXUAL_ABUSE_WITNESS	boolean	bit	yes
50	WITNESS_DETAILS	string	varchar(max)	yes
51	DELHX_REVIEWED	boolean	bit	yes
52	DATE	datetime	datetime	yes
53	COMMENTS	string	varchar(max)	yes
54	DEVHX_ID PK	integer	int	no
55	IS_DELETED	boolean	bit	yes