EMR_ENCOUNTERS_ASSESSMENT_PAS_64 · 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	DATE_OF_ASSESSMENT	string	varchar(150)	yes
3	TOTAL	string	varchar(20)	yes
4	CRISIS_SITUATION	string	varchar(3)	yes
5	CRISIS_SITUATION_DESCRIBE	string	varchar(max)	yes
6	CRISIS_CONTACTS	string	varchar(3)	yes
7	PREVIOUS_DATES	string	varchar(150)	yes
8	ALCOHOL_USE_ABUSE	boolean	bit	yes
9	ACADEMIC_WORK_PROBLEM	boolean	bit	yes
10	FAMILY_PROBLEM	boolean	bit	yes
11	CRISIS	boolean	bit	yes
12	OTHER_SUBSTANCE_ABUSE	boolean	bit	yes
13	COA_COSA	boolean	bit	yes
14	PROBLEM_GAMBLING	boolean	bit	yes
15	TRUANCY	boolean	bit	yes
16	BEHAVIOR_PROBLEM	boolean	bit	yes
17	INTERPERSONAL_RELATIONS	boolean	bit	yes
18	MENTAL_HEALTH_PROBLEM	boolean	bit	yes
19	OTHER_	boolean	bit	yes
20	OTHER_TEXT	string	varchar(150)	yes
21	ADMINISTERED	string	varchar(3)	yes
22	ADMINISTERED_TOOL	string	varchar(max)	yes
23	COUNSELING_SERVICES	string	varchar(3)	yes
24	IN_PROGRAM	boolean	bit	yes
25	IN_PROGRAM_TEXT	string	varchar(150)	yes
26	OUTSIDE_OF_PROGRAM	boolean	bit	yes
27	OTHER_SERVICES	string	varchar(3)	yes
28	OTHER_SERVICES_IN_PROGRAM	boolean	bit	yes
29	OTHER_SERVICES_OUTSIDE_OF_PROGRAM	boolean	bit	yes
30	NO_FURTHER_ACTION	boolean	bit	yes
31	REFERRAL	boolean	bit	yes
32	ADMISSION	boolean	bit	yes
33	ADMISSION_TO_PREVENTION	boolean	bit	yes
34	DISPOSITION_SUMMARY	string	varchar(max)	yes
35	PARTICIPANTS_PRESENTING_PROBLEMS	string	varchar(max)	yes
36	DISPOSITIONS_CBLIST	string	varchar(max)	yes
37	PARTICIPANTS_PRESENTING_PROBLEMS_CBLIST	string	varchar(max)	yes