Activity Based Funding - URG Grouper User Guide
Contents
1. Activity Based Funding URG Grouper User Guide IHPA Independent Hospital Pricing Authority URGGrouper User Guide Introduction The URGGrouper application has been developed by Independent Hospital Pricing Authority IHPA to assist state and territory health departments and hospitals to group hospital emergency department data to the URG classification system This application provides the following facilities 1 The ability to map other version of diagnosis codes to major diagnosis blocks 2 The ability to group an Access data file interactively and view group results and summary results The ability to batch group Access data files interactively The ability to group text files interactively and view group results and summary results and 5 The ability to batch group text files interactively Please note URGGrouper has been developed according to the agreed URG classification system and tested with sample data However issues may be identified as states and territories and hospitals run real life data through the software If you think that URGGrouper is grouping records incorrectly we would appreciate your assistance by notifying us as soon as possible in order to confirm and correct faults immediately Contact us For more information contact ABF Data Acquisition Independent Hospital Pricing Authority Level 6 1 Oxford Street DARLINGHURST NSW 2010 Phone 02 8215 11302. 4 Click the Batch Group button then the application starts grouping data files URG Grouper Select Folder Subfolders Included C Datatable Name Same As File Name List Files Settings List Files Please input datatable name B1_ED Extra Output Field s URGMDB ICD 10 AM 6th Edition E Ex_Access mdb Done E Ex_Access2 mdb Processing Information Files Processing Grouping E Ex_Access2 mdb When the grouping is completed a Complete message will be popped out and the running time will be displayed in the bottom of the tab page URG Grouper User Documentation 15 14 of URG Grouper Bacth Group Select Files Select Folder 7 Subfolders Included E Datatable Name Same As File Name PT List Files Settings Please input datatable name B1_ED Extra Output Field s URGMDB ICD 10 AM 6th Edition URG Grou X Completed Processing Information Running Time Time taken 69s The log will show whether a file is grouped successfully or not Please note episodes grouped to an E5 error diagnosis code no MDB map were given an ERR value in the MDB output field in the previous version In this revised grouper these episodes are still grouped to an E5 error however the output field for MDB is left blank as no MDB can be allocated URG Grouper Bacth Group Select Files Select Folder Subfolders Includ
3. Fax 02 8215 1111 Copyright Commonwealth of Australia URG Grouper User Documentation 2 of 15 Abbreviations The following abbreviations are used throughout this document Australian Modification AR DRG Australian Refined Diagnosis Related Group Clinical Modification Emergency Department International Classification of Diseases and related health problems ici MD MD ndependent Hospital Pricing Authority M B Major Diagnostic Block Major Diagnostic Category B C Urgency Disposition Groups Urgency Related Groups URG Grouper User Documentation 3 of 15 Input Fields A URG code is determined by five factors Episode End Status Type of Visit Triage Sex and Diagnosis Code In addition a Diagnosis Type field is required to identify the diagnosis code reported The valid values for the Episode End Status field are Admitted to this hospital including to units or beds within the emergency department D Non admitted patient emergency department service episode completed departed without being admitted or referred to another hospital Non admitted patient emergency department service episode completed j referred to another hospital for admission non admitted patient emergency department services episode was completed 6 Died in emergency department as a non admitted patient 9 Notstated inadequatelydescribed S Not stated inadequately described The valid value
4. AM 6th Edition Processing Information Files Processing Grouping Progress fa 2 Click the List Files button to list added Access files URG Grouper User Documentation 15 11 of i URG Grouper Single File Group Bacth Group Select Files Select Folder Subfolders Included C Datatable Name Same As File Name Plase input datatable name B1_ED C ICD 10 AM 6th Edition E Ex_Access2 mdb E Ex_Access mdb Processing Information Files Processing 3 Specify the data table name to be grouped in the Access databases by ticking the box Datatable Name Same As File Name i URG Grouper Single File Group Bacth Group Select Files Select Folder Subfolders Included Datatable Name Same As File Name List Files Settings Please input datatable name Extra Output Field s C URGMDB C ICD 10 AM 6th Edition E Ex_Access mdb E Ex_Access2 mdb L Processing Infomation Files Processing or input data table name URG Grouper User Documentation 12 of 15 im URG Grouper Select Files Select Folder Add Files Subfolders Included Add Folder C Datatable Name Same As File Name List Files Settings Please input datatable nam Extra Output Field s E Ex_Access mdb E Ex_Access2 mdb Processing Information Files Processing Please note if user tick Dat
5. be grouped i MM C URGMDB C ICD 10 AM 6th Edition View Result View URG Summary Processing Information CT Select an Access File 2 Specify the data table to be grouped in the Access database A new column called URG will be created in the specified data table If users wish to include MDB column in the table please tick the box URGMDB 1 URG Grouper Single File Group Bacth Group Select A File Select An Access File Extra Output Fields Please select the data table to be grouled C ICD 10 AM 6th Edition View Result View URG Summary Processing Information CT URG Grouper User Documentation 6 of 15 If the ICD version reported is not ICD 10 AM 6 Edition user can also include an XO06DDX mapped ICD 10 AM 6 Edition codes from the reported diagnosis codes column in the output table by ticking the box ICD 10 AM 6 Edition i URG Grouper Single File Group Bacth Group Select A File E Ex_Access mdb Select An Access File Extra Output Fields Please select the data table to be grouped B1_ED URGMDB ICD 10 AM 6th Edition View Result View URG Summary Processing Information 3 Click the Group button then the application starts grouping data i URG Grouper Single File Group Bacth Group Select A File E Ex_Access mdb Select An Access File Extra Output Fields Pl
6. a table Name Same As File Name then the application will only group data table with the same name as the file name if it exists in the database If user input a data table name then the application will only group this data table if it exists in the database A new column called URG will be created in the specified data table If user wishes to include MDB column in the table please tick the box URGMDB i URG Grouper Single File Group Bacth Group Select Files Select Folder Subfolders Included C Datatable Name Same As File Name List Files Settings Please input datatable name 7 B1_ ED i Extra Output Field s vw URGMDB WF CD 10 AM amp th Edition E Ex_Access mdb E Ex_Access2 mdb Processing Information Files Processing If the ICD version reported is not ICD 10 AM 6 Edition user can also include an XO6DDX mapped ICD 10 AM 6 Edition column in the output table by ticking the box ICD 10 AM 6 Edition URG Grouper User Documentation 13 of 15 i URG Grouper Single File Group Bacth Group Select Files Select Folder Subfolders Included Add Folder E Datatable Name Same As File Name List Files Settings List Files Please input datatable name B1_ED Extra Output Field s URGMDB ICD 10 AM 6th Edition E Ex_Access mdb E Ex_Access2 mdb Processing Information Files Processing
7. ease select the data table to be grouped B1_ED URGMDB ICD 10 AM amp th Edition Processing Infomation Grouping E Ex_Access mdb URG Grouper User Documentation 7 of 15 When the grouping is completed a Complete message will be popped out and the running time will be displayed in the bottom of the tab page URG Grouper Select A File View Result Processing Information Completed Grouping E Ex_Access mdb View URG Summary Extra Output Fields ICD 10 AM 6th Edition 4 The group results will show in a pop up window once the View Results button was clicked im URG Grouper HER Select A File E Ex_Access mdb Please select the data table to be grouped Select An Access File Extra Output Fields URGMDB ICD 10 AM 6th Edition Processing Information Completed Grouping E Ex_Access mdb Time taken 14 s URG Grouper User Documentation 8 of 15 URG Grouper View Result Ajna Ow me em Ww Ow oO woo eo M S SIBIBISIPI2IS Y000021 39732 Y000021 39969 2 2 2 2 2 2 2 2 2 1 1 1 2 2 3 2 2 gis sislsislsislsislsislslslslsl sls 5 User is able to view the URG summary results by clicking the View URG Summary button i URG Grouper Single File Group Bacth Gro
8. ed Datatable Name Same As File Name ICD 10 AM 6th Edition Processing Information Completed Grouping E Ex_Access2 mdb Time taken 69s URG Grouper User Documentation 15 of 15
9. s for the Type of Visit field are Dead on arrival Not reported unknown The valid values for the Triage field are Description Emergency Within 10 minutes Triage Category not assigned The valid values for the Diagnosis Type field are 1 edition ICD 10 AM 3 edition ICD 10 AM 5 edition ICD 10 AM 6 edition ICD 10 AM 7 edition ICD 10 AM URG Grouper User Documentation 4 of 15 8 edition ICD 10 AM AR DRG MDC 90s No diagnosis classification provided The valid values for the Sex field are 1 9 Not stated inadequately described __ A unique episode number for each episode is also required to link the URG with the complete ED episode Access File Format The following table shows the field structure required in the Access data table Note that your data table must follow this structure in order to run this application Tyseol vial Pent Lene Text Length 1 DiagType Diagnosis Type Text Length 2 diag 1 Diagnosis Code URG Grouper User Documentation Text 5 of 15 How to group a Microsoft Access file 1 Open URGroupA and from the Single File Group tab page click the Select an Access File button to select the Access file to be grouped aw Uper Single File Group BactiliGroup Select A File Select An Access File Extra Output Fields Select the data Please select the data table to be grouped table able to
10. up Select A File E Ex_Access mdb Select An Access File Extra Output Fields Please select the data table to be grouped URGMDB ICD 10 AM 6th Edition Processing Information Completed Grouping E Ex_Access mdb Time taken 14s URG Grouper User Documentation 9 of 15 URG Grouper View Result URG Grouper User Documentation 10 of 15 How to batch group Microsoft Access files 1 Open URGroupA and from the Batch Group tab page click the Add Files button to add Access files or click Add Folder button to add Access files in the folder ul URG Or Supe Single Fileffroup Bacth Group Select Folder Add Acces S C Subfolders Included C Datatable Name Same As File Name Files oe i List Files Settings Please input datatable name B1_ED C URGMDB C ICD 10 AM 6th Edition Specify the table name Processing Information Files Processing CT Grouping Progress Add a Folder If the box Subfolders Included is ticked then clicking Add Folder button will add all Access files in the folder and its subfolders i URG Grouper Single File Group Bacth Group Select Files Se j wider Add Files C Subfolders Included Add Folder C Datatable Name Same As File Name List Files Settings Please input datatable name B1_ED Extra Output Field s C URGMDB C ICD 10
Download Pdf Manuals
Related Search