In The Book of OHDSI there are examples of records for the table Person and others, but not for the Measurement table. I am an OMOP noob and I need to convert patient data (in csv) to OMOP tables (ETL). I am having trouble converting lab test results (blood tests, urine tests, etc) into the Measurement table. Some examples, showing the test results and their correspondent records in the Measurement table, would be very helpful to me. For instance, how do I create Measurement records for the following results:
Full Haemogram: Hemoglobin 9.1 g/dl Reference values: 11.5 - 15.5 g/dl Lymphocyte 0.79 mil/mm³ Reference values: 20 - 45 % / 1.50 - 3.50 mil/mm³
Reference values can also appear just for one gender:
Women: Inferior to 31 U/L. How to encode them in this case?