Search the OSCAR Documentation
< All Topics
Print

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 NameNumber of Rows
CdTherapeuticClass42649
CdPackaging39146
CdDrugProduct38561
CdSchedule43711
LinkGenericBrand38561
CdForm47588
CdPharmaceuticalStd22133
CdDrugSearch78810
CdRoute48595
CdActiveIngredients96261
CdInactiveProducts65609
Interactions3872
CdCompanies43433
CdDrugStatus124054
CdVeterinarySpecies4875

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

Table of Contents