Is there any documentation available on the types of relationship_ids available in the CONCEPT_RELATIONSHIP table? What they mean, How they are maintained? Etc? My use case is finding the ‘RxNorm has dose form’ for NDC drugs by first mapping them to their standard concept. This appears to be fairly well populated. I’m interested in knowing if CONCEPT_RELATIONSHIP can be leveraged for other types of information.
SELECT C.*
, FRM.CONCEPT_NAME
FROM CONCEPT C
LEFT JOIN CONCEPT_RELATIONSHIP SC ON SC.CONCEPT_ID_1 = C.CONCEPT_ID AND SC.RELATIONSHIP_ID = ‘Maps to’
LEFT JOIN CONCEPT_RELATIONSHIP F ON F.CONCEPT_ID_1 = SC.CONCEPT_ID_2 AND F.RELATIONSHIP_ID = ‘RxNorm has dose form’
LEFT JOIN CONCEPT FRM ON FRM.CONCEPT_ID = F.CONCEPT_ID_2
WHERE C.VOCABULARY_ID = ‘NDC’
AND C.CONCEPT_CLASS_ID = ‘11-digit NDC’
– 844,692
AND FRM.CONCEPT_ID IS NULL–142,886 NULL
;–1,139,578