EMR_ENCOUNTERS_VITALS · 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	HEIGHT	decimal	decimal(8,2)	yes
3	WEIGHT	decimal	decimal(8,2)	yes
4	TEMPERATURE	decimal	decimal(8,2)	yes
5	TEMPERATURE_SITE	string	varchar(50)	yes
6	PULSE_RATE	integer	smallint	yes
7	RESPIRATIONS	integer	smallint	yes
8	BP_SYSTOLIC	integer	smallint	yes
9	BP_DIASTOLIC	integer	smallint	yes
10	VITALS_REVIEWED	boolean	bit	yes
11	BMI	decimal	decimal(8,2)	yes
12	SMOKING_STATUS	string	char(1)	yes
13	LANGUAGE_ABIL	string	varchar(20)	yes
14	LANGUAGE_PROF	string	varchar(10)	yes
15	PERFORM_NOT_DONE	boolean	bit	yes
16	WAIST	decimal	decimal(4,1)	yes
17	FUNCTIONAL_STATUS	string	varchar(20)	yes
18	COG_STAT	string	varchar(20)	yes
19	HEAD_CIRCUMFERENCE	decimal	decimal(4,1)	yes
20	OXYGEN_SATURATION	decimal	decimal(5,2)	yes
21	HEIGHT_LYING	decimal	decimal(8,2)	yes
22	PREFORMED_MED_RECONCILATION	boolean	bit	yes
23	SUMMARY_OF_CARE_PROVIDED	boolean	bit	yes
24	LANGUAGE	string	varchar(60)	yes
25	PROSTHESIS_AIDS	string	varchar(20)	yes
26	ADL_SKILLS_FEEDING	string	varchar(20)	yes
27	ADL_BATHING	string	varchar(20)	yes
28	ADL_DRESSING	string	varchar(20)	yes
29	ADL_TOILETING	string	varchar(20)	yes
30	BEHAVIOR	string	varchar(20)	yes
31	COMMUNICATION	string	varchar(20)	yes
32	ACTIVITIES	string	varchar(50)	yes
33	ARM_SPAN	string	varchar(20)	yes
34	ARM_SPAN_LENGTH	integer	int	yes
35	OXYGEN_SAT	integer	int	yes
36	VITALS_AFTER	boolean	bit	yes
37	SMOKING_CESSATION_COUNSELING	boolean	bit	yes
38	TEXTBOX_2	string	varchar(max)	yes
39	TEXTBOX_3	string	varchar(max)	yes
40	TEXTBOX_1	string	varchar(max)	yes
41	TEXTBOX_4	string	varchar(max)	yes
42	TEXTBOX_5	string	varchar(max)	yes