EMR_ENCOUNTERS_PAIN_ASSESSMENT · 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	PAIN_PRESENT	boolean	bit	yes
4	LOCATION	string	varchar(max)	yes
5	DURATION	string	varchar(max)	yes
6	ONSET	string	varchar(max)	yes
7	INTENSITY_WORST	string	varchar(max)	yes
8	INTENSITY_BEST	string	varchar(max)	yes
9	FREQUENCY	string	varchar(max)	yes
10	QUALITY	string	varchar(max)	yes
11	DOES_ANYTHING_HELP	string	varchar(max)	yes
12	WHAT_HELPS	string	varchar(max)	yes
13	RECOMMENDATIONS	string	varchar(max)	yes
14	PAIN_ASS_REVIEWED	boolean	bit	yes