Skip Navigation Bar
NLM logo

Unified Medical Language System® (UMLS®)

Multum MediSource Lexicon (MMSL) Source Information

Click on a topic below the Source Synopsis section to display details.

Source Synopsis

Web site:
https://www.cerner.com/solutions/drug-database

Authority
Multum MediSource Lexicon is produced by Cerner Corporation.

Purpose
The Lexicon is used to improve patient safety when drugs are prescribed.

Description
The Lexicon is a foundational database with comprehensive drug product and disease nomenclature information. It includes drug names, drug product information, disease names, coding systems such as ICD-9-CM and NDC, generic names, brand names and common abbreviations. A comprehensive list of standard or customized disease names and ICD-9 codes is also included.

RxNorm Scope
The RxNorm representation of the Lexicon includes only branded clinical drugs, generic clinical drugs, ingredients, medical supplies, and brand names.

Audience
The Lexicon is used by physicians, hospitals, pharmacies, health insurance plans, government, and consumers.

Update Frequency
The Lexicon is updated monthly.

RxNorm Update Frequency
The Lexicon is updated in each RxNorm monthly release.

Sites Consulted

Multum [Internet]. Denver (CO): Cerner Corporation. Solutions; [cited 2018 March 21]. Available from: https://www.cerner.com/solutions/drug-database

Metadata

Field Value
Short NameMultum
FamilyMMSL
Source Restriction Level1
LanguageENG
License ContactMultum Information Services
3200 Cherry Creek South Drive, Suite 300
Denver
CO
United States
80209
888-633-4772 x1420
http://www.multum.com/
Content ContactMultum Information Services
3200 Cherry Creek South Drive, Suite 300
Denver
CO
United States
80209
888-633-4772 x1420
http://www.multum.com/

Source Representation

This section lists specific source data elements and provides information on their representation in RxNorm.

Summary of Changes

There are no changes to the original data format or to the data representation since last month's release.

Source Provided Files: Summary

The files are downloaded from: https://multumdc.cernerworks.com

The following files are used to process Multum in RxNorm:

File Name Description
ms_categories This table contains the descriptions for a more specific categorization of medical supplies.
ms_ndc_core_description Contains a listing of information about specific National Drug Code (NDC)-labeled medical items.
multum_combination_drug Contains a listing of all clinically active ingredients for multi-ingredient (combination) drugs using the Multum drug_id.
multum_dose_form Contains a listing of dose forms (cream, tablet, suppository, etc.), along with an abbreviation and a unique identifier for each dose form.
multum_drug_id Contains a listing of Multum's unique generic drug identifiers, as well as a clinically accurate name for the product.
multum_product_strength Contains a textual list of product strengths designed for end user display (25 mg, 15mg/5ml, 5%, etc.) and a unique identifier for each product strength.
multum_route Contains a listing of routes of administration (orally, topically, rectally, etc.) and a unique identifier for each route.
ndc_active_ingredient Provides the full salt/chemical name of all active ingredients of the drug product.
ndc_active_ingredient_list Identifies all active ingredients (and their individual strengths) in each group of drug products that shares the same Main Multum Drug Code (MMDC).
ndc_brand_name Contains a listing of brand names and a unique identifier for each name.
ndc_core_description Contains a listing of information about specific National Drug Code (NDC)-labeled products including the manufacturer, packaging information, and over-the-counter/prescription-only status.
ndc_main_multum_drug_code Contains a listing of all MMDCs — an important link to ancillary tables.
ndc_pregnancy_category Contains the U.S. Food and Drug Administration (FDA) pregnancy category to which a drug has been assigned.

Source-Provided Files: Details

The following is a list of fields in the Multum source files. Many data fields are not explicitly represented in RxNorm. In the RxNorm Representation column, "Not applicable" indicates fields not used; "Used internally" indicates fields used to cross-check data internally.

