RxNorm Prescription Drugs Relationships between Concepts and Atoms

$716 / year

This dataset contains all of the relationships that exist between atoms and between concepts for currently prescribable drugs. 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.

This dataset is a subset of currently prescribable drugs found in RxNorm. NLM intends it to be an approximation of the prescription drugs currently marketed in the US. The subset also includes some frequently-prescribed over-the-counter drugs.

The subset includes only the active RxNorm normalized names, codes (RxCUIs), attributes, and relationships, as well as the FDA structured product label drugs and ingredients and the small set of CMS data. It does not include data from any of the other 14 RxNorm data providers, such as First DataBank, Micromedex, or the Veterans Administration. NLM also removed suppressed and obsolete data SAB=RXNORM.

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-09-03

Version

2019-09

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

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

Other Titles

Currently Prescribable Related Concepts and Atoms, Related Concepts Analytics, Related Atoms Analytics

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
710074AUISY3284850AUIRXNORM4096
710166AUISY710164AUIRXNORM4096
710393AUISY3263617AUIRXNORM4096
710397AUISY3263647AUIRXNORM4096
710567AUISY2944829AUIRXNORM4096
711231AUISY711228AUIRXNORM4096
711235AUISY711232AUIRXNORM4096
713495AUISY3866140AUIRXNORM4096
713677AUISY713674AUIRXNORM4096
713681AUISY713678AUIRXNORM4096