FDB Search Tab

Use this tab to search the FDB Information Framework database for drug information. Each search returns a list of FDB packaged drugs even if the search criteria is for another drug concept. For example, a generic-based search searches the FDB Generic Drug concept for matches and returns a list of all packaged drugs associated with the matched generic drugs.

FDB search options are controlled on the User Preferences page. Altering preferences can cause any particular search to return different results.

To Search:

  1. Click the COTS Services tab. The system opens the FDB Search tab.

  2. In FDB Search Option Type, select an option from the drop-down list. See the list below for information on each type.

  3. In FDB Search String, enter search text.

  4. Click the Perform FDB Search button. The system displays first 501 items that match the query in a results table below.

  5. Click the Hide Existing PPS button below the results table to compare all of the NDCs in the search results and remove those that match NDCs that are already present in PPS-N.

After you have search results, complete any of these tasks:

FDB Search Option Type List

All

Select this option to search all FDB entries.

NDC

Enter at least five digits to search based on the NDC number. The system searches the first five digits of the 11-digit NDC number of the FDB Packaged Drug. The normal PPS-N data entry validation rules apply (numeric and correct format). The system displays an error message if your entry does not comply with the rules.

Label

Select this option to search based on the FDB Label Name Field.

Generic

Select this option to search based on the FDB Generic Drug Name Field.

GCNSEQNO

Select this option to search based on the Generic Code Number Sequence Number, which is a numeric value that corresponds to the Generic Code Number Sequence Number of an FDB generic drug. The normal PPS-N data entry validation rules apply (numeric only). The system displays an error message if your entry does not comply with the rules.

Drug Class

Select this option to search based on the FDB Drug Class.

The grouping of drug products is based on various criteria, which can include similarity of chemical structure, clinical indications, pharmacology, and therapeutic activity. Drug class includes fields for both the FDB Generic and the FDB Dispensable Drug.

Figure: FDB Search Tab with Results

FDB Search Tab with Results