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,