How to store a lab test range result in Measurement table

[jiawei-qian]

How to store a lab test range result in Measurement table

CDM or THEMIS convention?

THEMIS

Table or Field level?

Field

Is this a general convention?

No

Summary of issues

1. Some lab test result (such as: Urine WBC Count) is not a number but a range, e.g. 20-50/HPF. The measurement table has 2 fields to hold lab test results: value_as_number and value_as_concept_id. Don't know how this range result can store in Measurement table.
2. Some people asked if we can create 2 new fields to store actual range results or reuse current range_low/range_high fields.

Summary of answer

1. Measurement table cannot store range results now. After hot discussion in OHDSI Forum, Christian said he suggests to use the average value of the range (middle of the range) into value_as_number field. In this example, can store 35 into value_as_number field.

Related links

OHDSI Forum: https://forums.ohdsi.org/t/how-to-implement-a-lab-test-range-result-in-measurement-table/5221/24

[MelaniePhilofsky]

This is not a ratified convention. I will move it to the "Needs more work" column.