Drug Pair Lookup Query

The Drug Pair Lookup page provides the ability to perform a quick query search on the most common elements:

Drug Pair Lookup

You can perform a simple query to find a record from the FDB DIF and VA Custom tables. Enter query criteria in any or all of the four entry fields (Drug A, Drug B, Interaction, or Severity Level Code). The results are displayed under the VA Table Results and FDB Table Results panels. These consist of active customized Drug Pair records from the VA custom database that are available for modification, as well as their related Drug Pair records from the FDB database from which they were customized.

Field names are as follows:

Drug A The name of one of the drugs in the drug pair.Enter all or part of a drug name.
Drug B The name of another one of the drugs in the drug pair.Enter all or part of a drug name.
Interaction An assigned drug interaction number and description associated with the drug pair. This can be entered in conjunction with the Drug A and Drug B entries or can be used on its own. Enter either all or part of the Interaction ID or all or part of the interaction description.
Severity Level A drop-down list of available severity codes that are allowed for an interaction. This can be used on its own, but is most useful to limit the results produced by the other criteria.

To perform a Drug Pair Lookup query:

  1. Enter as much information as possible into the query form. The more detail that is added to the query, the more relevant the results.
  2. Drug Pair Lookup Query Form

  3. Click the Query button.
  4. Query Button

  5. Drug Pairs matching the query criteria (both VA and FDB) will be displayed. If the results are unsatisfactory, you can adjust the query criteria and click the Query button again. You can also Export the results of the query to a Excel spreadsheet.
  6. Drug Pair Query Results

  7. Click the adjacent link in the Select Column to view the drug pair record. VA records will display and Active link; FDB records display an Open link.
  8. Click the link to display the drug pair record

  9. To further customize the record, click the Interaction ID link to display the Drug-Drug Interaction (and the associated Drug Pairs).
  10. Click Interaction ID link to customize

Export Query Results

You can export the results of a Drug Pair Lookup query to an Excel spreadsheet.

Note: The maximum number of records that can be exported is 10000. If your query produces more than 10000 results, the first 10000 records will be exported to the spreadsheet and a message indicating the actual number of results will appear on the Criteria tab.

  1. Perform a Drug Pair Lookup query.
  2. Click the Export button associated with the Results list. The Export option is available for both VA and FDB results.
  3. Click the Export button to export the results of the Drug Pair Lookup query

  4. Click Open to display the query report;  click Save to save a copy of the report to your system.
  5. Choose what to do with the exported spreadsheet

  6. The spreadsheet contains two tabs:

See Also