EMR_ENCOUNTERS_PAS_44 · 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	CASE_NUMBER	string	varchar(20)	yes
3	MF	string	varchar(1)	yes
4	DATE_OF_BIRTH	datetime	datetime	yes
5	LAST_4_DIGITS_OF_SOCIAL	string	varchar(4)	yes
6	LAST_NAME_FIRST_2_LETTERS	string	varchar(2)	yes
7	LAST_NAME_FIRST_2_LETTERS2	string	varchar(2)	yes
8	INTAKE_DATE	datetime	datetime	yes
9	ADMISSION	boolean	bit	yes
10	ASSESSMENT	boolean	bit	yes
11	IF_ASSESSMENT_ADMISSION_DISPOSITION	string	varchar(50)	yes
12	NO_OF_ASSESSMENT_VISITS	integer	int	yes
13	SIGNIFICANT_OTHER	string	varchar(3)	yes
14	HISPANIC_ORIGIN_DESCRIPTION	string	varchar(80)	yes
15	HISPANIC_ORIGIN	string	varchar(80)	yes
16	LANGUAGE_DESCRIPTION	string	varchar(30)	yes
17	LANGUAGE	string	varchar(30)	yes
18	VETERAN_STATUS	string	varchar(3)	yes
19	MILITARY_DESCRIPTION	string	varchar(70)	yes
20	MILITARY	string	varchar(2)	yes
21	ZIPCODE	string	varchar(10)	yes
22	COUNTY_OF_RESIDENCE	string	varchar(30)	yes
23	TYPE_OF_RESIDENCE	string	varchar(50)	yes
24	LIVING_ARRANGEMENT	string	varchar(50)	yes
25	PRINCIPLE_REFERRAL_SOURCE	string	varchar(50)	yes
26	MARITAL_STATUS_DESCRIPTION	string	varchar(40)	yes
27	MARITAL_STATUS	string	varchar(1)	yes
28	CHILD_OF_ALCOHOL_SUBSTANCE_ABUSERS	string	varchar(50)	yes
29	TOTAL_NO_OF_CHILDREN	integer	int	yes
30	NO_OF_PATIENTS_CHILDREN_LIVING_WITH_PATIENT	integer	int	yes
31	NO_OF_CHILDREN_LIVING_IN_FOSTER_CARE	integer	int	yes
32	CASE_CHILD_PROTECTIVE_SERVICES	string	varchar(3)	yes
33	CRIMINAL_JUSTICE_STATUS	string	varchar(50)	yes
34	RESELT_OF_AN_ALTERNATIVE_TO_INCARCERATION	string	varchar(3)	yes
35	NO_OF_ARRESTS_PRIOR_30_DAYS	integer	int	yes
36	NO_OF_ARRESTS_PRIOR_6_MONTHS	integer	int	yes
37	NO_OF_DAYS_INCARC_PRIOR_6_MONTHS	integer	int	yes
38	HIGHEST_GRADE_COMPLETED	string	varchar(50)	yes
39	EMPLOYMENT_STATUS	string	varchar(50)	yes
40	PRIMARY_INCOME_SOURCE	string	varchar(50)	yes
41	PRIMARY_SUBSTANCE	string	varchar(50)	yes
42	PRIMARY_ROUTE	string	varchar(50)	yes
43	PRIMARY_FREQUENCY	string	varchar(50)	yes
44	AGE_OF_FIRST_USE_OF_PRIMARY_SUBSTANCE	integer	int	yes
45	SECONDARY_SUBSTANCE	string	varchar(50)	yes
46	SECONDARY_ROUTE	string	varchar(50)	yes
47	SECONDARY_FREQUENCY	string	varchar(50)	yes
48	AGE_OF_FIRST_USE_OF_SECONDARY_SUBSTANCE	integer	int	yes
49	TERTIARY_SUBSTANCE	string	varchar(50)	yes
50	TERTIARY_ROUTE	string	varchar(50)	yes
51	TERTIARY_FREQUENCY	string	varchar(50)	yes
52	AGE_OF_FIRST_USE_OF_TERTIARY_SUBSTANCE	integer	int	yes
53	STEP_PROGRAM_12	string	varchar(3)	yes
54	TOBACCO_USE	string	varchar(3)	yes
55	AGE_OF_FIRST_TOBACCO_USE	integer	int	yes
56	FREQUENCY_OF_USE_IN_PAST_30_DAYS	string	varchar(50)	yes
57	DATE_LAST_USED_MONTH	integer	int	yes
58	DATE_LAST_USED_YEAR	integer	int	yes
59	ROUTE_OF_TOBACCO	string	varchar(50)	yes
60	NO_OF_PRIOR_TX_EPISODES	integer	int	yes
61	PREGNANT	boolean	bit	yes
62	SPEECH_IMPAIRMENT	boolean	bit	yes
63	HEARING_IMPAIRMENT	boolean	bit	yes
64	SIGHT_IMPAIRMENT	boolean	bit	yes
65	MOBILITY_IMPAIRMENT	boolean	bit	yes
66	OTHER_MAJOR_PHYSICAL	boolean	bit	yes
67	MENTAL_RETARDATION	boolean	bit	yes
68	CO_EXISITING	boolean	bit	yes
69	EVER_TREATED_FOR_MENTAL_ILLNESS	boolean	bit	yes
70	EVER_HOSPITALIZED_FOR_MENTAL_ILLNESS	boolean	bit	yes
71	EVER_HOSPITALIZED_FOR_MORE_THAN_30	boolean	bit	yes
72	NO_OF_DAYS_IN_PATIENT_DETOX	integer	int	yes
73	NO_OF_EMERGENCY_ROOM_EPISODES	integer	int	yes
74	NO_OF_DAYS_HOSPITALIZED_FOR_NON_DETOX	integer	int	yes
75	REASON_FOR_HOSPITALIZATION	string	varchar(50)	yes
76	POSITIVE_FOR_GAMBLING	string	varchar(50)	yes
77	ADMISSION_DATE	datetime	datetime	yes
78	RACE_DESCRIPTION	string	varchar(40)	yes
79	RACE_DROPDOWN	string	varchar(10)	yes
80	HIGHEST_COMPLETED_GRADE	string	varchar(50)	yes
81	SEXUAL_ORIENTATION	string	varchar(20)	yes
82	GENDER_IDENTITY	string	varchar(35)	yes
83	HAVE_IEP	string	varchar(10)	yes
84	MEDICATION_ASSISTED	string	varchar(3)	yes
85	MEDICATION_ASSISTED_OPIOD	string	varchar(3)	yes
86	AQUIRED_BRAIN_INJURY	string	varchar(3)	yes
87	HIV_STATUS	string	varchar(30)	yes
88	HEP_B_STATUS	string	varchar(30)	yes
89	HEP_C_STATUS	string	varchar(30)	yes
90	ACQUIRED_BRAIN_INJURY	boolean	bit	yes