OHDSI Home | Forums | Wiki | Github

Vocabulary v5: concept_relationship: Concept 'Maps to' itself?

CDM Builders
#1

Is it valid to have a concept_id ‘Maps to’ itself in the concept_relationship table? I see 1,225,120
records out of 12,034,278.

EG
4339466 4339466 Maps to 1970-01-01 2099-12-31
4339490 4339490 Maps to 1970-01-01 2099-12-31
4339493 4339493 Maps to 1970-01-01 2099-12-31
4339497 4339497 Maps to 1970-01-01 2099-12-31
4339597 4339597 Maps to 1970-01-01 2099-12-31

Thanks,
Don

#2

Yes. A valid Standard Concept will map to itself. So, when you ETL, you find a Concept from your source code. In order to know what Concept to write. You take all (fresh) relationships “Mpas to” and write the resulting Concepts into the concept_id field. If the Concept was already a Standard one, it will have mapped to itself, and you right that one. If not, it will map to something else, which you should write. Makes sense?

#3

I see that concept_id=44814718 “Enrollment by geography” maps to the concept_id=44814723 “Period while enrolled in the study.” Is this correct?

#4

In the concept_relationship table “Enrollment by geography” (concept_id=44814718) maps to “Period while enrolled in the study” (concept_id=44814723). Is this correct?

t