EMR_ENCOUNTERS_LEGAL_HX · Accumedic EHI Export Format

01Relates to the patient

ACCOUNT is the patient's ACCOUNT; or 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	ACCOUNT	string	varchar(12)	no
2	SEQUENCE_NO	integer	int	no
3	ENCOUNTER_ID	integer	int	yes
4	USER_ID	string	varchar(20)	yes
5	PENDING_CHARGES	string	varchar(max)	yes
6	ARRESTS	string	varchar(max)	yes
7	CONVICTIONS	string	varchar(max)	yes
8	JAIL_PRISON	string	varchar(max)	yes
9	PAROLE_OFFICER	string	varchar(max)	yes
10	PAROLE_OFFICER_PHONE	string	varchar(max)	yes
11	PROBATION	string	varchar(max)	yes
12	PROBATION_OFFICER	string	varchar(max)	yes
13	PROBATION_OFFICER_PHONE	string	varchar(max)	yes
14	JUVENILE_DETENTION	string	varchar(max)	yes
15	DJS_INVOLVEMENT	string	varchar(max)	yes
16	DJS_WORKER	string	varchar(max)	yes
17	DJS_WORKER_PHONE	string	varchar(max)	yes
18	LEGAL_HX_REVIEWED	boolean	bit	yes
19	DATE	datetime	datetime	yes
20	COMMENTS	string	varchar(max)	yes
21	OFFENSE	string	varchar(200)	yes
22	DISPOSITION	string	varchar(100)	yes
23	AOD_INVOLVED	string	varchar(3)	yes
24	IS_DELETED	boolean	bit	yes
25	LEGAL_HX_ID PK	integer	int	no