Home

PCS Clinical Audit Tool – User Guide

1. m Fierro By Actve Patert Condition Pregnancy Yez Viteerg ly Mee Patent Cancion ities Yes Fierg By actos Pairt Lak Reads ce 12 rare Condtors JCadowscculy Yes Medeabons Groen Na Ferg By Actws Potent Conditions sides cul Vesk Mabosi Anttepoteceiver Bets Biocken No Dieter Nal Fiterme By Age 43 Actos Par CHILDREN 3 TO 12 YEARS CF AGE Fieiro Br Age ds 3 Age ce 12 Active Parier COABETES PATIENTS REQUIRING DIAGNOSIS REVIEW Fiir By Actve Paart Conditions Unekfined Diabetes Yez FEMALES 926 YEARS OF AGE Fiber py Farenins Aga ve 9 Age ce I Acton Patient ME ART AT TANS LAST 12 MTINTHS He driva Paiet Fette ME eel dr Meade cw 12 nde M EET OOR ale BP Medosioer Datei SIP mere QV Evert Rik HMR bunursstions Standa Report Figure 5 10 2A Loading a saved filter Click the Recalculate button 13 June 2012 PAGE 26 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 11 3 Setting a default filter A saved filter can also be set as a default so it will be automatically loaded when CAT opens e From the Default Filter drop down list choose the filter you would like to have preloaded Filter Name Description ACTIVE PRACTICE POPULATION Filtering By Active Patient ADULT HEALTH CHECKS 45 49 Filtering By Age gt 45 Age lt 49 Active Patient ANTENATAL REGISTER Filtering
2. Figure 6 2 1A Demographics Report The bar chart report provides the following features e Select All checkbox e Show Total Counts checkbox only available where counts are not shown by default e Age bracket selection box only available for bar charts grouped by age e Print button e Export button These are explained below 13 June 2012 PAGE 32 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Select All checkbox click this checkbox to select all segments of the graph legend is also selected Sdeded Ap Fenda Med Dem Breakdown EISER graphic by Age poputabon 253 E Selecta 7 Show Tots Counts Females 173 Nalaz 20 Other 0 Cofee Ga Mae 00 t4 75 73 na 65 68 amp 0 amp amp Figure 6 2 1B Select All Show Total Counts checkbox click this checkbox to display the count in each group 69 2 Age Figure 6 2 1C Show Total Counts Age Bracket selection box this allows you to select an age bracket value between 1 and 10 years The default value is 5 which displays ages grouped from 0 4 5 9 etc Changing this value for example to 10 would display as below The change is effected immediately on the chart P 50 59 40 49 Figure 6 2 1D Age bracket selection Print button click the Print button to print a copy of the graph Export button this allows you to obtain a list of patients making up any segment of the bar
3. FBG displays your data as a breakdown of FBG status 5 596 5 5 7 0 7 096 No FBG Recorded The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 20 1 FBG Mappings with Clinical systems The FBG mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical application Note Medical Director sometimes refers to FBG as BSLF Blood Sugar Level Fasting 6 2 21 INR International Normalised Ratio Pathology INR displays your data as a breakdown of INR status 1 5 1 5 2 0 2 0 3 0 3 0 4 0 4 0 No INR Recorded The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 21 1 INR Mappings with Clinical systems The INR mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical application 13 June 2012 PAGE 51 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 22 Spirometry Measurements gt Spirometry displays your data as a breakdown of date last recorded lt 6mths 6mths 1yr 1 2yrs gt 2yrs No Spirometry Recorded The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 22 1 Spirometry Mappings with Clinical systems The Spriometry mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical applicati
4. A pie chart displays the of patients who are required to have an FOBT test i e are not ineligible and have had an FOBT test order or result in the last 12 months in the following categories e FOBT Order and result an FOBT test result has been received in the last 12 months with an order recorded within 6 months prior e FOBT Order only an FOBT order has been recorded but no result has been received e FOBT Result only an FOBT order has been received but no order is recorded This graph allows the clinician to follow up patients who have had an order placed but where a result has not been received The FOBT category of Ineligible includes patients that are no longer required to have an FOBT test because they have a coded condition that implies exclusion Check the mappings for your clinical system 6 2 13 1 FOBT Mappings with Clinical systems The FOBT smear mappings are provided in the General Data Mappings Appendices for each Clinical application 13 June 2012 PAGE 47 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 14 Lipids Pathology gt Lipids displays your data as a breakdown of e Cholesterol lt 4 0 gt 4 0 and lt 5 5 gt 5 5 and lt 6 5 gt 6 5 and lt 7 5 gt 7 5 No Cholesterol Recorded e HDL lt 1 0 gt 1 0 and lt 2 0 gt 2 0 No HDL Recorded e LDL 25 gt 2 5 and lt 4 0 gt 4 0 No LDL Recorded e Triglycerides lt 2 0 gt 2 0 and lt
5. All You can select to filter by patients that e Have a current medication tick the Yes box e Do not have a current medication tick the No box If you tick one of the main medication headings bolded the sub heading selections will not be available and all patients matching that broad medication category will be selected 5 6 1 Medications Filter Mappings with Clinical systems The medications filter mappings are provided in the Medications Data Mappings Appendices for each Clinical system Medications are flagged as true if they are on the patient s current medication list The collection process does not make any decisions about whether a medication should actually have been removed from the current medication list The GP is responsible for making sure the list of medications is accurate 13 June 2012 PAGE 21 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 7 Results Filtering S Clinical Audit Fie Edt Hep Cm E Caen ere EIER C General Conditions Medccalions Last Recorded Result The dale range selected wil filler out results that are not within the selected period and treat Ihem as nol recorded This fier is only applicable to some reports O al O 26 me es 12 mths Q 224 mhs Date Range Irom to 03 08 2008 w 03 09 2008 Y Figure 5 7A Results Filtering This filter allows the user to view the last recorded result
6. Exchde E Mele E atsi Start Age Ay Noe T7 Active 3cin ys EEN E female E mn ATSI End Age lt 15mihs E Net Active Gity Suburb hdude Exclide E Other 7 Not Recorded Ys Mhs 30mhs Maite in leet 6 mthe DVA Health Cover Date Range ficte comma seperated w dcard T OVA 7 Medicare No E No V No Age 05 07 2010 to 05 07 2010 Hes Not Vsted n last 7 nan OVA Y mhs ll EE Gear General Figure 5 4a Demographic Filters Patient data can be filtered as follows Gender Male Female Other No selection All Note Ticking multiple boxes will create an OR criteria ie Male OR Female Ethnicity ATSI Aboriginal Torres Strait Islander non ATSI Not Recorded No selection All Note Ticking multiple boxes will create an OR criteria ie ATSI OR non ATSI DVA DVA Department Veteran Affairs non DVA No selection All Age 1 Enter a numeric start age or end age to limit your selection Choose Years default or Months as your search filter for start end age Note choosing Months will display the Demographics graph in months 2 No Age ticked will search for patients with a missing date of birth Health Medicare No Recorded Cover Medicare No Not Recorded No selection All Status A drop down list of Communcare Patient Status flags Communicare Users only 13 June 2012 PAGE 18 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Last Visi
7. User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 4 Allergies and Pie Chart functions Allergies displays your data as a breakdown of allergy status Allergy Recorded No Known Allergies Nothing Recorded The data is displayed as a pie chart The patient count in each allergy status group is displayed for each segment of the pie chart 5 Clinical Audit Fe UK Tools Heb Me calCiccho 3 HON Live Osta Fitting By Cordilione Asthma Ves Fersslez Dorogon Alesget Sacung Alcohol Mestues Panoz Disease Pap Se Medcakons Diabetes SP leni CV Even Fick ENA Ineaitetont Sands dFecots NES lev S949 Check O sae aa 7 SherePricringe Espot Free Allergy Status population 173 105 Ho Krown Allergies 35 Nothing Recorded Figure 6 2 4A Allergies Report The report provides the following features e Select All checkbox e Show Percentage checkbox e Print button e Export button These are explained below 13 June 2012 PAGE 38 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Select All checkbox click this checkbox to select all segments of the graph legend is also selected Selected Allergies Allergy recorded NKA Not recorded Demographics Allergiese Select All Allergy Status population 173 Allergy Recorded EE No Known Allergies ET Nothing Recorded 105 No Known Allergies 35 Nothing Recorde
8. e Not Recorded e 4years ago e 3 4 years ago e 2 3 years ago e 1 2 years ago e lt 1yearago Within each subcategory there is a further breakdown by age range 18 29 30 39 40 49 50 59 60 70 Total Count and Percentage is provided for each report line item e Percentage at the subcategory level is against the category total e Percentage at the age range level is against the subcategory total 13 June 2012 PAGE 46 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 12 Screening gt Mammogram The Mammogram tab provides e Mammogram Last Recorded A pie chart displays the of patients with a Mammogram Last Recorded in the following categories 0 2 years gt 2 3 years gt 3 4 years gt 4 years Not Recorded Ineligible Mammogram is recorded in the PrimaryCare Sidebar This graph will only display results if the PrimaryCare Sidebar is being used The Mammogram category of Ineligible includes patients that are no longer required to have an FOBT test because they have a coded condition that implies exclusion Check the mappings for your clinical system 6 2 13 Screening gt FOBT The FOBT Faecal occult blood test tab provides 2 subtabs e FOBT Last Recorded A pie chart displays the of patients with a FOBT Last Recorded in the following categories 0 2 years gt 2 3 years gt 3 4 years 4 years No FOBT Recorded Ineligible e FOBT Orders and results
9. Nov 2011 2710 GP MH Care Plan 2712 GP MH Care Plan Review 2713 GP MH Care Consultation Diabetes SIP includes item numbers 2517 2518 2521 2522 2525 2526 2620 2622 2624 2631 2633 2635 Asthma COC includes item numbers 2546 2547 2552 2553 2558 2559 2664 2666 2668 2673 2675 and 2677 11506 Respiratory 13 June 2012 PAGE 63 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Some item numbers have a follow up item number attached For example patients who have had a 2710 Mental Health Plan should have a follow up 2712 Review of Mental Health Plan You are able to identify patients that have not had the follow up item number by using selecting item 2710 from the recorded tab and item 2712 from the not recorded tab and using the Report button to do a cross tabulation 13 June 2012 PAGE 64 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 7 Reports 7 1 Standard Reports A number of reports are available under the Standard Reports tab e CX e TEN nss Hosea Directa 2 C Praga FiesMOIN2 BNI Dues Pao Stee Ossie Ho amp Tc BP Medion Diabetes SIP ews OV Evert Aik HMR Standsd Repos D Show Total Courts Kom teh G These are e Indicator Sets Some reports have been grouped under a tab Indicator Sets This is to indicate to users that th
10. Pao Sven Nedostions Date NE lare OV Evan Rik HMR Veaasgers Sind Repot LJ ssec C how Total Counts Demographic Breakdown by Age population 173 Forveles 173 Males 0 Oe C CAR CLINICAL AUOIT TOOL HPEN jum COMPUTER Erens P Figure 6 1A Filtering a data set for analysis 13 June 2012 PAGE 28 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Click the View Pop button at the top of the screen Figure 6 1B to get a list of the patients that have been selected in this dataset Note this is the filtered dataset not the full dataset 5 PCS Clinical Audit Figure 6 1B View Pop button This will pop up the Patient Reidentify Report with a list of patient details for the full filtered population Figure 6 1C Use the idi Export menu option to export the data to Excel format for follow up if required The far right column on the Population list will show you the patients last visit date T clinical Audit Figure 6 1C Patient Re identify Report for full filtered population 13 June 2012 PAGE 29 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 Data Set Results Graphs and Reports Click the Hide Extracts and Hide Filter buttons to maximise the use of your screen for viewing results The tabs along the top of the reports panel Figure 6 2A allow you to vi
11. 27 6 ANALYSING A DATA SET A 28 6 1 DATASET RESULTS OVERVIEW es Se Se tr ore er Ge bees Er e epic Ee T ua ENE Kb OR gek te te rm rere es ae YE Ee en d n 28 13 June 2012 PAGE 7 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 DATASET RESULTS GRAPHS AND REPORTS ee Ge ie E E E E E ne ee Ee ee 30 6 2 1 Demographics and Bar Chart functions SE orit e ra e BA As ed E re V EEN DES eV EARN EA Md eke ee dee 32 6 2 1 1 R identity RepORts EE EE EE EE EN 35 6 2 2 liries EE oq Ee OR ER EE EE AE EN 6 2 3 Patient REPON RE RE EE EASA 6 2 4 Allergies and Pie Chart functions 62A1 Allergies Mappings with Clinical System S id EN SS EE EE EK GE ES EO SG EES Ee NEK Gee en ede eed Oe a Une ek des ts 40 6 2 5 ye da EE OE EE N EE EE N EE 41 6 2 5 1 Smoking Mappings with Clinical SysteMS sis Se NE RR reperiet Ee DERE Ee RE Ee Ee ee ek VN Re Sek ede eed Nee N Ed Rd oek cused 41 6 2 6 Alcohol 6 2 6 1 A Alcohol Mappings with Clinical systems 6 2 7 BMI Body POSE DE EE EE IG raii 42 6 2 7 1 BMI Mappings ide le AL OR OE OE eva gea oaa 43 6 2 8 WISE iiss EE RE EE OE EEEE TETT 43 6 2 8 1 WaistMappings with Clinical Systems rater e ese ora EE Lk NES Nee VEE NE VER EV GEN Se ese SEE GN tests EY Eve sed 43 6 2 9 AO TE EE EE N N EE ss 44 6 2 9 1 Disease Mappings with Clinical systems sesse ee Re Re RA AA ee RA Re ee Re ee ee ee ee ee ee 45 6 2 10 S
12. 6 2 29 MBS Items The MBS Items tab is available when the clinical and billing systems are provided by the same vendor and the data extract for the clinical system is version 1 5 or above The PCS Clinical Audit User Guide Part 1 Installation and Configuration explains how to configure your preferences to collect billing data as well as clinical data The data is displayed as a bar graph of e Count of MBS items recorded e Count of MBS items not recorded Notes 1 You can use the Results filter to find the most recent MBS items that have been billed in a specific time period 2 Old item numbers are still collected and displayed in the appropriate bar segment of the graph Refer to the table below The item number will be viewable via the Reidentify report MBS Items currently collected are Old item numbers still collected HC 75 700 75 Health Check where HC includes item numbers 702 75 Health Check home 701 703 705 and 707 HC 45 49 717 45 49 Health Check HC 3 5 HKC HC Other 715 ATSI 55 HC 704 706 ATSI 55 AHC 715 ATSI 15 54 HC 710 ATSI 15 54 AHC 715 ATSI 15 HC 708 ATSI CHC 721 CDM GP Management Plan 723 CDM Team Care Arrangement 732 CDM Review 725 GP Management Plan Review 727 Team Care Arrangement Review 900 DMMR 903 RMMR GP MH Care Plan includes item numbers 2702 GP MH Care Plan 2700 2701 2715 2717 from 1
13. By Active Patient Conditions Pregnancy Yes ASTHMA REGISTER Filtering By Active Patient Conditions Asthma Yes CHD NOT ON ASPIRIN Filtering By Active Patient Last Results lt 12 mths Conditions Cardiovascular Ye CHD PATIENTS NOT ON BETA BLOCKERS OR DIURETICS Filtering By Active Patient Conditions Cardiovascular Yes Medications Antihypei CHILDREN 3 TO 12 YEARS OF AGE Filtering By Age gt 3 Age lt 12 Active Patient DIABETES PATIENTS REQUIRING DIAGNOSIS REVIEW Filtering By Active Patient Conditions Undefined Diabetes Yes FEMALES 9 26 YEARS OF AGE Filtering By Females Age gt 9 Age lt 26 Active Patient HEART ATTACKS AST 12 MONTHS Filterinn Ru Active Patient Conditinne MI Yas act Reste lt 12 mthe Save New Fiter Edit Delete Default Filter Medical Director 3 HCN Sample Data ACTIVE PRACTICE POPULATION ADULT HEALTH CHECKS 45 49 Demographics Allergies Smoking Alcohol Measures Pathology ANTENATAL REGISTER ASTHMA REGISTER Select Al F Show Total Counts CHD NOT ON ASPIRIN CHD PATIENTS NOT ON BETA BLOCKERS OR DIURI CHILDREN 3 TO 12 YEARS OF AGE DIABETES PATIENTS REQUIRING DIAGNOSIS REVIE FEMALES 9 26 YEARS OF AGE HEART ATTACKS LAST 12 MONTHS HEART FAILURE REGISTER HYPERLIPIDAEMIA BUT NOPT ON LIPID MODIFYING MENTAL HEALTH ISSUES REGISTER STROKE AND HEART ATTACK REGISTER LAST 12 Demographic Brea Females 0 Males Figure 5 10 3
14. Care by Patient The Items Completed per Patient graph provides a view by patient of items that have been completed or not Functions available are as described for Demographics Bar Chart but the Export button is renamed Worksheet for this graph as it gives a different style of re identify report Count of Diabetes SIP llems Completed Per Patient population 323 Exact fle Goes eot contain data kr BMI EP and Foot Exam recorded ie the laat amp lave Figure 6 2 24 2A Diabetes SIP Worksheet button 13 June 2012 PAGE 55 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 24 3 The Diabetes SIP Worksheet From the Items Completed per Patient graph click the Worksheet button to get a list of the patients in any segment s of the graph and view the list as a Diabetes SIP Worksheet The worksheet reports which items have been completed for a patient For completed items it reports in the item column either i the value of an item where it can or ii a tick V where no value is available eg smoking In this example we have picked patients that have 10 items completed 5 Patient Reidentification i P Ha f E nnd n Fitering By Conditions Diabetes Yes Selected Diabetes SIP Items Completed 10 s E s ss os s s i Gd a d a 525 E Fd d d a iaai mes ce Jer l1 id EA ge uL egre pel ds e em DLE i HL e detti e
15. EY Tee 6 2 24 3 The Diabetes SIP Worksheet 6 2 24 4 Diabetes SIP Mappings with Clinical Systems oii tere terree ein een tana ete eren d ee a ved n 6 2 25 CKD Chronic Kidney Disease Managemeht iiie etas iata dun NE Ed Ge dea kir VaL da Ya va ee d Ge ve E AE ER RD 13 June 2012 PAGE 8 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 220 M sculoskelctal oeeie ee E A E E E A Ee EE EP EL 57 6 2 27 CV Cardiovascular Event RISK iei EE OR OE OE OE OE ER N 58 6 228 IMMUNISATION N EE RE AE EE OO EE sadadarehersaiys 62 6 2 28 1 Immunisations Mappings with Clinical systems esse es ee RR RA Re ee Re ee ee ee endai dera sie ioeina 62 EN LL EE AE EE RO EE caceuaseacucaes 63 7 NREPORTS EE EE EE N EA EE EE EE M 65 73 STANDARD REPORTS RA AE EE EE dva RE deese ER a ees 65 7 1 1 APCC Australia Primary Care Collaboratives Report ss ee sk ee enne nennen nnne tnn nna 66 7 1 2 NPI National Performance Indicators Report tei dt t err e rente Tee V E PEERS ese ge 68 7 1 3 Summary Report Cal esee eat etna teu e dee de ia Es Se ERG N ER ee ee Eg ee ee rae REND FREE Rd 69 7 1 4 Mental Health MH Summary Report Card iii reset teh oa ae qu Reden Rea FERE EAR eed Md eke Ke Ee 69 7 1 5 QAIHC Indicators dele OR EE EE EE EE ER wae 7 1 6 Healthy For Life Report 4 1 7 NT AHKPI Indicators Report 7 1 8 National KPl Indicators RE DONE 5x2 i
16. Location Figure 10 2A Send To location selections 853 4 12 2009 7 02 PM 2 CAT Data Extra Send To You are about to send data to Christine at PEN Do you wish to continue Figure 10 2B Send To location confirmation Figure 10 2C Send To location sending progress z CAT Data Extra Send To The data extract has been sent successfully Figure 10 2D Send To location sent 13 June 2012 PAGE 80 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 11 CAT Tools Menu 5 Clinical Audit File Edit Tools Help Deidentify Dataset Collect Check For Updates Figure 11A CAT Tools menu The CAT Tools menu Figure 11A provides the following useful options Deidentify Dataset A data extract can be deidentified using the Deidentify tool menu option within CAT You must load the data set you wish to deidentify before running the tool e Click Tools gt Deidentify Dataset e You will receive a confirmation message once the process had completed Figure 11B e Click OK e The new deidentified dataset will appear in your list of extracts Figure 11C Created deidentified data file c clinicalaudit medicalmicrodata DEIDENTIFIED_penmlb_01 201002160908 11775 y1_6 data xml Created deidentified link data file c clinicalaudit medicalmicrodata DEIDENTIFIED_penmlb_01 201002160908 11775 v1_1 link xml Figure 11B Completed deidentify message 16 02 2010
17. No E Yes O No E Typen E wo 7 Asima E No E Hypertension ino E Infismmatory F No Chronic Renal Eno F Tysel 7 No coro P No 0 Heart Faize F No TE Masculoskaistal F No P Acute Renal Feature No E Undefined Diabeto F No E antievascetar Disease E Zene Disease aLI Ey Undefined Rena 7 No E Type torti S co E No E avo E No E Osteoporosis Ein 71 stroke El Ne 7 Caseta Sterness 7 No E Ostecerthets F no 7 Gestational E no om E no p fiaa F no EES Figure 5 5A Medical Conditions Filtering Selecting Conditions by ticking the boxes will limit your data to look at only patients that match all the conditions ticked Condition Yes No no selection All You can select to filter by patients that e Have a condition tick the Yes box e Do not have a condition tick the No box If you tick one of the main condition headings bolded the sub heading selections will not be available and all patients matching that broad condition category will be selected 5 5 1 Medical Conditions Filter Mappings with Clinical systems The conditions filter mappings are provided in the Conditions Data Mappings Appendices for each Clinical system Note that some conditions are flagged as true for a patient if the patient has ever had the condition ie the condition forms part of the patient history but is not currently listed as active eg heart disease Check the appendix fo
18. Report Card is available under the Standard Reports tab This report provides an instant snapshot of GP data quality across most of the graphs provided This means the user doesn t have to go to each tab and write the figures down The report can be exported to Excel so the user can create a month by month set of figures if they choose Note the user needs to collect new extract files for each monthly report The user can also use the filters to target specific populations This report is found under the Standard Reports tab Summary Report Card tab 3 Clinical Audit CAT Summary Report Card Report Date 2052803 MET Figure 7 1 3A Summary Report Card tab 7 14 Mental Health MH Summary Report Card The MH Summary Report Card is available under the Standard Reports tab This report provides a snapshot of GP data relating to Mental Health It is designed to encourage GPs to review and update their management strategies for patients diagnosed with mental health disorders specifically schizophrenia in their practices These new management strategies are in line with the Royal Australian and New Zealand College of Psychiatrists RANZCP guidelines and take into account the International Diabetes Federation criteria for metabolic syndrome How to use this report This report is designed to be used in conjunction with the CAT filters Some medications can increase a patient s metabolic risks and this report highlight
19. Right Panel e Data Reports Bottom Right Panel It is handy to be able to hide the data collection and data filter areas of the screen in order to make best use of your screen space to view the data results You can toggle between the View Hide modes at any time Once you have logged in the screen below will display You will see the population figure is initially O because you have not yet collected data from your clinical desktop system or loaded an existing extract file D DO Fese O natsi Endar ex Acts e 2 O Ne Ace ata O 0ta va O ems O Drv bana sepatu Snap shot Fie 55 D renova j ers zw w zoan Coes Goa Nedcal Diesel 2 C Phogente Fleit NDA Teengectics alpes Seeking UM wat Oresa Pap Sew Le Cine Kilo BP USLE Vedcshon Diebeler SIP Jew CV Ever Ric HR hi O Stow Tas Courts Esot Ape 5 El Pre Demographic Breakdown by Age Ferales 0 Mites 0 Oha C E Forde WE Vue Reports CAT CLINICAL AUDIT TOOL PEN e TED SI stet soucis Figure 3 1A CAT User Interface 13 June 2012 PAGE 13 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 4 COLLECTING DATA SETS NOTE Before you start collecting data sets ensure you have set up your preferences to point to the correct clinical desktop system for your practice See Setting Your Preferences for details about how to do this A data set is collected by clic
20. Value 20 08 2008 28 11 2005 503 2003 16 05 2008 24 08 2228 2012010 102008 17 01 2008 27 04 2008 5 08 2008 13012008 Result Over Time Figure 9A Timeline for Pap Smear Recorded TIPS 1 If you add or remove graph segments you can return to the Timeline tab and click the Timeline Recalculate button to refresh the graph 2 The From and To Dates default to cover a year before the extract date Adjust these to include older extracts if you have them If an extract does not appear you may simply need to reload it this will create summary data for the timeline which may not have previously been created 13 June 2012 PAGE 76 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 10 Send Data To function The Send Data To function allows practices to send a CAT data file from within CAT to an external location of their choice Only the data file is sent using this function The link file is NOT sent The function allows data to be sent securely via 1 Email MAPI or Other or 2 Secure FTP 10 1 Configuring locations A new menu option Edit gt Send Data Extracts Locations allows practices to configure locations they are happy to send data to File Tools Help Preferences Send Data tracts Locations Lfe It Figure 10 1A Send Data configuration menu option Send Data Extracts Locations Configuration x New Configuration Cine Ne
21. aao baee Eno N GE GESE SR EE ek Ke ek de 50 ORN RE N RE RE N EA 0E VER FTU EE FERRE RETYRE 50 6 2 18 1 HbA1c Mappings with Clinical System uie se redonner enne EE RENEE GR SE ONS SE EG REKEN GN ES Re SE Ee VR GN ee EK EEN GE 50 6 2 19 BP Blood Pressure eet terree ee Pd Res GE gana Ee eg evade se ies eve apu le eke Re nea ae eva REG Ee Ge 51 6 2 19 1 BP MappingsWwith delde SS LE EE AE EE EE EE E 51 6 2 20 FBG Fastina Blood Glucose Re SG eee eg Re ed d ee epa epe eeu be ds ed Hp son ges VER YI Rey eR ES as Se WERE Dee ee 51 6 2 20 1 FBG Mappings with ClinicalsySEelms s EE AE OE tev EE EVEN EET 51 6 2 21 INR International Normalised Ratio eese sesenta ee estas Ne ke ee ee ee 51 6 2 21 1 INR Mappings With Clinical Systems cic cie esse nts eret codes con ER EP EE e Rd bn Len Sha pe Pasa EE OE at 51 6 222 Ve is RR ieri i Er ER VERE C ESSE Ye Fed ERRRENEUR CIS ss EXURE DO cade e eey Drev EGER E EEEXE E e PEE ede geo E FRERE EYE R O 6 2 22 1 Spirometry Mappings with Clinical systems sesse sesse ee ee Re RA ee RA nennnn nennen ee ee ee ee ee ee rennes 6 223 MEdICAUONS N ME EO IE 6 2 23 1 Medications Mappings with ClirilCal systems ccrte EN GER EN eret re vei eae GAD E 6 2 24 Diabetes SIP Service Incentive Payment Items 6 2 24 1 Cycle of Care by temm ciere ete rrt ttt rne rere repere spas eo e N EA ede eee ves s ob Te UON OS 6 2 24 2 eel Me de de dy OR EE OE EE En RE EXE E o Eee SE rave E aT YS shoes sEVEN
22. chart If you click on any segment of the bar chart it will become highlighted and the Export button in the right hand corner of the results panel will become active You can select more than one segment of the graph Figure 6 2 1E 13 June 2012 PAGE 33 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Highlighted segment s of bar chart Export button active Clinical Audit read Vern Mecal Dieci 3 HOM Live Data Fiteing By Coraitions Asthma Vei Sesected AgelFersiesl Aleapes Stacking Alcohol Neasare Pathology Deady C Select C Show Tota Counts me 45 43 Cect STIs NPS Inscaerz Figure 6 2 1E Export Button Click the Export button to get a list of the patients that make up this group This works the same way as the View Pop button except that you not looking at the filtered population but are drilling down to a subset of it This will pop up the Patient Reidentify Report with a list of patient details Figure 6 2 1F The specific age value for each patient in the group selected will be provided in the last column Use the ol Export menu option to export the data to Excel format for follow up if required 5 Patient Reidentificatinn IM 4 eike 9 AA Dauid 100 Reidentify Pallenis Report Ag EE By Canditions vua deme Yes TL Ber pe we rue CE ERE P me ws EE 3 E pe rpm r3 e ee E eem ere ees pme
23. equation is used GFR mL min 1 73 m2 0 41 x Height Serum creatinine 88 The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 15 1 eGFR Mappings with Clinical systems The creatinine mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical application 6 2 16 MALB Microalbumin Pathology MALB displays your data as a breakdown of lt 15 mg L 15 mg L No Data The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 16 1 MALB Mappings with Clinical systems The microalbumin mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical application 13 June 2012 PAGE 49 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 17 ACR Microalbumin Creatinine Ratio Pathology gt ACR displays your data as a breakdown of lt 25 2 5 3 5 3 5 No Data ACR is either collected directly or is calculated as ACR mg mmol microalbumin mg L urinary creatinine mmol L where microalbumin and urininary creatinine have the same date The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 17 1 ACR Mappings with Clinical systems The ACR microalbumin and urinary creatinine mappings are provided in the General Data Mappings Appendices under M
24. help direct lifestyle advice and medicines to those who have the most to benefit Health professionals can access the following from www heartfoundation org au Professional Information Clinical Practice page Full guidelines Guidelines for the assessment of absolute cardiovascular disease risk e Quick Reference Guide e Risk assessment charts e Online risk calculator e Consumer information For more information contact the Heart Foundation on 1300 36 27 87 1 The National Vascular Disease Prevention Alliance NVDPA includes the Heart Foundation National Stroke Foundation Kidney Health Australia and Diabetes Australia 13 June 2012 PAGE 58 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 The Framingham Risk Equation FRE The FRE predicts the risk of a cardiovascular event over the next 5 years The calculation can be found in the Absolute CVD Risk Resources provided in the Heart Foundation website in the Technical report review of the evidence and evidence based recommendations for practice The calculation excludes patients who have e Age Non ATSI lt 45 or gt 74 ATSI lt 35 or gt 74 e Condition CVD The data items used in the calculation are e Age e Gender e Systolic BP mm Hg e Total Cholesterol Mg dL e HDL Mg dL e Smoking Status Smoker Non smoker e Diabetes e ECG LVH always set to 0 s ECG LVH ECG Echocardiogram is a test and LVH Lef
25. testen nnne 15 5 DATA GIE dd OR 16 5 1 DATA FILTERING OVERVIEW REM 16 5 2 CHANGING FILTER Sh 321223352 OE ee rne oon es EE RR OR EE 17 5 3 CLEARING FILTERS T N 17 5 4 DEMOGRAPHIC Aid IS RE tenia rip cerle EE EE Lain Paene eee RE dE eua eR oue 18 5 4 1 Demographic Filter Mappings with Clinical systems esses eene nennen nnne nans 5 5 MEDICAL CONDITIONS PIRERING s 520221235 RR N N re Pepe been ku N 55 1 Medical Conditions Filter Mappings with Clinical systems 5 5 2 PreghaNCY EE EE EE EE EE OE EE EO EE OE 5 6 IMEBICATIONSFIERERING os ee Ee Ge ee ee ee E N ee er 21 5 6 1 Medications Filter Mappings with Clinical systems ee ee Re Re ee ee ee enne ee ee ee ee 21 5 7 RESULTS FILTERING istaci EE ER EE EE EE N RAES 22 5 8 PATIENT ld Glas EE EE EA Ee 22 5 9 PATIENT STATUS ITE RIN Gig ei eet ee ee OER ED E RR Oe Ge Se Re fetu ste e s RE EE Ee Ge ee 23 5 10 PROVIDER Ri do M 23 5101 Methodofdssigningapatient to provider e rt trc de EE ea ek aas geb Ge See ae Ge Ke Eripe De ee de 23 5 1 SAVING FILTER CRIME RUA oe EG Oe ee GE GE GR EG ER E ee ee 24 511 1 Creating a New Filter Names SEN SEE ERG eret ER EN Ge Be HE EES Ge EH GEK ade MEER EE Ee ees EMT EE PR Bas TERRIER PEEL De ER 24 5 11 2 Loading existing filters EE EE EE EE EE ER N 26 5 11 3 NS od de OE OE OE EN ERR dE
26. 3 08 AM 11775 DEIDENTIFIED pe 16 02 2010 3 08AM 11775 PENMLB 01 Figure 11C Original and deidentified datasets in extracts list Check for Updates If a practice has skipped the option to take updates available for CAT they will not be prompted again when new updates are released This has caused problems for practices in the past This menu option has been added to allow practices to check for updates in case some have been missed Tools Check for Updates Note the practice must have installed a minimum of CAT 2 8 for this option to be available 13 June 2012 PAGE 81 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 APPENDIX A1 GENIE DATA COLLECTION For Genie users the data set collection is performed from within the Genie software application Clicking the CAT Collect button at the top left of the screen will provide you with the summary steps on how this is done within Genie For details of the steps in this process please refer to the Genie data Mappings document available from http help pencs com au cat htm APPENDIX A2 PRACTIX DATA COLLECTION For practiX users the data set collection is performed from within the practIX software application Clicking the CAT Collect button at the top left of the screen will provide you with the summary steps on how this is done within pratiX For details of the steps in this process please refer to the practiX data Mappings docu
27. 4 0 gt 4 0 No Triglycerides Recorded e Total Chol HDL Ratio lt 3 5 gt 3 5 and lt 5 0 gt 5 0 No Total Chol HDL Ratio Recorded The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 14 1 Lipids Mappings with Clinical systems The lipids mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical application If there are results for Cholesterol HDL LDL and or Triglycerides then the most recent values will be displayed If there are results for HDL and cholesterol is recorded the most recent values will be used by CAT to display the Chol HDL ratio Where the LD results is missing CAT will calculate it if possible using the Friedewald equation LDL cholesterol mmol L total cholesterol HDL cholesterol triglyceride 2 2 13 June 2012 PAGE 48 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 15 eGFR Estimated Glomerular Filtration Rate Pathology gt eGFR displays your data as a breakdown of gt 100 Normal 60 100mg ml Stage 1 30 60 mg ml Stage 2 15 30mg ml Stage 3 lt 15mg ml Stage 4 No Data eGFR ml min is calculated using the MDRD revised formula from serum creatinine measurement in micromoles age and gender This formula is GFR mL min 1 73 m 175 x S 1 1 x Age 9 x 0 742 if female The MDRD formula is for age gt 18 For children the Schwartz
28. 6 2006 1240 PM 11776 PENMLE_O Data set snap shot Figure 4A Collecting Data Sets 13 June 2012 PAGE 14 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 PENMLB_01 10 06 2008 12 40PM 11776 PENMLB_01 Figure 4B Data set entries Each entry displays the date time of collection the number of records retrieved and the machine name on which the collection was done Figure 4B You can collect as many data sets as you wish over time Each data set will be listed as an entry in the left hand column To analyse a specific data set click on the entry for that data set It will become highlighted and you will see the status bar in the top right hand corner of the screen flashing while the data is reloaded from the snap shot into Clinical Audit 4 1 What data is collected Data is only collected for patients who are active in your Clinical system Data for patients who are deceased or have been made inactive is not collected unless it is required for reporting and the practice has set this option on available MD BP only This means when you are analysing your data using CAT you are only seeing patients who are currently marked as active in your Clinical system You may find patients in CAT that you know are no longer active at your practice If you inactivate them in your Clinical system they will be excluded from future data collections 4 2 How is the data stored The collect saves 2 xml
29. 70 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 7 1 8 National KPI Indicators Report As part of the National Indigenous Reform Agreement NIRA the Council of Australian Governments COAG agreed that the Department of Health and Ageing in partnership with the state and territory health departments and in collaboration with the Australian Institute of Health and Welfare AIHW would develop a set of national key performance indicators KPIs for Indigenous specific primary health care services AIHW have provided specifications for these indicators The CAT National KPI Report is available for clinical systems where the CAT data extract meets the CAT data specifications version 1_6 or higher MBS Item Indicators in the report are available where the clinical and billing systems are provided by the same vendor More information is available in the CAT National KPI Indicators Quick Reference Guide available at http help pencs com au cat htm 7 1 8 1 Collecting Additional Patients in CAT for Reporting Practices submitting data for the National KPI report will need to extract additional patients to meet the population base required for the report The report requires that all patients who have visited the practice in the last 2 years should be included This definition includes archived and deceased patients The Medical Director and Best Practice preference tabs now include a new option Extract
30. A Selecting a default filter e On reopening CAT the Default Filter is preloaded e If you wish to clear the preloaded filter click the Clear Filters button Defaut Fiter ACTIVE PRACTICE POPULATION Medical Director 3 HCN Sample Data Filtering By Active Patient Demographics Alerges Smoking cohol Measures Pathology Disease Pap Smear Medications Diabetes SIP kens CV Evert Fisk HM Figure 5 10 3B The default filter is preloaded on opening CAT 13 June 2012 PAGE 27 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 ANALYSING A DATA SET 6 1 Data Set Results Overview Once you have selected your data set snap shot and your data filters click Recalculate You will see the status bar in the top right hand corner of the screen flashing while the filtered data is reloaded from the snap shot into Clinical Audit Once this has finished you are ready to work with the data set of patients that match all the conditions selected The data set for this exercise has 11795 patients and has been filtered on Gender Female and Condition Asthma 173 patients have been returned matching the filter Figure 6 1A Example Total Patients Filter Selected Patients 5 Clinteal Audit 18A0 200011424M 11775 PENMLE 01 Medical Disa 3 HCN Live Data Fieri By Conditor Ashra Ver Females Verg her LAMerges Smoking Akehal Nesaxes Pathologs Queste
31. ATAL REGISTER Ferr By Actvs Patent Condon Pregnancy Ves ASTHMA REGSTCR Fieiro y Actos Paart Cancion tera Yes CHD HOT ON ASPIRE Fiteeri Dy Arive Pairt Lyk lenis c 12 nthe Condhong caderet Yes Medcabons hice Ho CHD PATIENTS NOT OM BETA BLOCKERS CR DIURETICS Fieno By Actes Ferd Condition ICsidinirculr Vee Magosto Iekhypertenciver Bets Becker Ko Dieter Pal CHILDREN 370 12YEARS CF AGE Fieiro By Age 3 Age ce 12 etre Patient COAEE TES PATIENTS REQUIRING DIAGNOSIS REVIEW Fitesr By Actos Pafert Conditions Undefined Diabetes Yez FEMALES 25 YEARS OF AGE Fitvirc fir Farslar Age gt 8 Age lt 26 Activa Paarl MEANT ATTAINS 1 AST 12 MAINTE Vitae Har dries Patat Frans IME vaal Ld Heads c 12 the Ed Oet Hosea Drecha 2 C Pope Fies H2 Fhein By Covent Diabetes Vesk Active Patent EMI Diewe Pap Sms Loidi asinine Halo BP Medications Disbeles SIP Mews CV Evert Aik HVA kineser Stander Repos To load a saved filter e Click the Saved Filters tab e Click on the filter name required e The filter details will be loaded into the other filter tabs and will display at the top of the Results panel The Recaltulate button will turn red 5 Clinical Audit Geced Convitces Nedeaters Penis Porter Filter Hema ACTIVE PRACTICE POPULATION ADULT HEALTH CHE KS 4545 ANTENATAL REGISTER ASTHMA REGSTER CHD NUT ON ASPIRIN CKD PATIENTS NOT ON BETA BLOCKERS OR DIURETICS
32. Archived and Deceased Patients which can be set to Yes to enable this functionality The default selection will be set to No For practices where this set to No there will be no change to the way CAT functions For practices where this set to Yes the default population loaded will exclude patients that are archived and deceased enabling practices to continue working with CAT in the same way they always have The NKPI Report will include the additional patients and this will be noted at the top of the report Note for the 30 June 2012 collection deceased patients will not be included in the report to align the figures reported with Communicare Not all Communicare users will have been upgraded to extract deceased patients More information about this functionality is provided in the CAT Extracting Additional Patients Quick Reference Guide available at http help pencs com au cat htm 13 June 2012 PAGE 71 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 7 2 Cross Tabulation Report The cross tabulation report provides the ability to find patients who appear on more than one graph this assists with the identification of target population risk groups For example Highlight the graphs segment for BMI gt 30 Smoker BP gt 140 90 Cholesterol level gt 7 5 and view which patients meet all these criteria As you highlight report chart segments you will see 2 pieces of information on th
33. Details Filter Name Description Filtering By Active Patient Conditions Diabetes Yes Figure 5 10 1B Filter Details Description e Fillin the Filter Name Figure 5 10 1C Filter Details Filter Name ACTIVE PATIENTS WITH DIABETES Figure 5 10 1C Filter Details Filter Name entry e Click OK e The new filter name will now be listed on the Saved Filters tab Figure 5 10 1D 5 Clinical Audit File Edit Tools Prompts Help ea ees GEBIED General Conditions Medications Results Providers Saved Filters Filter Hame Description ACTIVE PATIENTS WITH DIABETES Filtering By Active Patient Conditions Diabetes Yes ER Gee besafRe Medical Director 2 CAMDW2 Filtering By Active Patient Conditions Diabetes Yes Figure 5 10 1D Saved Filters tab with new saved filter The filter name can be changed using the Edit button The filter can be deleted using the Delete button 13 June 2012 PAGE 25 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 11 2 Loading existing filters 5 Clinical Audit Fe tX W s Era WES Ge fase Fees 3 Geresd Cunices Nediostors Pisis Paredes Saved Fes Fiber Mara Deserta a ACTIVE PRACTICE POPULATION Fierro By Actos Patent ADULT HEALTH CHECKS 4548 Freire By Age gt 45 Age ce 49 Actes Patent ANTEN
34. FUNCTIONALITY Version 3 4 6 2 3 Patient Report This report details key health outcome measures for an individual patient e Click the Data Quality tab e Click the Patient Data Report tab e A patient list matching the filter criteria you have selected will be displayed o 20 patients per page will be displayed o Use the Prev Page and Next Page buttons to browse the list if it has more than 20 patients e Select the patient from list and click the Patient Report button to display a report with the key health outcome measures for this patient The report is divided into 3 sections o Clinical Data Items o Medicare Items o Diabetes Care Plan Items this section will only be displayed if the patient has a coded diagnosis of Diabetes The patient report is designed to be able to be deidentified by hiding the patient name and data values The default settings are 1 Patient name this appears above the report and is not printed on the report 2 Data values these are displayed as recorded completed yes no ie the data value details are not displayed Changing the report default display The Show Name in Report button will toggle the name on in the report if you wish to have this information printed The Show Details in Report button will toggle the data values on in the report where they are available if you wish to have this information printed 13 June 2012 PAGE 37 of 83 PCS Clinical Audit Tool
35. PCS Clinical Audit Tool User Guide Version 3 4 PART 2 FUNCTIONALITY IPEN amp G COMPUTER pM py SYSTEMS Boao 11 CERTIFIED Partner PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Company Contacts Sydney Head Office Document Contact Pen Computer Systems Level 1 35 Moore St Contact ee LEICHHARDT NSW 2040 roject Officer Phone 61 2 9506 3200 Phone 61 3 9866 8477 Fax 46129566 1182 Email christine chidgey Q pencs com au Email enquiries pencs com au Web www pencs com au Melbourne Office Pen Computer Systems Level 5 434 St Kilda Rd MELBOURNE VIC 3004 Phone 61 3 9866 8477 Fax 61 3 9866 5699 13 June 2012 PAGE 2 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Document Control Version Date Modified By Description 26 02 2007 08 03 2007 13 03 2007 25 07 2007 07 08 2007 24 09 2007 24 09 2007 01 03 2008 23 06 2008 26 06 2008 26 06 2008 01 09 2008 Christine Chidgey John Johnson Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey John Johnston Tarkan Shahho Christine Chidgey Review and Comment Add Appendices for Conditions and Medications Mappings Updates for revised functionality and screens Add Cardiovascular Risk Calculator Updates for revised functionality and screens Update versio
36. Report Selections To clear the Report Chart Segments you have selected click the Clear Filters button at the top right hand corner of the CAT screen The Clear Filters dialogue box will appear The Clear all Report Selections tick box will be pre selected if report segment selections have been made Click OK Please tick which selections you want to clear C Clear all Filter Selections v Clear all Report Selections Figure 7 2 1A Clear Filters dialogue box The e which appears on the tabs with selected report segments will be cleared The text line with selected report segments information will be cleared 13 June 2012 PAGE 73 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 8 How to improve data quality using CAT There are a number of ways that CAT can be used to improve the data quality of your clinical desktop system Some of these are listed below 8 1 Patients with no Date of Birth To find patients with no date of birth DOB use the age filter e Tick Age No Age e Click the Recalculate button e Click the View Pop Button e The Patient report for this filtered group will be displayed and you will see that the DOB column is empty 8 2 Patients with no Gender Patients with no gender will have their gender as something other than M or F in the data set probably it will be blank To find them use the gender filter e Tick Gender Ot
37. TION sesse ees see ee ee EE ER EE AA EE RE RR RE AA AE EE EE ERA RA AA saa EE ER ER ek ee 82 APPENDIX A3 MEDINET DATA COLLECTION sesse ees sesse ee se Se Ge ee AA AE EE RE RR RE suas essa ER ERA RA AA sas EE EE ER EER Ge ke ee 82 APPENDIX B MEDICAL DIRECTOR DATA CATEGORY MAPPINGS sccesessesssssccseeseessssenssssenseceseessessessenssscnoaseeseens 83 APPENDIX C BEST PRACTICE DATA CATEGORY MAPPINGS scsssssssssssessssessensccscescessssenseseencneceseessesssseeesesenscaseeeeens 83 APPENDIX D GENIE DATA CATEGORY MAPPINGG cccccscscsssssscncsscessessessssessecccaseescesssseusecsencaceseeseessesseuscucaoasseseens 83 APPENDIX E ZEDMED DATA CATEGORY MAPPINGS scscssssssensssseseeseesessessesscaseeecesesseuseeseucceceseessersesseneescucaseeseens 83 APPENDIX F PRACTIX DATA CATEGORY MAPPINGS sscccsssscssescesseseesssseesenscaeeescessssensesecusnaceseessesssseeeeeneascaseeseens 83 APPENDIX G COMMUNICARE DATA CATEGORY MAPPINGG ccssscsssssccssssssssnsccenscsssssenscnsenscaceseessessesensssseuonseeseens 83 APPENDIX H MEDINET DATA CATEGORY MAPPINGS cesses eene eene eene nnn AA Re EER ERA RA assa assess etes ER inna asian 83 13 June 2012 PAGE 9 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 1 INTRODUCTION 1 1 Clinical Audit Tool CAT The Clinical Audit Tool CAT analyses clinical information from GP Clinical Desktop Sy
38. a Yes Females AI ENE NR AE e ee Ie FT HIE 3 Hel Patlonts Report Age Filtering By Conditions Asthma Yesh Females Filtering By Conditions Asthma Yes Females Extract Detats Medica Director version 2 Exact Date 10 06 2006 Patient Court 11776 Pritet 25 06 2000 11 24 AM Cinca Aude Not Puzloned2 O 1 25 Pan Computer System Pty Lid Figure 6 2 1 1A Refine Selection button 13 June 2012 PAGE 35 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 2 Data Quality The Clinical Data Self Assessment CDSA Tool has been developed to report on the completeness of patient demographic and health summary data within the general practice clinical system It provides the following reports e Data Quality Dashboard Report to indicate the overall status of data quality based on the data indicators e Data Completeness Report to report the of completeness for each data indicator e Data Completeness Patient Graph to provide a graphical view of the data indicators and allow re identification of patients where data is missing e Duplicate Patients Report to list patient records within the clinical system where a duplication is suspected A Quick Reference Guide for this new tab is available with the CAT User Documentation at http help pencs com au cat htm 13 June 2012 PAGE 36 of 83 PCS Clinical Audit Tool User Guide Part 2
39. abetes care items HbA1c Eye Exam BMI 6mths BMI 6 12 mths BP 6mths BP 6 12 mths Foot Exam 6mths Foot Exam 6 12 mths Cholesterol Triglycerides HDL Microalbuminuria Smoking The data is displayed as e Count of Patients with Care Item Recorded in the Last x Months e Count of Patients with No Care Item Recorded in the Last x Months ie Items Remaining e Count of Items Completed per Patient where x is the number of months within which an item is required to be recorded 6 12 or 24 months T 0 0 Ww 0 0 e A 2 A N A A 2 SS sS S S S S C S AS XY e xv e xv e x xv Av NN V NN S AS S ES SS g os S g S a A v amp So g Care ltem Recordedin Cycle in lastX months A NOTE Old Extract files did not contain data for BMI BP and Foot Exam recorded in the last 6 12 months Where these are loaded CAT will display a message to alert the user that the extract file they are viewing does not contain the data elements in the last 6 12mths The bar segments of the chart for these data elements will always be empty and show 0 13 June 2012 PAGE 54 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 24 1 Cycle of Care by Item The Items Recorded and Items Remaining graphs will help you to identify by item the areas of care that still need to be recorded for a patient Functions available are as described for Demographics Bar Chart 6 2 24 2 Cycle of
40. al Audit E IG LL Pe UK Pos deos E EIEN Grass Focs 3 Hosea Dieci 2 C Pod Fies OW 2 EED krol BNI West Queste Pao Siew Lo Creatine HtAlc EP Nedestors Diete SPlisws CV Event FI ER Tnnniolons Standard lecots NBS here 4943 Check Pew aee 7 Si Fe Court Exchaded ET 5696 0 Putertrenhdedwee aze lrenATEl ci orage 74 5618 CVD 78 Incomplete Data Values for Calcuating CV Risk Count 2334 Incomplete data This horizontal bar chart helps practice staff improve their data quality by identifying patients with missing data The Export button can be used for this purpose as described above Excluded data The number of patients that have been excluded is provided in order of exclusion category 35 45 non ATSI gt 74 CVD Once a patient is excluded for meeting an exclusion category they are not counted in subsequent categories The content from the publication National Vascular Disease Prevention Alliance Guidelines for the assessment of absolute cardiovascular disease risk 2009 was used with permission from the Heart Foundation copyright material 13 June 2012 PAGE 61 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 28 Immunisations The Immunisations tab contains sub tabs for Influenza Pneumococcal HPV Pertrussis Swine Flu and Child Schedule Figure 6 2 19A The charts are all pie charts e Influenza Pneumoc
41. corded No Pap Smear Recorded Ineligible e Pap Smear Done Date where Pap Smear Recorded 1yr 1 2yrs 2 3yrs 3 4yrs gt 4yrs and in a report format e Pap Smear Summary Report Card this is explained below This report is always derived from your full dataset not you filtered dataset The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart The pap smear category of Ineligible includes patients who are flagged in the clinical system as not requiring a pap smear or who have a coded condition recorded that excludes them eg hysterectomy Check the pap smear mappings for your clinical system 6 2 11 1 Pap Smear Mappings with Clinical systems The pap smear mappings are provided in the General Data Mappings Appendices for each Clinical application 6 2 11 2 Pap Smear Summary Report Card The Pap Smear Summary Report Card is an initiative of the SA Cervix Screening Program SACSP to improve the management of clinical information related to cervical screening and support increased participation of women in screening It provides a report of eligible females aged 18 70 categorised by e Females with a last visit lt 36 mths e Active Females Not pregnant Pregnant and Total Each category is broken down into subcategories by how long ago the last pap smear was recorded The subcategories match the pie chart breakdowns provided allowing patients for follow up to be targeted
42. creening Cancer 6 2 11 Sreening gt PAD Smeat iiisii i ree atate aiiin FEN Ee Yan ad aare a Aa 46 6 2 11 1 Pap Smear Mappings With Clinical SVSEGIis 5 55 53 2 2 93 err rario coa Fit eorr eee ri Yea va eR cen Feder RY ER dede YE 46 6 2 11 2 Pap Smear Summary Report Card e reb eter riii eret eee Pe epe io Eh o De SN ETE Po Rekord aee AD de EA ERE XR E DR og 46 6 2 12 Screening Mammogratm uii er ve ete dnaudecbotecsteuadevadavaccvcddnsnsssseievecuestbanedeieladelacsuashuecssdsavadencbesanesias 47 6 213 Screening gt FOBT caretes aii N EE OE dn 47 6 2 13 1 FOBT Mappings with Clinical SyStelms 5 etre apetito eee th PEL PEE e FERE AK GE Ced AN Age ge Po ER eo F e e bee KEER ERE KE E AER e REIR 47 OMA MT Cop E 48 6 2 14 1 Lipids Mappings with Clinical systems 48 6 2 15 eGFR Estimated Glomerular Filtration Rate iieri e ete Ged nae eee puedes pube ede eaa De ge Eus 49 6 2 15 1 EGFR Mappings with Clinical SyStems iioc ren dee teer er Re Ge Se e ec ek Pan e v era e e ve e ede 49 6 2416 MAEPB Microalbumin sie d e e eet o ieee SG ee Re Gel vk eo de ceu ese pu Eua Poe eek ha Ke eie enue epa prar De Ek 49 6 2 16 1 MALB Mappings with Clinical SyStelms ecce cerei tree eere teret verga ds e lag 49 6 2 17 ACR Microalbumin Creatinine Ratio is iiic reto ete GER KG GEEN suas EYE Y RR Fed der ERR EG REP oA AER tian 50 6 2 17 1 ACR Mappings with Clinical Systems nente rare NE EKKE EN NEER EE ENS GN GES EE KENS WEEN
43. cted 6 2 10 Screening Cancer General Practice Victoria has developed an electronic decision support EDS tool for the identification of patients who meet the criteria for the screening of Cervical Cancer Breast Cancer and Colorectal Cancer This tool will be available in early December 2011 via the PrimaryCare Sidebar and will provide point of care screening prompts for the three identified cancer screening groups and the recording of screening details where those details are not held in the GP CIS i e Mammogram date and result CAT provides population based reporting for the tool under a new Screening tab which contains three sub tabs for the various screening sections These are e Pap Smear e Mammogram only available with compatible PrimaryCare Sidebar functionality e FOBT Note The Pap Smear tab is unchanged from the existing tab but has been moved under the new Screening tab A Quick Reference Guide for this new tab is available with the CAT User Documentation at http help pencs com au cat htm 13 June 2012 PAGE 45 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 11 Screening gt Pap Smear The pap smear tab automatically filters out the male population The population figure displayed on this tab is the number patients in your filtered dataset with gender female or other Pap Smear displays your data as a breakdown of e Pap Smear Recorded Pap Smear Re
44. d Figure 6 2 4B Select All Show Percentage checkbox click this checkbox to display the percentage in each group rather than the count 60 7 No Known Allergies Figure 6 2 4C Show Percentage Uncheck this checkbox to display count Print button click the Print button to print a copy of the graph Export button if you click on any segment of the pie chart it will become highlighted and the Export button in the right hand corner of the results panel will become active You can select more than one segment of the pie Figure 6 2 4D 13 June 2012 PAGE 39 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Highlighted segment of pie chart Export button active 5 Clinical Audit Mee al Dieet 3 HOM Live Data Fiteing By Cond Sec Mengen Nol recoddect Deneguphice Aegae Stacking Alcohol Neaze Pathology Diasa Pap Sras Medication Diabetes SIP tena CV Evert fick HYR Ixmcrscatinz Stardad Reports VAS Paris EDI Qect ET Ee EA Allergy Status population 173 LZ Alergy Recorded GE ho troen diese Nothing Recorded 60 No Known Allergen 1 5 Allergy Pleccesez Figure 6 2 2D Export Button Click the Export button to get a list of the patients that make up this group This works the same way as the View Pop button except that you not looking at the filtered population but are drilling down to a subset
45. data files to your preferred data folder One file is pure Clinical data and has no identifiable patient information This is called the DATA file The other file is the LINK file and contains all the patient identifiable data The LINK file is only used when you want to re identify a list of patients that make up a segment of a graph In your preferred data folder the files look like this Figure 4 2A Name Size Type Date Modified 5 MedicaMicrodate DEIDENTIFIED _TESTMEDICAL 20080401 7498 1_1 4ink xml 3 240 KB XML Document 10 4 2008 1 21 PM MedicaMicrodata DEIDENTIFIED_TESTMEDICAL 20080401 7498 v1 2 data xml 14 921 KB XML Document 10 4 2008 1 21 PM Figure 4 2A Data set XML file 4 3 Existing data set compatibility with changes to CAT CAT version 2 has new filters and reports Additional data is collected by version 2 for these new functions Your CAT version 1 extracts will not have the additional data needed to make these functions work You can load up your version 1 extracts and analyse them as before the new functionality will inactivated for these extracts by being greyed out 13 June 2012 PAGE 15 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 DATA FILTERING 5 1 Data Filtering Overview Data can be filtered so that you can view graphs and reports for specific criteria The data filters are organised into a series of tabs e General Demographics e Conditions Medica
46. dit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 22 06 2009 Christine Chidgey Updates for new CV Risk Calculator Updates for new logos on screens 08 07 2009 Christine Chidgey Rename BSLF graph to FBG Fasting Blood Glucose Appendix E has been added as a separate document covering the Clinical Desktop System Zedmed data mappings 06 08 2009 Christine Chidgey Update MBS 45 59 Linkages Reports to 2008 09 FY MBS Items not recorded graph added for MD Pracsoft3 users Update support information 29 09 2009 Christine Chidgey Group some existing tabs to reduce scrolling e Measures tab contains BMI Weight BP e Pathology tab contains Lipids eGFR MALB HbA1c FGB Updates to General Filter selections Add Alcohol ACR graph has been replaced by MALB eGFR calculation has been changed Additional MBS Items have been added for MD Pracsoft3 users Condition Drug Abuse has been added NPI CDM3 report has been amended in line with DoHA BP cut off of lt 130 80 QAIHC Indicators report added for MD users 26 11 2009 Christine Chidgey New conditions added to filter and APCC Reporting Peripheral Vascular Disease Carotid Stenosis Renal Artery Stenosis Chronic Renal Failure Immunisation chart for Swine flu 15 12 2009 Christine Chidgey 09 02 2010 Christine Chidgey Update document template Updates for new functionality Tools menu option Select All report option Age bracket changes Diabetes SIP worksheet improv
47. e data provided by this reports is able to be submitted to the Improvement Foundation web portal APCC Australian Primary Care Collaboratives Report Queensland Aboriginal and Islander Health Council QAIHC Indicators Report Healthy For Life NT AHKPI Northern Territory Aboriginal Health Key Performance Indicators National KPI O O O 0 0 More information about the submission process for these reports is available in the PCS Clinical Audit User Guide APCC Report and IF Submission available from http help pencs com au cat htm e NPI National Performance Indicators e Summary Report Card e Mental Health MH Summary Report Card Please note that the Pap Smear Summary Report Card is found under the Pap Smear tab 13 June 2012 PAGE 65 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 7 1 1 APCC Australia Primary Care Collaboratives Report The APCC Report is available under the Standard Reports Indicator Sets tab NOTE For this report to collect Assessment Data from the PrimaryCare Sidebar you must have your Prompts Preferences Patient Data Storage Shared Directory set Refer to the APCC Guide advised at the end of this section for instructions The APCC Report is always derived from your full data set not your filtered data set It will always show the practice total number for your registers Diabetes CHD and COPD patients This report provides you wi
48. e screen 1 A will appear on the tab where you have made a chart segment selection 2 Anew line will appear underneath where the filter details display This line will provide details of which chart segments are selected The example below shows BMI Obese Morbid Smoking Daily BP 140 90 Lipids Cholesterol 7 5 You will see that the Report button has become active 5 Clinical Audit File Edit Help Medical Director 2 C Program FilesMDw2 Selected BMI Obese Morbid Smoking Daily BP gt 140 90 Cholesterol gt 7 5 Demographics Allergies se Figure 7 2A Multiple report selections for cross tabulation e Click the Report button The standard Reidentify Report will display in an adjusted format to allow the data values for the chart selections you have made to be provided Figure 7 2B 2 Patient Reidentification Cross Tabulation Reidentify Report Selected BMI Obese Morbid Smoking Daily BP 140 90 Cholesterol 7 5 Be eme qmm jr qwe ANN GN N NN NN LL 7 Extract Details Practice Name PENMLS 01 Medical Director version 2 Extract Data 10 06 2008 Patient Count 11776 Printed 27 03 2008 11 09 AM Glmical Audit Not Pubtshedi2 1 0 2 Pan Computer Systems Ptr Lid Figure 7 2B Cross tabulation Reidentify Report 13 June 2012 PAGE 72 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 7 2 1 Clearing
49. e when they receive it e Click the Test button to check a test email is successfully sent and received e Click OK Send Data Extracts Locations Configuration x Ohrine at PEN Location Name Christine at PEN Enable Encrypt Password Send Data Method Email Email To Address christine chidgey pencs com au Practice Details to be sent with data Contact Email Practice ID ID123 Practice Name PEN Practice Figure 10 1C Send data email configuration 13 June 2012 PAGE 78 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 To configure a new ftp location e Select Edit gt Send Data Extracts Locations from the menu bar Figure 10 1A e The Send Data Extracts Locations configuration screen will be displayed e Select Secure FTP from the drop down Send Data Method list e Enter a location name that describes where the data will be sent e Click Add e Anew location tab will added to the Send Data Extracts Locations window with the location name you have provided e Fill in the mandatory fields Figure 10 1D o FTP Address o Practice ID and Practice Name e Other fields are optional you should check with the receiving location and to which additional FTP fields are required o Port Username and Password e If you wish to encrypt the zipped data file tick Enable Encrypt and provide a password You will need to let the r
50. easurements for each Clinical application 6 2 18 HBA1c Pathology gt HBA1c displays your data as a breakdown of HBA1c status lt 7 gt 7 and 896 8 and 1096 21096 No HBA1c Recorded The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 18 1 HbA1c Mappings with Clinical systems The HbA1c mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical application 13 June 2012 PAGE 50 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 19 BP Blood Pressure Measures gt BP displays your data as a breakdown of BP status lt 130 80 130 80 140 90 gt 140 90 No BP Recorded The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart A patient s BP must have both systolic and diastolic values recorded on the same day to be valid The most recent recording is used If only one value is recorded this will be invalid and display in the No BP Recorded category A patient s BP will be shown in the higher segment if either of the systolic or diastolic values is above the cut off Eg a BP of 141 85 will end up in the 140 90 category 6 2 19 1 BP Mappings with Clinical systems The BP mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical application 6 2 20 FBG Fasting Blood Glucose Pathology
51. eceiver know what this password is so they can un encrypt the file when they receive it e Click the Test button to check a test file is successfully sent and received e Click OK Send Data Extracts Locations Configuration x Location Name FTP Location Enable Encrypt Password Send Data Method Secure FTP FTP Address Port Usemame Password Practice Details to be sent with data Contact Email Practice ID Practice Name Figure 10 1D Send data secure ftp configuration 13 June 2012 PAGE 79 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 10 2 Sending data to a location Once a dataset from the Extracts panel is loaded the right click function is available This will display the list of send to locations that have been configured for the practice to choose from NOTE Only deidentified data is sent e Load the data set you wish to send e Right click on the extract listed in the extracts panel e Select Send To e The list of configured locations will be available Figure 10 2A e Select the location e Aconfirmation dialogue box will appear Figure 10 2B e Click OK e A progress bar will display while the send is in progress Figure 10 20 e Once completed a status message will be provided Figure 10 2D e Ahistory record will be written under menu option Tools gt Send Data History Christine at PEN FTP
52. efer under Reports section Patient status filter PAGE 6 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Contents GOIMPANY CONTACTS TTE a a De GE ee ED eg EG sons Joust a Ee DE Re ee ees 2 Sydney Hedd OFFICE EE EE OER EE OE EE 2 Melbourne Office riii i EE EE EE EE OR EE Ke 2 DOCUMENT CONTACT acis OE cause Wreiastebarsteeat TAE OE EE NAE EON ORAE 2 DOCUMENTCONTROL 2 15 rus vi eet tart N LE N ER EE N 3 1 INTRODUCTION EE OE EE EE M Q 10 11 CLINICAL AUDIT TOOL CAT EUCH GUIDE SE ee GE EET 1 3 NOTES ABOUT THIS USER GUIDE uu sees see ee ee ee ee ee ee ee ee Re ee GR ee Re ee Re ee Re ee Re ee Re ee Re Re Re Re Re Re ee 11 1 4 DEFINITIONS ACRONYMS AND ABBREVIATIONS eese ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee ee 11 1 5 RELATED DOCUMENTS 2 SYSTEM REQUIREMENTS INSTALLATION AND CONFIGURATION e eeeeee eene eene nnne nennen nnns snnt nnn nnn 12 3 CAT USER INTERFACE n 13 3 1 NAVIGATING THE CAT USER INTERFACE uses ese ese eene ee ea Ga eke GR Re Gee Re Re Re Re Re ee Ge Re Re ee Re Gee Re Re Re ee ee ee Re Re ee ee ee 13 4A COLLECTING DATA SE EE NEENA ETEEN N E NAE aaisa 14 4 1 WHATDATAJSCOLUECTED 3 5 NE OE EE ee 15 4 2 HOW ISTHE DATA oie dee AA EE ER RE N Y 15 4 3 EXISTING DATA SET COMPATIBILITY WITH CHANGES TO CAT esse see ee ee ese ese eene ee ee ee enne
53. efined only diagnosis recorded patients should have a primary diagnosis of Type I or Type II recorded e Tick the Diabetes Type I NO checkbox e Tick the Diabetes Type II NO checkbox e Tick the Diabetes Undefined checkbox e Click the Recalculate button e Click the View Pop Button e The Patient report for this filtered group will no primary Diabetes diagnosis recorded 13 June 2012 PAGE 75 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 9 Timeline The Timeline functionality allows you to view changes in your data extracts over time Most graphs have a Timeline button at the top right near the Export and Print buttons Note that the timeline only shows data from the total patient population it does not work with filters e Click segments from any graph s you like The Timeline button of a graph becomes active when a segment is selected on that graph e Click any active Timeline button e The Timeline graph is loaded into the new Timeline tab at the far right of the tabs A Clinical Audit File Edit Took Help View Erasta Ven Fitar Repat View Pep Gear ters Recalculate i 5 rear ag die Samele wel E D EE A keerunisations Standard Reports MBS terre Tneine an Pr From Date 1 09 2008 je To Date 17 05 2010 D Recakodate Teneline Graph Pap Smear Recorded Pap Smear Recorded Pap Smeer Recorded
54. ements 13 June 2012 PAGE 4 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 17 05 2010 01 07 2010 Christine Chidgey Christine Chidgey Charts ACR INR added Condition Atrial Fibrillation added MBS Item changes 45 49 tab has been removed Timeline functionality Send Data To functionality Update the Ethnicity filter to include Not Recorded 6 09 2010 04 01 2011 27 07 2011 02 11 2011 24 11 2011 Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey QAIHC Report is available for MD and BP users Filters General add Medicare Number Conditions add extra Mental Health Medications add extra Mental Health and Respiratory Graphs add Spirometry Send Data To an additional email option is available Saved Filters can set a default to be preloaded Rename Gardasil Immunisation to HPV Update the ACR graph information Add practix compatibility Add Communicare compatibility Add Medinet compatibility Updates for APCC revised screens New filters for last visit activity postcode and suburb Condition Gestational Diabetes added Medication Dabigatran added New Screening tab this includes subtabs for the screening of Cervical and Colorectal Cancer Pap Smear and FOBT respectively The Pap Smear tab is unchanged but has been moved under the Screening tab MBS Items added a
55. er You can filter by e Practice all providers are ticked e One or more providers tick those you wish to filter on and un tick the No Assigned Provider box e No Assigned Provider to find patients that are not assigned to any provider Providers with No Patients There may be providers in your database that are not attached to any patients For example this can occur in MD when a patient is imported from another practice and the providers attached to the patient are imported as well to keep the patient history complete Providers with no patients attached to them are hidden by default The checkbox Hide Providers with No Patients defaults to ticked e To see all Providers un tick this box Kama Proeifnr Ma Ran Phone 1 Fhonn ON Faan M EO Meter Berea 12140578 r r er Z oa Padena ABCOEF 029908 15 A Wi feet mm CEREA V is Acrigred Pewee amp ston Abe v Hide Providers th Ha Patients Figure 5 9A Provider Filtering 5 10 1 Method of assigning a patient to a provider The method of Assigned Provider determination is provided in the Assigned Providers Appendix for each Clinical application 13 June 2012 PAGE 23 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 11 Saving Filter Criteria The Saved Filters tab allows a set of filter criteria to be saved as a named search Saved search names can be reloaded at a later time and run This gives
56. er pri oe EE N oec sl Rl ie Sumane Fi same M 3208 os 010 n0 78 13070 4 33 34 Figure 6 2 24 3A Diabetes SIP Worksheet NOTE Old Extract Files will only have a possible maximum of 10 items counted BMI BP and Foot items in the last 6 12mths have not been collected AN When claiming a SIP payment you should always check all requirements have been met in your clinical software system 6 2 24 4 Diabetes SIP Mappings with Clinical systems The Diabetes SIP mappings are provided in the Diabetes SIP Data Mappings Appendices for each Clinical application 13 June 2012 PAGE 56 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 25 CKD Chronic Kidney Disease Management The CKD Manangement gt Management Items graph has a target population of patients gt 15 years with a CKD diagnosis and without a history of renal dialysis or kidney transplant It displays a stacked bar chart showing the of patients that have a recorded value for each of the management items Blood Pressure BMI HbA1c if Diabetic LDL Total Cholesterol Smoking ACE ARB prescribed Statin prescribed Values are displayed as Recorded Recorded and at target Recorded and not at target Not Recorded A worksheet provides a report of all the management items for the target population More information about this graph is provided in the CKD Management Quick Reference Guide available from http help
57. evention Alliance Heart Foundation National Stroke Foundation Diabetes Australia and Kidney Health Australia About the Guidelines The National Vascular Disease Prevention Alliance NVDPA Guidelines for the assessment of absolute cardiovascular disease risk has been developed through an evidence and consensus based approach and has received endorsement from the National Health and Medical Research Council This guideline is the first Australian guide with recommendations developed specifically for the Australian population The key recommendation is Absolute cardiovascular risk assessment using the Framingham Risk Equation to predict risk of a cardiovascular event over the next 5 years should be performed for all adults aged 45 74 years without existing CVD or not already known to be at increased risk of CVD Commence assessment in Aboriginal and Torres Strait Islander adults at 35 years In the guidelines absolute risk is defined as the numerical probability of a cardiovascular event occurring within a 5 year period This is a more accurate prediction of a person s individualised risk of CVD compared with traditional methods based on single risk factor assessments e g high cholesterol high blood pressure etc This release represents an important step towards improving health outcomes by establishing a more integrated approach to cardiovascular disease prevention in Australia Clinical decisions based on absolute CVD risk will
58. ew various graphical representations of your data set Clinical Audit File Edit Tools Data Submission Prompts Help Coleg Mew Exrects ViewFiter Repot View Pop Figure 6 2A CAT Reports tabs These are e Demographics e Data Quality review patient data completeness and duplicate patients report e Allergies e Smoking e Alcohol e Measures o BMI Body Mass Index o Waist o BP Blood Pressure e Pathology o Lipids includes Cholesterol HDL LDL Triglycerides Total Chol HDL Ratio eGFR Estimated Glomerular Filtration Rate ACR Albumin Creatinine Ratio MALB Microalbumin HBA1c FBG Fasting Blood Glucose o INR International Normalised Ratio e Disease Count Prevalence e Screening o Pap Smear o Mammogram o FOBT e Medications o Count Prevalence o Medications per Patient o Scripts Not Printed in Last 6mths e Diabetes SIP Service Incentive Payment Items e CKD Management e Musculoskeletal e CV Cardiovascular Event Risk e Immunisations includes Influenza Swine flu Pneumococcal HPV Pertussis Child Schedule O O OOO 13 June 2012 PAGE 30 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 e Standard Reports o Indicator Sets APCC Australian Primary Care Collaboratives Report QAIHC Report Healthy For Life NT AHKPI National KPI o NPI National Performance Indicators o Data Summary Report Cards All views are of your fil
59. female patients aged 20 69 with a pap smear in last 2 yrs These reports cannot be filtered by date They are applicable only to the date at which the data collection was extracted The date of extract will appear on the reporst The reason is because CAT collects a snap shot of a patient s current results at the date of extract It does not collect a full patient history and hence it is not possible to create NPI reports retrospectively A report toolbar is available which provides functions to view print and export the document Medical Director 2 C Program Fles MDW2 Demogeptics Alergies Smoking BMI Disease Pap Smear Lipids Creatinine HbAlc BP Medications Diabetes SIP Items CV Event Risk F 4 gt NPCC Repo NPI Repot Summary Report Cord CDM2 CDM 3 PREV 4 EEN K DGPP Chronic Disease Management 2 NPI Indicator CDM 2 The number of patients within the Division with diabetes last recordedHbAc vathn the previous 12months EETA and lt and lt Recorded 8 0 10 0 All numbers and percentages weer ett pec Aboriginal Torres Strait Islander origin numbers s ol Y 0 0 o0 9 Extract Details Patient Court 13341 Printed 15 10 2006 10 41 AM Clinical Audit 2201 Pen Computer Systems Pty Ltd Figure 7 1 2A NPI Reports 13 June 2012 PAGE 68 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 7 1 3 Summary Report Card The Summary
60. her e Click the Recalculate button e Click the View Pop Button e The Patient report for this filtered group will be displayed and you will see that the sex column is empty or has something other than M or F 8 3 Patients with no Allergy status recorded The Allergies tab displays your data as a breakdown of allergy status Allergy Recorded No Known Allergies Nothing Recorded Use this tab to identify patients with the status of Nothing Recorded Refer to the section on Allergies 8 4 Patients with no Smoking status recorded Smoking displays your data as a breakdown of smoking status Daily Smoker Irregular Smoker Ex Smoker Never Smoked Nothing Recorded Use this tab to identify patients with the status of Nothing Recorded You may need to use the age filter to exclude patients under 10 years old Refer to the section on Smoking 13 June 2012 PAGE 74 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 8 5 Patients with incorrect Diabetes coding Patients with Diabetes should be coded with a Diagnosis of Type I or Type II To find incorrect coding search for 1 Patients with both Type I and Type II recorded e Tick the Diabetes Type T checkbox e Tick the Diabetes Type II checkbox e Click the Recalculate button e Click the View Pop Button e The Patient report for this filtered group will have both diagnosis recorded 2 Patients with an Und
61. ical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 7 BMI Body Mass Index Measures gt BMI displays your data as a breakdown of BMI status Morbid Obesity 40 Obese 30 to 40 Overweight 25 to 29 9 Healthy 18 5 to 24 9 Underweight lt 18 5 The data is displayed as e Count per age range in a bar chart e Average BMI per age range in a bar chart with the healthy range indicated e Incomplete where either of height weight or height weight are missing so BMI cannot be calculated Functions available are as described for Demographics Bar Chart The Count on the Count graph will show you the total of the patients graphed this is the total number of patients where BMI has been able to be calculated Figure 6 2 7A The Percentage equivalent of Ceunt is displayed in brackets Fe Edt Tek Help Reim mae D re am 3 Mee als ect 3 HON Live Data Fete By Condibeons fAsthenaNY ei Feeder Oemogsapivee Alejas Sacking Alcohol Mestuet Paho eur wou BP O dos al Const joue ircor iis DMI Count by Age Range population 173 Court B2 Percentage 33 3 EB Moros NEN Otee 200025 9 EED Org 25 29 5 ED Hey 18 590 225 M Urderwegrt ECTS 81 Huber of Patents 9 4 MN 3 3 30 34 40 44 52 54 n e N n 0 24 u 32 10 Figure 6 2 7A BMI Count of patients where data is complete 13 June 2012 PAGE 42 of 83 PCS Clinical Audit Tool Use
62. iec eE hd eR Re chistes sa Pd ck e e E Te Eee Fe ERR RE ER e ea ARES TERI 7 1 8 1 Collecting Additional Patients in CAT for Reporting 7 2 CROSS TABULATION REPORT ctii coss fs EE OE ean Fee OE EE iat 7 2 1 Clearing Report Selections DE EE EE EE Ra ER ER iaaa 8 HOW TO IMPROVE DATA QUALITY USINQG CAT issie eere oie eos entran neo EER aeuo Sea se Seen ia yeso EN E Ten eU re sa van Henna nen 74 8 1 PATIENTS WITH NO DATE OF BIRTH 8 2 PATIENTS WITH NO GENDER 8 3 PATIENTS WITH NO ALLERGY STATUS RECORDED sv cases is cese s eese EENS GR erre SENE ERGE Ge Ge ct ee GEE a SN eodeni eg ance ce cespeanansesececssy duane 74 8 4 PATIENTS WITH NO SMOKING STATUS RECORDED 555 esprit EVER Feo rre I E ges EX S EE Ee EN See SN GERS Ge Ee KERN SEE RE EE GER 74 8 5 PATIENTS WITH INCORRECT DIABETES CODING sussa ese skik ooo tt reae GEGEE Feo Eo ea EE ex GESE ER ER Ge Gee EE KEES Ee REVO GE ESE Ee SR Eint E AR ERE E Eg EUN 75 LIU ld 76 10 SEND DATA TO FUNCTION m 77 10 1 CONFIGURING LOCATIONS iis idee ER doe Sco eee reae e Das cea eese sedere esee utes Toa reos aepo dea DIR APR S eaa eee ee NE ea esie 77 10 2 SENDING DATA TO ALLOCATION Ee OE EE EE 80 11 CAT TOOLS MENU M 81 APPENDIX A1 GENIE DATA COLLECTION ses see se ee ee ee EE ER RE RE RR RE AA AE EER RE RA AA KA EE EE ER ER Ge ke ee 82 APPENDIX A2 PRACTIX DATA COLLEC
63. irector 3 HON Sample Data 5 Year Risk of a Cardiovascular Event Total P Count 106 8136 Eligible Pop 2440 M20 8EEOS 29 EEg20 2 5 16 197 BH 10 157 NENS 3 7 JA Nu mbe ol Patients 35 39 40 44 45 49 50 54 55 59 60 64 65 69 70 74 Age Range Calostution uses the Anse CORE dle Disease Ask Assessment Franinghan Rak Equation Based se ve pusicacce Natera Vasca Darase Freversice Abarce Guidelines forme assessment cl absokte cai dovas cua SERE rst 2009 Used weh permission from the Heart Foundation Ar online version of the CVD rak caicugior ca be found in www CASCO au Figure 6 2 27A CV Event Risk Report By selecting the high risk sections of the bar chart and clicking the Export button a list of the patients that make up this group can be obtained This provides valuable information for practice staff working to improve chronic disease management and prevention The information can also for example be used to substantiate the 45 49 year old health check 13 June 2012 PAGE 60 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Within the eligible population a patient may have incomplete results for the data items used in the calculation The risk therefore cannot be calculated for these patients This data is displayed under the tab e Excluded and Incomplete Excluded patient details Incomplete patient details Clinic
64. king the Collect button at the top left of the screen Once you click the Collect button you will see the status bar in the top right hand corner of the screen flashing while the data is retrieved from the clinical desktop system e Genie practiX and Medinet users please note that the data collection is performed from within your clinical application Clicking the CAT Collect button at the top left of the screen will provide you with the summary steps on how this is done within your clinical application Step by step details are provided in the Appendices A section of the Mappings document for your clinical system The data set collected is saved in your preferred data folder see Setting Your Preferences for more information When the data retrieval has completed you will see an entry in the left hand column Click the View Extracts button if the column is not visible The data is stored as a snap shot on your PC You can use this snap shot for analysis at any time in the future The data set will be loaded automatically if the collection has occurred within CAT Genie practiX and Medinet user will need to click on the required data set to load it Tip To refresh the list of snap shots toggle the Hide View Extracts button Collect button Status bar 3 Clinteal Aridit Com Gerad Condticre Nedicatcne Providers Genter Elhwicity Age Lost Visi Pestcede 100
65. l e Medications e Results e Patient Name e Providers Another tab is provided for you to save your selected filter criteria e Saved Filters To filter the data simply select the criteria you require to look at This is usually done by ticking selection boxes The criteria you have selected will be displayed at the top of the Results panel They will be displayed even if you hide the filter panel Click Recalculate You will see the status bar in the top right hand corner of the screen flashing while the filtered data is reloaded from the snap shot into Clinical Audit This will limit your data to look at only patients that match all the conditions ticked Example Filter By displays the criteria selected eg Male Diabetes Type II Aspirin 5 Clinteal Audit oO Om Hodel Dies 2 C Progr Fies O2 Fein By Cordon Diabetes Type ll Yeal Mede skot ipin Y ex Maer Alewpey Sarcting EMI Diese Pap Saway Lipids Cissinine H3AIol EP Nedicatons Diabetes SIP Iewe NPOC Report OV Even Ric HYR KPI Regot Figure 5 1A Filtering example Examples for each of the filter types are provided in the following sections 13 June 2012 PAGE 16 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 2 Changing Filters When you make changes to the filters the new selections do not become effective in the Reports until you have clicked the Recalculate bu
66. laboratives National Performance Indicators NVDPA National Vascular Disease Prevention Alliance PCS Pen Computer Systems 13 June 2012 PAGE 11 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 Queensland Aboriginal and Islander Health Council Royal Australian College of General Practitioners Service Incentive Payment 1 5 Related Documents PCS Clinical Audit Tool User Guide Part 1 Installation and Configuration This User Guide provides instructions on how to use install and configure CAT This guide is available from http help pencs com au cat htm 2 SYSTEM REQUIREMENTS INSTALLATION AND CONFIGURATION These sections are included in the PCS Clinical Audit User Guide Part 1 Installation and Configuration 13 June 2012 PAGE 12 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 3 CAT USER INTERFACE Once the CAT software has been installed it is available from your Programs List e Click Start gt All Programs gt Pen Computer Systems gt PCS Clinical Audit e Enter your Account name and Authorisation key and click OK 3 1 Navigating the CAT User Interface Click the View Extracts and the View Filter buttons to display all the areas of the CAT user interface The screen is divided into 3 sections Figure 3 14 e Data Snap shots or Extracts collected for analysis Left Hand Panel e Data Filters Top
67. me m Em pem pem pr pp al Al ML pr pempess se mis emm S Filtering By Conditions Asthma Yes Females Extract Details Medical Director version 2 Extract Date 10 06 2003 Patient Count 11776 Printed 25 06 2008 9 11 AM Clrveal Audit Nol Published 2 0 1 25 Pen Computer Systerns Pty Lid Figure 6 2 1F Patient Re identify Report for selected report segments 13 June 2012 PAGE 34 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 1 1 Reidentify Report The reidentify report allows you to identify a list of patient that make up e the filtered population e asegment of a pie or bar chart The last column of the report will give you information specific to the graph you are looking at for example e population list will show you the patient last visit date e demographics graph will show you age e BMI graph will show you the BMI value The Refine Selection button lets you remove patients from the reidentified list for printing purposes This is helpful if you wish to target a small number of patients for follow up and only wish to print those you are targeting e Click the Refine Selection button Figure 6 2 1 1A e From the pop up list of patients untick those you do not wish to target e Click OK the reidentified list has removed the unticked patients Refine Selection button Pat emt Reidentificetion Patlonts Report Age 5 Conditions Asthm
68. ment available from http help pencs com au cat htm APPENDIX A3 MEDINET DATA COLLECTION For Medinet users the data set collection is performed from within the Medinet software application Clicking the CAT Collect button at the top left of the screen will provide you with the summary steps on how this is done within Medinet For details of the steps in this process please refer to the Medinet data Mappings document available from http help pencs com au cat htm 13 June 2012 PAGE 82 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 APPENDIX B MEDICAL DIRECTOR DATA CATEGORY MAPPINGS APPENDIX C BEST PRACTICE DATA CATEGORY MAPPINGS APPENDIX D GENIE DATA CATEGORY MAPPINGS APPENDIX E ZEDMED DATA CATEGORY MAPPINGS APPENDIX F PRACTIX DATA CATEGORY MAPPINGS APPENDIX G COMMUNICARE DATA CATEGORY MAPPINGS APPENDIX H MEDINET DATA CATEGORY MAPPINGS The Appendices for each Clinical Desktop System s Data Mappings are provided separately They are available from http help pencs com au cat htm 13 June 2012 PAGE 83 of 83
69. n number to match chm file Additional information included in various sections Add Home Medicine Review Updates to Appendices Updates for Version 2 release Updates for new functionality Immunisations Data Summary Report Cross Tabulation Report 04 09 2008 Christine Chidgey Add revised screen shots for new functions 14 10 2008 09 12 2008 17 02 2009 26 03 2009 27 04 2009 20 05 2009 01 Lan 12 13 14 a 20 1 241 i 13 June 2012 Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey Christine Chidgey Updates for NPI Reports 2008 09 Clarification of BP results Updates for version 2 3 release and in particular to 1 add a Results Date filter 2 provide ability to save filter criteria 3 improve Diabetes SIP graphs The CAT User Guide has been split into 2 parts this is Part 2 which covers the functionality of the application Updates for the APCC Report The CAT User Guide Appendices B C and D have been split out into separate documents These Appendices cover the Clinical Desktop System data mappings for Medical Director Best Practice and Genie respectively Waist BSLF renamed FBG graphs added MBS Items graph added for MD Pracsoft3 users Additional Mental Health conditions and medications added to Disease and Medications graphs Refer to appendices for mappings PAGE 3 of 83 PCS Clinical Au
70. nditions provided in the conditions filter except for some Mental Health Conditions The data is displayed as e Count per condition in a bar chart e Prevalence per condition as a percentage of this population in a bar chart A bar is also provided on the chart for patients that have None of these disease categories This is provided to assist practices in targeting patients for preventative care and miscoding Functions available are as described for Demographics Bar Chart EDELE Bas Es Medal Diet 2 C Prag an Fe WOW Faeing By Ace Parent EN Oes Pap Sas Lipids Ossie Hoale BP Medostions Disteles SIP Mews OV Evert Aik HR kwnurnstions Stander Repos Total Count of Disease Cases population 5094 Ea Murter of Patents 40 ra rd LI LSE Figure 6 2 9A Disease Report 13 June 2012 PAGE 44 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 9 1 Disease Mappings with Clinical systems The conditions disease mappings are provided in the Conditions Data Mappings Appendices for each Clinical system Note that some conditions are flagged as true for a patient if the patient has ever had the condition ie the condition forms part of the patient history but is not currently listed as active eg heart disease Check the appendix for your Clinical system for details about how different conditions are colle
71. nts with CHD who are currently prescribed an ACE or ARB Medication Patents with CHO whose reg sae xosm pNeverSnoted SSCS iv Not Recorded Figure 7 1 1A APCC Report 13 June 2012 PAGE 66 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 APCC participating practices For practices participating in the APCC program the APCC has developed a process where the report along with a set of manually entered measures can be submitted to the Improvement Foundation IF web portal CAT provides functionality along with the APCC report to support this process APCC participating practices will be provided with a Health Service Token which is entered via the CAT Preferences screen The APCC Report functionality is available from a set of menu options contained at the top of the APCC Report tab APCC Report tab with menu options Standard Reports tab Clinical Audit File Edit Tools Data Submission Prompts Help SE Mew Fe jp N Geni RA Medical Director 3 HEN Sample Data Extract Date 24 11 2011 9 54 AM Disease Screening Medications Diabetes SIP Items CV Event Risk HMR Immunisations St indicator Ses NPI Report Summary Report Card MH Summary Report Car EE National KPI View History Prevention Measures f1 gt i O ig EE LLL 100 M A report toolbar is available which provides functions
72. o the following clinical systems e Medical Director Health Communications Network Medical Director Clinical Desktop System e Best Practice the Clinical Desktop System produced by Best Practice Software e Genie the Clinical Desktop System produced by Genie Solutions e Zedmed the Clinical Desktop System produced by Zedmed Medical Software Solutions e practiX the Clinical Desktop System produced by iSoft e Communicare the Clinical Desktop System produced by Communicare Systems e Medinet the Clinical Desktop System produced by Abaki There are other Clinical Desktop Systems that may interoperate with the PCS Clinical Audit Tool in the future and additions will be made to this User Guide when they are available 14 Definitions acronyms and abbreviations Description Microalbumin Creatinine Ratio Australian Primary Care Collaboratives Aboriginal Torres Strait Islander Body Mass Index Blood Pressure Best Practice Blood Sugar Level Fasting more commonly called FBG Clinical Audit Tool Coronary Heart Disease Chronic Obstructive Pulmonary Disease Cardiovascular Cardiovascular Disease Department of Health and Ageing Department Veteran Affairs Fasting Blood Glucose Estimated Glomerular Filtration Rate Haemoglobin Alc High density Lipoproteins Home Medicine Review Improvement Foundation Low density Lipoprotein Medical Director National E Health Transition Authority National Primary Care Col
73. occal Pertussis and Swine flu all display the most recent date the patient had the immunisation or if no immunisation is recorded e HPV displays the number of doses a patient has had or if no dose is recorded The reidentification report includes the date of the last immunisation e Child Schedule provides a pie chart for children aged 0 7 years with their immunization status Fully immunised a child has received all the immunisations required for their age Up to date a child is not fully immunised but no dose is due Due immunisations are due now Overdue immunisations are overdue A reidentification worksheet provides details for each immunisation in the schedule More information is available in the CAT Childhood Immunisations Quick Reference Guide available at http help pencs com au cat htm Immunisation tab r Clinical Audit File Edit Data Submission Pro Medical Director 3 HCN Sample Data T rto eene Swine flu memi pr prem HPV Pertussis Child Schedule Immunisation charts Tools Figure 6 2 28A Immunisations tab Functions available are as described for Allergies Pie Chart 6 2 28 1 Immunisations Mappings with Clinical systems The immunisation mappings are provided in the Medications Data Mappings Appendices for each Clinical application 13 June 2012 PAGE 62 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4
74. of it This will pop up the Patient Reidentify Report with a list of patient details The specific allergy value for each patient in the group selected will be provided in the last column Use the idi Export menu option to export the data to Excel format for follow up if required 6 2 4 1 Allergies Mappings with Clinical systems The allergies mappings are provided in the General Data Mappings Appendices for each Clinical system 13 June 2012 PAGE 40 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 5 Smoking Smoking displays your data as a breakdown of smoking status Daily Smoker Irregular Smoker Ex Smoker Never Smoked Nothing Recorded The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart 6 2 5 1 Smoking Mappings with Clinical systems The smoking mappings are provided in the General Data Mappings Appendices for each Clinical system 6 2 6 Alcohol Alcohol displays your data as a breakdown of alcohol status Drinker Non Drinker Nothing Recorded The data is displayed as a pie chart Functions available are as described for Allergies Pie Chart Alcohol level of risk is currently under discussion and will be added soon 6 2 6 1 Alcohol Mappings with Clinical systems The alcohol mappings are provided in the General Data Mappings Appendices for each Clinical system 13 June 2012 PAGE 41 of 83 PCS Clin
75. on 13 June 2012 PAGE 52 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 23 Medications Medications count per category Medications is displayed as a count by medication category of patients that are currently taking a medication in the category and the prevalence in the population The Medication Prevalence is calculated by identifying the number of patients taking a specific medication category and expressing it as a percentage of the total population The medication categories are the same as the medication groups provided in the medications filter except for some Mental Health Medications The data is displayed as e Count per medication category in a bar chart e Prevalence per medication category as a percentage of this population in a bar chart A bar is also provided on the chart for patients that have None of these medications categories This is provided to assist practices in targeting patients for preventative care and miscoding Functions available are as described for Demographics Bar Chart Medications count per patient The Medications Per Patient tab displays the current medication status as a breakdown of the number of medications per patient 0 1 2 3 4 5 6 7 8 The number of medications is simply a count of the medications listed as current for the patient The Medications Not Printed in Last 6mths displays the number of scripts per patient tha
76. pencs com au cat htm 6 2 26 Musculoskeletal The Musculoskeletal gt Musculoskeletal Risk Factors graph provides a graph of Musculoskeletal Risk Factors These are Low BMI Vitamin D deficiency Smoking High alcohol intake Calcium deficiency Fracture minimal trauma Chronic kidney disease Multiple myeloma Selecting all segments of the graph and exporting to the reidentified patient list will provide a worksheet with details of which risk factors each patient has This graph along with the new musculoskeletal condition and medication categories will allow patients at risk to be identified for follow up e Patients who have musculoskeletal risk factors and are not on a musculoskeletal medication e Patients who have musculoskeletal diagnosis and are not on a musculoskeletal medication 13 June 2012 PAGE 57 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 27 CV Cardiovascular Event Risk The CV Event Risk graph displays your data as the risk of a Cardiovascular Event in 5 years time It is a guide only based on population health statistics and is useful for clinicians to gain a high level view of patients who are at risk for surveillance It is derived from the publication National Vascular Disease Prevention Alliance Guidelines for the assessment of absolute cardiovascular disease risk 2009 which is available from the websites of the members of the National Vascular Disease Pr
77. r Guide Part 2 FUNCTIONALITY Version 3 4 6 2 7 1 BMI Mappings with Clinical systems The BMI mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical system 6 2 8 Waist Measures gt Waist displays your data as a breakdown of risk status The risk ranges differ depending on whether you are measuring waist for risk of CVD or Diabetes CAT provides 2 separate tabs e Waist gt CVD Risk e Waist gt Diabetes Risk Ranges CVD Risk Diabetes Risk Male lt 93 94 102 gt 102 Non ATSI Male lt 102 102 110 gt 110 Female lt 80 80 88 gt 88 Non ATSI Female lt 88 88 100 gt 100 ATSI Male lt 90 90 100 gt 100 ATSI Female lt 80 80 90 gt 90 and No Waist Recorded Functions available are as described for Allergies Pie Chart 6 2 8 1 Waist Mappings with Clinical systems The Waist mappings are provided in the General Data Mappings Appendices under Measurements for each Clinical application 13 June 2012 PAGE 43 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 9 Disease Disease is displayed as a count the number of patients that have the disease and the prevalence in the population The Disease Prevalence is calculated by identifying the number of patients with a specific disease diagnosis and expressing it as a percentage of the total population The disease categories are the same as the co
78. r your Clinical system for details about how different conditions are collected 13 June 2012 PAGE 20 of 83 PCS Clinica Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 5 2 Pregnancy Pregnancy is included under the Conditions gt Other filter Ticking this as Yes will give you a list of the patients who are currently flagged as pregnant in the Clinical System Check the appendix for your Clinical system for details about how this is checked 5 6 Medications Filtering Medications are divided into 3 tabs to allow for a greater number of medications to be selected These are e Medications Heart e Medications Respiratory e Medications Other ACE or ARB Antithrombotics Beta Blockers Calcium Diurctics Lipid MAying E Yes E No E Yes E No I7 Yes E No El Yes O No E Yes E No E Yes Ei No ace Bmw E Asprin E so Amihyperiansives I7 No States Fi No F ARS PI Ne 77 Ciopidogre 7 No F Chronic Heart F No E Other F Ne 7 Dabgatran No Myocardial E Ne 7 werte F Ne Gear Medications Clinical Audit mode MERO SEED um L Les E ES File Edit Tools Prompts Scheduler Help m T Yers ait ES Resuts Provides iz Saved M Figure 5 6B Medications Heart Filtering Selecting Medications by ticking the boxes Yes or No will limit your data to look at only patients that match the medication status selected Medication Yes No no selection
79. s areas of patient care that may need further management Some suggested filters are 1 Filter on Condition Schizophrenia 2 Filter on Medications Antipsychotics Where the filtered population shows increased risk or a lack of data for physical measures like BP BMI and Waist the practice may need to consider their overall management strategies for these patients The report can be exported to Excel 13 June 2012 PAGE 69 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 7 1 5 QAIHC Indicators Report The Queensland Aboriginal and Islander Health Council QAIHC have a set of core indicators designed to support quality improvement initiatives A subset of these indicators is provided in the CAT QAIHC Indicators report The CAT QAIHC Report is available for clinical systems where the CAT data extract meets the CAT data specifications version 1_6 or higher MBS Item Indicators in the report are available where the clinical and billing systems are provided by the same vendor More information is available in the CAT QAIHC Indicators Quick Reference Guide available at http help pencs com au cat htm 7 1 6 Healthy For Life Report Healthy for Life HFL is a program funded by the Office of Aboriginal and Torres Strait Islander Health OATSIH which aims to improve the health outcomes of Aboriginal and Torres Strait Islander peoples 10 essential indicators have been developed for reporting p
80. stems It translates data into real statistical and graphical information that is easy to understand and action This allows practitioners to assess and improve the quality and completeness of patient information The benefit to the practice is to assist with its ongoing accreditation and provide opportunities to grow practice income The emphasis of the tool is to help practice staff to take specific action to improve patient coverage in chronic disease management and prevention Other benefits of CAT are many and include e targeting patients with particular needs e targeting patients with specific health risk profiles e improved compliance with statistical data collections e extracting data to meet the needs of others e meeting reporting requirements Statistics that are required for the Australia Primary Care Collaboratives APCC program and the DoHA Future Directions Key Performance Indicators for Divisions are a by product of the use of the system 1 2 User Guide The purpose of this document is to provide instructions on how to install and use the functionality provided by the CAT This manual is split into 2 parts Part 1 Installation and Configuration including how to collect data sets Part 2 Functionality 13 June 2012 PAGE 10 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 1 3 Notes about this User Guide This User Guide describes the use of the PCS Clinical Audit Tool with reference t
81. t 1 Nov 2011 for GP Mental Health Careplan 2700 2701 2715 2717 MBS Item 11506 for Respiratory added NT AHKPI report is available for all users and can be submitted to the Improvement Foundation portal National KPI report is available for all users and can be submitted to the Improvement Foundation portal The IF data submission has moved to the main menu from the APCC Report Immunisations Childhood Schedule has been added 13 June 2012 PAGE 5 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 14 02 2012 27 02 2012 28 03 2012 Christine Chidgey Christine Chidgey Christine Chidgey HMR tab has been removed The Medications per Patient graph is now under the Medications tab Filters for musculoskeletal conditions and medications have been added Additional Pain Relief medications have been added New graphs reports a Medications gt Medications Not Printed in Last 6mths a Musculoskeletal Risk Factors The Communicare Patient Status flag has been added to the General filter tab Communicare Users only Data Quality tab providing a Clinical Data Self Assessment CDSA tool funded by NEHTA comprises of a suite of graphs and reports relating to data completeness Patient name filter Patient Report for individual measures 13 June 2012 13 06 2012 Christine Chidgey Extracting additional patients to meet reporting requirements r
82. t The last visit date is the most recent date a patient contact has been recorded In Medical Director this is deemed to be the date of the most recent progress note Check the General Data Mappings Appendices for each Clinical system Values for selection are e Any the last visit was at any time all patients will be selected e None no last visit is recorded e 15 mths has visited in the last 15 months e 30 mths has visited in the last 30 months e Date Range with from to date selection only patients whose most recent visit occurred within a period of time Patients with a visit after the to date will be excluded The Date Range filter to note The Date Range filter cannot be used to retrospectively look at the data in a snap shot The snap shot is only valid for the point in time at which it was taken For example If you filter on last visit between 1 and 2 years ago you will be excluding patients you have had a visit more recently These patients may or may not have had a visit in the period of time you are selecting You will not be selecting all patients who visited within that period Activity Activity is how often a patient visits the practice Values for selection are e Active has had 3 visits in the last 2 years RACGP definition e Not Active a patient not meeting the RACGP definition of active And Or e Number of Visits in the last 6 mths e Has not visited in the las
83. t Ventricular Hypertrophy is a condition that is detected by this test If LVH is detected as definite this value in the FRE is set to 1 otherwise it is set to 0 Currently the outcome of this test is not recorded as a coded value in the clinical software packages and therefore cannot be extracted Hence this value is always set to 0 13 June 2012 PAGE 59 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 CV Event Risk displays your data as a breakdown of the 5 Year Risk of a Cardiovascular Event gt 30 25 29 20 24 16 19 10 15 5 9 and lt 5 The data is displayed as e Count per age range in a bar chart Chart functions available are as described for Demographics Bar Chart The graph provides a total population number the filtered population and an eligible population number The eligible population is the number of patients in your filtered dataset that can be assessed for risk ie patients that do not fall into one of the excluded groups The Count on the Count graph will show you the total of the patients graphed this is the total number of patients where CV Event Risk has been able to be calculated The eligible population graph count patients with incomplete data where no risk can be calculated These patients are displayed on the second tab 106 patients counted File Edit Prompts Help Collect View Exracis Mew Fier Repat vew Pop Medcal D
84. t X mths where X can be selected Postcode Enter a 4 digit postcode you can use as a wildcard or Multiple postcodes can be entered separated by a comma This filter allows you to select whether the list of postcodes is for e Include in the filter Patients matching a postcode in the list will be selected e Exclude from the filter Patients matching a postcode will not be selected The Exclude option allows practices to find patients that do not reside in their local area and may be transient Suburb Enter a suburb The same options as for postcode apply to suburb 13 June 2012 PAGE 19 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 4 1 Demographic Filter Mappings with Clinical systems The demographic filter mappings are provided in the General Data Mappings Appendices for each Clinical system 5 5 Medical Conditions Filtering Conditions are divided into 3 tabs to allow for a greater number of conditions to be selected These are e Conditions Chronic e Conditions Mental Health e Conditions Other Clinical Audit File Edit Tools DataSubmission Prompts Help Repot Genera Conditions Medcatons Palet Name Aesuts Providers Saved Fer Chroic Mental Heath Other Diabetes Respiratory Cardiovascular Musculoskeletal Renal Impairment E Yes E No E Yes E No B Yes E No E Yes E
85. t have not been printed in the last 6 months ie that may be out of date Functions available are as described for Allergies Pie Chart Exporting the data to a patient list from this tab will show you exactly how many medications a patient is on Exporting this list to Excel will allow you to sort the data by medication count allowing you to target patients on the greatest number of medications 6 2 23 1 Medications Mappings with Clinical systems The medications mappings are provided in the Medications Data Mappings Appendices for each Clinical application Medications are flagged as true if they are on the patient s current medication list The collection process does not make any decisions about whether a medication should actually have been removed from the current medication list The GP is responsible for making sure the list of medications is accurate 13 June 2012 PAGE 53 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 24 Diabetes SIP Service Incentive Payment Items The Diabetes SIP graph is not automatically filtered by the patients with Diabetes To review your Diabetes SIP items you need to first filter on Condition Diabetes E XS S The filtering is not done automatically as some of the items may be of interest for the wider patient population eg CHD patients who have not had a BP in the past 6 mths Diabetes SIP displays your data as a breakdown of di
86. tered data set not your full data set except for the Indicator Sets Reports The Indicator Sets Reports will specify which population they are reporting on Some views are automatically filtered further to suit the data being represented The graph header or footer titles will specify the population that is displayed For example e Pap Smear and Mammogram filters out gender male e CV Event Risk filters out age Non ATSI 45 or gt 74 ATSI 35 or gt 74 condition Cardiovascular disease CVD e Immunisations gt HPV filters out gender male and age 9 13 June 2012 PAGE 31 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 6 2 1 Demographics and Bar Chart functions Demographics displays your data set as a breakdown of males females and age group The data is displayed as a bar chart of the number of patients per age group Age group defaults to years but can be changed to months by selecting Mths in the Age filter Choosing to view demographics in months allows children to be targeted ceme Gass 3 Meca Decor 3 HON Live Data Fein By Cotidie Asthana Veil Feet Tswang tioci Master Petrology Diea Pap See Hedcatons Diabetes SP leno CV Evert Fk ENA Ineuniiatons Stand Reood NES leve 2549 Check C3 sedet ll C Stow Tisi Course es Apeteder 5 i Pre Demographic Breakdown by Age population 173 Ferrales 173 Vales 0 Ofer ed
87. th summary statistics for these patients This report cannot be filtered by date It is applicable only to the date at which the data collection was extracted The date of extract will appear on the report The reason is because CAT collects a snap shot of a patient s current results at the date of extract It does not collect a full patient history and hence it is not possible to create an APCC report retrospectively The report shows a breakdown of patients by ATSI Non ATSI and Not Recorded Demographics Allergies Smoking Alcohol Measures Pathology Disease Pap Smear Medications Diabetes SIP Items CV Event Risk HMR Immunisations Indicator Sets NPI Report Summary Report Card MH Summary Report Card APCC Report QAIHC Report Healthy For Life Reports n n Gian GE Ed HM 4 1 fib ile O BaO 10x Find Next APCC Report CORONARY HEART DISEASE ATSI Number of patients on the CHD register 134 SS Patients with CHD whose last recorded BP within the last 12 months was a ail are BP lt 130 80 mmHg 75 9 0 CHD 004 Patients with CHD who are currently prescribed an Antiplatelet Medication CHD 005 Patients with CHD who are currently prescribed a Statin 1 Medication 1 1 1 Patients with CHD whose last recorded LDL Cholesterol within the last 12 months was CHD 006 LDL lt 2mmol l or if no LDL Cholesterol lt 4mmol l Cholesterol Recorded Patie
88. that falls within a specified time period or date range It is also applied to the MBS Items By selecting a date range of e lt 6mths lt 12 mths lt 24 mths User defined range the user can filter out results that have not been measured within the selected period Results outside the selected period are treated as Not recorded This will give a more meaningful picture for charts like HbA1c where old results are really not relevant The filter is only applicable to some charts Where the filter has been applied the chart title will include the selected period For example HBA tc Status population 6984 with last recorded result 3 3 2008 3 9 2008 5 8 Patient Name Filtering The patient name filter allows you to search by first name and or surname text 13 June 2012 PAGE 22 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 5 9 Patient Status Filtering This filter will only have available options if your extract contains patients that are archived or deceased Refer to the CAT Extracting Additional Patients Quick Reference Guide available at http help pencs com au cat htm for information about this functionality 5 10 Provider Filtering The provider filter allows you to filter patients by provider This allows providers within your practice to drill down to their own patients The provider filter tab displays a list of the practice clinicians with a provider numb
89. the ability for practices to run the same filters over intervals of time and compare results A saved filter can also be set as a default so it will be automatically loaded when CAT opens Clinical Audit File Edit Tools Prompts Help Collect View Extracts Hide Filter Report View Pop Clear Filters Recalculate C General Conditions Medications Results Providers Saved Filters Filter Hame Description Save New Filter E dit Delete Default Filter none v Figure 5 10A Saved Filters tab 5 11 1 Creating a New Filter Name Initially the Saved Filters tab will be empty To create a filter e Select some filter options eg Active Patient with Diabetes e The Save New Filter button will become available Figure 5 10 1A 5 Clinical Audit File Edit Tools Prompts Help General Conditions Medications Results Providers Safed Filters Filter Hame Description Save New Filter Edit Delete Default Filter none Medical Director 2 CAMDW2 Filtering By Active Patient Conditions Diabetes Yes Figure 5 10 1A Save New Filter button e Click the Save New Filter button e The Filter Details dialogue box will open e The filter options you have selected will be shown in the filter Description Figure 5 10 1B 13 June 2012 PAGE 24 of 83 Version 3 4 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Filter
90. to view print and bo document Figure 7 1 1B APCC Report functionality The APCC Report menu options are e Prepare Report this option has been replaced by the Data Submission main menu option which will guide the user through the data transmission process e View History allows the user to view a list of previous reports that have been submitted e Manual Measures a data entry screen for the manual measures e Prevention Measure a data entry screen for the prevention measures that are not collected Practices that are not participating in the APCC program will be able to use the report but will not be able to submit any data E L 4 APCC participating practices should refer to the PCS Clinical Audit User Guide APCC O Report and IF Submission which provides detailed information about the report and submission process This guide is available from http help pencs com au cat htm 13 June 2012 PAGE 67 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 7 1 2 NPI National Performance Indicators Report The NPI Reports are available under the Standard Reports tab The NPI Reports are always derived from your full data set not your filtered data set The following NPI Reports for 2009 10 are available e CDM 2 for reporting on Diabetes patients HbA1c results in last 12mths e CDM 3 for reporting on CHD patients with BP lt 130 80 in last 12 mths e PREV 4 for reporting on
91. tspace Location Name Send Data Method Email MAPI Outlook Email SMTP Other Secure FTP This email option requires a MAPI compatible email client such as Microsoft Outlook or Outlook Express to be installed and configured on this machine Figure 10 1B Send Data configuration screen To configure a new email location Select Edit gt Send Data Extracts Locations from the menu bar Figure 10 1A The Send Data Extracts Locations configuration screen will be displayed If you use Outlook select Email MAPT from the drop down Send Data Method list Figure 10 1B Otherwise select Email SMTP Enter a location name that describes where the data will be sent Click Add 13 June 2012 PAGE 77 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY Version 3 4 e Anew location tab will added to the Send Data Extracts Locations window with the location name you have provided e MAPI Fill in the mandatory fields Figure 10 10 o Email To Address o Practice ID and Practice Name e SMTP Additional mail server fields will be required to be completed You may need to check with your service provider or system administrator to configure the settings correctly e Other fields are optional e Ifyou wish to encrypt the zipped data file tick Enable Encrypt and provide a password You will need to let the receiver know what this password is so they can un encrypt the fil
92. tton e The Recalculate button will turn red when the filter text has changed but the button has not been clicked Genes p e Ifthe Recalculate button has not be clicked the correct previous filter text will display on any printed graphs and reports 5 3 Clearing Filters To clear filters that have been selected either e Click the Clear Filters button in the top right hand corner of the screen to clear all your filters The Clear Filters dialogue box will appear Note This dialogue box is also used to clear any Report Selections that have been made Refer to the Cross Tabulation Report for details on this functionality The Clear all Filter Selections will be pre ticked Click OK to continue Please tick which selections you wantto clear V Clear all Filter Selections C Clear all Report Selections e Click the Clear button at the bottom right hand corner of each tab to clear only the filters for that tab AN NOTE Make sure you click Recalculate when you have changed the filters 13 June 2012 PAGE 17 of 83 PCS Clinical Audit Tool User Guide Part 2 FUNCTIONALITY 5 4 Demographic Filtering Clinical Audit Version 3 4 File Edit Tools Prompts Scheduler Help Cem Reo Memes E General Condtons Medostions Resus Providers Saved Fiters Pini Ede Age Last Vis Activity Postcode hdude
93. urposes These indicators cover the areas of e Maternal and Antenatal indicators 1 4 e Child Health indicators 5 6 e Adult Health indicators 6 10 The CAT HFL Report is available for clinical systems where the CAT data extract meets the CAT data specifications version 1 6 or higher MBS Item Indicators in the report are available where the clinical and billing systems are provided by the same vendor More information is available in the CAT HFL Quick Reference Guide available at http help pencs com au cat htm 7 17 NT AHKPI Indicators Report The NT AHKPI Northern Territory Aboriginal Health Key Performance Indicators is a collaboration between the Northern Territory Aboriginal Health Forum AHF partners to develop a Northern Territory wide primary health care performance reporting system for collecting and reporting key performance indicator KPI data These KPI s were developed to provide information to support health services in planning activities and in contributing to evidence based reporting requirements The CAT NT AHKPI Report is available for clinical systems where the CAT data extract meets the CAT data specifications version 1 6 or higher MBS Item Indicators in the report are available where the clinical and billing systems are provided by the same vendor More information is available in the CAT NT AHKPI Indicators Quick Reference Guide available at http help pencs com au cat htm 13 June 2012 PAGE

PCS Clinical Audit Tool – User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents

PCS Clinical Audit Tool &ndash; User Guide

Contents

Download Pdf Manuals

Related Search

Related Contents

PCS Clinical Audit Tool – User Guide