Why is there no value_source_value column in Observation? Like there is in Measurement? We have a use case where we need to track the provenance from the source system of entries in the value_ columns in the Observation table. Like we can in the Measurement table. Is this simply an oversight?
Hello @mgurley, I would bet the keepers of the OMOP CDM would say that the column
observation.value_as_string is intended for this purpose.
But you’re correct that there aren’t columns
observation.value_as_source_concept_id as the usual expected companions to the
Don’t go into the betting game, @quinnt. That field really gives you a verbatim value of the result. I am not happy with that field. We should have no verbatim fields, except in NOTE. Every verbatim field is prone to re-identification.