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:
- by Drug Identification Number (DIN),
- by Anatomical Therapeutic Chemical (ATC) Code,
- by single/multiple field combination.
Each method is explained directly below and at least one example is provided.
Figure A - Drug Product Search Engine
1. Search by Drug Identification Number (DIN)
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:
- Enter the correct eight-digit DIN in the DIN field (e.g. 02155907),
- Then click "Search" button or press Enter.
- The result should return specific information for the product queried. For DIN 02155907, the product information for ADALAT XL - SRT 30MG will be returned.
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).
2. Search by Anatomical Therapeutic Chemical (ATC) Code
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.
- Entering 'B' in the search field would return all products with the same anatomical group 'BLOOD AND BLOOD FORMING ORGANS'
- Entering 'M01' in the search field would return all products with the same therapeutic subgroup 'ANTIINFLAMMATORY AND ANTIRHEUMATIC PRODUCTS'
In order to properly use this search option, users should:
- Enter the ATC code in the appropriate search field.
- Then click "Search" button or press Enter.
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.
3. Search by the Other Criteria
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:
- Product Name
- Active Ingredient(s)
- Active Ingredient Group Number (10-digit number)
- Route(s) of Administration
- Dosage Form(s)
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".
- To search by status, click on the appropriate status from the picklist.
- Using more search fields and criteria (Company, Product Name, Active Ingredient, Dosage Form, Route of Administration, Regulatory Schedule, and Active Ingredient Group Number) will allow users to further narrow their search result.
- Several logical operators such as 'AND' / 'OR' for the Active Ingredient Field and 'Control' / 'Shift' functionality for the Dosage Form and Route of Administration pick lists are available to users to ameliorate the search result.
- Words entered in any of the search fields are treated as a string of characters. A space is treated as any other character in the string.
Example 1: Single Criteria Search
- Company: ACME Canada Pharmaceutical Inc.
You can enter: acme
or acme Canada
or ACME Canada Pharmaceutical
or acme canada pharmaceutical Inc
- Product Name: Regular Strength Tylenol Cold daytime
You can enter: Tylenol
or Tylenol cold daytime
or regular strength tylenol
or regular strength tylenol cold
or regular strength tylenol cold daytime
- Active Ingredient: Ethinyl Estradiol
You can enter: Ethinyl
or Ethinyl Estradiol
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.
Example 2: Multiple Word for a Single Criteria Search
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.
Example 3: Single Entry Search for a Specific Drug Status
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:
- Status = Marketed
- Company = Apotex.
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.
Example 4: Combination Entry Search using the 'and' / 'or' Operator for Active Ingredients
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.
- If a user wishes to obtain information on oral products containing two specific active ingredients (e.g.: LEVONORGESTREL and ETHINYL ESTRADIOL) that were cancelled post-market, then they will need to qualify the following parameters using the appropriate logical operators:
- Status = Cancelled Post Market
- Active Ingredient = LEVONORGESTREL AND ETHINYL ESTRADIOL
- Route of Administration = Oral
The 'AND' operator can be typed directly in the search field and will only return results for all oral products specifically containing LEVONORGESTREL and ETHINYL ESTRADIOL anywhere in the name as active ingredients and exclude all product containing only one active ingredient that was entered.The 'OR' operator will do the opposite, the result will only return products containing one active ingredient or the other (e.g.: LEVONORGESTREL OR ETHINYL ESTRADIOL). This will naturally return a larger number of results, since any drugs having EITHER an active ingredient with a name that includes the string 'LEVONORGESTREL' OR any ingredient which includes the string 'ESTRADIOL', anywhere in its name will be returned. For instance, a single-ingredient drug that contains 'PYRITHIONE ZINC' will be returned, just like a multiple-ingredient drug that contains 'SELENIUM (YEAST)'. Drugs that have both some selenium and some zinc would also be returned, since having both also satisfies the criteria of having either one or the other.
- If a user wishes to obtain information on all sunscreen products which are currently marketed in Canada and which contain at least three active ingredients (e.g. OXYBENZONE, OCTINOXATE, and OCTISALATE) or include all sunscreen products with one active ingredient (e.g.: OCTOCRYLENE), users will need to qualify the following parameters using the appropriate 'AND' / 'OR' logical operators:
- Status = Marketed
- Active Ingredient = OXYBENZONE AND OCTINOXATE AND OCTISALATE OR OCTOCRYLENE
- Route of Administration = Topical
- Dosage Form = Lotion
4. How can I access the Product Monographs (PMs), the Prescribing Information (PI), or the Veterinary Labelling?
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 either a PM, PI, or a Veterinary Labelling 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 and Veterinary Labelling; 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, PI, or Veterinary Labelling and the 'NO' represents that there is no available documents at this time. The PM,PI, or Veterinary Labelling version released reflects the latest Health Canada document and may not be identical to the version maintained by the product sponsor.
- Date modified: