### Configure MySQL RxNorm Load Shell Script Parameters (Linux/Solaris)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Example configuration for the 'populate_mysql_rxn.sh' script on Linux or Solaris, setting essential parameters like MySQL home directory, database user, password, database name, and database server.

```Shell
MYSQL_HOME= /usr
user=myuser
password=p4ssw0rd
db_name=RxNormPrescribe
dbserver=ServerName
```

--------------------------------

### RxNorm Generic Pack (GPCK) Examples

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Illustrative examples of Generic Pack (GPCK) term types in RxNorm. These examples show how specific generic drug packs are represented using the defined GPCK syntax, detailing their SCD components and quantities.

```APIDOC
{28 (Norethindrone 0.35 MG Oral Tablet) } Pack
{11 (varenicline 0.5 MG Oral Tablet) / 42 (varenicline 1 MG Oral Tablet) } Pack
```

--------------------------------

### Configure MySQL RxNorm Load Batch Script Parameters (Windows)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Example configuration for the 'Populate_mysql_rxn.bat' script on Windows, setting essential parameters like MySQL home directory, database user, password, host, and database name. Values should be enclosed in quotes if they contain spaces.

```Batch
Set MYSQL_HOME= "C:\Program Files\MySQL\MySQL Server 5.0"
Set user=myuser
Set password=p4ssword
Set host_name=localhost
Set db_name =RxNormPrescribe
```

--------------------------------

### Oracle Database Script Files

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Documentation of key script files located in the `\prescribe\scripts\oracle` subdirectory for Oracle database setup. This includes files for batch control, index creation, table creation, and control files for data loading.

```APIDOC
Filename: populate_oracle_rxn_db.bat
  Description: The batch control file for the load process
Filename: rxn_index.sql
  Description: Index creation commands (optional)
Filename: RxNormDDL.sql
  Description: Table creation (and deletion) commands
Filename: RXNCONSO.ctl
  Description: Control file for RXNCONSO.RRF
Filename: RXNREL.ctl
  Description: Control file for RXNREL.RRF
Filename: RXNSAT.ctl
  Description: Control file for RXNSAT.RRF
```

--------------------------------

### RxNorm Branded Pack (BPCK) Examples

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Illustrative examples of Branded Pack (BPCK) term types in RxNorm. These examples demonstrate how specific drug packs are represented using the defined BPCK syntax, including their components and market names.

```APIDOC
{12 (Ethinyl Estradiol 0.035 MG / Norethindrone 0.5 MG Oral Tablet) / 9 (Ethinyl Estradiol 0.035 MG / Norethindrone 1 MG Oral Tablet) / 7 (Inert Ingredients 1 MG Oral Tablet) } Pack [Leena 28 Day]
{6 (azithromycin 250 MG Oral Tablet) } Pack
```

--------------------------------

### MySQL Database Script Files

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Documentation of key script files located in the `\prescribe\scripts\mysql` subdirectory for MySQL database setup. This includes files for table creation, data loading scripts for both Windows and Unix/Linux environments, and optional index creation scripts.

```APIDOC
Filename: Table_scripts_mysql_rxn.sql
  Description: Creates the tables
Filename: Populate_mysql_rxn.bat
  Description: Load the RxNorm files from windows into tables
Filename: populate_mysql_rxn.sh
  Description: Load the RxNorm files from Unix/Linux to tables
Filename: Load_scripts_mysql_rxn_win.sql
  Description: Windows loading script (called from populate script)
Filename: Load_scripts_mysql_rxn_unix.sql
  Description: Unix/Linux loading script (called from populate script)
Filename: Indexes_mysql_rxn.sql
  Description: Creates table indexes (optional)
```

--------------------------------

### Execute RxNorm MySQL Load Script (Windows)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

These snippets demonstrate how to execute the MySQL import command from a Windows batch script. The first example includes the password parameter, while the second shows how to remove it if the database is configured without a password.

```Batch
%MYSQL_HOME%\bin\mysql –u %user% -p%password% -h%hostname% --local-infile=1 %db_name% <Table_scripts_mysql_rxn.sql >>mysql.log 2 >&1
```

```Batch
%MYSQL_HOME%\bin\mysql –u %user% -h%hostname% --local-infile=1 %db_name% <Table_scripts_mysql_rxn.sql >>mysql.log 2 >&1
```

--------------------------------

### RXNREL.RRF Sample Records

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Example entries demonstrating the data structure and content format within the RXNREL.RRF file, illustrating concept and atom relationships as they appear in the dataset.

```APIDOC
334291||CUI|RO|259711||CUI|consists_of|4194504||RXNORM||||N||
|2074692|AUI|SY||2849222|AUI|print_name_of|4622221||VANDF||||||
```

--------------------------------

### Additional RxNorm Drug Name Examples with Quantity Factors

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

These further examples showcase the application of the new quantity factor format for RxNorm drug names. They illustrate how volume and concentration are represented at the beginning of the drug name for various dose forms, such as prefilled syringes.

```APIDOC
3 ML Insulin, Aspart, Human 100 UNT/ML Prefilled Syringe
2 ML hyaluronate 10 MG/ML Prefilled Syringe [Hyalgan]
```

