search

National-COVID-Cohort-Collaborative / Phenotype_Data_Acquisition

The repository for code and documentation produced by the N3C Phenotype and Data Acquisition workstream
60 stars 35 forks source link

OMOP CDM measurement table value_source_value column data - one example #121

Closed stephanieshong closed 4 years ago

stephanieshong commented 4 years ago

This is really not an issue, but wondering if OMOP sites can set the measurement.value_source_value column with loinc codes and lab text. This will allow DI&H to run the codes to validate if proper loinc codes were used for the lab. ( LOINCCODE: lab text) The data will get dispersed to number of different target domain, so all target domain table will need to be look at to see if there is place to store the original loinc and lab text values.

rtmill commented 4 years ago

The source LOINC code should already be stored in the field measurement_source_value. The field value_source_value is intended to store the result of the lab as it appears in the source. Are you seeing differently in the data?

stephanieshong commented 4 years ago

I was wondering about the loinc code and the lab text. We have a tool we can run and perform a double check.

kmkostka commented 4 years ago

The columns are capturing information as it is coded in the local source system. It's not a hardcoded choice.

stephanieshong commented 4 years ago

Got it. Thank you.