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:
Click the COTS Services tab. The system opens the FDB Search tab.
In FDB Search Option Type, select an option from the drop-down list. See the list below for information on each type.
In FDB Search String, enter search text.
Click the Perform FDB Search button. The system displays first 501 items that match the query in a results table below.
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:
Print
FDB Search Results to print NDC
search results
(or export to CSV
or Excel spreadsheet)
Review NDC Details to see NDC details
Match Results to match selected NDCs to existing items in PPS-N
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