OHDSI Home | Forums | Wiki | Github

Source values in my measurements dataset '<0.006'

Hello everyone!
I’m now implementing my first ETL and I’m currently making the measurement_table. In my source dataset, I have some examination results where the value of the result is stored like this: ‘<0.006’.
How do you suggest storing this information in the value_as_number_field?

Verify the operator_concept_id of the MEASUREMENT table. That is applied to the value_as_number. Operators are <, ≤, =, ≥, and >.

1 Like

So,you mean that in the operator_concept_id field i put the concept_id of < and in the value_as_number field i store the value 0.006. Right?

Correct. The concept_id of less sign is 4171756.