How to populate MEASUREMENT.MEASUREMENT_SOURCE_CONCEPT_ID

[ericaVoss]

How to populate MEASUREMENT.MEASUREMENT_SOURCE_CONCEPT_ID

CDM or THEMIS convention?

CDM

Table or Field level?

Field

Is this a general convention?

Single Field

Summary of issues

• Improve text clarity
• MEASUREMENT_SOURCE_CONCEPT_ID is listed as not required, I believe this is not correct. Source Values, Source Concept Ids, and Standard Concept Ids

Summary of answer

VERSION	ETL Convention	Required
CURRENT	If the MEASUREMENT_SOURCE_VALUE is coded in the source data using an OMOP supported vocabulary put the concept id representing the source value here.	No
SUGGESTED	If the MEASUREMENT_SOURCE_VALUE is coded in the source data using a vocabulary supported by OMOP Standardized Vocabularies, insert the CONCEPT_ID representing the source value here.	Yes

Related links

• https://ohdsi.github.io/CommonDataModel/cdm54.html#measurement
• FORUMS - Measurement table discussion

Other comments/notes

• None

[clairblacketer]

@ericaVoss I updated the wording but I will open a second ticket to discuss requiring both measurement_source_concept_id and observation_source_concept_id. The discussion a couple years ago centered on the fact that, often, measurements and observations are manually mapped and may not have a source concept id