1.5.1 Administration View: oscarReport

Users with Administrative Role set can enter the Admin tab and access the following reports

QUERY BY EXAMPLE

If you know how to use SQL language, you can create your own search queries, personalizing your search of patient demographics. Similar to the Demographic Report Tool in the Report Tab

1. Click on the "Query By Example" link
   
2. Either free enter the SQL OR
3. Select from past saved queries by choosing from the drop down menu, then clicking "Load Query"
4. Click the "Query"  button and
5. Your results will show below on the same page

You may view your query history and edit your favourite queries by clicking on the corresponding links on the upper left corner of the window

REPORT BY TEMPLATE

Report by Template is a powerful query engine that allows for non technical people to run standard reports.  A tutorial for this is at www.oscarcanada.org

To add a template you click on the Add Template link.  You can devise your own or use one developed by the community and posted at

http://www.oscarcanada.org/oscar-users/emr-resource/report-templates

To run a template first you click on a predefined template for your clinic, for example 7. Rostered Patients

By intent many of the options are hidden by default, by clicking the Show/Hide link they are shown here. 

 If you simply click "Run Query" then you get the results on the same screen

By intent the Query is hidden by default, by clicking the Show/Hide link it is shown here. 

screen

 AGE/SEX REPORT

This report gives you the statistics for the number of patients in each age group and each sex for a practice.

1. There are 3 types of reports you can select: Rostered, Non-rostered, and Total
2. Click the check box beside one of the above 3 for the type of report you want to create
3. Select a provider from the drop-down menu or select ‘all providers’ if you want a report on all the doctors in the office
4. Select a begin and end date by clicking on the word links to get a calendar.
5. Clicking on a day will insert the date into the date box
6. Click ‘Create Report’ button
7. To the far left is the age range
8. Across the top give you the division between male and female
9. The #### column gives you the numeric count

• The %%%% column gives you the percentage of females or males compared to the total of that sex. Totals are across the bottom
• You can continue to create a report for each doctor by changing the doctors name and clicking ‘Create Report’ again
• You can continue to create one of the other types of reports by clicking on another type of reports and clicking the ‘Create Report’ again
• The printer button is in the upper left corner to print the reports

VISIT REPORT

This is a report to analyze the types of encounters you are doing in your practice, hospital, clinic, house call etc.

1. There are 2 types of reports you can select: Larry Kain and Visit

• Larry Kain report is a specific report of the total numbers for a clinic, broken down into clinic visits, HHS (4 Hamilton hospitals) and All other (house calls and St Josephs hospital)

• Visit Report is a much more definitive report, giving a breakdown of each doctor, nurse and grouped into teams. The people included in this report can be edited through the ‘Manage Provider List’ link on the upper right corner of the screen.

To Begin

1. Click the radio button beside one of the two types of report you want to create
2. Select a begin and end date by clicking on the word links to access a calendar
3. Clicking on a day will insert the date into the date box
4. Click the ‘Create Report’ button
5. You can continue to create one of the other types of reports by clicking on another type of report button and clicking ‘Create Report’ again

Manage Provider List For Visit Report

This gives you a complete list of all providers, past and present, drawn from the ‘Providers Records’ at the top of the Admin Screen.

1. Click on the ‘Manage Provider List’ link on the upper right corner of the screen
2. Click on the checkmark box beside each person you want on the report and in the team you want them to show up
3. When you are finished, click on the ‘Submit’ button at the bottom of the screen

PCN CATCHMENT REPORT

The PCN Catchment Report is a program written for doctors who are part of the Primary Care Reform Health payment module. This report is used as a double check to make sure patients outside of your allotted area have not been rostered in error. The patients showing on this report would have to be de-rostered and seen on a fee-for-service basis.  In the example below the patient from Alliston should be derostered as the practice is centred in the tri-town.

