Home Package List Routine Alphabetical List Global Alphabetical List FileMan Files List FileMan Sub-Files List Package Component Lists Package-Namespace Mapping

Info | Desc | Accessed By FileMan Db Calls | Fields

Print Page as PDF

Global: ^ETSRXN(129.22

Package: Enterprise Terminology Services

Global: ^ETSRXN(129.22

Information

FileMan FileNo	FileMan Filename	Package
129.22	RXNORM RELATED CONCEPTS	Enterprise Terminology Services

Description

RxNorm is a standardized nomenclature for clinical drugs. RxNorm is produced by the National Library of Medicine (NLM). In this context, a clinical drug is a pharmaceutical product given to (or taken by) a patient with a therapeutic or diagnostic intend. The name of the drug in RxNorm combines its ingredients, dosage strength, and form. The RxNorm Related Concepts file contains a subset of the data distributed by NLM in the RXNREL.RRF file. This file follows the general format of the MRREL.RRF file of the Metathesaurus in NLM's Unified Medical Language System (UMLS). Some of the Metathesaurus fields are not provided by RxNorm and are marked as "(no value provided)". There is one row in this table for each relationship between concepts or atoms known to RxNorm. In addition, explicit SY RELs are provided which give the UMLS Metathesaurus CUI and AUI as the RXCUI2 and RXAUI2 fields. Note that for asymmetrical relationships there is one row for each direction of the relationship. Note also the direction of REL - the relationship which the SECOND concept or atom (with Concept Unique Identifier RXCUI2 and Atom Unique Identifier (RXAUI2) HAS TO the FIRST concept or atom (with Concept Unique RXCUI1 and Atom Unique Identifier RXAUI1).

Accessed By FileMan Db Calls, Total: 2

Package	Total	Routines
Enterprise Terminology Services	2	ETSRXN1 ETSRXNTX

Fields, Total: 8

Field #	Name	Loc	Type	Details
.01	RXCUI1	0;1	FREE TEXT	**********************REQUIRED FIELD********************** INPUT TRANSFORM: `K:$L(X)>8!($L(X)<1) X` `MAXIMUM LENGTH: 8` LAST EDITED: `APR 13, 2017` HELP-PROMPT: `Answer must be 1-8 characters in length.` DESCRIPTION: `Unique identifier of the first concept.` CROSS-REFERENCE: `129.22^B` `1)= S ^ETSRXN(129.22,"B",$E(X,1,30),DA)=""` `2)= K ^ETSRXN(129.22,"B",$E(X,1,30),DA)` RECORD INDEXES: `D (#1474)`
.02	RELATIONSHIP (REL)	0;2	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>4!($L(X)<1) X` `MAXIMUM LENGTH: 4` LAST EDITED: `JAN 24, 2017` HELP-PROMPT: `Answer must be 1-4 characters in length.` DESCRIPTION: `Relationship of the second concept or atom to the first concept or atom.`
.03	RXCUI2	0;3	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>8!($L(X)<1) X` `MAXIMUM LENGTH: 8` LAST EDITED: `APR 18, 2017` HELP-PROMPT: `Answer must be 1-8 characters in length.` DESCRIPTION: `Unique identifier of the second concept`
.04	SECONDARY RELATIONSHIP (RELA)	0;4	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>100!($L(X)<1) X` `MAXIMUM LENGTH: 100` LAST EDITED: `APR 18, 2017` HELP-PROMPT: `Answer must be 1-100 characters in length.` DESCRIPTION: `Additional (i.e more specific) relationship label.`
.05	SOURCE (SAB)	0;5	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>20!($L(X)<1) X` `MAXIMUM LENGTH: 20` LAST EDITED: `JAN 25, 2017` HELP-PROMPT: `Answer must be 1-20 characters in length.` DESCRIPTION: `Abbreviation of the source of relationship.`
.06	SUPPRESSION_FLAG (SUPPRESS)	0;6	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>1!($L(X)<1) X` `MAXIMUM LENGTH: 1` LAST EDITED: `MAR 29, 2017` HELP-PROMPT: `Answer must be 1 character in length.` DESCRIPTION: `Suppressible flag. Values = N, Y, or E.` `Reflects the suppressible status of the attribute.` `N - Attribute is not suppressed.` `Y - Attribute is suppressed by RxNorm` `editors.` `E - Attribute is an unquantified, non-` `prescribable drug with related` `quantified prescribable drugs.`
.07	CONTENT_VIEW_FLAG (CVF)	0;7	FREE TEXT	INPUT TRANSFORM: `K:$L(X)>50!($L(X)<1) X` `MAXIMUM LENGTH: 50` LAST EDITED: `JAN 25, 2017` HELP-PROMPT: `Answer must be 1-50 characters in length.` DESCRIPTION: `This fields denotes whether or not a concept is currently prescribable.`
91	UNIQUE RECORD ID	VA;1	FREE TEXT	**********************REQUIRED FIELD********************** INPUT TRANSFORM: `K:$L(X)>50!($L(X)<1) X` `MAXIMUM LENGTH: 50` LAST EDITED: `APR 18, 2017` HELP-PROMPT: `Answer must be 1-50 characters in length.` DESCRIPTION: `This field is a unique ID for every row and will be used to keep the records in the central repository in sync with the records in this file. During initial population, it will be derived from the line number in the` `RXNREL.RRF file.` RECORD INDEXES: `D (#1474)`

Info | Desc | Accessed By FileMan Db Calls | Fields