EMR_ENCOUNTERS_INTAKE · 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	INT_PAT_AGE	integer	int	yes
3	INT_RACE	string	varchar(80)	yes
4	INT_GENDER	string	varchar(10)	yes
5	INT_MARITAL_STATUS	string	varchar(20)	yes
6	INT_FAITH	string	varchar(20)	yes
7	INT_NUM_BOYS	integer	int	yes
8	INT_NUM_GIRLS	integer	int	yes
9	INT_BOYS_AGES	string	varchar(80)	yes
10	INT_GIRLS_AGES	string	varchar(80)	yes
11	INT_RESIDES_WITH	string	varchar(20)	yes
12	INT_CHILDREN_YN	string	varchar(3)	yes
13	INT_TYPE_OF_RESIDENCE	string	varchar(30)	yes
14	INT_EDUCATION	string	varchar(30)	yes
15	INT_WORK_SKILL	string	varchar(30)	yes
16	INT_EMPLOYED_AS	string	varchar(80)	yes
17	INT_UNEMPLOYED	boolean	bit	yes
18	INT_MEANS_OF_SUPPORT	string	varchar(80)	yes
19	INT_SOURCE_OF_REFERRAL	string	varchar(30)	yes
20	REF_AFTERCARE	boolean	bit	yes
21	REF_AFTERCARE_DELUSIONS	boolean	bit	yes
22	REF_AFTERCARE_HALLUCINATIONS	boolean	bit	yes
23	REF_AFTERCARE_THOUGHT_DISORDER	boolean	bit	yes
24	REF_AFTERCARE_INCOHERENT_THINKING	boolean	bit	yes
25	REF_DEPRESSION	boolean	bit	yes
26	REF_ANXIETY	boolean	bit	yes
27	REF_BEHAVIORAL_PROBLEMS	boolean	bit	yes
28	REF_SUP_STRUCTURE	boolean	bit	yes
29	REF_UNABLE_TO_FUNCTION	boolean	bit	yes
30	REF_SOCIALIZATION_REHAB	boolean	bit	yes
31	INT_INTAKE_NUMBER	string	varchar(30)	yes
32	REF_REFERRAL_PERSON	string	varchar(80)	yes
33	REF_REFERRAL_REASON	string	varchar(50)	yes
34	HIST_DEPRESSION	boolean	bit	yes
35	HIST_ANXIETY	boolean	bit	yes
36	HIST_PSYCHOTIC_MANEFESTATION	boolean	bit	yes
37	INT_ARRIVED_BY	string	varchar(30)	yes
38	INT_PRES_PROBLEMS	string	varchar(max)	yes
39	INT_PRECIP_FACTORS	string	varchar(max)	yes
40	INT_NO_PRIOR_PSYCH_TMT	boolean	bit	yes
41	INT_NO_FAM_HIST_MENT_ILLNESS	boolean	bit	yes
42	INT_HIST_OUTPATIENT_TMT	boolean	bit	yes
43	INT_OUTPAT_LOCATION	string	varchar(max)	yes
44	INT_OUTPAT_REASON	string	varchar(max)	yes
45	INT_OUTPAT_TIME	string	varchar(max)	yes
46	INT_OUTPAT_TMT_WITH	string	varchar(max)	yes
47	INT_OUTPAT_POSITIVE_OUTCOME	boolean	bit	yes
48	INT_INPATIENT_HOSP	boolean	bit	yes
49	INT_IP_DATING_BACK_TO_AGE	integer	int	yes
50	INT_DRUG_ALC_NONE	boolean	bit	yes
51	INT_HIST_ALC_NEVER_TX	boolean	bit	yes
52	INT_ALC_SINCE_AGE	integer	int	yes
53	INT_TX_DETOX_DATES	string	varchar(max)	yes
54	INT_ATTENDS_AA	boolean	bit	yes
55	INT_NO_ALC_SINCE	string	varchar(20)	yes
56	INT_BORN_RAISED	string	varchar(max)	yes
57	INT_EARLY_DEV_UNEVENTFUL	boolean	bit	yes
58	INT_BIRTH_ORDER	integer	int	yes
59	INT_OLDEST_YOUNGEST	string	varchar(10)	yes
60	INT_OLDEST_YOUNGEST_ORD	integer	int	yes
61	INT_NUM_BRO	integer	int	yes
62	INT_NUM_SIS	integer	int	yes
63	INT_BRO_AGES	string	varchar(30)	yes
64	INT_SIS_AGES	string	varchar(30)	yes
65	INT_FATHERS_OCC	string	varchar(50)	yes
66	INT_MOTHERS_OCC	string	varchar(50)	yes
67	INT_FATHERS_DEMEANOR	string	varchar(20)	yes
68	INT_MOTHERS_DEMEANOR	string	varchar(20)	yes
69	INT_FATHER_CAUSE_DEATH	string	varchar(30)	yes
70	INT_MOTHERS_CAUSE_DEATH	string	varchar(30)	yes
71	INT_FATHERS_YEAR_DEATH	string	varchar(4)	yes
72	INT_MOTHERS_YEAR_DEATH	string	varchar(4)	yes
73	INT_MOTHERS_AGE_DEATH	string	varchar(3)	yes
74	INT_FATHERS_AGE_DEATH	string	varchar(3)	yes
75	INT_PAT_AGE_FATHERS_DEATH	integer	int	yes
76	INT_PAT_AGE_MOTHERS_DEATH	integer	int	yes
77	INT_PARENTS_MARRIAGE_DESC	string	varchar(30)	yes
78	INT_PAT_AGE_PARENTS_DIVORCE	integer	int	yes
79	INT_PAT_ONLY_CHILD	boolean	bit	yes
80	INT_PAT_LIKED_BEING_CENTER_OF_ATTN	boolean	bit	yes
81	INT_PAT_LONELY_WITHOUT_SIBLINGS	boolean	bit	yes
82	INT_PAT_REL_SIBLINGS_DESC	string	varchar(30)	yes
83	INT_GROWING_UP_HAPPY	string	varchar(20)	yes
84	INT_PAT_LONER	string	varchar(30)	yes
85	INT_PAT_DATING_DESC	string	varchar(30)	yes
86	INT_PAT_STARTED_DATING_AGE	integer	int	yes
87	INT_PAT_NEVER_DATED	boolean	bit	yes
88	INT_PAT_STARTED_SEXUAL_RELATIONS_AGE	integer	int	yes
89	INT_PAT_SEX_POS_NEG	string	varchar(20)	yes
90	INT_PAT_EXP_SEX_PARTNERS	string	varchar(30)	yes
91	INT_PAT_NO_SEX_UNTIL_MARRIAGE	boolean	bit	yes
92	INT_PAT_NEVER_HAD_SEX	boolean	bit	yes
93	INT_NEG_SEX_EXP_PARENTS	boolean	bit	yes
94	INT_NEG_SEX_EXP_PEERS	boolean	bit	yes
95	INT_TRAUM_SEX_EXP_PARENTS	boolean	bit	yes
96	INT_TRAUM_SEX_EXP_PEERS	boolean	bit	yes
97	INT_PHYS_ABUSE_CHILD	boolean	bit	yes
98	INT_SEX_ABUSE_CHILD	boolean	bit	yes
99	INT_PHYS_ABUSE_CHILD_DETAILS	string	varchar(max)	yes
100	INT_SEX_ABUSE_CHILD_DETAILS	string	varchar(max)	yes
101	INT_PAT_RCVD_CARE_FOR_ABUSE	boolean	bit	yes
102	INT_NO_HIST_PHYS_SEX_ABUSE	boolean	bit	yes
103	INT_ABUSE_DETAILS	string	varchar(max)	yes
104	INT_MAR_HIST_STATUS	string	varchar(20)	yes
105	INT_MAR_AGE	integer	int	yes
106	INT_MAR_MET_SPOUSE	string	varchar(30)	yes
107	INT_MAR_DATED_YEARS	integer	int	yes
108	INT_MAR_DESC	string	varchar(30)	yes
109	INT_MAR_ENDED_DIVORCE	boolean	bit	yes
110	INT_MAR_DIVORCE_AFTER_YEARS	integer	int	yes
111	INT_MAR_PAT_AGE_DIVORCE	integer	int	yes
112	INT_NUM_CHILDREN	integer	int	yes
113	INT_MAR_PARENT_DESC	string	varchar(30)	yes
114	INT_MAR_SPOUSE_PARENT_DESC	string	varchar(30)	yes
115	INT_MAR_SPOUSE_OCC	string	varchar(30)	yes
116	INT_MAR_ABLE_TO_PROVIDE_FAMILY	boolean	bit	yes
117	INT_MAR_UNABLE_PROVIDE_DETAILS	string	varchar(30)	yes
118	INT_MAR_FRIENDS_FAMILY	string	varchar(30)	yes
119	INT_MAR_SOCIAL	string	varchar(30)	yes
120	INT_MAR_NUM_PREV_MARRIAGES	integer	int	yes
121	INT_EDU_EXP	string	varchar(20)	yes
122	INT_EDU_LIKED	string	varchar(10)	yes
123	INT_EDU_TYPE_STUDENT	string	varchar(20)	yes
124	INT_EDU_HAPPY_STUDENT	string	varchar(10)	yes
125	INT_EDU_EARLY_RECOLLECTION	boolean	bit	yes
126	INT_EMP_INFO	string	varchar(30)	yes
127	INT_EMP_NO_GAINFUL	boolean	bit	yes
128	INT_EMP_LAST	string	varchar(30)	yes
129	INT_EMP_YEARS	integer	int	yes
130	INT_EMP_LAST_WORKED_YEARS	integer	int	yes
131	INT_EMP_GOT_ALONG_COWORKERS	boolean	bit	yes
132	INT_EMP_STRESSFUL	boolean	bit	yes
133	INT_EMP_UNABLE_PERFORM	boolean	bit	yes
134	INT_FUNC_AGE_APPEAR	string	varchar(50)	yes
135	INT_FUNC_GROOMING	string	varchar(80)	yes
136	INT_FUNC_SOCIAL	string	varchar(70)	yes
137	INT_TMT_PSYCHOPHARM	boolean	bit	yes
138	INT_TMT_IND_SUPP	boolean	bit	yes
139	INT_TMT_REHAB	boolean	bit	yes
140	INT_TMT_FAMILY	boolean	bit	yes
141	INT_TMT_CASE_MGT	boolean	bit	yes
142	INT_TMT_CRISIS	boolean	bit	yes
143	INT_TMT_COLL	boolean	bit	yes
144	INT_TMT_PSYCH_TEST	boolean	bit	yes