EMR_ENCOUNTERS_ROS_MUSCULO · 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	MSC_JOINT_SWELLING	string	varchar(max)	yes
3	MSC_JOINT_PAIN	string	varchar(max)	yes
4	MSC_MUSCLE_CRAMPS	string	varchar(max)	yes
5	MSC_STIFFNESS	string	varchar(max)	yes
6	MSC_BACK_PAIN	string	varchar(max)	yes
7	MSC_PRESENCE_OF_JOINT_FLUID	string	varchar(max)	yes
8	MSC_GOUT	string	varchar(max)	yes
9	MSC_ARTHRITIS	string	varchar(max)	yes
10	MSC_MUSCLE_WEAKNESS	string	varchar(max)	yes
11	MSC_MUSCLE_ACHES	string	varchar(max)	yes
12	MSC_LOSS_OF_STRENGTH	string	varchar(max)	yes
13	MSC_JOINT_SWELLING_COMMENT	string	varchar(max)	yes
14	MSC_JOINT_PAIN_COMMENT	string	varchar(max)	yes
15	MSC_MUSCLE_CRAMPS_COMMENT	string	varchar(max)	yes
16	MSC_STIFFNESS_COMMENT	string	varchar(max)	yes
17	MSC_BACK_PAIN_COMMENT	string	varchar(max)	yes
18	MSC_PRESENCE_OF_JOINT_FLUID_COMMENT	string	varchar(max)	yes
19	MSC_GOUT_COMMENT	string	varchar(max)	yes
20	MSC_ARTHRITIS_COMMENT	string	varchar(max)	yes
21	MSC_MUSCLE_WEAKNESS_COMMENT	string	varchar(max)	yes
22	MSC_MUSCLE_ACHES_COMMENT	string	varchar(max)	yes
23	MSC_LOSS_OF_STRENGTH_COMMENT	string	varchar(max)	yes
24	ROS_MUSCULO_REVIEWED	string	varchar(max)	yes