Personal tools
You are here: Home / Older Versions / V 9.x / 1.0 General Operation / 1.5 Reports / 1.5.1 Administration View: oscarReport

1.5.1 Administration View: oscarReport

Describes reports shown in the Administrative View.

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

 Query by Example

  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

Report By 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. 

Rostered Patients

 

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. 

You can PRINT export to spread sheet as CVS or XLS from this

screen

Query Results

 

 

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.

 

  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 perticular 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, phone number, 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. Click on “Flu Billing Report” at oscarReport section
  3. Select a year (it will default to search the period 2002 and 2003) and a provider you wish to generate (It is recommended not to general all Provider or it needs to take 1-2 minutes for the complete process)
  4. Click Generate Report (normal wait for 30 secs)
  5. The yellow patient rows mean they haven’t had a flu shot while the purple means have had a flu shot on a specific date.

 

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 with this feature.

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

ACTIVITY REPORT

PROVIDER SERVICE REPORT


Provider Service

 

  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

Document Actions