Field	Value
Short Name	Micromedex
Family	MMX
Source Restriction Level	3
Language	ENG
License Contact	Micromedex 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 Contact	productsupport@merative.com, (877) 843-6796

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

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

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;