Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Unified Medical Language System® (UMLS®)

Micromedex Source Information

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

Source Synopsis

Web site:
https://www.merative.com/documents/brief/micromedex-redbook-brochure

Authority
RED BOOK is product by Micromedex, a division of Merative.

Purpose
The purpose of RED BOOK is to allow comprehensive access to current and accurate drug pricing and description information.

Description
RED BOOK covers FDA-approved drug products. It includes prescription drugs, over-the-counter drugs, and nondrug products.

RxNorm Scope
The RxNorm representation of RED BOOK only contains information on branded clinical drugs and generic clinical drugs.

Update Frequency
RED BOOK is updated daily.

RxNorm Update Frequency
RED BOOK is updated in each RxNorm monthly release.

Metadata

Field Value
Short NameMicromedex
FamilyMMX
Source Restriction Level3
LanguageENG
License ContactMicromedex
100 Phoenix Drive
Ann Arbor
MI
United States
48108
(844) 637.2848
info@mdx.com
https://www.merative.com/documents/brief/micromedex-redbook-brochure
Content Contactproductsupport@merative.com, (877) 843-6796

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 RxNorm source processing since last month's release.

Source Provided Files: Summary

The files are downloaded from: https://downloads.micromedex.com/

The following files are used for RxNorm source processing.

File Name Description
dea.dos Drug Enforcement Agency (DEA) Class Code File
ExFixUnpack_DOS_Y2K.out Main File
expgenrc.dos Expanded Generic Cross Reference (GCR) Code File
expstren.dos Expanded Product Strength Code File
form.dos Form Code File
gcr.dos Generic Cross Reference Code File
gfc.dos Generic Formulation Code File
mfr.dos Manufacturer Code File
prodcat.dos Product Category Code File
roa.dos Route of Administration Code File

Source-Provided Files: Details

The following is a list of fields in the Micromedex source files. Many Micromedex 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: dea.dos
# Field Name Description RxNorm Representation
1 deaClassCode Indicates the class to which the Drug Enforcement Agency (DEA) has assigned the product under the Controlled Substances Act of 1970. Not applicable
2 deaClassDesc Description of the DEA code assigned to the product under the Controlled Substances Act of 1970. RXNSAT.ATV when RXNSAT.ATN=DCSA

File Name: ExFixUnpack_DOS_Y2K.out

Many fields in the ExFixUnpack_DOS_Y2K.out file are "Not applicable". The abridged table below includes relevant fields used in RxNorm processing.

# Field Name Description RxNorm Representation
14 NDC 5-4-2 Format (ndc) Supplies the 5-4-2 configuration of the product's current National Drug Code (NDC), Universal Product Code (UPC), or Health-Related Item (HRI) Code, with embedded dashes RXNSAT.ATV when RXNSAT.ATN=NDC
17 NDC Standard 10 Format (ndc10) Supplies the product's current NDC, Universal Product Code, or Health-Related Item number in 10-digit format with no embedded dashes. RXNSAT.ATV when RXNSAT.ATN=UPC
24 Product Name (productName) Supplies the name given to the product by the manufacturer Used to build the MMX TTY=BD string RXNCONSO.STR
27 Product Category Code (productCategory) Access the Manufacturer table to see the complete manufacturer information. Used internally. Values 01, 04, 05, 07, 08, 09, and 10 identify TTY=BD atoms.
49 DESI Drug Indicator (desiDrugFlag) Indicates if the product “lacks substantial evidence of effectiveness,” as determined by the FDA's Drug Efficacy Study Implementation (DESI) review RXNSAT.ATV when RXNSAT.ATN=DESI_DESC

File Name: expgenrc.dos
# Field Name Description RxNorm Representation
1 gcrCode A unique 6-digit code assigned to all products that contain the same set of active ingredients. Not applicable
2 gcrExpName Information describing the active ingredients represented by a gcrCode. Used to build RXNCONSO.STR

File Name: expstren.dos
# Field Name Description RxNorm Representation
1 strengthCode Identifies the strength of the ingredients in a product. Not applicable
2 strengthExpName Strength descriptions for products. Full string of ingredient strengths without any constraints due to number of ingredients or characters. RXNSAT.ATV when RXNSAT.ATN=DST

Used to build RXNCONSO.STR

File Name: form.dos
# Field Name Description RxNorm Representation
1 formCode Designates the dosage form or the type of medical supply Not applicable
2 masterFormCode Complete list of codes designating the dosage form or the type of medical supply Not applicable
3 formDesc Provides information about the dosage form or the type of medical supply RXNSAT.ATV when RXNSAT.ATN=DDF

Used to build RXNCONSO.STR

File Name: gcr.dos
# Field Name Description RxNorm Representation
1 gcrCode A unique 6-digit code assigned to all products that contain the same set of active ingredients. Used internally
2 gcrName Information describing the active ingredients represented by a gcrCode. Used internally

