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

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	SELF_IDENTIFIED_ISSUES_1	string	varchar(max)	yes
3	SELF_IDENTIFIED_ISSUES_2	string	varchar(max)	yes
4	SELF_IDENTIFIED_ISSUES_3	string	varchar(max)	yes
5	SELF_IDENTIFIED_ISSUES_4	string	varchar(max)	yes
6	SELF_IDENTIFIED_ISSUES_5	string	varchar(max)	yes
7	SELF_IDENTIFIED_PLAN_1	string	varchar(max)	yes
8	SELF_IDENTIFIED_PLAN_2	string	varchar(max)	yes
9	SELF_IDENTIFIED_PLAN_3	string	varchar(max)	yes
10	SELF_IDENTIFIED_PLAN_4	string	varchar(max)	yes
11	SELF_IDENTIFIED_PLAN_5	string	varchar(max)	yes
12	PEER_SUPPORT	string	varchar(max)	yes
13	SIGNIFICANT_OTHER	string	varchar(max)	yes
14	OTHER_NEEDS_IDENTIFIED	string	varchar(max)	yes
15	ASSESSMENT_IDENTIFICATION	string	varchar(max)	yes
16	VOCATIONAL_EDUCATIONAL	string	varchar(max)	yes
17	INDENTIFIED_NEED_1	string	varchar(max)	yes
18	INDENTIFIED_NEED_2	string	varchar(max)	yes
19	INDENTIFIED_NEED_3	string	varchar(max)	yes
20	INDENTIFIED_NEED_4	string	varchar(max)	yes
21	INDENTIFIED_NEED_5	string	varchar(max)	yes
22	INDENTIFIED_NEED_6	string	varchar(max)	yes
23	PROVIDER_1	string	varchar(40)	yes
24	PROVIDER_2	string	varchar(40)	yes
25	PROVIDER_3	string	varchar(40)	yes
26	PROVIDER_4	string	varchar(40)	yes
27	PROVIDER_5	string	varchar(40)	yes
28	PROVIDER_6	string	varchar(40)	yes
29	DATE_1	datetime	datetime	yes
30	DATE_2	datetime	datetime	yes
31	DATE_3	datetime	datetime	yes
32	DATE_4	datetime	datetime	yes
33	DATE_5	datetime	datetime	yes
34	DATE_6	datetime	datetime	yes
35	TIME_1	string	varchar(10)	yes
36	TIME_2	string	varchar(10)	yes
37	TIME_3	string	varchar(10)	yes
38	TIME_4	string	varchar(10)	yes
39	TIME_5	string	varchar(10)	yes
40	TIME_6	string	varchar(10)	yes