--------------------------------

### RxNorm Qualitative Distinction Normalized Name Examples

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Examples of RxNorm normalized names (SCD and SBD) demonstrating the application of Qualitative Distinction (QD) modifiers as prefixes to drug product strings. Each entry has a unique RXCUI.

```APIDOC
| RXCUI | Term Type (TTY) | String |
| --- | --- | --- |
| 848951 | SBD | Sugar-Free Cholestyramine Resin 4000 MG Powder for Oral Suspension [Prevalite] |
| 1801283 | SCD | Emollient Fluocinonide 0.5 MG/ML Topical Cream |
| 1801298 | SCD | Microencapsulated Potassium Chloride 10 MEQ Extended Release Oral Tablet |
| 993954 | SBD | Smoking Cessation 12 HR Bupropion Hydrochloride 150 MG Extended Release Oral Tablet [Zyban] |
```

--------------------------------

### RXNATOMARCHIVE.RRF Sample Data Records

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Provides illustrative sample records from the RXNATOMARCHIVE.RRF file. These examples demonstrate the data format and content for archived RxNorm atoms, including unique identifiers, strings, timestamps, and source information.

```APIDOC
1138734|A0540716|Cefotetan Disodium|3/15/2005 8:05:03 PM|3/10/2005 2:56:21 PM|3/15/2005 8:05:02 PM|10203141||ENG||||203141|RXNORM|IN|203141
2057262|2057262|Testosterone / Testosterone Injectable Solution [Andro-Cyp 100]|3/17/2005 2:01:59 PM|3/16/2005 12:23:16 PM|3/17/2005 2:01:58 PM|10363337||ENG||||363337|RXNORM|SBDF|363337
```

--------------------------------

### RxNorm Qualitative Distinction Attribute Examples (RXNSAT.RRF)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Examples of the `RXN_QUALITATIVE_DISTINCTION` attribute found in the RXNSAT.RRF file, linking specific qualitative distinctions (e.g., Emollient, Sugar-Free) to their corresponding RxNorm concepts.

```APIDOC
| Attribute Name (ATN) | Attribute Value (ATV) |
| --- | --- |
| RXN_QUALITATIVE_DISTINCTION | Emollient |
| RXN_QUALITATIVE_DISTINCTION | Microencapsulated |
| RXN_QUALITATIVE_DISTINCTION | Smoking Cessation |
| RXN_QUALITATIVE_DISTINCTION | Sugar-Free |
```

--------------------------------

### RXNCUICHANGES.RRF Sample Data Records

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Presents sample records from the RXNCUICHANGES.RRF file, showcasing how concept ID changes are recorded. These examples illustrate the format for tracking updates to RxNorm concept identifiers, including cases where only partial information is provided for archived forms.

```APIDOC
426260|117164003|SNOMEDCT|PT|HLA-DQ2 antigen|27034|461862|
||RXNORM|||670619|702633|
```

--------------------------------

### Example RXNSAT.RRF Entries for RxNorm NDC Attributes

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Shows sample entries from the RXNSAT.RRF file, specifically demonstrating how NDC attributes are recorded for a given RXCUI. These entries highlight both source-asserted NDC values (e.g., from MMSL) and normalized RxNorm-asserted NDC values, indicating the attribute name (ATN='NDC') and the source (SAB).

```Text
213684|||2368285|AUI|759|||NDC|MMSL|61646050116|N||
213684|||1171481|AUI|213684|||NDC|RXNORM|61646050116|N||
213684|||1171481|AUI|213684|||NDC|RXNORM|58716032716|N||
```

--------------------------------

### Sample RXNCONSO.RRF Entry for Base Atom with SUPPRESS=E Value

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

An example of an RXNCONSO.RRF entry for a Base atom that is assigned an SBD form with a SUPPRESS=E value. This illustrates a scenario where a Base atom can be linked to an RxNorm form despite representing multiple underlying products.

```APIDOC
1360216|ENG||||||2938275||||MMSL|BD|6598|Flovent Diskus, 100 mcg inhalation powder||N||
```

--------------------------------

### RxNorm Drug Names Before Dose Form Transformation

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

These examples illustrate the original format of RxNorm drug names before the introduction of the quantity factor. They show how dose forms like '24 hour Extended Release Tablet' and 'Weekly Transdermal Patch' were integrated directly into the drug name string.

```APIDOC
Bupropion 300 MG 24 hour Extended Release Tablet [Wellbutrin]
Clonidine 0.00833 MG/HR Weekly Transdermal Patch
```

--------------------------------

### RxNorm Drug Names After Dose Form Transformation

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

These examples demonstrate the new format of RxNorm drug names after the dose form transformation. A quantity factor (e.g., '24 HR', '168 HR') is now prepended to the drug name, allowing for more standardized and flexible representation of time, measure, or strength.

```APIDOC
24 HR Bupropion 300 MG Extended Release Tablet [Wellbutrin]
168 HR Clonidine 0.00833 MG/HR Transdermal Patch
```

--------------------------------

