EMR_ENCOUNTERS_OASAS_PAS_45N_2017 · 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	PROVIDER_NO	integer	int	yes
3	PROGRAM_NO	integer	int	yes
4	PROVIDER_CLIENT_ID	string	varchar(10)	yes
5	SEX	string	varchar(6)	yes
6	BIRTH_DATE	datetime	datetime	yes
7	LAST_NAME_2_CHAR	string	varchar(2)	yes
8	DATE_LAST_TREATED	datetime	datetime	yes
9	DAYS_IN_STABILIZATION	string	varchar(2)	yes
10	DAYS_IN_REHAB	string	varchar(2)	yes
11	DAYS_IN_REINT_SCATTER	string	varchar(2)	yes
12	LOCADTR_ASMT_ID	integer	int	yes
13	EDUCATION_LEVEL	integer	int	yes
14	EMPLOYMENT_STATUS	string	varchar(2)	yes
15	EMPLOYMENT_LENGTH	string	varchar(13)	yes
16	TYPE_OF_RESIDENCE	string	varchar(37)	yes
17	LIVING_ARRANGEMENT	string	varchar(29)	yes
18	TREATED_FOR_MENTAL_ILLNESS	string	varchar(3)	yes
19	HOSPITALIZED_FOR_MENTAL_ILLNESS	string	varchar(3)	yes
20	HOPITALIZED_30PLUS_FOR_MENTAL_ILLNESS	string	varchar(3)	yes
21	STATUS_TOBACCO	string	varchar(20)	yes
22	TOTAL_TREATMENT_VISITS	integer	int	yes
23	INDIVIDUAL_COUNSELING_SESSIONS	integer	int	yes
24	GROUP_COUNSELING_SESSIONS	integer	int	yes
25	NUM_OF_ARRESTS_30_DAYS	integer	int	yes
26	NUM_OF_ARRESTS_6_MONTH	integer	int	yes
27	NUM_OF_DAYS_INCARCERATED_6M	integer	int	yes
28	NUM_OF_DAYS_HOSPITALIZED_6M	integer	int	yes
29	NUM_OF_ER_EPISODES_6M	integer	int	yes
30	PRIMARY_FREQUENCY	string	varchar(23)	yes
31	SECONDARY_SUBSTANCE	string	varchar(27)	yes
32	TERTIARY_SUBSTANCE	string	varchar(27)	yes
33	TERTIARY_FREQUENCY	string	varchar(23)	yes
34	FIRST_OTHER_SUBSTANCE	string	varchar(27)	yes
35	FIRST_OTHER_ROUTE	string	varchar(10)	yes
36	SECOND_OTHER_SUBSTANCE	string	varchar(27)	yes
37	SECOND_OTHER_ROUTE	string	varchar(10)	yes
38	SECOND_OTHER_FREQUENCY	string	varchar(23)	yes
39	THIRD_OTHER_SUBSTANCE	string	varchar(27)	yes
40	THIRD_OTHER_ROUTE	string	varchar(10)	yes
41	THIRD_OTHER_FREQUENCY	string	varchar(23)	yes
42	TOBACCO_FREQUENCY	string	varchar(23)	yes
43	TOBACCO_LAST_USED_YEAR	string	varchar(4)	yes
44	TOBACCO_LAST_USED_ROUTE	string	varchar(7)	yes
45	TREATED_FOR_ASTHMA	string	varchar(3)	yes
46	HYPERTENSION	string	varchar(7)	yes
47	TREATED_FOR_HYPERTENSION	string	varchar(3)	yes
48	HIV_STATUS	string	varchar(20)	yes
49	TESTED_FOR_HIV	string	varchar(7)	yes
50	HEP_B_STATUS	string	varchar(20)	yes
51	TESTED_FOR_HEP_B	string	varchar(7)	yes
52	HEP_C_STATUS	string	varchar(20)	yes
53	TESTED_FOR_HEP_C	string	varchar(7)	yes
54	TB_TEST_RESULT	string	varchar(20)	yes
55	TREATED_FOR_TB	string	varchar(3)	yes
56	DISCHARGE_STATUS	string	varchar(59)	yes
57	REFERRAL_DISPOSITION	string	varchar(55)	yes
58	SELF_HELP_GROUPS	string	varchar(3)	yes
59	MENTAL_HEALTH_PROGRAMS	string	varchar(67)	yes
60	ALCOHOL_USE_STATUS	string	varchar(19)	yes
61	VOCATIONAL_EDU_STATUS	string	varchar(19)	yes
62	MEDICAL_CONDITIONS_STATUS	string	varchar(19)	yes
63	MED_DURING_TX_METHADONE	boolean	bit	yes
64	MED_DURING_TX_BUPRENORPHINE	boolean	bit	yes
65	MED_DURING_TX_NALTREXONE_VIVITROL	boolean	bit	yes
66	MED_DURING_TX_ANTABUSE	boolean	bit	yes
67	MED_DURING_TX_NICOTINE_LOZENGES	boolean	bit	yes
68	MED_DURING_TX_NICOTINE_GUM	boolean	bit	yes
69	MED_DURING_TX_CHANTIX	boolean	bit	yes
70	MED_DURING_TX_CAMPRAL	boolean	bit	yes
71	MED_DURING_TX_NALOXONE	boolean	bit	yes
72	MED_DURING_TX_CLONODINE	boolean	bit	yes
73	MED_DURING_TX_BACLOFEN	boolean	bit	yes
74	MED_DURING_TX_OTHER	boolean	bit	yes
75	MED_DURING_TX_NONE	boolean	bit	yes
76	TREATED_FOR_TRAUMA	string	varchar(3)	yes
77	TREATED_FOR_DOMESTIC_VIOLENCE	string	varchar(3)	yes
78	PERPETRATOR_OF_DOMESTIC_VIOLENCE	string	varchar(17)	yes
79	TREATED_FOR_PREP_DOMESTIC_VIOLENCE	string	varchar(3)	yes
80	ORIENTATION_TO_CHANGE	string	varchar(39)	yes
81	DAYS_IN_REINT_CONGREGATE	string	varchar(2)	yes
82	LOCADTR_ASMT_DATE	datetime	datetime	yes
83	PRIMARY_PAYMENT_SOURCE	string	varchar(36)	yes
84	STATUS_GAMBLING	string	varchar(20)	yes
85	FAMILY_COUNSELING_SESSIONS	integer	int	yes
86	NUM_OF_DAYS_IN_DETOX_6M	integer	int	yes
87	PRIMARY_SUBSTANCE	string	varchar(27)	yes
88	SECONDARY_FREQUENCY	string	varchar(23)	yes
89	FIRST_OTHER_FREQUENCY	string	varchar(23)	yes
90	DIABETES	string	varchar(7)	yes
91	TREATED_FOR_DIABETES	string	varchar(3)	yes
92	CHEMICAL_DEPENDENCE_PROGRAMS	string	varchar(28)	yes
93	EMOTIONAL_FUNCTIONING_STATUS	string	varchar(19)	yes
94	MED_DURING_TX_NALTREXONE_REVIA	boolean	bit	yes
95	MED_DURING_TX_GABAPENTIN	boolean	bit	yes
96	LAST_4_SSN	string	varchar(4)	yes
97	TOBACCO_LAST_USED_MONTH	string	varchar(2)	yes
98	ASTHMA	string	varchar(7)	yes
99	DISCHARGE_DISPOSITION	string	varchar(70)	yes
100	HEALTH_INSTITUTIONS	string	varchar(53)	yes
101	OTHER_REFERRALS	string	varchar(34)	yes
102	DRUG_USE_STATUS	string	varchar(19)	yes
103	SOCIAL_FUNCTIONING_STATUS	string	varchar(19)	yes
104	FAMILY_SITUATION_STATUS	string	varchar(19)	yes
105	LEGAL_STATUS	string	varchar(19)	yes
106	MED_DURING_TX_ZYBAN_WELLBUTRIN	boolean	bit	yes
107	MED_DURING_TX_NICOTINE_PATCH	boolean	bit	yes
108	MED_DURING_TX_VACCINES	boolean	bit	yes
109	EXPERIENCED_TRAUMA	string	varchar(17)	yes
110	VICTIM_OF_DOMESTIC_VIOLENCE	string	varchar(17)	yes
111	COEXISTING_PSYCHIATRIC_DISORDER	string	varchar(3)	yes
112	PRIMARY_FREQUENCY_2017	string	varchar(30)	yes