The Drug Product Database (DPD) Online Query search is NOT case sensitive. If the search result exceeds the limit, users will need to refine their search in order to reduce the number of records returned.
Punctuation marks, such as commas, colons, parentheses, brackets, hyphens, or wildcards should not be used in searches as the DPD online does not recognize any.
There are three ways to query a product:
Each method is explained directly below and at least one example is provided.
Figure A - Drug Product Search Engine
A DIN is an eight-digit number assigned to each drug product authorized for use in Canada. In order to properly use this search option, users should:
The result query should only return one record due to the uniqueness of a DIN. Please note that searching by DIN is a search on its own, regardless of the search criteria entered in section 3 (See Figure A above). That is, the DIN field is independent of other search fields (e.g. company, brand name, active ingredient and/or Active Ingredient Group Number).
ATC code is searchable using any characters. A search can be done using a minimum of one character for the code or as many as 7 characters. If one character of the ATC Code is entered then the search result will be broad. However, if all 7 characters are entered then the search result will be more precise. Please note that ATC codes are displayed up to the 4th level only.
In order to properly use this search option, users should:
Please note that searching by ATC code is a search on its own, regardless of the search criteria below. It is also important to note that if there is more than one record found, the Search Results Summary page will be displayed.
If the DIN or the ATC code is unknown, leaving those fields empty provides users the flexibility to search by any single or by any combination of the following fields:
In order to properly use this single or combination search option, users should select appropriate status. Enter choice of a single search or any combined search criteria in any of the fields listed above, and then click the "Search" button or press "Enter".
Furthermore, if only one word is entered as the search criteria, the system will automatically search it as a complete or partial word. Therefore, searching by 'ethyl' will include 'ethyl acetate', but also 'diethylamine salicylate' and 'vitamin b12 (methylcobalamin)', among others. As mentioned above in Note (2), if more characters are entered as the search criteria, the more restrictive the search will be. Thus, searching for 'diethylamine' will only return drugs containing ingredients with names like 'diclofenac diethylamine', or 'diethylamine salicylate', since diethylamine is not a part of any word used to describe active ingredients.
Searching for 'folic acid' will exactly return products containing 'folic acid', but also 'folic acid (calcium d-pantothenate)' and 'folic acid (yeast)', among others. The word 'folic' can be preceded by any other word or prefix in the Active Ingredient names, just as the word 'acid' can be followed by any other word or suffix, but the exact sequence folic+space+acid has to be present inside the name otherwise it will not return the proper results.
If you wish to obtain a list of all marketed DINs for a company, then users will at least need to qualify the following search fields:
The search results can be further refined if additional search criteria are entered. That is, if the user wishes to obtain all capsules from Apotex Inc. that are marketed, then 'Capsule' should be selected in the 'Dosage Form' pick list.
Users can use the AND / OR operator for the Active Ingredient field only to refine their search. These types of queries are usually geared for advanced users.
Users will need to query for a product by entering a DIN, ATC, or a combination of fields such as Company Name, Product Name, and/or Active Ingredients at the front page of the DPD search engine. Once the query is performed, a 'Search Results Summary' page will appear. Users will have the ability to identify which DINs have a PM or PI attached. A column called 'Product Monograph' was added immediately after the 'Class' column. Please note that Health Canada will use the same functionality as the PM in the DPD to also post Prescribing Information; however, the column labels in the 'Search Results Summary Page' will remain as 'Product Monograph'. The information found in the column will contain either 'YES' or 'NO'. The 'YES' represents that the product contains a PM or a PI and the 'NO' represents that there is no available documents at this time. The PM or PI version released reflects the latest Health Canada document and may not be identical to the version maintained by the product sponsor.