### Execute RxNorm MySQL Load Script (Linux/Solaris)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This command shows how to execute the 'populate_mysql_rxn.sh' script from the command line on Linux or Solaris after it has been configured and made executable.

```Shell
populate_mysql_rxn.sh
```

--------------------------------

### Execute MySQL RxNorm Load Script (Linux/Solaris)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Command to run the 'populate_mysql_rxn.sh' script from the command line after configuration and setting execute permissions.

```Shell
populate_mysql_rxn.sh
```

--------------------------------

### Configure RxNorm MySQL Load Script Parameters (Linux/Solaris)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This snippet illustrates how to set the necessary parameters (MySQL home, user, password, database name, database server) within the 'populate_mysql_rxn.sh' script for Linux or Solaris environments.

```Shell
MYSQL_HOME= /usr
user=myuser
password=p4ssw0rd
db_name=RxNorm
dbserver=ServerName
```

--------------------------------

### Execute RxNorm MySQL Index Script (Windows)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This SQL command sequence shows how to select the target database and then execute the 'Indexes_mysql_rxn.sql' script from the MySQL command prompt on Windows to create indexes.

```SQL
USE <DATABASENAME>
\. C:\RXNORM\MySQL\Indexes_mysql_rxn.sql
```

--------------------------------

### Execute MySQL Index Creation Script

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Commands to make the MySQL index creation script executable and then run it against the specified RxNorm database. This script creates necessary indexes to optimize database performance.

```Bash
chmod +x Indexes_mysql_rxn.sql
mysql -umyuser –pmypass -hmyhost RxNorm < Indexes_mysql_rxn.sql
```

--------------------------------

### Set Permissions for RxNorm Load Script (Linux/Solaris)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This command is used to make the 'populate_mysql_rxn.sh' script executable on Linux or Solaris systems before it can be run.

```Shell
chmod 775 populate_mysql_rxn.sh
```

--------------------------------

### Create RxNorm Database Indexes

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Steps to execute the 'Indexes_mysql_rxn.sql' script, which creates necessary indexes on the RxNorm database tables. This involves setting execute permissions for the script and running it via the MySQL client.

```bash
chmod +x Indexes_mysql_rxn.sql
```

```bash
mysql -umyuser –pmypass -hmyhost RxNorm < Indexes_mysql_rxn.sql
```

--------------------------------

### Configure RxNorm MySQL Load Script Parameters (Windows)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This snippet shows how to set the required parameters (MySQL home, user, password, host, database name) within the 'Populate_mysql_rxn.bat' script for Windows environments. These parameters are crucial for the script to connect to the MySQL database.

```Batch
Set MYSQL_HOME= "C:\Program Files\MySQL\MySQL Server 5.0"
Set user=myuser
Set password=p4ssword
Set host_name=localhost
Set db_name =RxNorm
```

--------------------------------

### Set Execute Permissions for Load Script (Linux/Solaris)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Command to change file permissions for the 'populate_mysql_rxn.sh' script, making it executable before running.

```Shell
chmod 775 populate_mysql_rxn.sh
```

--------------------------------

### Find RxNorm drugs associated with HCPCS J codes

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This SQL query identifies RxNorm drugs (GPCK, BPCK, SCD, SBD term types) that are associated with HCPCS J codes by joining `rxnsat` and `rxnconso` tables, filtering for `atn` 'DHJC' and `atv` starting with 'J%'.

```SQL
SELECT distinct b.rxcui, a.atv as hcpcs, b.tty, b.str
FROM rxnsat a, rxnconso b
WHERE a.atn = 'DHJC'
AND a.atv like 'J%'
AND a.rxcui = b.rxcui
AND b.tty in ('GPCK', 'BPCK', 'SCD', 'SBD')
ORDER BY a.atv;
```

--------------------------------

### Oracle Batch File Parameters

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Parameters required for customizing the `populate_oracle_rxn_db.bat` file for specific Oracle environments. These parameters define the Oracle home directory, database user credentials, and the TNS service name for connection.

```APIDOC
Parameter: ORACLE_HOME
  Description: The location of your RDBMS software binaries (in this case, Oracle)
Parameter: user
  Description: The user name to use to connect to your database schema
Parameter: password
  Description: The password to use to connect to your database schema
Parameter: tns_name
  Description: The server name (or SID) of your database
```

--------------------------------

### Create MySQL Database

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

A SQL command to create a new MySQL database. The `IF NOT EXISTS` clause prevents an error if the database already exists, and `CHARACTER SET utf8` ensures proper character encoding for the database.

```SQL
CREATE DATABASE IF NOT EXISTS [database name] CHARACTER SET utf8;
```

--------------------------------

### Execute MySQL Index Script from CLI (Windows)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Commands to execute the 'Indexes_mysql_rxn.sql' script from the MySQL command prompt after the data load is complete. This includes selecting the database and specifying the script path.

```MySQL CLI
USE <DATABASENAME>
. C:\RXNORM\MySQL\Indexes_mysql_rxn.sql
```

--------------------------------

### Execute RxNorm MySQL Load Script (Linux/Solaris) - Password Handling

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This snippet demonstrates the structure of the MySQL import command within a Linux/Solaris shell script, showing how the password parameter (`-p$password`) is included. The text indicates that this parameter should be removed if the database has no password.

