Global: ^C0CRXN(176.002

FileMan FileNo	FileMan Filename	Package
176.002	RXNORM NDC TO RXCUI	RxNorm for VISTA

Description

Licensed under GPL. This file is part of the CCD/CCR Extraction from Vista/RPMS Project being run by WorldVista. This file was produced by Sam Habiel on December 26, 2008. This file will be used to get RxNorm if only the NDC number is available. This is currently the case in the RPMS database. The original file is RxNorm Simple Concept and Atom Attributes file (RXNSAT.RRF). Most of the entries are not imported; only those entries whose Attribute Name (ATN, piece 9) is NDC and whose source (SAB, piece 10) is RXNORM are imported. The filtering is done by the mumps import code. Here's a complete description of RXNSAT.RRF file from RxNorm (Note that only fields prefixed by * are actually imported into the File Manager): This file follows the general format of the MRSAT.RRF file of the Metathesaurus. Some of the Metathesaurus fields are not provided by RxNorm and are marked as "(no value provided)". There is exactly one row in this table for each concept, atom, or relationship attribute that does not have a sub-element structure. Not all RxNorm concepts or RxNorm relationships have entries in this file. This file includes all source vocabulary attributes that do not fit into other categories. Col. Description *RXCUI Unique identifier for concept (concept id) LUI Unique identifier for term (no value provided) SUI Unique identifier for string (no value provided) RXAUI Unique identifier for atom (RxNorm Atom ID) STYPE The name of the column in RXNCONSO.RRF or RXNREL.RRF that contains the identifier to which the attribute is attached, e.g., CUI, AUI. CODE "Most useful" source asserted identifier (if the source vocabulary contains more than one). ATUI Unique identifier for attribute SATUI Source asserted attribute identifier (optional - present if it exists) ATN Attribute name. Possible values appear in RXNDOC.RRF and are described in Appendix B.2 of the Metathesaurus documentation SAB Abbreviation of the source of the attribute. Possible values appear in RXNSAB.RRF and are listed in Appendix B.4 of the Metathesaurus documentation *ATV Attribute value described under specific attribute name in Appendix B.2. of the Metathesaurus documentation. A few attribute values exceed 1,000 characters. Many of the abbreviations used in attribute values are explained in RXNDOC.RRF and included in Appendix B.3. of the Metathesaurus documentation SUPPRESS Suppressible flag. Values = E, Y, or N. Reflects the suppressible status of the attribute; not yet in use. See also SUPPRESS in MRCONSO.RRF and MRDEF.RRF and MRREL.RRF of the Metathesaurus documentation. CVF Content view flag In summary the file is an import of RXNSAT.RRF filtered by ATN="NDC" and SAB="RXNORM". Imported fields are RXCUI and ATV (= NDC). RxNorm can be found at http://www.nlm.nih.gov/research/umls/rxnorm/ RxNorm is updated monthly.

Package	Total	Routines
IHS Changes To Pharmacy	1	APSPES4
IHS Electronic Health Record	1	BEHOARCV

Package	Total	Routines
IHS Electronic Health Record	1	BEHOARCV
RxNorm for VISTA	1	C0CRXNRD

Fields, Total: 2

Field # Name Loc Type Details

Field #	Name	Loc	Type	Details
.01	RXCUI	0;1	FREE TEXT	**********************REQUIRED FIELD********************** INPUT TRANSFORM: `K:$L(X)>8!($L(X)<1)!'(X?.N) X` LAST EDITED: `FEB 15, 2009` HELP-PROMPT: `RXCUI (RxNorm) Number` SOURCE OF DATA: Piece 1 of RXNSAT.RRF CROSS-REFERENCE: `176.002^B` 1)= S ^C0CRXN(176.002,"B",$E(X,1,30),DA)="" 2)= K ^C0CRXN(176.002,"B",$E(X,1,30),DA) RECORD INDEXES: `COMB (#304)`
2	NDC	0;3	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>11!($L(X)<9)!'(X?9.11N) X` LAST EDITED: `FEB 15, 2009` HELP-PROMPT: `NDC number, normal 11 digit form without dashes` SOURCE OF DATA: Piece 11 of RXNSAB.RRF when filtered for NDC.*RXNORM CROSS-REFERENCE: `176.002^NDC` 1)= S ^C0CRXN(176.002,"NDC",$E(X,1,30),DA)="" 2)= K ^C0CRXN(176.002,"NDC",$E(X,1,30),DA) RECORD INDEXES: `COMB (#304)`

.01

RXCUI

0;1

FREE TEXT

************************REQUIRED FIELD************************

INPUT TRANSFORM: K:$L(X)>8!($L(X)<1)!'(X?.N) X
LAST EDITED: FEB 15, 2009
HELP-PROMPT: RXCUI (RxNorm) Number
```
SOURCE OF DATA:   Piece 1 of RXNSAT.RRF
```

CROSS-REFERENCE: 176.002^B

1)= S ^C0CRXN(176.002,"B",$E(X,1,30),DA)=""

2)= K ^C0CRXN(176.002,"B",$E(X,1,30),DA)

RECORD INDEXES: COMB (#304)

NDC

0;3

FREE TEXT

INPUT TRANSFORM: K:$L(X)>11!($L(X)<9)!'(X?9.11N) X
LAST EDITED: FEB 15, 2009

HELP-PROMPT: NDC number, normal 11 digit form without dashes

SOURCE OF DATA:   Piece 11 of RXNSAB.RRF when filtered for NDC.*RXNORM

CROSS-REFERENCE: 176.002^NDC

1)= S ^C0CRXN(176.002,"NDC",$E(X,1,30),DA)=""

2)= K ^C0CRXN(176.002,"NDC",$E(X,1,30),DA)

RECORD INDEXES: COMB (#304)

Customize PDF page

Package: RxNorm for VISTA

Global: ^C0CRXN(176.002

Information

Description

Directly Accessed By Routines, Total: 2

Accessed By FileMan Db Calls, Total: 2

Fields, Total: 2