I am trying to put all the medical data collected into CDM tables so that I can run patient level predictions.
So while in the process of writing ETL’s I have ended up in lot of confusions.
So CDM 5 onwards the ‘Measurement’ table was introduced. According to the documentation it says
“The MEASUREMENT table contains both orders and results of such Measurements as laboratory tests, vital signs, quantitative findings from pathology reports”
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 ?
Suppose we have data like -
How many cigarettes do you smoke per day ?
Ans: 20 to 30
Does this answer qualify to be put in Measurement table ?
“weight” in SNOMED is considered as an Observation but its measured as part of vitals which is numerical
value. So does this come under Observation or Measurement ??
I am looking for more clarity on what data needs to go in Observation table and Measurement table ?
Kindly help me out.
Thank you for your time,