EMR_ENCOUNTERS_PSYCHOSOCIAL_HISTORY_02 · 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.

02References

ENCOUNTER_ID → EMR_ENCOUNTERS.ENCOUNTER_ID

03Columns

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	MENTAL_HEALTH_HISTORY	string	varchar(max)	yes
3	PHARMACOLOGICAL_MEDICATIONS	string	varchar(3)	yes
4	PRESCRIBING_PHYSICIAN	string	varchar(60)	yes
5	MEDICINE_NAMES	string	varchar(max)	yes
6	DOSE_FREQUENCY	string	varchar(max)	yes
7	DATE_BEGIN	string	varchar(max)	yes
8	DATE_STOPPED	string	varchar(max)	yes
9	FAMILY_PSYCHIATRIC_DISORDER	string	varchar(3)	yes
10	FAMILY_PSYCHIATRIC_EXPLAIN	string	varchar(max)	yes
11	PATIENT_ADOPTED	string	varchar(3)	yes
12	AGE_AT_ADOPTION	string	varchar(2)	yes
13	PATIENT_RAISED_BY	string	varchar(50)	yes
14	NUMBER_OF_SIBLINGS	string	varchar(2)	yes
15	BIRTH_ORDER	string	varchar(50)	yes
16	PARENT_DIVORCED	string	varchar(3)	yes
17	AGE_AT_DIVORCE	string	varchar(2)	yes
18	REMARRIAGE	string	varchar(3)	yes
19	HISTORY_LIVING_EARLY_CHILDHOOD	string	varchar(max)	yes
20	FAMILY_HEALTH	string	varchar(max)	yes
21	SIGNIFICANT_SEPARTATION_LOSS	string	varchar(7)	yes
22	DESCRIBE_SEPARATION_LOSS	string	varchar(max)	yes
23	HISTORY_ABUSE	string	varchar(7)	yes
24	DESCRIBE_ABUSE	string	varchar(max)	yes
25	HISTORY_EATING_DISORDER	string	varchar(7)	yes
26	DESCRIBE_EATING_DISORDER	string	varchar(max)	yes
27	CULTURAL_BACKGROUND	string	varchar(max)	yes
28	ADDITIONAL_ISSUES_ADDICTION	string	varchar(max)	yes
29	AGE_AT_REMARRIAGE	string	varchar(2)	yes
30	CURRENT_STUDENT	string	varchar(3)	yes
31	LIST_GRADE	string	varchar(10)	yes
32	HIGHEST_GRADE_DEGREE	string	varchar(30)	yes
33	LD	boolean	bit	yes
34	ED	boolean	bit	yes
35	ABOVE_AVERAGE	boolean	bit	yes
36	AVERAGE	boolean	bit	yes
37	BELOW_AVERAGE	boolean	bit	yes
38	POOR	boolean	bit	yes
39	DESCRIBE_EDUCATION	string	varchar(max)	yes
40	PRESENT_EMPLOYMENT	string	varchar(max)	yes
41	PAST_EMPLOYMENT	string	varchar(max)	yes
42	VOCATIONAL_ASESSMENT_NEEDED	string	varchar(3)	yes
43	REFERRAL_TO_EAC_NEEDED	string	varchar(3)	yes
44	PATIENT_SELF_SUPPORTING	string	varchar(3)	yes
45	OTHER_FINANCIAL_SUPPORTS	string	varchar(max)	yes
46	LEGAL_HISTORY_YES	boolean	bit	yes
47	LEGAL_HISTORY_NA	boolean	bit	yes
48	PAST_CONVICTIONS_WARRENTS	string	varchar(max)	yes
49	PINS_PETITIONS	string	varchar(3)	yes
50	PINS_BY_WHOM	string	varchar(50)	yes
51	PINS_DESCRIBE	string	varchar(max)	yes
52	MANDATED_TREATMENT	string	varchar(3)	yes
53	MANDATED_BY_WHOM	string	varchar(50)	yes
54	PAROLE	boolean	bit	yes
55	PROBATION	boolean	bit	yes
56	TASC	boolean	bit	yes
57	NAME_AND_NUMBER	string	varchar(max)	yes
58	PEER_GROUP	string	varchar(max)	yes
59	SEXUALITY	string	varchar(max)	yes
60	SPIRITUALITY	string	varchar(max)	yes
61	LEISURE	string	varchar(max)	yes
62	THERAPIST_SUMMARY_ASSESSMENT	string	varchar(max)	yes
63	MANDATED_TREATMENT_OTHER	boolean	bit	yes
64	MANDATED_TREATMENT_OTHER_COMM	string	varchar(40)	yes
65	YES	boolean	bit	yes
66	NO	boolean	bit	yes
67	DESCRIBE	string	varchar(max)	yes
68	RECOMMENDATIONS	string	varchar(max)	yes