File Name: gfc.dos
# Field Name Description RxNorm Representation
1 gfc (gfcCode) Supplies a unique 6-digit code identifying drugs with common active ingredients, master dosage form, strength, and route of administration. RXNCONSO.CODE
2 gfcMasterCode Master code for the generic formulation code Not applicable
3 gcrCode A unique 6-digit code assigned to all products that contain the same set of active ingredients. Used internally
4 formCode Identifies drug dosage form Used internally
5 strengthCode Identifies drug strength Used internally
6 roaCode Identifies drug route of administration Used internally
7 gfcDeact Provides deactivate information Not applicable

File Name: mfr.dos
# Field Name Description RxNorm Representation
1 mfg_name_long Identifies the name of the company that markets the product. The name appearing in this field corresponds to the FDA-registered labeler name identified by the five-digit labeler code on the NDC number. Therefore, names appearing in this field will include distributors and repackagers in addition to original manufacturers. RXNSAT.ATV when RXNSAT.ATN=LABELER
2 mfgName Marketing company’s name Not applicable
3 mfgCode Six digit numeric code used to associate product records with manufacturer information that is delivered in an associated relational file. Not applicable
4 address1 Marketing company’s street address line 1 Not applicable
5 address2 Marketing company’s street address line 2 Not applicable
6 city Marketing company’s city address Not applicable
7 state Marketing company’s state Not applicable
8 ZIP Marketing company’s zip code Not applicable
9 phoneAreaCode Marketing company’s telephone area code Not applicable
10 phoneNumber Marketing company’s phone number Not applicable
11 faxAreaCode Marketing company’s fax number area code Not applicable
12 faxNumber Marketing company’s fax number Not applicable

File Name: prodcat.dos
# Field Name Description RxNorm Representation
1 productCategory Code designating a product’s prescription and trade-name status. Not applicable
2 productCatDesc Provides information about a product’s prescription and trade-name status, such as prescription generics or branded over-the-counter products (OTCs). RXNSAT.ATV when RXNSAT.ATN=MMX_RXO

File Name: roa.dos
# Field Name Description RxNorm Representation
1 roaCode Identifies the product’s intake or application method (route of administration). Not applicable
2 roaName Information describing the product’s route of administration. RXNSAT.ATV when RXNSAT.ATN=DRT

Used to build RXNCONSO.STR

RxNorm Representation

This section lists RxNorm data elements and traces them back to the specific Micromedex 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://downloads.micromedex.com/

RxNorm uses the following files:

File Name Description
dea.dos DEA Class Code File
ExFixUnpack_DOS_Y2K.out Main File
expgenrc.dos Expanded Generic Cross Reference File
expstren.dos Expanded Product Strength Code File
form.dos Form Code File
gfc.dos Generic Formulation Code File
mfr.dos Manufacturer Code File
prodcat.dos Product Category Code File
roa.dos Route of Administration Code File

RxNorm Identifiers:

Identifiers are assigned as follows:

Identifier Origin
CODE gfc.dos.gfcCode
SAUI Not Applicable
SCUI Not Applicable
SDUI Not Applicable

Atoms (RXNCONSO):

Term Type Origin
CD CODE=gfc.dos.gfcCode

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

STR=
expgenrc.dos.gcrExpName (Generic Name)
expstren.dos.strengthExpName (Strength)
roa.dos.roaName (Route)
form.dos.formDesc (Dose Form)

Example: Aluminum Chloride 12.5% Topical application Solution
BD CODE=gfc.dos.gfcCode
ExFixUnpack_DOS_Y2K.out.productCategory values of 01, 04, 05, 07, 08, 09, and 10 identify BD atoms.

Micromedex’s branded drug name string is expressed as Generic Name + Strength + Route + Dose Form + Product Name.

STR=
expgenrc.dos.gcrExpName (Generic Name)
expstren.dos.strengthExpName (Strength)
roa.dos.roaName (Route)
form.dos.formDesc (Dose Form)
ExFixUnpack_DOS_Y2K.out.productName (Product Name)

Example: Aluminum Chloride 12.5% Topical application Solution [CERTAIN DRI]
MTH_RXN_CD
(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_CD 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:
Morphine Sulfate 15 MG/1 ML Injection Solution

Duplicate atoms:
Morphine Sulfate 15 MG/1 ML Injection Solution_#1
Morphine Sulfate 15 MG/1 ML Injection Solution_#2
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, go to 9.0 Duplicating Source Asserted Atoms (to resolve NDC conflicts)

Relationships (RXNREL):

No relationships are provided for this source.


Attributes (RXNSAT):

ATN Origin
DCSA dea.dos.deaClassDesc
DDF form.dos.formDesc
DRT roa.dos.roaName
DST expstren.dos.strengthExpName
DESI_DESC ExFixUnpack_DOS_Y2K.out.desiDrugFlag
LABELER mfr.dos.mfg_name_long
MMX_RXO prodcat.dos.productCatDesc
NDC ExFixUnpack_DOS_Y2K.out.ndc
UPC ExFixUnpack_DOS_Y2K.out.ndc10

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 310965 Ibuprofen 200 MG Oral Tablet [Motrin] SBD N
2065 Menadol, 200 mg oral tablet 310965 Ibuprofen 200 MG Oral Tablet [Menadol] SBD O
2065 Ibu-Tab, 200 mg oral tablet 310965 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 = 'MMX'
     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: May 31, 2024