File Name: ms_categories
# Field Name Description RxNorm Representation
1 ms_category_id Medical supplies category identifier Used internally
2 ms_category_name Medical supplies category description RXNCONSO.STR where TTY=SC

RXNSAT.ATV where RXNSAT.ATN=TYPE for TTY=MS

File Name: ms_ndc_core_description
# Field Name Description RxNorm Representation
1 ms_ndc_code The National Drug Code (NDC) is the standard 11 digit identifier for each drug product, as recognized by Centers for Medicare & Medicaid Services (CMS), other federal and state agencies, and many commercial enterprises. Not applicable
2 ms_brand_description Contains drug names as they appear on the label of a medical supply RXNCONSO.STR for TTY=MS
3 ms_inner_package_size Represents the number of individual units present in the innermost packaging of a drug Not applicable
4 ms_inner_package_description Textual description of the packaging units Not applicable
5 ms_outer_package_size Designates the total number of inner packages present in the final packaged product Not applicable
6 ms_source_description The names of manufacturers, redistributors, and repackagers of the medical product Not applicable
7 ms_category Provides a general textual description of the medical supply type Not applicable
8 ms_category_id Assigns a more specific category to a medical supply Used internally

File Name: multum_combination_drug
# Field Name Description RxNorm Representation
1 drug_id Drug identifier of the combination drug Used internally
2 member_drug_id Drug identifier of the clinically active ingredients (which are, by definition, mono-ingredient drugs) Used internally

File Name: multum_dose_form
# Field Name Description RxNorm Representation
1 dose_form_code Unique identifier for each dose form Used internally
2 dose_form_abbr Abbreviation of dose form RXSAT.ATV where RXNSAT.ATN=DDFA
3 dose_form_description Dose form names RXSAT.ATV where RXNSAT.ATN=DDF

Also used to build CD and BD strings in RXNCONSO.STR

File Name: multum_drug_id
# Field Name Description RxNorm Representation
1 drug_id Multum's identification codes for generic drugs RXNCONSO.CODE for TTY=GN
2 drug_name Clinically accurate name for the product RXNCONSO.STR for TTY=GN

Also used to build CD string in RXNCONSO.STR

File Name: multum_product_strength
# Field Name Description RxNorm Representation
1 product_strength_code Unique identifier for each product strength Used internally
2 product_strength_description Product strength description designed for end user display RXNSAT.ATV when RXNSAT.ATN=DST

Also used to build CD and BD strings in RXNCONSO.STR

File Name: multum_route
# Field Name Description RxNorm Representation
1 route_code Unique identifier for each route Used internally
2 route_abbr Abbreviations for the various routes of administration RXNSAT.ATV when RXNSAT.ATN=DRTA
3 route_description Routes of administration descriptive name RXNSAT.ATV when RXNSAT.ATN=DRT

Also used to build CD and BD strings in RXNCONSO.STR

File Name: ndc_active_ingredient
# Field Name Description RxNorm Representation
1 active_ingredient_code Unique identifier for full salt/chemical name of all active ingredients RXNCONSO.CODE for TTY=IN
2 active_ingredient Full salt/chemical name of all active ingredients of the drug product RXNCONSO.STR for TTY=IN

File Name: ndc_active_ingredient_list
# Field Name Description RxNorm Representation
1 main_multum_drug_code The Main Multum Drug Code (MMDC) is Multum's designator for groups of similar drug products. The MMDC serves as the primary link to all of Multum's tables containing drug product information. Used internally
2 active_ingredient_code Unique code for each active ingredient Used internally
3 ingredient_strength_code Unique code for each ingredient strength Not applicable

File Name: ndc_brand_name
# Field Name Description RxNorm Representation
1 brand_code Unique code for each brand name RXNCONSO.CODE for TTY=BN
2 brand_description Drug names as they appear on labels of drug products RXNCONSO.STR for TTY=BN

Also used to build TTY=BD string in RXNCONSO.STR