```Shell
$MYSQL_HOME/bin/mysql -u $user -p$password -h$dbserver --local-infile=1 $db_name <Table_scripts_mysql_rxn.sql >>mysql.log 2 >&1
```

--------------------------------

### Comparative Summary of RxNorm History Files

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Provides a comparative overview of key characteristics for RxNorm history files: RXNCUI, RXNATOMARCHIVE, and RXNCUICHANGES. It highlights differences in general purpose, included term types, cumulative status, and RXCUI data fields, offering a quick reference for understanding their distinct roles.

```APIDOC
RxNorm History File Comparison:
  - RXNCUI:
      General purpose: To track retired RxNorm normalized names for dispensable drugs
      Term Types (TTY) included: SCD, SBD, GPCK, BPCK from SAB=RXNORM only
      Cumulative status: Cumulative from March 2009
      RXCUI data fields: CUI1, CUI2
  - RXNATOMARCHIVE:
      General purpose: To track archival of all RxNorm normalized names
      Term Types (TTY) included: All TTYs from SAB=RXNORM only
      Cumulative status: Cumulative from March 2005
      RXCUI data fields: RXCUI, MERGED_TO_RXCUI
  - RXNCUICHANGES:
      General purpose: To track RXCUI changes for any atom in the RxNorm database since the last monthly release
      Term Types (TTY) included: All TTYs from data sources (SAB=not RXNORM) and SAB=RXNORM (Note: For SAB=RXNORM, all data fields are populated for SY and PSN. For other TTYs, only SAB, OLD_RXCUI, and NEW_RXCUI data are provided.)
      Cumulative status: Not Cumulative
      RXCUI data fields: OLD_RXCUI, NEW_RXCUI
```

--------------------------------

### Monitor MySQL Load Process from CLI

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Command to monitor the active processes within the MySQL command shell while the load script is running, useful for tracking progress.

```MySQL CLI
mysql>show processlist;
```

--------------------------------

### Correcting MySQL Data Load Command

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Illustrates the correction for the MySQL data loading command, specifically removing the space between '-p' and the password variable. This command executes an SQL script to populate the database and redirects output to a log file.

```Bash
$MYSQL_HOME/bin/mysql –u $user –p$password $db_name <Table_scripts_mysql_rxn.sql >>mysql.log 2>&1
```

```Bash
$MYSQL_HOME/bin/mysql –u$user $db_name <Table_scripts_mysql_rxn.sql >>mysql.log 2>&1
```

--------------------------------

### Configure MySQL Script for Passwordless Connection

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Instructions to modify the 'populate_mysql_rxn.sh' script by removing password parameters. This is necessary for MySQL databases configured without a password, ensuring the script can connect successfully without authentication issues.

```bash
$MYSQL_HOME/bin/mysql –u $user –p$password $db_name <Table_scripts_mysql_rxn.sql >>mysql.log 2>&1
```

```bash
$MYSQL_HOME/bin/mysql –u$user $db_name <Table_scripts_mysql_rxn.sql >>mysql.log 2>&1
```

--------------------------------

### Create New MySQL Database for RxNorm

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

SQL command to create a new MySQL database for RxNorm data. The command includes a check to ensure the database is only created if it does not already exist and specifies UTF-8 character encoding.

```SQL
CREATE DATABASE IF NOT EXISTS [database name] CHARACTER SET utf8;
```

--------------------------------

### APIDOC: Prefilled Applicator Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Prefilled Applicator Products in RxNorm.

```APIDOC
Prefilled Applicator Product:
  Includes these dose forms:
    - Prefilled Applicator
```

--------------------------------

### Sample RXNCONSO.RRF Entries for Base and Duplicate Atoms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Illustrates the structure of entries in the RXNCONSO.RRF file for a Base atom and its duplicated forms. It shows how the string and term type (TTY) change for duplicates, reflecting the new atom identities.

```APIDOC
1875730|ENG||||||8739698||||GS|BD|105940|TachoSil Absorbable Fibrin Sealant Topical Patch||N||
1001593|ENG||||||8742121||||GS|MTH_RXN_BD|105940|TachoSil Absorbable Fibrin Sealant Topical Patch_#1||N||
1014305|ENG||||||8742122||||GS|MTH_RXN_BD|105940|TachoSil Absorbable Fibrin Sealant Topical Patch_#2||N||
```

--------------------------------

### Monitor MySQL Process During Data Load

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

A SQL command to monitor active processes within the MySQL command shell. This is useful for observing the progress of data loading or other long-running operations.

```sql
mysql>show processlist;
```

--------------------------------

### APIDOC: Shampoo Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Shampoo Products in RxNorm.

```APIDOC
Shampoo Product:
  Includes these dose forms:
    - Medicated Shampoo
```

--------------------------------

### Monitor MySQL Processes

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This SQL command can be used within the MySQL command shell to monitor the progress of the load script by listing active processes.

```SQL
mysql>show processlist;
```

--------------------------------

