EMR_ENCOUNTERS_PROBLEMS · 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	SEQUENCE_NO PK	integer	int	no
3	SEVERITY	string	varchar(max)	yes
4	DURATION	string	varchar(max)	yes
5	PROBS_REVIEWED	boolean	bit	yes
6	PROBLEM_ID	integer	int	no
7	ACTIVE_TXPLAN	boolean	bit	yes
8	PROBLEM	string	varchar(max)	yes
9	PROBLEM_STATUS	string	varchar(15)	yes
10	START_DATE	datetime	datetime	yes
11	RESOLVED_DATE	datetime	datetime	yes
12	ADDRESSED_ON_NOTE	boolean	bit	yes