File Name: ndc_core_description
# Field Name Description RxNorm Representation
1 ndc_code The National Drug Code is the standard 11-digit identifier for each drug product, as recognized by CMS, other federal and state agencies, and many commercial enterprises. It is unique to each specific product. RXNSAT.ATV where RXNSAT.ATN=NDC for TTY=BD
2 main_multum_drug_code The Main Multum Drug Code (MMDC) is Multum's designator for groups of similar drug products. The MMDC serves as the primary link to all of Multum's tables containing drug product information. Used internally
3 brand_code This field contains a unique code for each brand name. Used internally
4 otc_status This field designates whether a product is available by prescription only (Rx) or if it is available over-the-counter (OTC). Not applicable
5 inner_package_size This field represents the number of individual units present in the innermost packaging of a drug. Not applicable
6 inner_package_desc_code This field contains a code that represents units that describe the package size. Not all drug products require a package unit description for a complete representation of the packaging. Not applicable
7 outer_package_size This field designates the total number of inner packages present in the final packaged product. Not all drug products require an outer package size for a complete representation of the packaging. (The package unit may suffice.) Not applicable
8 obsolete_date This field contains data only if a drug product is no longer manufactured. It will contain the date when the product became obsolete. Used internally
9 source_id This field contains a unique code for each drug source (manufacturer/redistributor). Not applicable
10 orange_book_id This field contains a unique code for each Orange Book code. Not applicable
11 unit_dose_code This one character designation indicates if the product is supplied in unit dose packaging. Not applicable
12 repackaged This field indicates whether the original product has been repackaged by another drug vendor. Not applicable
13 gbo This field designates the product's status as a brand name product or a generic product based on Multum's internal editorial rules and cost algorithms. Not applicable

File Name: ndc_main_multum_drug_code
# Field Name Description RxNorm Representation
1 main_multum_drug_code The Main Multum Drug Code (MMDC) is Multum's designator for groups of similar drug products. This is an extremely important code for developers who are using Multum's database products because it serves as the primary link to all of Multum's tables containing drug product information.

An MMDC is assigned to each unique combination of the following fields: active ingredient(s), strength, route of administration, and dosage form. As a result, the MMDC is a very useful field for identifying drug products that share these same four important characteristics.
RXNCONSO.CODE for TTY=CD/BD
2 principal_route_code Contains a code for the principal (or most common) route of administration for a specific drug (MMDC). Used internally
3 dose_form_code This field contains a numeric designation for a dose form. Used internally
4 product_strength_code This field contains a unique code for each product strength description. Used internally
5 drug_id This field contains Multum's identification codes for generic drugs. Used internally
6 csa_schedule This field describes the drug class assigned to a specific product type (MMDC) under the Controlled Substances Act of 1970. RXNSAT.ATV where RXNSAT.ATN=DCSA
7 j_code This is Multum's designation for the Health Care Common Procedure Code (J-Code) used for submitting claims to insurance organizations. RXNSAT.ATV where RXNSAT.ATN= DHJC
8 j_code_description This field contains the full text of the Health Care Common Procedures Billing Code Description Not applicable

File Name: ndc_pregnancy_category
# Field Name Description RxNorm Representation
1 drug_id Unique identifier of a drug Used internally
2 pregnancy_category Pregnancy category assigned by the FDA RXNSAT.ATV where RXNSAT.ATN=DPC

RxNorm Representation

This section lists RxNorm data elements and traces them back to the specific Multum data that populates them.

Summary of Changes

There are no changes to the original data format or to RxNorm source processing since the last monthly release.

Source Provided Files:

The files are downloaded from: https://multumdc.cernerworks.com

RxNorm uses the following files:

