OHDSI Home | Forums | Wiki | Github

Concept Invalid Reason is 'U', but no 'Concept Replace by' Relationship


(Don Torok) #1

Vocab v5.0 01-AUG-19
select * from concept where concept_id = 4232762;

concept_id concept_name domain_id vocabulary_id concept_class_id standard_concept concept_code valid_start_date valid_end_date invalid_reason
4232762 Closure of intestinocolonic fistula Procedure SNOMED Procedure 89646009 1970-01-01 2019-01-30 U

SELECT * from concept_relationship where concept_id_1 = 4232762;

concept_id_1 concept_id_2 relationship_id valid_start_date valid_end_date invalid_reason
4232762 4195720 Is a 2011-07-31 2099-12-31
4232762 4085962 Maps to 2019-01-31 2099-12-31
4232762 4085962 Concept poss_eq to 2019-01-31 2099-12-31
4232762 4043006 Has dir morph 2011-07-31 2099-12-31
4232762 4215634 Has dir proc site 2011-07-31 2099-12-31
4232762 4044539 Has method 2011-07-31 2099-12-31

(Christian Reich) #2

Thanks, @DTorok. This is a bug. Looks like SNOMED deprecated it and replaced it with - itself. That’s how it must have snuck through. Let’s find out.


(Christian Reich) #3

Forget what I said. Mixed up the two concepts (both ending in 62)

The replacement can be “Concept replaced by” or “Concept is possibly equivalent to”. That’s SNOMED notation. They either distinctly replace something, or they invalidate a concept and give us more of a probabilistic replacement.

So, all good.


t