Negative Integers in MEASUREMENTS #16
Description
| TYPE | NOTES |
|---|---|
| ITEM | What should be done with negative integers for MEASUREMENTS? |
| FORUM POST | http://forums.ohdsi.org/t/negative-values-in-lab-test-records/4012 |
| SOLUTION | Only allow values for negative measurements (see list below). If you have negative values for positive measurements, then set it to NULL. Negative Measurements 1925-7-Base excess in Arterial blood by calculation 1927-3-Base excess in Venous blood by calculation 8632-2 - QRS-Axis 11555-0 - Base excess in Blood by calculation 1926-5 - Base excess in Capillary blood by calculation 28638-5 - Base excess in Arterial cord blood by calculation 28639-3 - Base excess in Venous cord blood by calculation |
| NEXT STEPS | 1. Work to develop an exception list (e.g. 1925-7-Base excess in Arterial blood by calculation, RANGE: mmol.L:[-2,+2], https://s.details.loinc.org/LOINC/1925-7.html), 2. Update ACHILLES (@vojtechhuser) to do a warning on non-exempt tests that are negative. 3. Work with CDM WG to document both the exception list and above text in the VALUE_AS_NUMBER column. https://github.com/OHDSI/CommonDataModel/wiki/MEASUREMENT |