File Name Description
ms_categories This table contains the descriptions for a more specific categorization of medical supplies.
ms_ndc_core_description Contains a listing of information about specific National Drug Code (NDC)-labeled medical items.
multum_combination_drug Contains a listing of all clinically active ingredients for multi-ingredient (combination) drugs using the Multum drug_id.
multum_dose_form Contains a listing of dose forms (cream, tablet, suppository, etc.), along with an abbreviation and a unique identifier for each dose form.
multum_drug_id Contains a listing of Multum's unique generic drug identifiers, as well as a clinically accurate name for the product.
multum_product_strength Contains a textual list of product strengths designed for end user display (25 mg, 15mg/5ml, 5%, etc.) and a unique identifier for each product strength.
multum_route Contains a listing of routes of administration (orally, topically, rectally, etc.) and a unique identifier for each route.
ndc_active_ingredient Provides the full salt/chemical name of all active ingredients of the drug product.
ndc_active_ingredient_list Identifies all active ingredients (and their individual strengths) in each group of drug products that shares the same Main Multum Drug Code (MMDC).
ndc_brand_name Contains a listing of brand names and a unique identifier for each name.
ndc_core_description Contains a listing of information about specific National Drug Code (NDC)-labeled products including the manufacturer, packaging information, and over-the-counter/prescription-only status.
ndc_main_multum_drug_code Contains a listing of all MMDCs — an important link to ancillary tables.
ndc_pregnancy_category Contains the U.S. Food and Drug Administration (FDA) pregnancy category to which a drug has been assigned.

RxNorm Identifiers:

Identifiers are assigned as follows:

Identifier Origin
CODE NOCODE where TTY=SC/MS;
ndc_active_ingredient. active_ingredient_code for TTY=IN;
multum_drug_id.drug_id for TTY=GN;
ndc_brand_name.brand_code for TTY=BN;
ndc_main_multum_drug_code.main_multum_drug_code for TTY=BD/CD
SAUI Not Applicable
SCUI Not Applicable
SDUI Not Applicable

Atoms (RXNCONSO):

Term Type Origin
CD CODE=ndc_main_multum_drug_code.main_multum_drug_code

Multum’s clinical drug name is expressed as Generic Name + Strength + Route + Dose Form.

STR=
multum_drug_id.drug_name (Generic Name)
multum_product_strength.product_strength_description (Strength)
multum_route.route_description (Route)
multum_dose_form.dose_form_description (Dose Form)

Example:
rilpivirine 25 mg Oral Tablet
rilpivirine (Generic Name) 25 mg (Strength) Oral (Route) Tablet (Dose Form)
BD CODE=ndc_main_multum_drug_code.main_multum_drug_code

Multum’s branded drug name is expressed as Brand Description + Strength + Route + Dose Form.

STR=
ndc_brand_name.brand_description (Brand Description)
multum_product_strength.product_strength_description (Strength)
multum_route.route_description (Route)
multum_dose_form.dose_form_description (Dose Form)

Example:
Lohist, 1 mg-2.5 mg/5 mL oral liquid
Lohist (Brand Description) 1 mg-2.5 mg/5 mL (Strength) oral (Route) liquid (Dose Form)
IN CODE=ndc_active_ingredient.active_ingredient_code

Multum’s ingredient is a simple description of the generic chemical name of the drug. One drug can be associated with any number of ingredients.

Example: rilpivirine
STR=ndc_active_ingredient.active_ingredient
BN CODE=ndc_brand_name.brand_code
STR=ndc_brand_name.brand_description
GN CODE=multum_drug_id.drug_id
STR=multum_drug_id.drug_name
MS CODE=NOCODE
STR=ms_ndc_core_description.ms_brand_description
SC CODE=NOCODE
STR=ms_categories.ms_category_name
MTH_RXN_BD (RxNorm created atom) If original source atom has more than one NDC and the NDCs have different meanings, the atom is duplicated. Duplicate MTH_RXN_BD atoms are created and the original atom is called a Base atom.*

CODE=Same as original or Base atom
STR=Same as original with a suffix

