<< Return to WorldOSCAR.org

Introduction

The purpose of this tool is to identify discrepencies in the roster status of patients. In particular, it is designed to compare lists of patients marked as rostered according to OSCAR against the XML list of rostered patients supplied by the Ministry of Health, to identify patients in only one list.

This tool is designed to do all analysis and comparison locally on a client browser. Put another way, it does not transmit any data to a third-party server. Consider reviewing the source code of this page to satisfy yourself to this effect. Also, note that this program has been tested ONLY on Windows based computers. Sorry, we don't know if it will work on OSX.

Lastly, this tool has been made available to the public by Magenta Health without any warranty or guarantee of any sort. Please rely on this tool entirely at your own risk.

Instructions

  1. Type the last name of the MD according to OSCAR:

  2. Type the first name of the MD according to OSCAR:

  3. Run the following query in OSCAR's query by example:

    SELECT concat(demographic_no,',',hin,',',last_name,',',first_name) FROM demographic WHERE roster_status = "RO" AND provider_no IN (SELECT provider_no FROM provider WHERE last_name = "" AND first_name = "")

  4. Copy and paste the result, starting at the first row of data, into the following box


  5. Open the downloaded XML file for the MD in Notepad++, and copy everything into the following box