EMR_ENCOUNTERS_GENERAL_INFORMATION · 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	ENCOUNTER_ID PK	integer	int	no
2	DBO	datetime	datetime	yes
3	AGE	integer	int	yes
4	SSN_LAST_4_DIGITS	string	varchar(4)	yes
5	ACCOUNT	string	varchar(12)	yes
6	REFERRAL_SOURCE	string	varchar(100)	yes
7	PRU	string	varchar(100)	yes
8	RACE	string	varchar(100)	yes
9	HISPANIC_ORIGIN	string	varchar(100)	yes
10	MALE	boolean	bit	yes
11	FEMALE	boolean	bit	yes
12	UNKNOWN	boolean	bit	yes
13	LAST_GRADE_COMPLETED	string	varchar(50)	yes
14	DATE_OF_ADMISSION	datetime	datetime	yes
15	DATE_COMPLETED	datetime	datetime	yes
16	DATE_OF_THIS_REVIEW	datetime	datetime	yes
17	UPDATE_90	boolean	bit	yes
18	REVIEW	boolean	bit	yes
19	JUSTIFICATION	boolean	bit	yes
20	GROUP_CODE	string	varchar(100)	yes