Example:
Base atom:
Tobramycin 28 MG Inhalation Capsule [TOBI PODHALER]

Duplicate atoms:
Tobramycin 28 MG Inhalation Capsule [TOBI PODHALER]_#1
Tobramycin 28 MG Inhalation Capsule [TOBI PODHALER]_#2
Tobramycin 28 MG Inhalation Capsule [TOBI PODHALER]_#3
*For more information about Base atoms, go to 9.0 Duplicating Source Asserted Atoms (to resolve NDC conflicts)

Relationships (RXNREL):

Clinical Drug (TTY = CD):

Atom Type 1 Atom Type 2 Relationship Origin
Clinical Drug (CD) Ingredient (IN) has_ingredient ndc_active_ingredient_list.main_multum_drug_code = ndc_main_multum_drug_code.main_multum_drug_code
Clinical Drug (CD) Generic Ingredient (GN) has_ingredient ndc_main_multum_drug_code.drug_id = multum_drug_id.drug_id

Branded Drug (TTY = BD):

Atom Type 1 Atom Type 2 Relationship Origin
Branded Drug (BD) Ingredient (IN) has_ingredient ndc_active_ingredient_list.main_multum_drug_code = ndc_core_description.main_multum_drug_code
Branded Drug (BD) Brand Name (BN) has_ingredient ndc_core_description.brand_code = ndc_brand_name.brand_code

Brand Name (TTY = BN):

Atom Type 1 Atom Type 2 Relationship Origin
Brand Name (BN) Branded Drug (BD) ingredient_of ndc_core_description.brand_code = ndc_brand_name.brand_code

Generic Ingredient (GN):

Atom Type 1 Atom Type 2 Relationship Origin
Generic Ingredient (GN) Clinical Drug (CD) ingredient_of ndc_main_multum_drug_code.drug_id = multum_drug_id.drug_id
Generic Ingredient (GN) Generic Ingredient (GN) contains multum_combination_drug.drug_id = multum_drug_id.drug_id

Ingredient (TTY = IN):

Atom Type 1 Atom Type 2 Relationship Origin
Ingredient (IN) Branded Drug (BD) ingredient_of ndc_active_ingredient_list.main_multum_drug_code = ndc_core_description.main_multum_drug_code
Ingredient (IN) Clinical Drug (CD) ingredient_of ndc_active_ingredient_list.main_multum_drug_code = ndc_main_multum_drug_code.main_multum_drug_code

Medical Supply (TTY = MS):

Atom Type 1 Atom Type 2 Relationship Origin
Medical Supply (MS) Specific Categorization of Medical Supply (SC) isa ms_categories.ms_category_id = ms_ndc_core_description.ms_category_id

Specific Categorization of Medical Supply (TTY = SC):

Atom Type 1 Atom Type 2 Relationship Origin
Specific Categorization of Medical Supply (SC) Medical Supply (MS) inverse_isa ms_categories.ms_category_id = ms_ndc_core_description.ms_category_id


Attributes (RXNSAT):

Attribute Name (ATN) Term Type (TTY) Origin
DCSA CD, BD ndc_main_multum_drug_code.csa_schedule
DDF CD, BD multum_dose_form.dose_form_description
DDFA CD, BD multum_dose_form.dose_form_abbr
DHJC CD, BD ndc_main_multum_drug_code.j_code
DPC GN ndc_pregnancy_category.pregnancy_category
DRT CD, BD multum_route.route_description
DRTA CD, BD multum_route.route_abbr
DST CD, BD multum_product_strength.product_strength_description
NDC BD ndc_core_description.ndc_code
TYPE MS ms_categories.ms_category_name

Data Examples with Sample Database Queries

This section lists source terminology specific data examples and sample database queries using Structured Query Language (SQL) to obtain the data. For more information about RxNorm data and files, see the RxNorm Technical Documentation.

Names and Codes in RXNCONSO.RRF

