Clarity on what data needs to go in Observation table and Measurement table

[MPhilofsky (Melanie Philofsky)]

@kenith_Aiyappa

Incase of Labs which return textual data like - “Pale yellow” or “1-2 ph” where do we have to put these data ?
Is it in Observation or Measurement table ?

@kenith_Aiyappa

I am looking for more clarity on what data needs to go in Observation table and Measurement table ?

The table to put data is determined by the domain_id of the standard concept_id representing the source code. In general, labs belong in the Measurement table. If the result of the lab is a Float data type, it belongs in the value_as_number field, results that map to a concept_id go in the value_as_concept_id field, a string text value of 50 characters or less goes to the value_source_value field, and if you have a > 50 character result, then put the data in the Note table and link it to the measurement_id via the Fact Relationship table.

The Book of OHDSI is a very useful resource and it’s FREE! It explains the conventions. I highly suggest reading it

Also, If you have similar questions to this, you should put it in the CDM Builders forum thread. This is the research thread and your questions might go unanswered here since it is a build question.