EMR_ENCOUNTERS_PSYCHIATRIC_PROGRESS_NOTE · 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	DESC1	string	varchar(70)	yes
3	DESC2	string	varchar(70)	yes
4	AXIS1_1	string	varchar(9)	yes
5	AXIS1_2	string	varchar(9)	yes
6	INTERVAL_HISTORY	string	varchar(max)	yes
7	INTERVAL_PSYCHIATRIC	string	varchar(max)	yes
8	CURRENT_MEDICATIONS	string	varchar(max)	yes
9	NO_SIDE_EFFECTS	boolean	bit	yes
10	ORDERED	boolean	bit	yes
11	REVIEWED	boolean	bit	yes
12	LAB_TESTS	string	varchar(max)	yes
13	DIAGNOSTIC_RESULTS	boolean	bit	yes
14	RISKS_AND_BENEFITS	boolean	bit	yes
15	INSTRUCTION	boolean	bit	yes
16	IMPORTANCE	boolean	bit	yes
17	RISK_FACTOR	boolean	bit	yes
18	PATIENT_FAMILY	boolean	bit	yes
19	PROGNOSIS	boolean	bit	yes
20	COUNSELING_PROVIDED	string	varchar(max)	yes
21	NURSING	boolean	bit	yes
22	RESIDENTIAL_STAFF	boolean	bit	yes
23	SOCIAL_WORK	boolean	bit	yes
24	PHYSICIANS	boolean	bit	yes
25	FAMILY	boolean	bit	yes
26	CAREGIVER	boolean	bit	yes
27	COORDINATION_OF_CARE	string	varchar(max)	yes
28	ADDITIONAL_DOCUMENTATION	string	varchar(max)	yes
29	DURATION_OF_FACE_TO_FACE	integer	int	yes
30	START_TIME	string	varchar(15)	yes
31	END_TIME	string	varchar(15)	yes
32	CPT	string	varchar(15)	yes
33	GREATER_THAN	boolean	bit	yes
34	UPDATE_DESC1	string	varchar(70)	yes
35	UPDATE_DESC2	string	varchar(70)	yes
36	UPDATE_AXIS1_1	string	varchar(9)	yes
37	UPDATE_AXIS1_2	string	varchar(9)	yes