EMR_ENCOUNTERS_MARITAL_REL_HX · 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	STATUS	string	varchar(max)	yes
6	STATUS_DATE	datetime	datetime	yes
7	NATURE_OF_RELATIONSHIP	string	varchar(max)	yes
8	SATISFACTION	string	varchar(max)	yes
9	PREVIOUS_RELATIONSHIPS	string	varchar(max)	yes
10	CHILDREN	string	varchar(max)	yes
11	CUSTODY	string	varchar(max)	yes
12	SEXUAL_ORIENTATION	string	varchar(max)	yes
13	SEXUAL_HISTORY	string	varchar(max)	yes
14	SEXUAL_PROBLEMS	string	varchar(max)	yes
15	MAR_REL_HX_REVIEWED	boolean	bit	yes
16	COMMENTS	string	varchar(max)	yes
17	MRHX_ID PK	integer	int	no
18	IS_DELETED	boolean	bit	yes