EMR_ENCOUNTERS_ROS_GASTRO · 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	GST_EXCESSIVE_APPETITE	string	varchar(max)	yes
3	GST_LOSS_OF_APPETITE	string	varchar(max)	yes
4	GST_INDIGESTION	string	varchar(max)	yes
5	GST_VOMITING_BLOOD	string	varchar(max)	yes
6	GST_NAUSEA	string	varchar(max)	yes
7	GST_VOMITING	string	varchar(max)	yes
8	GST_YELLOWISH_SKIN_COLOUR	string	varchar(max)	yes
9	GST_GAS	string	varchar(max)	yes
10	GST_ABDOMINAL_PAIN	string	varchar(max)	yes
11	GST_ABDOMINAL_BLOATING	string	varchar(max)	yes
12	GST_HEMORRHOIDS	string	varchar(max)	yes
13	GST_DIARRHEA	string	varchar(max)	yes
14	GST_CHANGE_IN_BOWEL_HABITS	string	varchar(max)	yes
15	GST_CONSTIPATION	string	varchar(max)	yes
16	GST_DARK_TORRY_STOOLS	string	varchar(max)	yes
17	GST_EXCESSIVE_APPETITE_COMMENT	string	varchar(max)	yes
18	GST_LOSS_OF_APPETITE_COMMENT	string	varchar(max)	yes
19	GST_INDIGESTION_COMMENT	string	varchar(max)	yes
20	GST_VOMITING_BLOOD_COMMENT	string	varchar(max)	yes
21	GST_NAUSEA_COMMENT	string	varchar(max)	yes
22	GST_VOMITING_COMMENT	string	varchar(max)	yes
23	GST_YELLOWISH_SKIN_COLOUR_COMMENT	string	varchar(max)	yes
24	GST_GAS_COMMENT	string	varchar(max)	yes
25	GST_ABDOMINAL_PAIN_COMMENT	string	varchar(max)	yes
26	GST_ABDOMINAL_BLOATING_COMMENT	string	varchar(max)	yes
27	GST_HEMORRHOIDS_COMMENT	string	varchar(max)	yes
28	GST_DIARRHEA_COMMENT	string	varchar(max)	yes
29	GST_CHANGE_IN_BOWEL_HABITS_COMMENT	string	varchar(max)	yes
30	GST_CONSTIPATION_COMMENT	string	varchar(max)	yes
31	GST_DARK_TORRY_STOOLS_COMMENT	string	varchar(max)	yes
32	ROS_GASTRO_REVIEWED	string	varchar(max)	yes