Here are sample source terminology code, source string, RxNorm Concept Unique Identifier (RXCUI), RxNorm string, term type (TTY), and suppress values.

SOURCE_CODE SOURCE_STR RXCUI RXNORM_STR RXNORM_TTY SUPPRESS
2065 Motrin IB, 200 mg oral tablet 201126 Ibuprofen 200 MG Oral Tablet [Motrin] SBD N
2065 Motrin Migraine Pain, 200 mg oral tablet 201126 Ibuprofen 200 MG Oral Tablet [Motrin] SBD N
2065 Menadol, 200 mg oral tablet 206890 Ibuprofen 200 MG Oral Tablet [Menadol] SBD O
2065 Ibu-Tab, 200 mg oral tablet 206889 Ibuprofen 200 MG Oral Tablet [Ibu-Tab] SBD O

Here is a sample database query to retrieve the data above:

SELECT distinct rc1.code as source_code, rc1.str as source_str, rc1.rxcui, rc2.str as rxnorm_str, rc2.tty as rxnorm_tty , rc2.suppress
FROM rxnconso rc1, rxnconso rc2
WHERE rc1.code = '2065'
     AND rc1.sab = 'MMSL'
     AND rc1.rxcui = rc2.rxcui
     AND rc2.sab = 'RXNORM'
     AND rc2.tty in ('SCD','SBD','GPCK','BPCK');

Names and Relationships in RXNCONSO.RRF and RXNREL.RRF

Here are sample source terminology code, source string, RXCUI, relationship name, RxNorm term type (TTY), RxNorm brand name, and suppress values.

SOURCE_CODE SOURCE_STR RXCUI RELA RXNORM_TTY RXNORM_BN SUPPRESS
4862 ibuprofen 5640 has_tradename BN Ultraprin N
4862 ibuprofen 5640 has_tradename BN Xylon N
4862 ibuprofen 5640 has_tradename BN Ibudone N
4862 ibuprofen 5640 has_tradename BN PediaCare Children's Pain & Fever w/ Ibuprofen N

Here is a sample database query to retrieve the data above:

SELECT distinct rc1.code as source_code, rc1.str as source_str, rc1.rxcui, rr.rela, rc2.tty as rxnorm_tty, rc2.str as rxnorm_bn, rc2.suppress
FROM rxnconso rc1, rxnrel rr, rxnconso rc2
WHERE rc1.code = '4862'
     AND rc1.sab = 'MMSL'
     AND rc1.rxcui = rr.rxcui2
     AND rr.rela = 'has_tradename'
     AND rr.rxcui1 = rc2.rxcui
     AND rc2.sab = 'RXNORM'
     AND rc2.tty = 'BN'
     ORDER BY suppress;

National Drug Code (NDC) and Names in RXNSAT.RRF and RXNCONSO.RRF

Here are sample source NDC, RXCUI, TTY, RxNorm string, and suppress values.

NDC RXCUI RXNORM_TTY RXNORM_STR SUPPRESS
00363039215 310965 SCD Ibuprofen 200 MG Oral Tablet N
00363039320 310965 SCD Ibuprofen 200 MG Oral Tablet N
00927007001 310965 SCD Ibuprofen 200 MG Oral Tablet N
24385060478 310965 SCD Ibuprofen 200 MG Oral Tablet N

Here is a sample database query to retrieve the data above:

SELECT distinct rs.atv as ndc, rs.rxcui, rc.tty as rxnorm_tty, rc.str as rxnorm_str, rs.suppress
FROM rxnsat rs, rxnconso rc
WHERE rs.atn = 'NDC'
     AND rs.sab = 'MMSL'
     AND rs.rxcui = rc.rxcui
     AND rc.sab = 'RXNORM'
     AND rc.tty in ('SCD','SBD','GPCK','BPCK')
     AND rc.rxcui = '310965'
     ORDER BY suppress;

Last Reviewed: March 31, 2020