Skip Navigation Bar

Unified Medical Language System® (UMLS®)

Micromedex Source Information

Click on a topic below the Source Synopsis section to display details, or click "Expand All" to display all information.

Expand All  Collapse All

Source Synopsis

Web site:
http://truvenhealth.com/products/micromedex

Authority
RED BOOK® is produced by Micromedex®, a healthcare brand of Truven Health Analytics.

Purpose
The purpose of RED BOOK is to allow comprehensive access to current and accurate drug pricing 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.
The RxNorm representation of RED BOOK contains information on approximately 29,401 branded clinical drugs and 28,614 generic clinical drugs.

Update Frequency
RED BOOK is updated daily.

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

Sites Consulted

RED BOOK [Internet]. Micromedex Clinical Knowledge Suite. Truven Health Analytics, an IBM Company; c2017. [cited 2017 Sept 21].
Available from: https://truvenhealth.com/products/micromedex/product-suites/clinical-knowledge/red-book

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
SCUI 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