RxNorm Relationships between Concepts and Atoms

$716 / year

This dataset contains all of the relationships that exist between atoms and between concepts. This includes source-provided relationships and relationships between RXNORM source-provided drug names.

Complexity

RxNorm provides normalized names for clinical drugs and links its names to many of the drug vocabularies commonly used in pharmacy management and drug interaction software, including those of First Databank, Micromedex, MediSpan, Gold Standard Drug Database, and Multum. By providing links between these vocabularies, RxNorm can mediate messages between systems not using the same software and vocabulary.

RXNORM provided relationships exist between atoms and between concepts, while source-provided relationships only exist between atoms from that source.

Relationships in this dataset connect RXAtom_AUI_IDs or RXConcept_CUI_IDs. The corresponding drug names for these RXAtom_AUI_IDs and RXConcept_CUI_IDs are found in “RxNorm Drugs Names and Identifiers” dataset.

For asymmetrical relationships there is one row for each direction of the relationship.

Direction of relationship: the relationship which the SECOND concept or atom (with RXConcept2_CUI_ID and RXAtom2_AUI_ID) HAS TO the FIRST concept or atom (with RXConcept1_CUI_ID and RXAtom1_AUI_ID).

A relationship will exist between the base atom and its duplicate atoms with “includes” and “included_in” (Relationship_Attribute_RELA). This relationship will carry the Source_Abbreviation=RXNORM.

Specified (with quantity factor) and unspecified (without quantity factor) versions of extended release products are connected by the “has_quantified_form” and “quantified_form_of” reciprocal relationship attributes (Relationship_attribute_RELA)

Date Created

2004-11

Last Modified

2020-04-06

Version

2020-04

Update Frequency

Monthly

Temporal Coverage

N/A

Spatial Coverage

United States

Source

John Snow Labs; National Library of Medicine (NLM);

Source License URL

Source License Requirements

Reporting Requirements

Source Citation

N/A

Keywords

RxNorm Normalized Names, Source Vocabulary Attributes, RxNorm Data History, Drug Vocabulary Links, RxNorm Software Vocabulary, RxNorm Database, Common Drug Vocabularies, Currently Prescribable Drugs, Source Provided Relationships, RXNREL

Other Titles

Related Concepts And Atoms For Each Source Provider, Related Concepts Analytics, Related Atoms Analytics, Current Prescribable Content Subset

NameDescriptionTypeConstraints
RXConcept1_CUIUnique identifier of first conceptstringmaxLength : 8
RXAtom1_AUIUnique identifier for first atomstringmaxLength : 8
Relation_Source1_Type_STYPE1The name of the column in “RxNorm Drugs Names and Identifiers” that contains the identifier used for the first concept or first atom in source of the relationship (e.g., 'AUI' or 'CUI').stringmaxLength : 50
Relationship_Code_RELRelationship code of second concept or atom to first concept or atomstringmaxLength : 4
RXConcept2_CUIUnique identifier of second conceptstringmaxLength : 8
RXAtom2_AUIUnique identifier for second atomstringmaxLength : 8
Relation_Source2_Type_STYPE2The name of the column in “RxNorm Drugs Names and Identifiers” that contains the identifier used for the first concept or first atom in source of the relationship (e.g., 'AUI' or 'CUI').stringmaxLength : 50
Relationship_Attribute_RELAAdditional (more specific) relationship labelstringmaxLength : 100
Relationship_RUIUnique identifier for relationshipstringmaxLength : 10
Source_Asserted_Relationship_SRUISource asserted relationship identifier, if presentstringmaxLength : 50
Source_AbbreviationSource abbreviationstringrequired : 1 maxLength : 20
Source_of_Relationship_TextSource of relationship labelsstringmaxLength : 1000
Source_Asserted_DirectionSource asserted directionality flag.numberlevel : Nominal
Machine_Generated_RGMachine generated and unverified indicatorstringmaxLength : 10
Suppressible_Flag_SUPPRESSSuppressible flag.stringenum : Array maxLength : 1
Content_View_FlagContent view flag. RxNorm includes one value, '4096', to denote inclusion in the Current Prescribable Content subset.stringmaxLength : 50
RXConcept1 CUIRXAtom1 AUIRelation Source1 Type STYPE1Relationship Code RELRXConcept2 CUIRXAtom2 AUIRelation Source2 Type STYPE2Relationship Attribute RELARelationship RUISource Asserted Relationship SRUISource AbbreviationSource of Relationship TextSource Asserted DirectionMachine Generated RGSuppressible Flag SUPPRESSContent View Flag
5AUISY6AUIpermuted_term_of155592245MSH
5SDUISIB104746SDUI154524204MSH
5SDUIRN609702SDUImapped_to154691227MSH1.0
5AUISY2666961AUIsort_version_of155371534MSH
5AUISY2681015AUIentry_version_of155054914MSH
5SDUISIB2745151SDUI155497941MSH
6AUISY5AUIhas_permuted_term154688723MSH
8AUISY8199098AUIhas_permuted_term155465282MSH
10AUISY7860018AUIhas_permuted_term154667876MSH
19AUISY8142157AUIhas_permuted_term155372711MSH