Just updating this thread with the most current recommendation. If you have ideas or more items for the exception list let us know!
Only allow values for negative measurements (see list below). If you have negative values for positive measurements, then set it to NULL.
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
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