EMR_ENCOUNTERS_ASSESSED_NEEDS · 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	SEQUENCE_NO PK	integer	int	no
3	ASSESSED_NEED	string	varchar(max)	no
4	NEED_ACTIVE	boolean	bit	no
5	INDIVIDUAL_DECLINED	boolean	bit	no
6	DEFERRED	boolean	bit	no
7	REFERRED_OUT	boolean	bit	no
8	GROUPID	integer	smallint	yes
9	PROBLEMNUMBER	integer	smallint	yes
10	FAMILY_DECLINED	boolean	bit	yes
11	NOT_APPLICABLE	boolean	bit	yes
12	IS_DELETED	boolean	bit	yes