### Summary of Data Elements for Base and Duplicate Atoms (Table 1)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This table provides a detailed summary of key data elements (CODE, RXAUI, ATV, STR, TTY, NDC, RXCUI) for a Base atom and its duplicates. It specifically illustrates the differences when the Base atom is not assigned an RxNorm form, serving as a data schema reference.

```APIDOC
| **Data Element** | **Base atom** | **Duplicate 1** | **Duplicate 2** |
| --- | --- | --- | --- |
| CODE | 105940 | 105940 | 105940 |
| RXAUI | 8739698 | 8742121 | 8742122 |
| ATV (Attribute Value) | Base | Duplicate | Duplicate |
| STR (SAB=not RXNORM source atom string) | TachoSil Absorbable Fibrin Sealant Topical Patch | TachoSil Absorbable Fibrin Sealant Topical Patch_#1 | TachoSil Absorbable Fibrin Sealant Topical Patch_#2 |
| TTY (Term Type) | BD | MTH_RXN_BD | MTH_RXN_BD |
| NDC | 00944-8701-01 (SUPPRESS=Y)  00944-8702-02 (SUPPRESS=Y) | 00944-8702-01 (SUPPRESS=N) | 00944-8702-02 (SUPPRESS=N) |
| RXCUI | 1875730 | 1001593 | 1014305 |
| STR (SAB=RXNORM String) | None* | Fibrinogen 337 MG / Thrombin 123 UNT Medicated Patch [TachoSil] (SUPPRESS=N) | Fibrinogen 173 MG / Thrombin 62.2 UNT Medicated Patch [TachoSil] (SUPPRESS=N) |
```

--------------------------------

### APIDOC: Vaginal Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Vaginal Products in RxNorm.

```APIDOC
Vaginal Product:
  Includes these dose forms:
    - Douche
    - Vaginal Cream
    - Vaginal Film
    - Vaginal Foam
    - Vaginal Gel
    - Vaginal Ointment
    - Vaginal Ring
    - Vaginal Suppository
    - Vaginal Tablet
```

--------------------------------

### MySQL Index Limitation Workaround

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

SQL commands to address potential MySQL index limitation issues, particularly with specific versions. This workaround involves enabling `innodb_large_prefix`, creating a specific index on the `RXNSAT` table, and then altering the table to add a primary key with limited column sizes.

```SQL
Set innodb_large_prefix to ON
Create index rxnsat_idx on RXNSAT (RXAUI, RXCUI, SAB, ATN(250),ATV(700))
Alter table RXNSAT add primary key (RXAUI, RXCUI, SAB, ATN(250),ATV(700))
```

--------------------------------

### Summary Chart of Base and Duplicate Atoms with Suppress=E Value

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This table provides a detailed comparison of data elements for a base atom and its duplicates, specifically highlighting the 'AMBIGUITY_FLAG' context. It shows how attributes like CODE, RXAUI, ATV, STR, TTY, NDC, and RXCUI differ or remain consistent across base and duplicate entries, including suppression flags for NDC and RXNORM strings.

```APIDOC
| Data Element | Base atom | Duplicate 1 | Duplicate 2 |
| --- | --- | --- | --- |
| CODE | 6598 | 6598 | 6598 |
| RXAUI | 2938275 | 7725578 | 7725579 |
| ATV (Attribute Value) | Base | Duplicate | Duplicate |
| STR (SAB=not RXNORM source atom string) | Flovent Diskus, 100 mcg inhalation powder | Flovent Diskus, 100 mcg inhalation powder_#1 | Flovent Diskus, 100 mcg inhalation powder_#2 |
| TTY (Term Type) | BD | MTH_RXN_BD | MTH_RXN_BD |
| NDC | 00173060202 (SUPPRESS=Y)  00173060200 (SUPPRESS=Y)  54569626600 (SUPPRESS=O) | 00173060200 (SUPPRESS=N) | 00173060202 (SUPPRESS=N) |
| RXCUI | 1360216 | 896031 | 896023 |
| STR (SAB=RXNORM String) | Fluticasone propionate 0.1 MG/ACTUAT Dry Powder Inhaler [Flovent]  **(SUPPRESS=E form AUI 2938275)** | 28 ACTUAT Fluticasone propionate 0.1 MG/ACTUAT Dry Powder Inhaler [Flovent] (SUPPRESS=N) | 60 ACTUAT Fluticasone propionate 0.1 MG/ACTUAT Dry Powder Inhaler [Flovent] (SUPPRESS=N) |
```

--------------------------------

### Monitor MySQL Processes

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

A SQL command to view active processes within the MySQL command shell. This is useful for monitoring long-running operations such as large data loads or complex queries.

```SQL
mysql>show processlist;
```

--------------------------------

### RxNorm RRF File Primary Keys Reference

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Documentation of the primary keys for each of the RxNorm RRF files. These keys are essential for uniquely identifying rows within the loaded database tables and understanding data relationships, especially given the intentional data duplication in some files.

