EMR_ENCOUNTERS_FHX · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT; or 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	ACCOUNT	string	varchar(12)	no
2	SEQUENCE_NO	integer	int	no
3	ENCOUNTER_ID	integer	int	yes
4	USER_ID	string	varchar(20)	yes
5	DISEASE_NAME	string	varchar(max)	yes
6	RELATIONSHIP	string	varchar(50)	yes
7	AGE	integer	smallint	yes
8	DECEASED	string	varchar(5)	yes
9	FHX_REVIEWED	boolean	bit	yes
10	DATE	datetime	datetime	yes
11	COMMENTS	string	varchar(max)	yes
12	DISEASE_DESC	string	varchar(max)	yes
13	FHX_ID PK	integer	int	no
14	ADDICTED	boolean	bit	yes
15	RECOVERY_STATUS	string	varchar(150)	yes
16	FHX_MI	string	char(1)	yes
17	IS_DELETED	boolean	bit	yes