EMR_ENCOUNTERS_PSH_RISK_ASSESSMENT · 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	HURT_YOURSELF_WHEN_AND_HOW	string	varchar(max)	yes
3	SUICIDAL_THOUGHTS	string	varchar(3)	yes
4	SUICIDE_ATTEMPT_UNDER_INFLUENCE_DESCRIBE	string	varchar(max)	yes
5	UNDER_INFLUENCE_OF_ALCOHOL	string	varchar(3)	yes
6	ASSAULT_LOST_CONTROL	string	varchar(3)	yes
7	NOT_UNDER_INFLUENCE_WHEN_AND_HOW	string	varchar(max)	yes
8	ABUSED_BY_WHOM	string	varchar(max)	yes
9	DISCUSSED_THE_ABUSE	string	varchar(3)	yes
10	DISCUSSED_WITH_WHOM	string	varchar(max)	yes
11	TRAUMAAGE	string	varchar(5)	yes
12	VOILENT	string	varchar(3)	yes
13	HURT_YOURSELF	string	varchar(3)	yes
14	EMOTIONALLY	boolean	bit	yes
15	ONGING_PROBLEM	string	varchar(3)	yes
16	EXPTRAUMA	string	varchar(5)	yes
17	TRAUMAMANY	string	varchar(5)	yes
18	HURTING_SOMEONE_DESCRIBE	string	varchar(max)	yes
19	VERBALLY	boolean	bit	yes
20	ASSAULT_ENDORSED	string	varchar(max)	yes
21	NOT_UNDER_INFLUENCE_OF_ALCOHOL	string	varchar(3)	yes
22	FELT_LIKE_HURTING_SOMEONE	string	varchar(3)	yes
23	ASSAULTED_SOMEONE	string	varchar(3)	yes
24	NEVER_BEEN_ABUSED	boolean	bit	yes
25	SEXUALLY_ABUSE	boolean	bit	yes
26	ASSAULT_EXPERIENCING_PSYYCHOSIS	string	varchar(3)	yes
27	PHYSICALLY	boolean	bit	yes
28	TRAUMANUMBER	string	varchar(5)	yes
29	NOT_WORTH_LIVING	string	varchar(3)	yes
30	COMMITTING_SUICIDE	string	varchar(3)	yes
31	SUICIDE_ATTEMPT_UNDER_INFLUENCE	string	varchar(3)	yes
32	ASSAULTED_SOMEONE_DESCRIBE	string	varchar(max)	yes