OHDSI Home | Forums | Wiki | Github

Concept cannot be found in CONCEPT_ANCESTOR table

Vocabulary Users
#1

In this study: https://github.com/OHDSI/StudyProtocols/blob/master/Study%201%20-%20Treatment%20Pathways/R%20Version/HelperFunctions.R
the researchers use the following concept codes

    TxList <- '21600712,21500148'
    DxList <- '201820'

as ancestor_concept_id to find the corresponding descendent_concept_ids. But why I cannot find those concept ids in either CONCEPT_ANCESTOR or CONCEPT tables?

Also I found that I cannot find any ICD9 hierarchy in the CONCEPT_ANCESTOR table.

I am using CDMv5.

#2

@panCtrlV:

Not sure what you mean. Both

select * from concept where concept_id in (21600712, 21500148, 201820)

and

select * from concept_ancestor where ancestor_concept_id in (21600712, 21500148, 201820)

return plenty of records.

Because ICD9CM concepts are non-standard Concepts, and therefore do not particicpate in the hierarchy. Only their mapped SNOMED counterparts (like 201820 “Diabetes mellitus” for example) do.

t