EMR_ENCOUNTERS_PROVIDERS_OF_NEEDED_SERVICES · 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	IDENTIFIEDNEED5	string	varchar(max)	yes
3	PROVIDER2	string	varchar(max)	yes
4	PROVIDER5	string	varchar(max)	yes
5	DATE1	datetime	datetime	yes
6	DATE4	datetime	datetime	yes
7	ADDRESS_1	string	varchar(55)	yes
8	ADDRESS_3	string	varchar(55)	yes
9	TIME1	string	varchar(8)	yes
10	TIME2	string	varchar(8)	yes
11	TIME4	string	varchar(8)	yes
12	TIME5	string	varchar(8)	yes
13	PHONE_NUMBER_4	string	varchar(55)	yes
14	DATE2	datetime	datetime	yes
15	DATE5	datetime	datetime	yes
16	ADDRESS_4	string	varchar(55)	yes
17	PHONE_NUMBER_3	string	varchar(55)	yes
18	IDENTIFIEDNEED2	string	varchar(max)	yes
19	DATE3	datetime	datetime	yes
20	TIME6	string	varchar(8)	yes
21	ADDRESS_5	string	varchar(55)	yes
22	PHONE_NUMBER_1	string	varchar(55)	yes
23	PROVIDER6	string	varchar(max)	yes
24	ADDRESS_2	string	varchar(55)	yes
25	PHONE_6	string	varchar(20)	yes
26	ADDRESS_6	string	varchar(100)	yes
27	TIME3	string	varchar(8)	yes
28	PHONE_NUMBER_5	string	varchar(55)	yes
29	IDENTIFIEDNEED4	string	varchar(max)	yes
30	PROVIDER3	string	varchar(max)	yes
31	IDENTIFIEDNEED1	string	varchar(max)	yes
32	IDENTIFIEDNEED3	string	varchar(max)	yes
33	IDENTIFIEDNEED6	string	varchar(max)	yes
34	PROVIDER1	string	varchar(max)	yes
35	PROVIDER4	string	varchar(max)	yes
36	DATE6	datetime	datetime	yes
37	PHONE_NUMBER_2	string	varchar(55)	yes