Clinical Audit Tool Frequently Asked Questions
Medtech Clinical Audit Tool Frequently Asked Questions
This document contains important information for all Medtech Clinical Audit Tool users. Please ensure that this document is circulated accordingly. We suggest that this document is filed safely for future reference.
Copyright © Medtech Limited
Page 1 of 7
Clinical Audit Tool Frequently Asked Questions
Table of Contents PRELIMINARY FILTER ............................................................................................. 4 How do I view unenrolled, casual and registered patients?............................................................. 4 How do I limit the number of patients in the data grid to 15 per page? .......................................... 4 How do I view the patient data for the last 5 years? ......................................................................... 4
OTHER CAT FILTERS .............................................................................................. 4 How do I view all male patients 18 years old and over? ................................................................... 4 How do I view all patients on anticoagulant medication? ................................................................ 4 How do I select all patients with diabetes and/or depression?........................................................ 4 How do I select all patients equal to a certain age e.g. 14 & 49? ..................................................... 4 How can I quickly display another parameter from the data grid e.g. Ethnicity? .......................... 4
SCREEN MAPPER .................................................................................................... 4 How do I map a screening term? ......................................................................................................... 4
ELIMINATING/INCLUDING DUPLICATE RECORDS ............................................... 5 How do I eliminate duplicate records of patients from the data grid? ............................................ 5 How do I view entire records of patients in the data grid? ............................................................... 5
VIEWING INCLUDED AND EXCLUDED RECORDS ................................................ 5 How do I view the excluded data from a particular query? .............................................................. 5 How do I view the included data from a particular query? ............................................................... 5
PIE GRAPH FEATURES ........................................................................................... 5 How do I print a pie graph? .................................................................................................................. 5 How do I view a pie graph in 2D? ........................................................................................................ 5 How do I rotate a pie graph? ................................................................................................................ 5 How do I slice up a pie graph? ............................................................................................................ 5
Copyright © Medtech Limited
Page 2 of 7
Clinical Audit Tool Frequently Asked Questions
ACTIVATING PATIENTS FROM CAT ....................................................................... 6 How do I move a CAT patient onto the Medtech32 palette?............................................................. 6
ADDING RECALLS ................................................................................................... 6 How do I add a patient recall for a CAT patient? ............................................................................... 6
HEALTH STAT ACTION MENU ................................................................................ 6 What is the HealthStat action menu for? ............................................................................................ 6
CAT GRAPHS VS HEALTH STAT GRAPHS ............................................................ 6 Why do the HealthStat graphs and CAT graphs display different results e.g. Flu Vaccination 65+? ........................................................................................................................................................ 6
CAT RESULTS VS QUERY BUILDER RESULTS .................................................... 6 Why are the CAT results different from the Query Builder results?................................................ 6
PRELIMINARY FILTER, CPI REPORTS AND HEALTHSTAT ................................. 6 Why does the preliminary filter not work for CPI Reports and HealthStat? ................................... 6
MEDICATIONS .......................................................................................................... 7 Why are only some medications shown and not all the medications present in the filter? ......... 7
REPORTS .................................................................................................................. 7 How can I view PPP Queries? .............................................................................................................. 7 How can I view Pre-Defined Queries? ................................................................................................. 7
Copyright © Medtech Limited
Page 3 of 7
Clinical Audit Tool Frequently Asked Questions
Preliminary Filter How do I view unenrolled, casual and registered patients? On the preliminary filter, select ‘Casual’ and ‘Registered’ from the Reg Status field and ‘Declined to Enrol’ from the Enrolment Status field. To select multiple Reg Status, use Ctrl + click each option.
How do I limit the number of patients in the data grid to 15 per page? On the preliminary filter, select ‘15’ on the Records Per Page field.
How do I view the patient data for the last 5 years? On the preliminary filter, select ‘5’ on the Data Range field.
Other CAT Filters How do I view all male patients 18 years old and over? On the Demographics screen, select the Male tick box and enter 18 in the From Age field. Click the Get Values button to retrieve the data.
How do I view all patients on anticoagulant medication? On the Medications screen, unselect all the selected medications by selecting the Select All tick box. To select the anticoagulant medications, select all the medications in the Anticoagulant section by selecting the Aspirin, Clopidogrel and Warfarin tick boxes. Click the Get Values button to retrieve the data.
How do I select all patients with diabetes and/or depression? On the Classifications screen, uncheck all the selected classifications by selecting the Select All tick box. To select the diabetes and depression patients, select the Diabetes Mellitus and Depression tick boxes. Click the Get Values button to retrieve the data.
How do I select all patients equal to a certain age e.g. 14 & 49? Instead of using the Demographics filter, the Advanced Filter can also be used. To open the . Select Age in the Advanced Filter, in the Demographics screen, click the Advanced Filter icon ‘Select a field’ field, select “Between” in the ‘Select a condition’ field and enter the age values in the “From” & “To” field. Click the Ok button to retrieve the data. The advance filter can also be used to select various other parameters for age like greater than, less than, etc.
How can I quickly display another parameter from the data grid e.g. Ethnicity? To quickly display a graph for another parameter from the data grid, use the display filter located in the top right corner of the screen. To select another parameter, click on the display filter drop down and select a parameter. The corresponding parameter will be displayed.
Screen Mapper How do I map a screening term? In the CAT homepage, click on the Map Screening Terms link to open the Screening Mapper window. To map a screening term, click on the screening name e.g. HbA1c. Select the screening term from the Term drop down field and select the value from the Value drop down field. Click the Add button to add the screening term to the Screening Mapper window. Click the Ok button to create the screening term. Copyright © Medtech Limited Page 4 of 7
Clinical Audit Tool Frequently Asked Questions
Eliminating/Including Duplicate Records How do I eliminate duplicate records of patients from the data grid? To eliminate duplicate record sets of same patients, click on the “Eliminate Duplicate Record Set” icon . This will eliminate the multiple listing of single patient and list the latest data for each patient. For example in Classification screen if same patient has Asthma, CHD & Hypertension recorded and Asthma is the latest data recorded then clicking “Eliminate Duplicate Record Set” icon will remove the multiple listing of the patient for each of the diagnosis of CHD & Hypertension and will only show Asthma in the data grid.
How do I view entire records of patients in the data grid? By default CAT screen will show patients entire record set, but if the user clicks the “Eliminate Duplicate Record Set” icon it will only show the data for the latest entries, and the icon changes to . Clicking this icon will revert back to the default setting and show the “Show Entire Record Set” entire record set for each patient.
Viewing Included and Excluded Records How do I view the excluded data from a particular query? To view the excluded data, click on the View Excluded Records icon
.
How do I view the included data from a particular query? To view the included data, click on the View Included Records icon
.
Pie Graph Features How do I print a pie graph? To print a pie graph, right click on the graph and select ‘Print Chart’.
How do I view a pie graph in 2D? To view a pie graph in 2D, right click on the graph and select ‘View 2D’.
How do I rotate a pie graph? To rotate a pie graph, right click on the graph and select ‘Enable Rotation’. Then hold the left mouse button over the graph and move it clockwise or anti-clockwise.
How do I slice up a pie graph? To slice up a pie graph, right click on the graph and select ‘Enable Slicing Movement’. Then left click on the segment you wish to slice from the graph. Note: • •
If an interactive graph has less than 30 items, the graph will be displayed as a pie graph. If an interactive graph has more than 30 items, the graph will be displayed as a bar graph.
Copyright © Medtech Limited
Page 5 of 7
Clinical Audit Tool Frequently Asked Questions
Activating Patients From CAT How do I move a CAT patient onto the Medtech32 palette? To move a CAT patient onto the Medtech32 palette, click on the patient name in the data grid.
Adding Recalls How do I add a patient recall for a CAT patient? In the CAT data grid, select the patient by selecting the tick box in the All column. Add a patient recall by selecting the Do Recall Tasks For Selected Patients icon which will open the Patients Next Visit pop-up. Select the Patients Recall option and click Ok. This will open the Medtech32 Patient Recalls screen.
Health Stat Action Menu What is the HealthStat action menu for? When a user clicks on a Health Stat link in the Health Stat custom browser, the data results will be displayed on the Health Stat screen in the CAT custom browser.
CAT Graphs vs Health Stat Graphs Why do the HealthStat graphs and CAT graphs display different results e.g. Flu Vaccination 65+? The HealthStat graph displays the query results for your practice and the national sample. Clicking on the link to view your patients will open the CAT custom browser. The CAT custom browser displays the excluded patients for most queries e.g. all patients 65+ who have not had the flu immunisation vaccine. This has been intentionally designed so that the practice can view all outstanding patients i.e. patients that need to be contacted and vaccinated. Note: Health Stat only queries registered and funded patients
CAT Results vs Query Builder Results Why are the CAT results different from the Query Builder results? The way that CAT and Query Builder display results are quite different. For a particular query, Query Builder will display every instance of a record, even if 2 or more records are the same, whereas CAT will only display the latest instance of a record even if 2 or more records are the same. For CAT CPI Reports, if a patient has the same disease entered in History and Classification, CPI Reports will only show the latest dated entry of the disease whereas Query Builder will display both instances.
Preliminary Filter, CPI Reports and HealthStat Why does the preliminary filter not work for CPI Reports and HealthStat? The preliminary filter is not applicable to CPI Reports and Health Stat as CPI Reports and Health Stat queries display all the latest patient results, and not the historic results.
Copyright © Medtech Limited
Page 6 of 7
Clinical Audit Tool Frequently Asked Questions
Medications Why are only some medications shown and not all the medications present in the filter? The Medication screen uses the information in the MIMS tables. If the MIMS table is out of date, the medication information displayed will be inaccurate. When using CAT, always ensure that MIMS is up to date.
Reports How can I view PPP Queries? The PPP Queries, CPI Queries and Pre-Defined queries have been included as sub menus under the action menu “Reports”. Clicking on the PPP sub menu will display the 15 negative condition queries of the PPP in single screen with each graph representing one query.
How can I view Pre-Defined Queries? The sub menu of Pre-Defined queries is further divided into four sub groups of Screening Management, Registration Management, Read Coding Management & Chronic Disease Management. Clicking on any of these sub groups will display the graph and data for the queries coming under each category.
Copyright © Medtech Limited
Page 7 of 7
