warning: Creating default object from empty value in /home1/werthei1/public_html/wcworks/modules/taxonomy/taxonomy.pages.inc on line 33.
Open Source Clinical Application Resource

OSCAR... What is it?


OSCAR is Open Source Clinical Application Resource. It was developed at McMaster University and has a web site at http://www.oscarcanada.org/ We are currently working on adding modules for Quebec (RAMQ) billing.
Hint: You can use the Search tool in the left side to find all Oscar related articles or click on the key-word below the title of each article.
Useful Oscar related links:
Oscar Canada: http://oscarcanada.org/
Oscar Canada blog: http://oscarcanada.blogspot.com/
Oscar PEI: http://blog.oscarpei.net/


Welcome to the Wertheimer Works Inc. web site. We will keep track of software installations, updates and development.
I do a lot of development in DataEase, a very old but incredibly useful database development tool.
EDI is another large part of my business. I've developed a few EDI translators. One is written using DataEase and is called Spe+EDI http://www.spe-edi.com , the other uses Oracle PL/SQL. Most of the EDI work that I do is with Department Stores (WalMart, Sears, etc). None of it is in the Healthcare industry (yet), which brings me to:
OSCAR, an Open Source application for Healthcare professionals. This is an amazing tool that runs on any browser, using a set of popular Open Source applications (Linux, Java, Apache, MySQL, Postgres, etc). A lot of the Oscar related content here is aimed at people new to Linux and Java.
You can contact me at (514) 891-3275 or earlw@spe-edi.com I am located in Montreal, Quebec, Canada.

Oscar SQL Tips

Here are some tips for using SQL commands.
You can run any SQL command that reads data (Ex. select) by using the Admin, oscarReport, Query By Example option.
You will see a window labelled 'Enter a Query'.  Enter your SQL commands and press Query to execute it.
If the syntax is invalid, nothing will happen.
(Ex. select count(*) from demographic to see how many records are in the demographic table )

Adding Preventions to Oscar


The list of Preventions are contained in two XML files.

Oscar in the News


 With the $1 billion Ontario eHealth controversy, Oscar is in the news...
Slashdot - News article
CBCNews.ca - News story
Global Toronto - Video

Oscar Installation Troubleshooting


Oscar is installed, but isn't running.  Here are some ideas to help troubleshooting.
Before Installation
If you have already installed Ubuntu and Oscar, and having problems, see below.  This paragraph is not going to help ;-(
If you decide to start again from scratch, then the following tips may make your life a bit easier.
Indivica (David Daley) has published an excellent installation guide.  You can find it at http://indivica.com/?page_id=123  Use it.

Oscar and Quebec (RAMQ) Billing


Much of the Quebec billing information can be found online at: http://www.ramq.gouv.qc.ca/fr/professionnels/devlog/index.shtml
Most (if not all) of the info is in french, I will do my best to translate the relevant documents from french into english.

There is a process and forms to be filled out to become an approved provider of electronic data. This does not prevent or restrict access to information.

OSCAR Billing


Understanding the Ontario billing module.

/usr/share/tomcat5.5/oscar.properties has parameters that control the Billing processes
billregion=ON is the default. This can be BC or QC (soon)

/oscar_source/web/billing/CA/ON/billingON.jsp is the main Billing input form source.
/usr/share/tomcat5.5/webapps/oscar/billing/CA/ON/billingON.jsp is the same

There are a number of hard-coded choice fields:

Visit Type (xml_visittype)

Billing Type (xml_billtype)

  • Bill OHIP / ODP
  • WSIB / WCB (Worker's Compensation Board)
  • OSCAR demographic error


    When entering a demographic (patient), it is possible to enter a blank effective date. This will cause the display to error.

    You can use the following mySQL commands to repair the record:

    Open a terminal session.
    (You enter the stuff after the $ or > )

    $mysql -uroot -pyour-mysql-password
    The system should display "Enter password:"
    Enter your mySQL administrator password.

    The system will display a welcome message followed by the mysql> prompt
    mysql> use oscar_mcmaster ;

    Syndicate content