EMR_ENCOUNTERS_ROS_RESP · 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	RSP_SLEEP_DISTURBANCES_DUE_TO_BREATHING	string	varchar(max)	yes
3	RSP_COUGH	string	varchar(max)	yes
4	RSP_SHORTNESS_OF_BREATH	string	varchar(max)	yes
5	RSP_COUGHING_UP_BLOOD	string	varchar(max)	yes
6	RSP_CHEST_DISCOMFORT	string	varchar(max)	yes
7	RSP_WHEEZING	string	varchar(max)	yes
8	RSP_EXCESSIVE_SPUTUM	string	varchar(max)	yes
9	RSP_EXCESSIVE_SNORING	string	varchar(max)	yes
10	RSP_SLEEP_DISTURBANCES_DUE_TO_BREATHING_COMMENT	string	varchar(max)	yes
11	RSP_COUGH_COMMENT	string	varchar(max)	yes
12	RSP_SHORTNESS_OF_BREATH_COMMENT	string	varchar(max)	yes
13	RSP_COUGHING_UP_BLOOD_COMMENT	string	varchar(max)	yes
14	RSP_CHEST_DISCOMFORT_COMMENT	string	varchar(max)	yes
15	RSP_WHEEZING_COMMENT	string	varchar(max)	yes
16	RSP_EXCESSIVE_SPUTUM_COMMENT	string	varchar(max)	yes
17	RSP_EXCESSIVE_SNORING_COMMENT	string	varchar(max)	yes
18	ROS_RESP_REVIEWED	string	varchar(max)	yes