EMR_ENCOUNTERS_ROS_GENITO · 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	GNT_URINARY_FREQUENCY	string	varchar(max)	yes
3	GNT_BLOOD_IN_URINE	string	varchar(max)	yes
4	GNT_FOUL_URINARY_DISCHARGE	string	varchar(max)	yes
5	GNT_KIDNEY_PAIN	string	varchar(max)	yes
6	GNT_URINARY_URGENCY	string	varchar(max)	yes
7	GNT_NIGHT_TIME_URINATION	string	varchar(max)	yes
8	GNT_LACK_OF_SEXUAL_DRIVE	string	varchar(max)	yes
9	GNT_GENITAL_SORES	string	varchar(max)	yes
10	GNT_CONTROL_BLADDER	string	varchar(max)	yes
11	GNT_UNUSUAL_URINARY_COLOR	string	varchar(max)	yes
12	GNT_URINARY_FREQUENCY_COMMENT	string	varchar(max)	yes
13	GNT_BLOOD_IN_URINE_COMMENT	string	varchar(max)	yes
14	GNT_FOUL_URINARY_DISCHARGE_COMMENT	string	varchar(max)	yes
15	GNT_KIDNEY_PAIN_COMMENT	string	varchar(max)	yes
16	GNT_URINARY_URGENCY_COMMENT	string	varchar(max)	yes
17	GNT_NIGHT_TIME_URINATION_COMMENT	string	varchar(max)	yes
18	GNT_LACK_OF_SEXUAL_DRIVE_COMMENT	string	varchar(max)	yes
19	GNT_GENITAL_SORES_COMMENT	string	varchar(max)	yes
20	GNT_CONTROL_BLADDER_COMMENT	string	varchar(max)	yes
21	GNT_UNUSUAL_URINARY_COLOR_COMMENT	string	varchar(max)	yes
22	ROS_GENITO_REVIEWED	string	varchar(max)	yes