Drugref 2 Prescribing Database
Drugref is OSCAR’s drug database service.
The drug list is abstracted from Health Canada’s Drug Product Database. The OSCAR Deb updates drugref quarterly.
The interaction service uses publicly available data from the U.S. National Library of Medicine (NLM), National Institutes of Health, Department of Health and Human Services
Both sources provide the data “as is” and neither endorse it nor OSCAR’s implementation.
Document Version History
- v1.0 – Initial instructions – Mar 1, 2023
Documentation Copyright © 2023 by Peter Hutten-Czapski MD under the Creative Commons Attribution-Share Alike 4.0 Unported License
Updating Drugref
There are two options to update Drugref manually
Option 1 – Within OSCAR
Administration > Integration > Update Drugref
Click on the “Update Drugref Database” link and wait about an hour
Option 2 – Directly with Drugref
Simply load drugref directly into your browser
https://localhost:8443/drugref/Update.jsp
You will have to wait until drugref is updated (about an hour) before the page will load, but when it does it will show you the current state of your updated database
Update Drugref Database!
| Table Name | Number of Rows |
|---|---|
| CdTherapeuticClass | 42649 |
| CdPackaging | 39146 |
| CdDrugProduct | 38561 |
| CdSchedule | 43711 |
| LinkGenericBrand | 38561 |
| CdForm | 47588 |
| CdPharmaceuticalStd | 22133 |
| CdDrugSearch | 78810 |
| CdRoute | 48595 |
| CdActiveIngredients | 96261 |
| CdInactiveProducts | 65609 |
| Interactions | 3872 |
| CdCompanies | 43433 |
| CdDrugStatus | 124054 |
| CdVeterinarySpecies | 4875 |
Time spent on importing data: 34 minutes
Time spent on new generic import: 3 minutes
Added Descriptor and Strength
Number of drug names being added descriptor: 1699
Number of drug names being added strength: 17662