1. Under oscarReport click on the ‘PCN Catchment Report’ link
2. This will automatically check the database and display a report of patients with postal codes outside your particular PCN Catchment Area only
3. The report only shows 50 patients at a time on the screen & you will need to click on the link on the upper left corner of the screen to view other pages.
4. The printer button is in the upper left corner to print the complete report

FLU BILLING REPORT

Criteria: Patient Name, DOB, sorted by physician, 65 years and older, have NOT had a flu shot as of (start date if needed each year), billing codes G590A and G591A Patient Status: of AC and UHIP, + Roster Status of RO, NR,FS, RF, PL.  Anything else taken out.

1. Click on the ‘Flu Billing Report’ link
2. Select a year (it will default to search the current year)
3. Click on a provider (it will default to all providers) you wish to generate
4. Click update Report
5. The billing date is that date of the billing done in that specific year.  If it is blank they have not been billed.

OVERNIGHT BATCH ELIGIBILITY CHECKING

Use this report for a quick way to check the validity of patients' health card codes.  See Chapter 6- Health Card Version Codes for details.

SURVEILLANCE REPORT

Monitor the number of surveys being conducted.

To enable this feature add the following lines to the oscar.properties file

#Survey configuration file location
surveillance_config_file=/usr/share/tomcat6/surveillance-config.xml
#Survey Export directory
surveillance_directory=/var/lib/tomcat6/webapps/OscarDocument/oscar/surveillance/

<survey surveyTitle="Flu Survey" randomness="10" period="1" surveyId="flu01">
       # SurveyTitle = Title of survey
       # randomness = 10  this means one in ten, one would be every patient seen would be surveyed
       # period = 1  The time before this patient will be considered to be randomized again.
       # surveyID = just a unique id

        <surveyQuestion> html that will display  </surveyQuestion>

       # provider numbers that will see the survey
        <provider>17</provider>
        <provider>180</provider>

       # possible answers
        <answer status="D" value="">Ask Later</answer>
        <answer status="A" value="Y">Yes</answer>
        <answer status="A" value="N">No</answer>
        <answer status="A" value="R">Don't Ask Again</answer>

        # export Query to pull data out
         <exportQuery>select s.surveyDataId, s.survey_date, s.answer, d.year_of_birth, substring(d.postal,1,3) as postal from surveyData s, demographic d where s.demographic_no = d.demographic_no  and processed is null and status = 'A' and s.surveyId =  </exportQuery>     

        # export format 
         <exportString>"${surveyDataId}"&#09;"${survey_date}"&#09;"${answer}"&#09;"${year_of_birth}"&#09;"${postal}"</exportString>
                                                                                    
</survey>

The Survey(ies) can be queried through the links offered on the Admin view

If you clicked on the Flu survey above the question would be shown as well as the settings and the results as below.  One No answer, one Answered status and one Declined survey.

REHAB STUDY

View the results of the Encounter Forms which have been included as a part of this research study.

EXPORT PATIENT LIST BY APPOINTMENT TIME

Does what it says.  Select the doctor(s) and date range and get a comma delineated text file

ACTIVITY REPORT

PROVIDER SERVICE REPORT

1. Insert the start date
2. Then the end date
3. Click EXPORT
4. Download the CSV file (Firefox shown)
5. Open with a Spreadsheet with separators set to Comma (Open Office dialog shown)

POPULATION REPORT

CDS REPORT

MIS REPORT

OCAN REPORT

DISEASE REGISTRY REPORT

This report will let you pull data from the Diagnosis Registry.  Lets say you want to search all the patients you have registered with diabetes.  You can simply type in the code or the name and a pick list will show with the possibilities.  Select your code(s) and add them one by one (or by group) with add.

After you have added the diagnosis that you are interested in then you can select your doctor and the selection type.  Distincted means that for multiple diagnosis each patient will show once for each applicable diagnosis.  Otherwise the patient will show if they have either of the diagnosis being searched against.  Here is a report for Diabetes and Hypertension (either one) showing the first two results Helen and David.