```APIDOC
File: RXNDOC.RRF
  Primary Key: There is no primary key. Whole record must be unique.
File: RXNCONSO.RRF
  Primary Key: RXAUI can be used as a primary key.
File: RXNSAT.RRF
  Primary Key: RXAUI, RXCUI, SAB, ATN, and ATV (RXCUI not needed) combination can be used as a composite primary key.
File: RXNSTY.RRF
  Primary Key: RXCUI, STY combination can be used as a composite primary key.
File: RXNREL.RRF
  Primary Key: Adding “RELA” to the key combination RXAUI1, RXCUI1, RXAUI2, RXCUI2, REL, and RUI can be used as a composite primary key.
File: RXNSAB.RRF
  Primary Key: RSAB can be used as a primary key.
File: RXNCUI.RRF
  Primary Key: CUI1, CUI2 can be used as a composite primary key.
File: RXNATOMARCHIVE.RRF
  Primary Key: RXAUI, RXCUI, and MERGED_TO_RXCUI combination can be used as a composite primary key.
File: RXNCUICHANGES.RRF
  Primary Key: There is no primary key. Whole record must be unique.
```

--------------------------------

### APIDOC: Urethral Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Urethral Products in RxNorm.

```APIDOC
Urethral Product:
  Includes these dose forms:
    - Urethral Suppository
```

--------------------------------

### APIDOC: Toothpaste Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Toothpaste Products in RxNorm.

```APIDOC
Toothpaste Product:
  Includes these dose forms:
    - Toothpaste
```

--------------------------------

### Sample RXNREL.RRF Entries for Base-Duplicate Relationships

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Shows the relationship entries in the RXNREL.RRF file that link a Base atom to its duplicate atoms. These relationships use 'includes' and 'included_in' attributes (RELA) to define the hierarchical connection.

```APIDOC
|8739698|AUI|RO||8742121|AUI|included_in|108284901||RXNORM||||||
|8742121|AUI|RO||8739698|AUI|includes|108284902||RXNORM||||||
|8739698|AUI|RO||8742122|AUI|included_in|108284903||RXNORM||||||
|8742122|AUI|RO||8739698|AUI|includes|108284904||RXNORM||||||
```

--------------------------------

### APIDOC: Paste Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Paste Products in RxNorm.

```APIDOC
Paste Product:
  Includes these dose forms:
    - Oral Paste
    - Paste
    - Toothpaste
```

--------------------------------

### RxNorm Branded Pack (BPCK) Syntax

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Defines the syntax for Branded Pack (BPCK) term types in RxNorm. A BPCK represents a pack containing one or more SCDs or SBDs (Semantic Branded Drugs) with their quantities, along with a specific market name.

```APIDOC
{'quantity' (SCD1/SBD1) / 'quantity' (SCD2/SBD2) / 'quantity' (SCDn/SBDn) } Pack [Market Name]
```

--------------------------------

### Normalize NDC Codes to HIPAA Format in RxNorm

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Illustrates the normalization process for NDC codes within RxNorm, converting various source formats into the 11-digit, no-dashes HIPAA compliant format. This helps standardize NDC data for consistency across different sources and facilitates accurate association with RxNorm clinical drug concepts.

```Text
Source-asserted NDC attribute | Normalized NLM-asserted NDC attribute
--- | ---
000406-0522-05 | 00406052205
000406052201 | 00406052201
054868-5338-*3 | 54868533803
0591-0933-01 | 00591093301
60951-700-85 | 60951070085
```

--------------------------------

### Workaround for MySQL Index Limitation Issues

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Provides a workaround for specific MySQL versions that may encounter index limitation issues. The steps include configuring 'innodb_large_prefix' and manually creating or altering indexes for the RXNSAT table to accommodate larger key sizes.

```sql
Set innodb_large_prefix to ON
```

```sql
Create index rxnsat_idx on RXNSAT (RXAUI, RXCUI, SAB, ATN(250),ATV(700))
```

```sql
Alter table RXNSAT add primary key (RXAUI, RXCUI, SAB, ATN(250),ATV(700))
```

--------------------------------

### APIDOC: Oral Ointment Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Oral Ointment Products in RxNorm.

```APIDOC
Oral Ointment Product:
  Includes these dose forms:
    - Oral Ointment
```

--------------------------------

### APIDOC: Rectal Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Rectal Products in RxNorm.

```APIDOC
Rectal Product:
  Includes these dose forms:
    - Enema
    - Rectal Cream
    - Rectal Foam
    - Rectal Gel
    - Rectal Ointment
    - Rectal Solution
    - Rectal Spray
    - Rectal Suppository
```

--------------------------------

### APIDOC: Oral Foam Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Oral Foam Products in RxNorm.

```APIDOC
Oral Foam Product:
  Includes these dose forms:
    - Oral Foam
```

--------------------------------

### APIDOC: Oral Cream Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Oral Cream Products in RxNorm.

```APIDOC
Oral Cream Product:
  Includes these dose forms:
    - Oral Cream
```

--------------------------------

### RxNorm Extended Release Product Relationships (RXNREL.RRF)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Illustrates the reciprocal relationships between specified and unspecified extended release products in the RXNREL.RRF file, using `has_quantified_form` and `quantified_form_of` RELA attributes. These relationships exist between SCD and SBD terms.

