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

#	Column	Type	Source type	Null
1	ENCOUNTER_ID PK	integer	int	no
2	LOC1_INDICATE	string	varchar(50)	yes
3	LOC1_N	boolean	bit	yes
4	LOC1_N_INDICATE	string	varchar(50)	yes
5	LOC1_Y	boolean	bit	yes
6	LOC10_N	boolean	bit	yes
7	LOC10_N_INDICATE	string	varchar(50)	yes
8	LOC10_Y	boolean	bit	yes
9	LOC11_N	boolean	bit	yes
10	LOC11_N_INDICATE	string	varchar(50)	yes
11	LOC11_Y	boolean	bit	yes
12	LOC12_N	boolean	bit	yes
13	LOC12_Y	boolean	bit	yes
14	LOC13_N	boolean	bit	yes
15	LOC13_N_INDICATE	string	varchar(50)	yes
16	LOC13_Y	boolean	bit	yes
17	LOC13_Y_INDICATE	string	varchar(50)	yes
18	LOC14_N	boolean	bit	yes
19	LOC14_Y	boolean	bit	yes
20	LOC15_N	boolean	bit	yes
21	LOC15_N_INDICATE	string	varchar(50)	yes
22	LOC15_Y	boolean	bit	yes
23	LOC2_N	boolean	bit	yes
24	LOC2_N_INDICATE	string	varchar(50)	yes
25	LOC2_Y	boolean	bit	yes
26	LOC2_Y_INDICATE	string	varchar(50)	yes
27	LOC3_N	boolean	bit	yes
28	LOC3_N_INDICATE	string	varchar(50)	yes
29	LOC3_Y	boolean	bit	yes
30	LOC3_Y_INDICATE	string	varchar(50)	yes
31	LOC4_N	boolean	bit	yes
32	LOC4_Y	boolean	bit	yes
33	LOC4_Y_INDICATE	string	varchar(50)	yes
34	LOC5_N	boolean	bit	yes
35	LOC5_Y	boolean	bit	yes
36	LOC6_N	boolean	bit	yes
37	LOC6_N_INDICATE	string	varchar(50)	yes
38	LOC6_Y	boolean	bit	yes
39	LOC6_Y_INDICATE	string	varchar(50)	yes
40	LOC7_N	boolean	bit	yes
41	LOC7_N_INDICATE	string	varchar(50)	yes
42	LOC7_Y	boolean	bit	yes
43	LOC8_N	boolean	bit	yes
44	LOC8_N_INDICATE	string	varchar(50)	yes
45	LOC8_Y	boolean	bit	yes
46	LOC8_Y_INDICATE	string	varchar(50)	yes
47	LOC9_N	boolean	bit	yes
48	LOC9_N_INDICATE	string	varchar(50)	yes
49	LOC9_Y	boolean	bit	yes
50	LOC9_Y_INDICATE	string	varchar(50)	yes
51	Q1	string	varchar(3)	yes
52	Q2	string	varchar(3)	yes
53	Q3	string	varchar(3)	yes