Personal tools
You are here: Home / OSCAR EMR version 15 / 3.0 Administration / 3.12 Data Management

3.12 Data Management

These functions allows for patient data backup export and import functions in OSCAR 15

   Database/Document Download

  1. Log in to OSCAR with a user that has admin rights.
  2. Navigate to Admin > Data Management
  3. Click the "oscarDatabase/Document Download" link.  You will see something like the following
    15 Backup
  4. There are four types of file present.  One is a log file that is there to trouble shoot the backup script.  The largest file will be labeled Full.OscarBackup.oscar_15.2017-09-18-21:10:01.tar.gz.enc which contains enough to restore the specific OSCAR program you use, its configuration file, as well as the database and documents.  Files newer than the full backup contain just the database or the newer documents and are labeled as such.  Click the file names to save the files to the local computer.
  5. For a full restore you want three files, the Full Oscar Backup, and the newest database and document files.
  6. Restoring from a backup is a technically demanding endeavor and should be done by individuals familiar with linux, databases and the OSCAR program such as the approved Oscar Service Providers.

Demographic Export

 

This export is for transferring patient demographic, clinical and administrative data to another clinic, or to another compatible program.  Oscar will need to temporarily write to usr/local/temp for export to happen.

CMS Export

11x Demographic Export

The Patient Demographic Export abstracts files and exports them in a standardized import export format

  1. Click on the 'Demographic Export' (if you do not see this option contact your site support staff for privileges)
  2. Choose a patient set from the drop down menu that you defined earlier in the Demographic Report Tool.  In this case we have selected the list of patient(s) that we labeled '>65'
  3. What do you want to export?  Usually you want all options checked so 'Check All'
  4. Click the Export button to export into either of the two XML formats supported  a) CMS spec 4.0 format (OntarioMD) or b)  E2E-DTC (BC Pito). 
  5. The zip file can be used to import the patient(s) into another Oscar or other compatible software.  Alternately you can open it with a text editor or  Firefox  (the zip consists of a text file, a log file, and xml file) 

Diabetes Export

The Diabetes export  can be accessed here. 

  1. Identify the patient set
  2. Specify the date range
  3. Export!
  4. It will download a zip of XML files with certain data extracted from the chart as per OMD standard.

11x Diabetes Export

CIHI Export

  • The CIHI export is another specific format (Canadian Institute for Health Information) 
  • When this report completes the page will refresh with the generated file name appearing in the list.

11x CIHI export

 

Rourke 2009 Export

This export is of the older Rourke 2009 Forms on the system.  Most users have migrated to using the newer Rourke 2014 eForm.

 

Import New Demographic

This tool is to import patient(s) who have come from another clinic that uses Oscar, or other compatible software. 

  1. Click on Import New Demographic
  2. Browse to the file from the other system.  It has to be in CMS 4.0 spec format.  Leave the file zipped.
  3. Options, if offered usually best to leave at default values
  4. Import!

Merge Patient Records

The merge references one record as associated with the invalid record. The invalid record can be found using the search function of Oscar and when you open it up, it just loads the echart and demographic of the valid demo.

Technically the merge creates a pointer to the valid record and makes reading or writing to the invalid one difficult, by setting a role/object for provider "_all" with all rights denied for that demographic number.  Thus if there is information that you want kept, you should transfer it to the correct record before doing this procedure.

  1. Search normally and then change the demographic name so that they are close and you know which chart to keep
  2. Search again with the merge record facility so that both names are brought up
  3. Check the check boxes for the ones that you want to merge. 
  4. Click on the radio button for the main chart and
  5. Then click the button that says 'Merge Selected Records'

 

Merge

Update Patient Provider

If a set of patients needs to change the Resident, Nurse or Midwife that cares for them, choose from the former and replacement provider, as well as the last name patient range, from the drop down menus.  Then, click "Go".

11x Patient Provider Update

This example replaces the Resident 'doctor doe' with 'Peter Hutten-Czapski' for all of the patients with last names ending in A that were previously tagged as those for doctor doe

Document Actions

Product Dispensing

This is a new function available for those who need to maintain their own formulary from which they can dispense.

Fix notes with invalid role

  • If you have some notes which have a reporter_caisi_role of 0
  • This utility will fix them in a bulk way.
  • Make sure you know what you are doing!



Document Actions