OHDSI Home | Forums | Wiki | Github

Measurement VALUE_AS_NUMBER negative results


I have bumped into an issue while trying to record the numeric measurement results for Height-for-Age Z Score (HAZ), BMI-for-Age Z Score and Weight-for-Age Z Score (WAZ) (from Athena e.g. Athena). These measurement results can contain negative values, as the result is expressed as a positive value or a negative value depending on whether the value is greater than or less than the median. So when the Z Score of an individual measure is 0 (zero), it means that it is equal to the median, but when it’s negative, it means e.g. that the individuals weight is less than median.

In the description of VALUE_AS_NUMBER it says: "If there is a negative value coming from the source, set the VALUE_AS_NUMBER to NULL, with the exception of the following Measurements (listed as LOINC codes): ". This would mean that the negative Z Score results could not be recorded at all in OMOP CDM as they should be set to NULL. Could it be possible to add these kind of measurements to the approved “exceptions” so that also the numeric values could be recorded and preserved, or how should we proceed with recording these measurements in OMOP CDM?

Thank you for the help and best regards,

No, set them to negative. Usually, measurements are positive, with few exceptions. In order to keep up the quality we tell ETLers to block the negative results, e.g., for glucose in blood. They are used in many source data to indicate a lost sample, or a withdrawn prior result, or such things. We don’t want that. But in your case the negative values are legit. We should make the text clarify that better.


Tagged as a Themis issue.