Physical measurements

Physical Measurements Integration

This tab checks on the physical measurements in the measurement table submitted by sites. It does not include physical measurement data from enrollment.

Please note that AoU requires standard LOINC concepts for the measurement table. 

(US Core Implementation also requires LOINC: https://www.hl7.org/fhir/us/core/StructureDefinition-us-core-body-weight.html )

Body Height (EHR)

For body height, we count any records with reasonable descendant concept_id under the ancestor concept_id 1029031

Complete concept_id set

3036277,1029031,3019171,3014149,3023540,37020651,3035463,3015514,3036798,3013842,3008989,36304231,1003304,37020737,1003232,1003850,4030731

Body Weight (EHR)

For body weight, we count any records with reasonable descendant concept_id under the ancestor concept_id 1029318

Complete concept_id set

3025315,1029318,3042378,40759214,3013747,40759213,3023166,3013762,3011043,3026600,3022484,40759177,36305329,46234683,3013131,1004122,3003176,3013853,3010147,40771968,3019336,3005422,3010220,1003206,3009617,3015644,3022281,3011054,21492642,40760186,1003642,40761330,40771967,1003088,1004141,1003261,3029459,3028871,3002072,3046286,3046309,3046001,3016341,3028864,3034205,3007541,3008900,3012860,3020933,3014618,3015141,3008303,3009664,3014140,3015512,3034737,3035618,3036221,3020110,3016054,3000749,3018372,3008484,3033534,3033528,3021838,3001912,3033350,3043735,3046620,3008128,3011956,3037845,3018298,3022724,3013673,3005565,3001647,3023704,3017459,3004464,3002756,3010914,3026659,43533987,45876173,45876171,3028543,45876172,3027492

 

BMI (EHR)

For BMI, we count any records with concept_id 44783982, 40762636, 3038553

Complete concept_id set

44783982, 40762636, 3038553

Heart Rate (EHR) 

For Heart rate, we count any records with reasonable descendant concept_id under the ancestor concept_id 37069660

Complete concept_id set

3027018,37069660,3013901,3011020,3015006,3019657,3021659,36303780,40771524,3013786,3040891,40771525,40771526,3031207,3032300,36303943,3035288,3033692,3031069,36303602,3010413,3005326,3026028,3009881,21490736,3042292,3026867,3010183,3013100,3015625,3027998,3021545,40758551,3001376,3013883,36305351,36303801,3023766,42527141,1002621,40769110,1002782,3023233,1003329,43533822,3003841,43533818,21490670,3000276,1002982,40758554,37039497,37039371,1003097,40758555,1003485,1003869,1003968,40769763,1003181,1003574,1004124,1004003

Blood Pressure (EHR) 

For blood pressure, in the overall rate we count any of the following three categories: systolic, diastolic, other. The overall rate captures all three, and the tooltip breaks down the systolic and diastolic percentages. 

Complete concept_id set

3018822, 36305059, 4232915, 4292062, 21490674, 3009435, 3012888, 4154790, 3034703,

21490851, 44789316, 3017188, 3019962, 3013940, 4236281, 3018592, 36304326, 4248524, 4268883, 3027598, 3018336, 3012526, 21490675, 3017490, 21490680

Systolic concept_id set

3004249, 4152194, 3018586, 21490853, 3028737, 44789315,

3005606, 3009395, 3035856, 4248525, 3018822, 36305059, 4232915, 4292062, 21490674, 3009435

Diastolic concept_id set

3012888, 4154790, 3034703,

21490851, 44789316, 3017188, 3019962, 3013940, 4236281, 3018592, 36304326, 4248524, 4268883

    

SQL template

Taking body height as an example.

To count number of participants with body height measurements:

 select (distinct person_id) as participants_with_ehr_height
 from measurement
 where measurement_concept_id in (3036277,1029031,3019171,3014149,3023540,37020651,
  3035463, 3015514,3036798,3013842,3008989,36304231,1003304,37020737,1003232,1003850,4030731)

To calculate the body height integration rate:

body height integration rate = participants_with_ehr_height / participants_with_EHR

participants_with_EHR = total counts of distinct participants with records in the visit_occurrence table

Features available on the dashboard

• Tooltip - detailed information, calculation equation, and links to Zendesk articles by clicking marks
  • 
• Information button
  •