```APIDOC
| RXCUI (1) | TTY (1) | STR (1) | RELA | RXCUI (2) | TTY (2) | STR (2) |
| --- | --- | --- | --- | --- | --- | --- |
| 1099759 | SCD | 24 HR Valproic Acid 250 MG Extended Release Capsule | has_quantified_form | 1099760 | SCD | Valproic Acid 250 MG Extended Release Capsule |
| 1014577 | SBD | 12 HR cetirizine hydrochloride 5 MG / Pseudoephedrine Hydrochloride 120 MG Extended Release Tablet [Cetiri-D] | has_quantified_form | 1014578 | SBD | cetirizine hydrochloride 5 MG / Pseudoephedrine Hydrochloride 120 MG Extended Release Tablet [Cetiri-D] |
| 849487 | SCD | Naproxen sodium 825 MG Extended Release Tablet | quantified_form_of | 849484 | SCD | 24 HR Naproxen sodium 825 MG Extended Release Tablet |
| 1098612 | SBD | lamotrigine 300 MG Extended Release Enteric Coated Tablet [Lamictal] | quantified_form_of | 1098610 | SBD | 24 HR lamotrigine 300 MG Extended Release Enteric Coated Tablet [Lamictal] |
```

--------------------------------

### RxNorm Generic Pack (GPCK) Syntax

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Defines the syntax for Generic Pack (GPCK) term types in RxNorm. A GPCK represents a pack containing one or more SCDs (Semantic Clinical Drugs) with their specified quantities.

```APIDOC
{'quantity' (SCD1) / 'quantity' (SCD2) / 'quantity' (SCDn) } Pack
```

--------------------------------

### Map NDCs to RxCUIs and RxNorm drug names

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This SQL query creates a mapping between National Drug Codes (NDCs) and RxCUIs from the `rxnsat` table, and associates them with the RxNorm drug name (STR) from the `rxnconso` table, filtering by specific term types (SCD, SBD, GPCK, BPCK) and ordering by drug name.

```SQL
SELECT a.atv as ndc, a.rxcui, b.str
FROM rxnsat a, rxnconso b
WHERE a.atn = 'NDC'
AND a.rxaui = b.rxaui
AND b.tty in ('SCD','SBD','GPCK','BPCK')
ORDER BY b.str;
```

--------------------------------

### Workaround for MySQL Index Limitations

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This set of SQL commands provides a workaround for specific MySQL versions that may have index limitation issues. It involves setting 'innodb_large_prefix' and then creating/altering the 'RXNSAT' table's primary key and index.

```SQL
Set innodb_large_prefix to ON;
Create index rxnsat_idx on RXNSAT (RXAUI, RXCUI, SAB, ATN(250),ATV(700));
Alter table RXNSAT add primary key (RXAUI, RXCUI, SAB, ATN(250),ATV(700));
```

--------------------------------

### Retrieve RxNorm details for a given NDC

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This SQL query retrieves the RxCUI, Source Abbreviation (SAB), Term Type (TTY), Code, and String (STR) from the `rxnconso` table for a given National Drug Code (NDC) by first finding the associated RxCUI from `rxnsat`.

```SQL
SELECT rxcui, sab, tty, code, str
FROM rxnconso
WHERE rxcui in (select rxcui FROM rxnsat WHERE atv = '50458025303');
```

--------------------------------

### APIDOC: Soap Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Soap Products in RxNorm.

```APIDOC
Soap Product:
  Includes these dose forms:
    - Medicated Bar Soap
    - Medicated Liquid Soap
```

--------------------------------

### Find CODE for a given RxCUI

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This SQL query retrieves the `CODE` associated with a specific RxCUI from the `rxnconso` table.

```SQL
SELECT code
FROM rxnconso
WHERE rxcui='243670';
```

--------------------------------

### APIDOC: Oral Paste Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Oral Paste Products in RxNorm.

```APIDOC
Oral Paste Product:
  Includes these dose forms:
    - Oral Paste
    - Toothpaste
```

--------------------------------

### RxNorm RXN_AVAILABLE_STRENGTH Attribute Sample Records

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

These sample records illustrate the structure of the RXN_AVAILABLE_STRENGTH attribute values. Each record shows an AUI (Atom Unique Identifier), the attribute name (RXN_AVAILABLE_STRENGTH), the source (RXNORM), and the attribute value (ATV) representing an available strength for a drug.

```APIDOC
1155862|||3818473|AUI|1155862|||RXN_AVAILABLE_STRENGTH|RXNORM|10 MG|N||
1187310|||3848818|AUI|1187310|||RXN_AVAILABLE_STRENGTH|RXNORM|100 MG/ML|N||
1171313|||3828706|AUI|1171313|||RXN_AVAILABLE_STRENGTH|RXNORM|0.12 MG/ML (expressed as Naphazoline Hydrochloride) / 2 MG/ML|N||
```

--------------------------------

### APIDOC: Topical Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Topical Products in RxNorm.

```APIDOC
Topical Product:
  Includes these dose forms:
    - Medicated Pad
    - Medicated Patch
    - Medicated Tape
    - Powder Spray
    - Topical Cream
    - Topical Foam
    - Topical Gel
    - Topical Liquefied Gas
    - Topical Lotion
    - Topical Oil
    - Topical Ointment
    - Topical Powder
    - Topical Solution
    - Topical Spray
    - Topical Suspension
    - Transdermal System
```

