search

OHDSI / Themis

Repository for OMOP CDM conventions as defined by THEMIS. These can be reference lists of concepts, pieces of standardized code for data generation or quality certification, and debates.
Apache License 2.0
28 stars 9 forks source link

How to store a lab test range result in Measurement table #140

Open jiawei-qian opened 6 months ago

jiawei-qian commented 6 months ago

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 commented 6 months ago

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

MelaniePhilofsky commented 1 month ago

@crabcakeworld,

This is originally your issue. Do you still have a use case?