EMR_ENCOUNTERS_MH_VISIT · 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	OTHERS_PRESENT	string	varchar(max)	yes
3	PAT_LEGAL_STATUS	string	varchar(max)	yes
4	CHARGES_PENDING	string	varchar(max)	yes
5	LIVING_SITUATION	string	varchar(max)	yes
6	EMPLOYMENT_SCHOOL_STATUS	string	varchar(max)	yes
7	REASON_FOR_REFERRAL	string	varchar(max)	yes
8	STRENGTHS	string	varchar(max)	yes
9	WEAKNESSES	string	varchar(max)	yes
10	SOCIAL_INTERESTS	string	varchar(max)	yes
11	RECREATIONAL_INTERESTS	string	varchar(max)	yes
12	HOBBIES	string	varchar(max)	yes
13	LEISURE_TIME_AVAILABLE	string	varchar(max)	yes
14	COLLATERAL_TREATMENT_1	string	varchar(max)	yes
15	COLLATERAL_TREATMENT_2	string	varchar(max)	yes
16	JUSTIFICATIONS_FOR_ADDITIONAL_TREATMENT	string	varchar(max)	yes
17	CLINICAL_FORMULATION	string	varchar(max)	yes
18	MH_VISIT_REVIEWED	boolean	bit	yes