EMR_ENCOUNTERS_ROS_PSYCH · 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	PSY_THOUGHTS_OF_SUICIDE	string	varchar(max)	yes
3	PSY_ANXIETY	string	varchar(max)	yes
4	PSY_SENSE_OF_GREAT_DANGER	string	varchar(max)	yes
5	PSY_THOUGHTS_OF_VIOLENCE	string	varchar(max)	yes
6	PSY_DEPRESSION	string	varchar(max)	yes
7	PSY_MENTAL_PROBLEMS	string	varchar(max)	yes
8	PSY_FRIGHTENING_VISIONS_OR_SOUND	string	varchar(max)	yes
9	PSY_THOUGHTS_OF_SUICIDE_COMMENT	string	varchar(max)	yes
10	PSY_ANXIETY_COMMENT	string	varchar(max)	yes
11	PSY_SENSE_OF_GREAT_DANGER_COMMENT	string	varchar(max)	yes
12	PSY_THOUGHTS_OF_VIOLENCE_COMMENT	string	varchar(max)	yes
13	PSY_DEPRESSION_COMMENT	string	varchar(max)	yes
14	PSY_MENTAL_PROBLEMS_COMMENT	string	varchar(max)	yes
15	PSY_FRIGHTENING_VISIONS_OR_SOUND_COMMENT	string	varchar(max)	yes
16	ROS_PSYCH_REVIEWED	string	varchar(max)	yes