search

EHDEN / ETL-UK-Biobank

ETL UK-Biobank
https://ehden.github.io/ETL-UK-Biobank/
12 stars 4 forks source link

Document ctv3 mapping strategy (extraction from NHS migration) #351

Open MaximMoinat opened 2 years ago

MaximMoinat commented 2 years ago

Together with Vaclav, I decided on some heuristics to decide which to choose:

  1. Take only 'preferred' terms and with an active mapping status (ctv3_termtype = 'P' and mapstatus = 1)
  2. Take only SNOMED codes that exist in OMOP vocabulary and are marked as Standard concept (vocabulary_id = 'SNOMED' and target.standard_concept = 'S')
  3. Then, look at the SNOMED domain and class. In general, prefer Measurement, then Condition, then Observation and lastly Procedure.