Field	Value
Short Name	Multum
Family	MMSL
Source Restriction Level	1
Language	ENG
License Contact	Multum Information Services 3200 Cherry Creek South Drive, Suite 300 Denver CO United States 80209 888-633-4772 x1420 http://www.multum.com/
Content Contact	Multum Information Services 3200 Cherry Creek South Drive, Suite 300 Denver CO United States 80209 888-633-4772 x1420 http://www.multum.com/

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

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

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;