Noiced that some SNOMED to ICD mapping are missing from the download of vocabularies.
Here are some examples:
Missing ICD code:
SOURCE: SNOMED - CONCEPT_CODE: 102447009 CONCEPT_ID: 4010333 (Postmenopausal osteoporosis)
- When compared in athena.ohdsi.org - I see ICD10 codes such as concept_code: M81.0 (concept_id: 45538882)
But I do not see this ICD10 code in the downloaded concepts.
Am I missing anything or else is there an issue with concepts that I have downloaded (a month ago) ?
Here is the query that I was running:
WITH CTE_VOCAB_MAP AS (
select conc1.vocabulary_id as SOURCE_VOCABULARY_ID, conc1.concept_id as SOURCE_CONCEPT_ID, conc1.concept_code as SOURCE_CONCEPT_CODE, conc2.vocabulary_id as TARGET_VOCABULARY_ID, conc2.concept_id as TARGET_CONCEPT_ID, conc2.concept_code as TARGET_CONCEPT_CODE
from concept conc1
inner join concept_relationship crel
on conc1.concept_id = crel.concept_id_1 and crel.relationship_id = ‘Mapped from’
inner JOIN concept conc2
ON crel.concept_id_2 = conc2.concept_id
)
SELECT *
FROM CTE_VOCAB_MAP
WHERE SOURCE_VOCABULARY_ID IN (‘SNOMED’)
and source_concept_code = ‘102447009’