RxNorm Prescription Drugs Relationships between Concepts and Atoms

$395 / 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

2018-10-01

Version

2018-10-01

Update Frequency

Monthly

Temporal Coverage

N/A

Spatial Coverage

United States

Source

John Snow Labs => National Library of Medicine (NLM)

Source License URL

John Snow Labs Standard License

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

Name Description Type Constraints
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
3723582AUISY4655AUIRXNORM4096
9268832AUISY8011AUIRXNORM4096
9270342AUISY1684AUIRXNORM4096
9270343AUISY2332AUIRXNORM4096
9270634AUISY7824AUIRXNORM4096
9273919AUISY9557AUIRXNORM4096
710166AUISY710164AUIRXNORM4096
711231AUISY711228AUIRXNORM4096
711235AUISY711232AUIRXNORM4096
712358AUISY712356AUIRXNORM4096