EMR_ENCOUNTERS_FAM_DETAILS · 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	MOTHER_NAME	string	varchar(max)	yes
3	MOTHER_AGE	integer	int	yes
4	MOTHER_EDUCATION	string	varchar(max)	yes
5	MOTHER_OCCUPATION	string	varchar(max)	yes
6	FATHER_NAME	string	varchar(max)	yes
7	FATHER_AGE	integer	int	yes
8	FATHER_EDUCATION	string	varchar(max)	yes
9	FATHER_OCCUPATION	string	varchar(max)	yes
10	PARENTS_MARITAL_STATUS	string	varchar(max)	yes
11	PARENTS_MARITAL_STATUS_YEAR	integer	int	yes
12	MOTHER_REMARRIED	boolean	bit	yes
13	FATHER_REMARRIED	boolean	bit	yes
14	SIBLINGS	string	varchar(max)	yes
15	HALF_AND_STEP_SIBLINGS	string	varchar(max)	yes
16	FAMILY_RELATIONSHIP_DETAILS	string	varchar(max)	yes
17	SUBSTANCE_ABUSE	string	varchar(max)	yes
18	MENTAL_ILLNESS	string	varchar(max)	yes
19	SUICIDE	string	varchar(max)	yes
20	VIOLENCE	string	varchar(max)	yes
21	OTHER_FAMILY_ISSUES	string	varchar(max)	yes
22	PEER_RELATIONS	string	varchar(max)	yes
23	GANG_INVOLVEMENT	string	varchar(max)	yes
24	RELATIONS_WITH_AUTHORITY	string	varchar(max)	yes
25	SOCIAL_SUPPORT_NETWORKDS	string	varchar(max)	yes
26	HOBBIES_INTERESTS	string	varchar(max)	yes
27	CULTURAL_ISSUES	string	varchar(max)	yes
28	RELIGIOUS_ISSUES	string	varchar(max)	yes
29	FAM_DET_REVIEWED	boolean	bit	yes