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

2019-11-04

Version

2019-11

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_of149946913MSH
5SDUISIB104746SDUI148885384MSH
5SDUIRN609702SDUImapped_to149051238MSH1.0
5AUISY2666961AUIsort_version_of149727475MSH
5AUISY2681015AUIentry_version_of149412702MSH
5SDUISIB2745151SDUI149853144MSH
6AUISY5AUIhas_permuted_term149048755MSH
8AUISY8199098AUIhas_permuted_term149820683MSH
10AUISY7860018AUIhas_permuted_term149028054MSH
19AUISY8142157AUIhas_permuted_term149728651MSH