(I am not sure if this belongs to Implementers or Vocabulary Users. Since I am an ETL implementer, this seems more natural…)
https://ohdsi.github.io/CommonDataModel/cdm531.html#measurement says this about value_as_concept_id column:
If the raw data gives a categorial result for measurements those values are captured and mapped to standard concepts in the ‘Meas Value’ domain.
This is also the destination for the ‘Maps to value’ relationship.
What should I do with a source concept “Y90.0 Blood alcohol level of less than 20 mg/100 ml” from ICD10 vocabulary (concept_id=45590669)?
CONCEPT_RELATIONSHIP row with relationship_id == “Maps to” says this is a SNOMED vocabulary concept in Measurement domain: “167009006 Blood ethanol measurement” so this clearly goes into MEASUREMENT table.
CONCEPT_RELATIONSHIP row with relationship_id == “Maps to value” states the ICD10 code maps as value to SNOMED concept “442082004 Measurement finding within reference range” (Concept_id=40481826) but the domain is “Condition”.
Can I use this Concept_id=40481826 as MEASUREMENT.value_as_concept_id even though it is in Condition domain and not “Meas value”?