First, dates. I see 1970-01-01 and 2099-12-31 as valid start date and valid end date for relationships respectively. Dates are also correct for concepts: Athena1 and Athena2
SELECT * FROM concept_relationship WHERE concept_id_1 = 4219637 AND relationship_id = 'Maps to';
SELECT * FROM concept_relationship WHERE concept_id_1 = 2615860 AND relationship_id = 'Maps to';
Now, changes of standard_concept status. Again, Snomed is in charge of these changes. They invalided concepts and we followed. You can check these concepts in any available Snomed Browser.
The tricky thing here is the reason for invalidation. Snomed doesn’t offer a replacement, because the Inactivation reason was Nonconformance to editorial policy component (quoting snomed, you can double check in any snomed browser).
For Ileostomy set you can see one Active possibly_equivalent_to inactive (SNOMED) link. But links of this type no longer serve as reasons to construct Maps to, because of their ambiguity.
Forgive me, but the dates from the first set (old vocabulary) are reasonable, but those from the second set, (updarted vocabulary,) are 1970-08-20 and 1970-08-31.
This led me to believe there was an error in the file.
Roger, we are both on AOU, therefore we should be on the same vocab, did you update again before they asked us to? I am getting the same results as Oleg.
SELECT * FROM dbo.concept c where c.concept_id IN (2615860,4219637);
SELECT
c1.* ,CR.RELATIONSHIP_ID ,c2.*
FROM SH_OMOP_DB_PROD.CDM.CONCEPT AS C1
INNER JOIN SH_OMOP_DB_PROD.CDM.CONCEPT_RELATIONSHIP AS CR
ON C1.CONCEPT_ID = CR.CONCEPT_ID_1
INNER JOIN SH_OMOP_DB_PROD.CDM.CONCEPT AS C2
ON C2.CONCEPT_ID = CR.CONCEPT_ID_2
WHERE C1.concept_id IN (4223561
,4219637
,2615860
,45761420
,45762654
,4225474
,45763083
,37396766
,4222511)
AND UPPER(CR.RELATIONSHIP_ID) IN (‘CONCEPT REPLACED BY’, ‘MAPS TO’)
Hi. I am a beginner and a nephrologist of South Korea. I am interested with device vocabulary for peritoneal dialysis(PD). Recently I have a struggle about searching concept Id about PD transfer set. Concept ID 45768371, 45761561 are Deprecated and validity ends 31-Jul-2021. what are new concept IDs mapped these concept IDs? Is tubing set same with transfer set? Hierachy and relationship aren’t there. Another question is what means dialysis access system? Please recommend me some contact points. Thanks a lot!
Hello, @11122. Unfortunately, concepts mentioned by you, do not have active equivalents. Tubing set You can use more general concept from SNOMED vocabulary Athena
In short, devices are the least standardized Domain in our vocabulary ecosystem. We usually just take what source vocabularies give to us in the Device domain and make them standard if they are valid in the source because it is impossible to standardize devices. Let’s say you have furosemide from Supplier A under Brand A1 and furosemide from Supplier B under Brand B1. It is still the same. But if you take the hemodialysis set from Supplier A, it is so much different from the hemodialysis set from Supplier B (coating, length, connectors, etc.)