Search the OSCAR Documentation
< All Topics

Preferred Pharmacies

Documentation Copyright © 2022 by Adrian Starzynski under the Creative Commons Attribution-Share Alike 3.0 Unported License

The PREFERRED PHARMACY: link lets you specify the patients preferred pharmacy to be printed on the Rx or to be faxed directly from OSCAR.

Access Preferred Pharmacies Setup

  •  At the right of the Prescriptions header, there is a dropdown for the Preferred Pharmacy for the patient. It is initially blank but you can click the Preferred Pharmacy link to access preferred pharmacy options.
  • Once you click PREFERRED PHARMACY: you will get a list of pharmacies that have been entered into the system. Search for the one you are looking for and select it from the list below the instructions to set it as the preferred Pharmacy.

Searching/Selecting Pharmacies

  • When you have a large number of Pharmacies listed, you can use the search to narrow the list as I have done with searching fo which captures Fort Erie Pharmacy, Fortino’s and Silver Fox. Not shown: you can search using multiple criteria at the same time.  Entering fo to and b for pharmacy city and postal code respectively, will narrow the search to Fortino’s in this list
  • Hover over a pharmacy and it’s information will be bolded. Click on it and the chosen pharmacy will be transferred to the Preferred Pharmacies column on the left.

Adding a New Pharmacy

  • If you can’t find the pharmacy in the list of existing pharmacies, you can always add it on your own using the Add a New Pharmacy link.
  • You should always check to be sure that the pharmacy you want to add doesn’t already exist or else there will be a mess of duplicates in your system!
  • Note: A pharmacy name and fax number is required to add a pharmacy
  • Fill in the blanks that appear on the screen. When you are finished, click Submit. You can edit information later on by selecting the Edit link in pharmacies search.

Managing Pharmacies

  • If you set more than one preferred pharmacy, the default position will be that of the top-most pharmacy listed in the Preferred Pharmacies column.
  • Use the Up and Down buttons to alter the order of the pharmacies.
  • You can unlink a pharmacy from the patient with the unlink button.
  • View Details link gives you the full pharmacy information
  • The Edit link will open the specific pharmacy and will modify the information for all users and patients (be careful!)
  • The Delete link will delete the specific pharmacy from all users and patients (be careful!)

Now, Fortino’s is the default (use the dropdown to select a different preferred pharmacy for the particular Rx) and you will be able to fax from Rx to the current indicated pharmacy.

Pharmacies Database

In most cases, your OSCAR system will come with a blank list of preferred pharmacies, meaning you will have to either add each one manually or have your OSCAR Service Provider (OSP) import a list through the back-end. This part is technical and meant only for those who know what they are doing. You have been warned! It is easy to mess up your whole pharmacies list if you don’t know what you’re doing here…

Since there are so many pharmacies, it’s a waste of time to manually add each one since a list already exists.

Here is a download link for a .csv file with all the pharmacies in Canada. This includes the pharmacy name/address/fax of all pharmacies in Canada (over 6,300!)

You could send this file to your OSP and ask them to import it into your OSCAR pharmacies table. It’s called the “pharmacyInfo” database table. You will have to modify the .csv file by adding the missing columns because this is required for the pharmacyInfo table. Different OSCAR versions may have additional columns in this table; you can check what columns your system has by running a custom query under Administration>Reports>Query By Example>in the Enter a Query field, enter (without the quotes): “select * from pharmacyInfo”

pharmacyInfo table columns
  • recordID: any number, normally sequential (required)
  • ID: leave this blank
  • name: pharmacy name (required)
  • address: pharmacy street address
  • city: pharmacy city
  • province: pharmacy province
  • postalCode: pharmacy postal code
  • phone1: pharmacy phone1
  • phone2: pharmacy phone2
  • fax: pharmacy fax (required)
  • email: pharmacy email
  • serviceLocationIdentifier: leave this blank
  • addDate: the date/time that the pharmacy was added, in computer time format like 2022-01-05 12:17:15
  • status: if the pharmacy is active it is 1, if it is deleted the status is 0. Deleted pharmacies don’t get really deleted; their status just changes to “0” so they get hidden from the pharmacies list in the front-end.

The recordID is how the system links preferred pharmacies to patients. If you already have pharmacies in your system and you import this file with the new list, then all the patients with current preferred pharmacies will be unlinked from that pharmacy since the recordID field was changed in the pharmacyInfo table.

If you currently have pharmacies and you want to import new pharmacies while keeping the existing ones linked to the patients who have it set, then you first have to run this RBT to export the pharmacyInfo table to .xls so you can work with it. Save the exported copy as a backup in case you need to revert! Then create a copy of the spreadsheet and edit the copied .xls in bulk, preserve the recordID fields of the pharmacies you want to keep, and then have your OSP override the pharmacyInfo table with your modified file. You can also add pharmacies to your spreadsheet, and create new recordID numbers and have that replace your pharmacyInfo table so that you can use your modified version while preserving existing pharmacies.

Table of Contents