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