EMR_ENCOUNTERS_DISCHARGE_SUMMARY · 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	ADMISSION_DATE	datetime	datetime	yes
3	DISCHARGE_DATE	datetime	datetime	yes
4	DATE_OF_FINAL_DISCHARGE	datetime	datetime	yes
5	SUMMARY_OF_PROGRESS	string	varchar(max)	yes
6	ALL_OR_MOST_GOALS_MET	boolean	bit	yes
7	SOME_TREATMENT_GOALS_MET	boolean	bit	yes
8	REFERRED_TO_ALTERNATIVE_TYPE	boolean	bit	yes
9	LEFT_AGAINST_CLINICAL_ADVICE	boolean	bit	yes
10	NON_COMPLIANCE_WITH_PROGRAM_RULES	boolean	bit	yes
11	CLIENT_LOST_TO_CONTACT	boolean	bit	yes
12	CLIENT_MOVED_AWAY	boolean	bit	yes
13	CLIENT_INCARCERATED	boolean	bit	yes
14	MEDICAL_REASONS	boolean	bit	yes
15	CLIENT_DEATH	boolean	bit	yes
16	IS_FURTHER_TREATMENT_RECOMMENDED	string	varchar(3)	yes
17	RESIDENTIAL_SUBSTANCE_ABUSE_PROGRAM	boolean	bit	yes
18	REHAB	boolean	bit	yes
19	STRUCTURED_OUTPATIENT_SUBSTANCE_ABUSE_PROGRAM	boolean	bit	yes
20	RESIDENTIAL_PSYCHIATRIC_PROGRAM	boolean	bit	yes
21	OP_COUNSELING_WITH_ANOTHER_CLINICIAN	boolean	bit	yes
22	PSYCHIATRIC_INPATIENT	boolean	bit	yes
23	PSYCHIATRIC_OUTPATIENT	boolean	bit	yes
24	DUAL_DIAGNOSIS_PROGRAM	boolean	bit	yes
25	SELF_HELP_PEER_SUPPORT_GROUP	boolean	bit	yes
26	OTHER	boolean	bit	yes
27	OTHER_COMM	string	varchar(70)	yes
28	NAME_OF_REFERRAL	string	varchar(70)	yes
29	DATE_OF_REFERRAL	datetime	datetime	yes
30	CLIENT_REFUSED_REFERRAL	boolean	bit	yes
31	CONFIRMED_USE_BY_PHONE	boolean	bit	yes
32	CONFIRMED_USE_WITH_CLIENT	boolean	bit	yes
33	REFERRAL_OUTCOME_UNKNOWN	boolean	bit	yes
34	FAMILY_AGREES	string	varchar(3)	yes
35	FAMILY_WILL	string	varchar(3)	yes
36	CLIENT_FAMILY_WITH_CONTINUE	boolean	bit	yes
37	CLIENT_ATTEND_12_STEPS	boolean	bit	yes
38	CLIENT_ATTEND_TREATMENT	boolean	bit	yes
39	AT_TEMPO_GROUP	boolean	bit	yes
40	SELF_HELP	boolean	bit	yes
41	PRIVATE_COUNSELING	boolean	bit	yes
42	TREATMENT_WHERE	string	varchar(70)	yes
43	TREATMENT_WHOM	string	varchar(70)	yes
44	DATE_OF_APPOINTMENT	datetime	datetime	yes
45	CLIENT_HAS_EDUCATION	boolean	bit	yes
46	CLIENT_ATTENDS_SCHOOL	boolean	bit	yes
47	WHICH_ONE	string	varchar(70)	yes
48	CLIENT_IS_EMPLOYED	boolean	bit	yes
49	CLIENT_IS_EMPLOYED_WHERE	string	varchar(70)	yes
50	CLIENT_HAS_OTHER_STRUCTURED_ACTIVITY	boolean	bit	yes
51	CLIENT_HAS_OTHER_STRUCTURED_EXPLAIN	string	varchar(max)	yes
52	CLIENT_LEFT_TREATMENT_PRIOR	boolean	bit	yes
53	PROGRAM_STATUS	string	varchar(20)	yes
54	LIVING_ARRANGEMENTS	string	varchar(40)	yes
55	IF_PATIENT_NOT_LIVING_ALONE	string	varchar(max)	yes
56	SELF_IDENTIFIED_RELAPSE	string	varchar(max)	yes
57	OTHER_IDENTIFIED_NEEDS	string	varchar(max)	yes
58	DEVELOPED_WITH_PATIENT	boolean	bit	yes
59	PATIENT_IS_MINOR	boolean	bit	yes
60	REFUSED_TO_PARTICIPATE	boolean	bit	yes
61	CLIENT_ACCEPT_OD_TRAINING_MATERIAL	string	varchar(3)	yes
62	CC_JUSTIFICATION	string	varchar(max)	yes
63	CLIENT_PARTICIPATING_CONTUNUING_CARE	string	varchar(3)	yes
64	PRESCRIPTION_PROVIDED	string	varchar(3)	yes
65	SERVICE_COURSE	string	varchar(max)	yes
66	OD_PREV_TRAINING_DATE	datetime	datetime	yes
67	KIT_PROVIDED	string	varchar(3)	yes
68	REASON_FOR_CLOSING_TERMINATION	string	varchar(max)	yes
69	NARCAN_KIT_GIVEN	string	varchar(3)	yes
70	COPY_OF_THE_PLAN	string	varchar(3)	yes
71	COPY_OF_PLAN_WAS_OFFERED_TO_PATIENT	boolean	bit	yes
72	COPY_OF_DISCHARGE_WAS_OFFERED	string	varchar(3)	yes