Ambiguity IndBrand NameDate ActivatedDate ObsoletedDose FormIngredientNDCOriginal CodeOriginal SourceOriginal Term TypePrescribable IndQtyRX AUIRX CUIRX NameStrengthUNII Code
| Business Data Model Data Model |
| Description | RxNorm is two things: a normalized naming system for generic and branded drugs; and a tool for supporting semantic interoperation between drug terminologies and pharmacy knowledge base systems. The National Library of Medicine (NLM) produces RxNorm. |
| Relationship | |
 RxNorm_Medication_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Ambiguity Ind
| Description | The attribute of the Atom that has been duplicated. The original Atom is Base. Duplicate atoms are Duplicate. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Brand Name
| Description | Represents brand names as seen on the packaging. In cases where the name on the packaging includes extra information that represents information beyond ingredient or strength. For example: Advair 115/21 Tylenol Cold Relief Zoloft |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Date Activated
| Description | The date when an Atom was reactivated from SUPPRESS=O to SUPPRESS=N. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Date Obsoleted
| Description | The date when an Atom was changed from SUPPRESS=N to SUPPRESS=O; Attribute of BPCK, GPCK, SBD, SCD, SBDC, SCDC, SBDF, SCDF, or DF Atom that has no source-asserted Atoms and no relationships to SUPPRESS=N Atoms. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Dose Form
| Description | The form of the drug dose. RxNorm uses a set of dose forms based upon those included in the Health Level 7 (HL7) data standard. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Ingredient
| Description | Ingredients generally use the United States Adopted Name (USAN). The Basis of Strength Substance (BoSS) is used in the fully normalized name (for example: warfarin sodium vs warfarin in 'Warfarin Sodium 1 MG Oral Tablet'). |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
NDC
| Description | National Drug Code (NDC) value normalized from source-asserted NDC. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Original Code
| Description | The source code (CODE) of the original source Atom from which RxNorm concept was created. This source code is only found in RXNSATOCD, except some DF and ET Atom attributes in RXNSAT, which are from HL7. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Original Source
| Description | The source abbreviation (SAB) of the original source Atom from which the RxNorm concept was created. This source abbreviation is only found in RXNSATOCD, except some DF and ET Atom attributes in RXNSAT, which are from HL7. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Original Term Type
| Description | The term type (TTY) of the original source Atom from which the RxNorm concept was created. This term type is only found in RXNSATOCD. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Prescribable Ind
| Description | An indicator that shows whether Atoms are included in the Current Prescribable Content subset. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Qty
| Description | Factors of time, measures or strength attributed to SCD and SBD Atoms. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
RX AUI
| Description | The unique identifier of the RxNorm Atom. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
RX CUI
| Description | The unique identifier of the RxNorm concept. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
RX Name
| Description | The normalized name for each RxNorm concept. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Strength
| Description | SAB=RXNORM bases the strength on the active ingredient(s), which may be either the precise (salt or ester) or the base ingredient of the drug. Strengths are expressed to three significant digits and use the 'milli' metric system equivalents (for example milligrams, milliliters). Liquids are expressed per milliliter. When a powder can be reconstituted to a range of liquid concentrations, the highest concentration in the range is used for the normalized form. |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
UNII Code
| Description | A Unique Ingredient Identifier (UNII) used by the US Food and Drug Administration (FDA). |
| Data Type | Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
RxNorm_Medication_FK
| Is Identifying Relationship | false |
| Child Table | RxNorm |
| Child Role Name | is referenced by |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Medication |
| Parent Role Name | references |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |