EMR_ENCOUNTERS_DISCHARGE · 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	PROVIDER	string	varchar(max)	yes
3	PROGRAM	string	varchar(max)	yes
4	NOTE_DATE	datetime	datetime	yes
5	DISCHARGE_DATE	datetime	datetime	yes
6	DISCHARGE_STATUS	string	varchar(max)	yes
7	DISCHARGE_CONDITION	string	varchar(max)	yes
8	DISCHARGE_REASON	string	varchar(max)	yes
9	TOTAL_SESSIONS_SEEN	integer	int	yes
10	DISCHARGE_RECOMMENDATIONS	string	varchar(max)	yes
11	DISCHARGE_SUMMARY	string	varchar(max)	yes
12	DISCHARGE_REVIEWED	boolean	bit	yes
13	SEVERAL_CONTACT_ATTEMPTS_MADE	boolean	bit	yes
14	DATE_OF_LAST_CONTACT_ATTEMPT	datetime	datetime	yes
15	DATE_OF_DISCHARGE	datetime	datetime	yes