Can someone enlighten me why the same term depending on which codesystem is mapped to it would be transformed into Measurement Table or Observation Table?
Example: Urine Color (part of a Urinalysis panel lab order) reported as a lab result (LOINC encoded) and it’s value (Amber, Yellow, Red) which would be mapped in the US (per USCDI) to SNOMED CT Qualifier Value codes and ETL into OMOP Observation Table.
The same Urine color value of Amber, Red, Yellow, etc. if mapped to a LOINC Answer Code would ETL into OMOP Measurement Table.
(Also laboratory medicine does not make the distinctions of lab result into Measurement and Observation, but I realize others outside of laboratory medicine like to categorize results and their values as seen here into different tables. Hence the issue.)
Was there a reason OMOP decided to split the same item into 2 different tables? It seems if users are not aware, they can miss a portion of lab results with their queries/analyses. With multicenter studies, they’d have to query both not knowing how an individual site may have mapped this term to ensure it’s included in all cases.
Also given USCDI lists SNOMED CT Qualififer values as the codesystem standard for qualitative result values, it would be nice if they were in the same table as the results from which they originate. It would be nice if all lab results were in the same table too.
Thank you for helping me to understand the why behind this design.