This query is designed to provide approval information for the ingredient
Input:
| Parameter |
Example |
Mandatory |
Notes |
| Ingredient Concept ID |
1713332 |
Yes |
Concept ID for ingredient - 'Amoxicillin' |
Sample query run:
The following are sample runs of the query. The input parameters are highlighted in blue.
SELECT ingredient_concept_id,
c.concept_name AS ingredient_name,
approval_date,
approved_by
FROM drug_approval a, concept c
WHERE ingredient_concept_id = concept_id
AND ingredient_concept_id = 1713332
Output:
Output field list:
| Field |
Description |
| Ingredient_Concept_ID |
Concept ID of the ingredient |
| Ingredient_Name |
Name of the ingredient |
| Approval_Date |
Date when ingredient has been approved |
| Approved_By |
Agency that has that approved ingredient |
Sample output record:
| Field |
Value |
| Ingredient_Concept_ID |
1713332 |
| Ingredient_Name |
Amoxicillin |
| Approval_Date |
12/9/1974 |
| Approved_By |
FDA |
| 