--------------------------------

### Apply MySQL Index Limitation Workaround for RxNorm Tables

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

SQL commands to address potential index limitation issues in specific MySQL versions when loading RxNorm data. This involves setting the `innodb_large_prefix` option and modifying the `RXNSAT` table to create an index and primary key with specified column lengths.

```SQL
Set innodb_large_prefix to ON;
Create index rxnsat_idx on RXNSAT (RXAUI, RXCUI, SAB, ATN(250),ATV(700));
Alter table RXNSAT add primary key (RXAUI, RXCUI, SAB, ATN(250),ATV(700));
```

--------------------------------

### APIDOC: Ophthalmic Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Ophthalmic Products in RxNorm.

```APIDOC
Ophthalmic Product:
  Includes these dose forms:
    - Ophthalmic Cream
    - Ophthalmic Gel
    - Ophthalmic Irrigation Solution
    - Ophthalmic Ointment
    - Ophthalmic Solution
    - Ophthalmic Suspension
```

--------------------------------

### Workaround for MySQL Index Limitation Issues

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Steps to address potential index limitation issues in specific MySQL versions. This involves setting 'innodb_large_prefix' and then creating/altering indexes with specified column lengths.

```SQL
Set innodb_large_prefix to ON;
Create index rxnsat_idx on RXNSAT (RXAUI, RXCUI, SAB, ATN(250),ATV(700));
Alter table RXNSAT add primary key (RXAUI, RXCUI, SAB, ATN(250),ATV(700));
```

--------------------------------

### Modify MySQL Load Batch Script for No Password (Windows)

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Instructions on how to modify the 'Populate_mysql_rxn.bat' script to remove the password parameter if the MySQL database is configured without one. This involves removing '-p%password%' from the mysql command line.

```Batch
%MYSQL_HOME%\bin\mysql –u %user% -p%password% -h%hostname% --local-infile=1 %db_name% <Table_scripts_mysql_rxn.sql >>mysql.log 2 >&1
```

```Batch
%MYSQL_HOME%\bin\mysql –u %user% -h%hostname% --local-infile=1 %db_name% <Table_scripts_mysql_rxn.sql >>mysql.log 2 >&1
```

--------------------------------

### APIDOC: Oral Gel Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Oral Gel Products in RxNorm.

```APIDOC
Oral Gel Product:
  Includes these dose forms:
    - Oral Gel
```

--------------------------------

### RXNATOMARCHIVE.RRF File Structure Definition

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

Defines the column structure for the RXNATOMARCHIVE.RRF file, which contains data about RxNorm normalized names that are no longer part of the RxNorm database. It details each column's name, number, and description, providing a comprehensive schema for parsing the file.

```APIDOC
RXNATOMARCHIVE.RRF Schema:
  1. RXAUI: RxNorm Unique identifier for atom (RxNorm Atom ID)
  2. AUI: Metathesaurus Unique identifier for atom
  3. STR: String
  4. ARCHIVE_TIMESTAMP: Date/Time Archived
  5. CREATED_TIMESTAMP: Date/Time Created in this version of RxNorm
  6. UPDATED_TIMESTAMP: Date/Time Updated in this version of RxNorm
  7. CODE: "Most useful" source asserted identifier (if the source vocabulary has more than one identifier), or a Metathesaurus-generated source entry identifier (if the source vocabulary has none.)
  8. IS_BRAND: Branded data flag (not used)
  9. LAT: Language of Term
  10. LAST_RELEASED: Date this name (atom) was last released from RxNorm
  11. SAUI: Source asserted atom identifier [optional]
  12. VSAB: Versioned Source Abbreviation (NOTE: For the RxNorm terminology (e.g. SAB=RXNORM), the UMLS Metathesaurus version data will be frozen with the year 2020 starting with the RxNorm November 2020 release.)
  13. RXCUI: RxNorm Unique identifier for concept (concept ID)
  14. SAB: Source abbreviation
  15. TTY: Term type in source
  16. MERGED_TO_RXCUI: RxNorm Unique identifier for concept (concept ID) which name (atom) was merged into
```

--------------------------------

### APIDOC: Oral Spray Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Oral Spray Products in RxNorm.

```APIDOC
Oral Spray Product:
  Includes these dose forms:
    - Oral Spray
```

--------------------------------

### Find current RxCUI for retired RxCUI

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/techdoc

This SQL query identifies the current RxCUI(s) that replace a given retired RxCUI by querying the `rxncui` table, where `cui1` is the retired RxCUI and `cui2` is the current one.

```SQL
SELECT cui2
FROM rxncui
WHERE cui1='102889';
```

--------------------------------

### APIDOC: Pellet Product Dose Forms

Source: https://www.nlm.nih.gov/research/umls/rxnorm/docs/index.html/2016/appendix3

Defines the specific dose forms categorized under Pellet Products in RxNorm.

```APIDOC
Pellet Product:
  Includes these dose forms:
    - Oral Pellet
```