opensafely-core / cohort-extractor

Cohort extractor tool which can generate dummy data, or real data against OpenSAFELY-compliant research databases
Other
38 stars 13 forks source link

EMIS BMI query uses (we think) incorrect codes #479

Open evansd opened 3 years ago

evansd commented 3 years ago

From comparing the CTV3 and SNOMED codes in TPP, we think the correct codes to use for the BMI query are:

Code Description
27113001 Body weight
248333004 Standing height
60621009 Body mass index

This would explain why the results are currently mostly NULL.

Relevant code is here: https://github.com/opensafely-core/cohort-extractor/blob/7f242dc3691b56ef51451d0c7c9bc1ec07bf1acb/cohortextractor/emis_backend.py#L362-L377

evansd commented 3 years ago

FAO @inglesp

HelenCEBM commented 3 years ago

In the meantime it's possible to query BMI in EMIS in other ways: https://github.com/opensafely/covid19-vaccine-coverage-tpp-emis/blob/70b041d295c4ccdb80f23009206d080a7dab74b4/analysis/study_definition.py#L201-L235