For rituximab, PubMedID=25130775 is tagged with the MeSH tag D000069283.
<MeshHeading>
<DescriptorName MajorTopicYN="N" UI="D000069283">Rituximab</DescriptorName>
<QualifierName MajorTopicYN="Y" UI="Q000009">adverse effects</QualifierName>
<QualifierName MajorTopicYN="N" UI="Q000627">therapeutic use</QualifierName>
</MeshHeading>
We are using the following query in the VOCAB to make the hop from MeSH to RxNorm:
SELECT A.CONCEPT_CODE source_concept_code, A.CONCEPT_NAME source_concept_name, B.CONCEPT_CODE concept_code, B.CONCEPT_NAME concept_name, B.CONCEPT_ID concept_id, B.CONCEPT_CLASS_ID concept_class_id
FROM CONCEPT A, CONCEPT B, CONCEPT_RELATIONSHIP CR
WHERE A.VOCABULARY_ID = 'MeSH' AND
CR.CONCEPT_ID_2 = A.CONCEPT_ID AND
B.CONCEPT_ID = CR.CONCEPT_ID_1 AND
B.VOCABULARY_ID = 'RxNorm' AND
CR.RELATIONSHIP_ID = 'Mapped from'
If you use this map in Vocab v20160311
, rituximab gets mapped to MeSH tag of C092560 not the D000069283 being used in PubMed. Thus we would not be able to take this PubMed article in LAERTES with the drug rituximab.
I’d like to understand this better what is going on here. Particularly if you understand the differences between C’ and D’ codes.