Hi all, we want to create a cohort definition involving glucose measurement using threshold values - which are different for fasting glucose measurement and random glucose measurement (in serum/plasma). The standard concept for measurement of “Glucose [Mass/volume] in Serum or Plasma” (concept ID = 3004501, LOINC concept code = 2345-7) in our EHR dataset has multiple measurement_source_value(s) with the same measurement_source_concept_id (3004501) - as below. There are about 65 distinct measurement_source_value, I have listed the ones with high record counts in our dataset.
BASIC METABOLIC PANELGLUCOSE
GLUCOSE
COMP METABOLIC PANELGLUCOSE
GLUCOSEGLUCOSE
GLUCOSE (OO)GLUCOSE
RENAL FUNCTION PANEL (OO)GLUCOSE
CMP & GFR(QUEST ONLY)GLUCOSE
COMP METABOLIC PANEL W/EGFRGLUCOSE
BASIC METABOLIC PANEL W/EGFRGLUCOSE
RENAL TRANSPLANT POST-OP LONG LAB SETGLUCOSE
FASTING GLUCOSEGLUCOSE
LIVER TRANSPLANT POST-OP LONG LAB SETGLUCOSE
CMP W/EGFRGLUCOSE
BMP & GFR(QUEST ONLY)GLUCOSE
RANDOM GLUCOSE (OO)GLUCOSE
ADD ON BMP W/EGFRGLUCOSE
ADD ON CMP W/EGFRGLUCOSE
RENAL TRANSPLANT POST-OP SHORT LAB SETGLUCOSE
COMMUNITY HEALTH SCREEN W/LDLGLUCOSE
COMPREHENSIVE METABOLIC PANEL W/EGFRGLUCOSE
As seen above, the measurement_concept_id (3004501) includes many different source values. ATLAS allows using measurement_source_concept_id to create the cohort, however in this case it is the same for all values. To use the correct thresholds we need to be able to differentiate between them and remove ambiguities such as ‘GLUCOSE’ with no other specification. Wondering if someone has looked into this and used these concepts previously, or if there is some way to alter mappings and use the measurement_source_value. Thank you!