OHDSI / CommonDataModel

Definition and DDLs for the OMOP Common Data Model (CDM)
https://ohdsi.github.io/CommonDataModel
892 stars 451 forks source link

Update Measurement.value_as_number guidance #532

Closed MelaniePhilofsky closed 1 month ago

MelaniePhilofsky commented 1 year ago

The Measurement.value_as_number guidance states "If there is a negative value coming from the source, set the VALUE_AS_NUMBER to NULL, with the exception of the following Measurement" and then lists 7 LOINC codes. However, Loinc code 18517-3, QRS axis, can be negative. There are probably other LOINC codes from EKG readings which can be negative since parts of an EKG can have negative values.

These data come across in EHR "Lab" tables.

ericaVoss commented 7 months ago

@MelaniePhilofsky - I added the QRS axis to the list but was successful in finding EKGs to include.

@aostropolets or @dimshitc does LOINC provide any information on which codes are allowed to have negative values? I'm looking for a more standardized way to identified measurements that allow negative values. You can see what I'm doing here: https://github.com/OHDSI/Themis/issues/16

clairblacketer commented 1 month ago

This was added to the THEMIS convention library and CDM documentation was updated accordingly