PAT_INTAKE · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT

Single-patient export: the patient's rows.

02References

ACCOUNT → PATIENTS.ACCOUNT

03Columns

#	Column	Type	Source type	Null
1	ACCOUNT PK	string	varchar(12)	no
2	GUARDIAN_NAME	string	varchar(65)	yes
3	DANGEROUS_RISK_SITUATION	string	varchar(3)	yes
4	PRIMARY_LANG_ENG	boolean	bit	yes
5	PRIMARY_LANG_SPANISH	boolean	bit	yes
6	PRIMARY_LANG_OTHER	boolean	bit	yes
7	PRIMARY_LANG_OTHER_DESC	string	varchar(80)	yes
8	RECEIVED_SVC_BEFORE	string	varchar(3)	yes
9	PROGRAM	string	varchar(15)	yes
10	RECEIVE_SVC_ELSEWHERE	string	varchar(3)	yes
11	RECEIVE_SVC_ELSEWHERE_DESC	string	varchar(300)	yes
12	REASON_FOR_SERVICE	string	varchar(500)	yes
13	REFERRING_PERSON_ORG	string	varchar(150)	yes
14	REFERRING_PERSON_ORG_NUM	string	varchar(25)	yes
15	LEGAL_STAT_NA	boolean	bit	yes
16	LEGAL_STAT_PROBABTION	boolean	bit	yes
17	LEGAL_STAT_PAROLE	boolean	bit	yes
18	LEGAL_STAT_AOT	boolean	bit	yes
19	LEGAL_STAT_CPS	boolean	bit	yes
20	LEGAL_STAT_DSS	boolean	bit	yes
21	REQ_COURT_ORDERED	string	varchar(3)	yes
22	REQ_COURT_ORDERED_DESC	string	varchar(100)	yes
23	MANDATED	string	varchar(3)	yes
24	MANDATED_BY	string	varchar(100)	yes
25	SP_NEEDS_NONE_REPORTED	boolean	bit	yes
26	SP_NEEDS_SIGN_LANG	boolean	bit	yes
27	SP_NEEDS_ACT_LISTENING_DEVICE	boolean	bit	yes
28	SP_NEEDS_LANG_INTERPRETER	boolean	bit	yes
29	SP_NEEDS_TTD_TTY	boolean	bit	yes
30	SVC_NEEDED_MEDICAID_TRANSP	boolean	bit	yes
31	SVC_NEEDED_WHEELCHAIR	boolean	bit	yes
32	SVC_NEEDED_OTHER	boolean	bit	yes
33	SVC_NEEDED_OTHER_DESC	string	varchar(200)	yes
34	HAVE_DRIVERS_LICENSE	string	varchar(3)	yes
35	IS_CONDITIONAL_LICENSE	string	varchar(3)	yes
36	LICENSE_REVOKED_DWI	string	varchar(3)	yes
37	ON_PSYCHOTROPIC_MEDS	string	varchar(3)	yes
38	ON_PSYCHOTROPIC_MEDS_REFILL_NEEDED	string	varchar(80)	yes
39	HAD_TX_FOR_SUBSTANCE_ABUSE	string	varchar(3)	yes
40	HAD_TX_FOR_SUBSTANCE_ABUSE_DESC	string	varchar(80)	yes
41	SELF_PAY_FEE	decimal	money	yes
42	DELINQUENT_BALANCE_DUE	decimal	money	yes
43	INCOME_SOURCE_WAGE_SELF	boolean	bit	yes
44	INCOME_SOURCE_SSI	boolean	bit	yes
45	INCOME_SOURCE_SSD	boolean	bit	yes
46	INCOME_SOURCE_VETERAN	boolean	bit	yes
47	INCOME_SOURCE_WORKERS_COMP	boolean	bit	yes
48	INCOME_SOURCE_UNEMPLOYMENT	boolean	bit	yes
49	INCOME_SOURCE_SSA	boolean	bit	yes
50	INCOME_SOURCE_TANF	boolean	bit	yes
51	INCOME_SOURCE_OTHER	boolean	bit	yes
52	INCOME_SOURCE_OTHER_DESC	string	varchar(150)	yes
53	CBC_NUM	string	varchar(25)	yes
54	PREGNANT	string	varchar(3)	yes
55	IV_USER	string	varchar(3)	yes
56	REFERRAL_SOURCE_1	string	varchar(2)	yes
57	REFERRAL_SOURCE_2	string	varchar(2)	yes
58	REFERRAL_SOURCE_NPI	integer	int	yes
59	CURRENT_RESIDENCE	string	varchar(1)	yes
60	TYPE	string	varchar(2)	yes
61	CHRONIC_HOMELESSNESS	string	varchar(1)	yes
62	EMPLOYMENT_TYPE	string	varchar(1)	yes
63	IN_SCHOOL	string	varchar(1)	yes
64	PREGNANT_DUE_DATE	datetime	datetime	yes
65	SSI	string	varchar(1)	yes
66	SSDI	string	varchar(1)	yes
67	ENGLISH	string	varchar(1)	yes
68	PREFERRED_LANGUAGE	string	varchar(1)	yes
69	DISABILITY	string	varchar(2)	yes
70	LEGAL_STATUS	string	varchar(2)	yes
71	TOBACCO_USE	string	varchar(2)	yes
72	PRESENTING_PROBLEMS_1	string	varchar(3)	yes
73	PRESENTING_PROBLEMS_2	string	varchar(3)	yes
74	PRESENTING_PROBLEMS_3	string	varchar(3)	yes
75	DRUG_USED	string	varchar(2)	yes
76	DRUG_USED_2	string	varchar(2)	yes
77	DRUG_USED_3	string	varchar(2)	yes
78	DRUG_METHOD_1	string	varchar(1)	yes
79	DRUG_METHOD_2	string	varchar(1)	yes
80	DRUG_METHOD_3	string	varchar(1)	yes
81	DRUG_FREQ_1	string	varchar(1)	yes
82	DRUG_FREQ_2	string	varchar(1)	yes
83	DRUG_FREQ_3	string	varchar(1)	yes
84	AGE_FIRST_USED_1	string	char(2)	yes
85	AGE_FIRST_USED_2	string	char(2)	yes
86	AGE_FIRST_USED_3	string	char(2)	yes
87	FEELING	string	char(2)	yes
88	THINKING	string	char(2)	yes
89	SUBSTANCE_USE	string	char(2)	yes
90	MEDICAL	string	char(2)	yes
91	FAMILY	string	char(2)	yes
92	INTERPERSONAL	string	char(2)	yes
93	ROLE	string	char(2)	yes
94	SOCIO_LEGAL	string	char(2)	yes
95	SELF_CARE	string	char(2)	yes
96	MEDICAL_STATUS	string	char(1)	yes
97	EMPLOYMENT_STATUS_ASI	string	char(1)	yes
98	ALCOHOL	string	char(1)	yes
99	DRUS_ASI	string	char(1)	yes
100	LEGAL_STATUS_ASI	string	char(1)	yes
101	FAMILY_RELATIONSHIPS	string	char(1)	yes
102	PSYCHIATRIC_STATUS	string	char(1)	yes
103	CHEMICAL_USE	string	char(1)	yes
104	SCHOOL_STATUS	string	char(1)	yes
105	EMPLOYMENT_STATUS_TASI	string	char(1)	yes
106	FAMILY_TASI	string	char(1)	yes
107	PEER	string	char(1)	yes
108	LEGAL_STATUS_TASI	string	char(1)	yes
109	PSYCHIATRIC	string	char(1)	yes
110	ACE_SCORE	string	char(2)	yes
111	ARRESTS_30	string	char(2)	yes
112	ARRESTS_12	string	char(2)	yes
113	SELF_HELP_30	string	char(2)	yes
114	FAMILY_ID	string	varchar(10)	yes
115	CLINICIAN_OF_RECORDS	string	varchar(10)	yes
116	PLACEMENT	string	char(1)	yes
117	RESTRICTIVE_PLACEMENT	string	char(2)	yes
118	SELF_HARM	string	char(2)	yes
119	SUSPENDED_SCHOOL	string	char(2)	yes
120	ABSENT_DAY_CARE	string	char(2)	yes
121	ABSENT_SCHOOL	string	char(2)	yes
122	MAIDEN_NAME	string	varchar(80)	yes
123	CLINIC_DAY_ARRIVAL	string	varchar(15)	yes
124	REGISTRY_NUM	string	varchar(20)	yes