User Manual. - Health & Social Care Information Centre
Contents
1. Log empty gt Double clicking on a record within the display opens it in the Single Spell Grouping screen HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved Page 16 of 41 The Casemix Service The space beneath each field name allow the user to enter filter criteria to limit the records displayed based on one or more starting characters Pressing the Enter key activates the filter The screenshot below shows the display file feature with an active filter ic HRG4 2009 10 Reference Costs Grouper File Edit Tools Help DAE ee rvaaB 5000 Episodes csy NHS DIAG_12 DIAG_13 DIAG_14 OPEROI OPER_02 OPER_03 OPER_04 The l Information Centre for health and social care J481 J021 F104 D759 5560 N221 lt Current Database 5000 Episodes csv z i j YenNznq0000e lt Log empty gt Multiple criteria can be added by entering values in more than one column To remove a filter criterion delete it and press the Enter key HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 17 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Single Spell Grouping This option allows real time grouping of individual records using data manually entered by the user The mandatory fields for the currently selected dat2. M Multiple trauma DominantProcedure but at spell level The primary diagnosis used when spell grouping The 1st secondary diagnosis used when spell grouping The number of episodes in the spell The duration of the spell used for grouping The length of stay used when generating reports This field is populated in reference cost groupers only The trimpoint for the HRG allocated to the spell This field is populated in reference cost groupers only The number of days the spell exceeds the trimpoint This field is populated in reference cost groupers only The number of critical care days in the spell Includes a row for each episode that contains an error in relational form RowNo The key into other files Iteration In conjunction with RowNo provides a unique key for the record Code Type The field type causing the problem HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 34 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Code Where populated the value of that code causing the problem Error Message Explanation of the problem 9 File name _ssc_rel csv Contains the Specialised Service Codes There will be no entries for Spells that do not have SSCs RowNo The key into other files In this case it is the row number associated to the spell first episode in the spell Procodet The organisation code from the user s input
3. A Record Definition File RDF is required by the Grouper to identify the locations of the fields in the source data The Record Definition File Wizard allows the user to create a Record Definition File The Record Definition File Wizard is accessed via the New RDF item on the File menu Using the Record Definition File Wizard Step One Note that sample Record Definition Files are provided as part of the grouper installation program these can be found within the grouper program folder User defined RDFs allow users the flexibility of using the grouper with locally defined input file layouts Record Definition File Wizard Database Admitted Patient Care HAG4 Description APC ICD10 0PCS4 Reference Cost Grouper 09 10 Data Definition Method Create fields manually Enter field positions and characteristics directly using the Record Definition File editor Create from a sample file Visually define field positions from a sample input file The mandatory fields required in the RDF are different for each database The Create fields manually option allows the user to use a grid to define field positions and attributes To jump straight to the RDF editor select this option and click the Next button The Create from a sample file option allows the user to create an RDF interactively using a sample data file Clicking Next will prompt the user to select the file on which the RDF is to be based HRG4
4. Casemix Service HRG4 EF HRG4 2009 10 Reference Costs Grouper User Manual 31 March 2010 The Casemix Service HRG4 2009 10 Reference Costs Grouper User Manual Table of Contents In Adobe Reader the Bookmarks tab can be used to show the table of contents in a separate panel Record Definition Files 3 Grouping Modes 3 Running the Grouper from the Command Line non interactive mode 3 Grouping in Interactive Mode 4 The Grouper Main Screen 7 Current Database 9 Record Definition File Wizard 10 Record Definition File Editor 13 Process File 15 Display File 16 Database Selection Screen 19 Subtraction of Days from Admitted Patient Care Duration 24 Picture 25 Extract 27 Contact Information 29 HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 2 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Record Definition Files The grouper relies on a text file called a Record Definition File RDF to indicate the field position column number of each of the mandatory fields in the input file The entries in the RDF act as pointers so that the grouper knows the location of each field in the input file Each time the grouper is run the user must ensure that an appropriate RDF is selected For convenience the grouper installation includes sample RDFs one for each of the data types that the application can process These files can be found in the g
5. Data has headings Reports FCE Daycases by TFC and HRG4 FCE Daycases Diagnosis Procedure by TFC and HRG4 FCE Truncated Elective Inpatient Bed Days by TFC and HRG4 FCE Truncated Elective Inpatient Bed Days Diagnosis Procedure by TFC and HRG4 FCE Truncated Non Elective Inpatient Bed Days by TFC and HRG4 FCE Truncated Non Elective Inpatient Bed Days Procedure Diagnosis by TFC and HRG4 FCE Excess Inpatient Bed Days by TFC and HRG4 Unbundled HRG4 Admitted Patient Care FCE Truncated Non Elective Long Stay Inpatient Bed Days by TFC and HRG4 FCE Truncated Non Elective Long Stay Emergency Inpatient Bed Days by TFC and HRG4 FCE Truncated Non Elective Long Stay Non Emergency Inpatient Bed Days by TFC and HRG4 FCE Non Elective Short Stay Inpatient Bed Days by TFC and HRG4 FCE Non Elective Short Stay Emergency Inpatient Bed Days by TFC and HRG4 FCE Non Elective Short Stay Non Emergency Inpatient Bed Days by TFC and HRG4 J Crall N anasana heu UDCA Deselect all Select all Process Cancel It is crucial that the file selected in the Filename box is a previously processed non relational FCE output file the output file that has the name ending in _FCE The use of other output files will result in reports that are either blank or contain incorrect figures Note that reporting from a previously grouped file should only be done if the grouped file was produced using the same version of the HRG4 Reference Cost Group
6. Database Selection Record Definition File Editor File Display e Log Area This area displays progress and status messages during and after grouping HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 8 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Current Database ic HRG4 2009 10 Reference Costs Grouper File Edit Tools Help AQE raaB Current Database The Information Centre for health and social care lt Log empty gt Database Admitted Patient Care HAG4 Description Record Definition File C Program Files IC HRG4 2009_10 RC Grouper HRG4_sample_APC dh The current database is shown on the main window of the application see screenshot above The user must ensure that the Database selected matches the data type of the Record Definition File and the type of data to be grouped Failure to ensure that the data type of the RDF and the database match will lead to grouping errors The Record Definition File drop down box displays any Record Definition Files that have been used within the current session The Browse button allows the user to locate Record Definition Files HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 9 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Record Definition File Wizard
7. and HRG4 Unbundled HRG4 Non NACReport003 rgf _NACReport003 xml Admitted Consultations Adult Critical Care Report Title Command line Output file name extension Adult Critical Care by HRG4 ACCReport001 rgf _ACCReport001 xml Emergency Medicine Report Title Command line Output file name extension Emergency and Urgent Care EMReport001 rof _EMReport001 xml by HRG4 A amp E The user has the option of producing reports either during processing a file or as a separate operation To produce reports during file processing select the required reports in the Process File dialog box This is done using the check boxes next to the report names HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 22 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service To produce reports based on a data file that has already been grouped select Run Reports from the Tools menu This opens the Run Reports dialog box shown below which allows selection of the grouped data file and the record definition file that was used to group it Select the required reports from the list by clicking the checkboxes and click the Process button Run Reports File Format Record Definition File Program Files IC HRG4 2009_10 RC Grouper HRG4_sample_APC rdf Previously processed non relational FCE file Filename l
8. Iteration Fields The role of the RowNo field is to provide a method of uniquely identifying FCEs within output files The existence of a unique identifier for FCEs allows related records to be identified in different output files For example in the case of unbundled HRGs the file name _ub_rel csv shows the unbundled HRGs for each output row The field RowNo contains the RowNo of the matching output record in the file name FCE csv If these files are imported to a relational database the RowNo fields can be used as the basis from which to derive keys to allow the relationship between these records to be represented Where there is more than one related record for example where there are more than one unbundled HRGs for an FCE the field Iteration is used to differentiate between the multiple related records Examples of where Iteration is used are e aninput row may generate more than one unbundled HRG e aninput row may result in more than one data quality message There is no significance to the numerical values of Iteration the numbers are assigned in order according to the order of the input data the sorted input data in the case of files that are sorted prior to grouping Admitted Patient Care A single input file produces eleven output files 1 File name csv A list of other output files this file is for validation only and will normally be ignored by users 2 File name s
9. based grouping Programme Budgeting Category This field is populated in reference cost groupers only The calculated episode duration This is the input Episode duration minus the number of critical care days entered The episode duration used when generating reports This field is populated in reference cost groupers only The episode trimpoint for the HRG allocated to the episode This field is populated in reference cost groupers only The number of days that the episode exceeds the trimpoint This field is populated in reference cost groupers only Used when generating reports from grouped data This field is populated in reference cost groupers only The spell level Core HRG An indication of the grouping method used for the episode P Procedure driven D Diagnosis driven M Multiple trauma DominantProcedure at spell level The primary diagnosis used when spell grouping The 1st secondary diagnosis used when spell grouping The number of episodes in the spell The duration of the spell used for grouping The length of stay used when generating reports This field is populated in reference cost groupers only The trimpoint for the HRG allocated to the spell This field is populated in reference cost groupers only The number of days the spell exceeds the trimpoint This field is populated in reference cost groupers only HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Author Casemix Serv
10. by TFC and HRG4 FCE Excess Inpatient Bed Days by TFC and HRG4 Select all reports Deselect all reports Process Cancel When all selections have been made click the Process button to group the file A progress bar is displayed When grouping is complete the progress bar and the Process File dialog box will close the application returns to the Main Screen It is very important that the user examines the entries in the log area after grouping If grouping fails this will be reported in the log area HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 15 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved Display File The Casemix Service The application provides a Display File facility accessed from the Tools menu The fields displayed using this facility are restricted to those defined in the Record Definition File The field positions pictures and extract values from the RDF are applied The output is a text file so can be opened using other applications ic HRG4 2009 10 Reference Costs Grouper File Edit Tools Help ADMIMETH DISDEST The DisDes Information Centre for health and social care DISMETH DisMeth woe amp Se ww EPIDUR EpDur 10 131 43 125 19 218 17 3 MAINSPEF MainSpec 350 145 370 499 130 330 120 100 NEOCARE TRETSA NeoLevel TmtFun o o o o o o ao v Bi
11. grouper using the shortcut on the Windows Start menu HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 4 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Steps to group a file 1 Export data e g from a Patient Administration System or other computer system in comma separated text format It is strongly recommended that field names are included as the first row of the data extract this makes it considerably easier to work with the file The Guide to File Preparation document available from the Casemix web site specifies the input file mandatory fields and their formats 2 On the grouper main screen Current Database tab select the Database that corresponds to the data type to be grouped ic HRG4 2009 10 Reference Costs Grouper File Edit Tools Help a INHS The Information Centre for health and social care Current Database Click here to select database Database Admitted Patient Care HRG4 Description Record Definition File C Program Files IC HRG4 2009_10 RC Grouper HRG4_sample_APC rdf lt Log empty gt 3 Select an appropriate Record Definition File RDF for the database to be used for grouping This is done by clicking the Browse button and navigating to the appropriate RDF Ensure that the RDF is intended for use with the same data type as the selected database e g if the selected database is
12. number of report rows may exceed this number When opening a report where the number of rows exceeds the available number of worksheet rows Excel will display an error message such as Problems During Load In this case the entire report may be viewed using Excel 2007 or later Admitted Patient Care Truncation Where the report title includes the word truncated this means that any episodes having a duration that exceeds the reference costs trimpoint use the trimpoint as the episode duration i e they are truncated at the trimpoint The excess bed days report shows the total days where trimpoints have been exceeded Automatic Adjustments in Admitted Patient Care reports During report generation one day is automatically added to the episode duration of zero length ordinary admission episodes Patient Classification 1 This is in line with NHS Reference Costs guidance This does not apply to daycases FCE Reports Report Title Command line Output file name extension FCE Daycases by TFC and APCFCEReport001 rgf _APCFCEReport001 xml HRG4 FCE Daycases APCFCEReport002 raf _APCFCEReport002 xml Diagnosis Procedure by TFC and HRG4 FCE Truncated Elective APCFCEReport003 rgf _APCFCEReport003 xml Inpatient Bed Days by TFC and HRG4 FCE Truncated Elective APCFCEReport004 rgf _APCFCEReport004 xml Inpatient Bed Days Diagnosis Procedure by TFC and HRG4 FCE Truncated Non Elective APCFCEReport005 rof _APCFCERepor
13. 0 The NHS Information Centre All rights reserved Non Admitted Care The Casemix Service A single input file produces seven output files 1 File name csv 2 File name attend csv lt input data gt RowNo NAC_HRG GroupingMethodFlag DominantProcedure UnbundledHRGs 3 File name quality csv lt input data gt RowNo Error Message 4 File name attend rel csv lt input data gt Contains a list of all the other files produced This file will normally be ignored All of the input data for the attendance including any non mandatory fields are reproduced in the output A unique row number field applied when grouping This serves as the key for other output files The Core HRG for the attendance An indication of the grouping method used for the attendance The dominant procedure used for procedure based grouping A variable number of fields containing unbundled HRGs at episode level Unbundled HRGs are appended to the end of each record there may be zero one or more unbundled HRGs per record This file contains one row per attendance that contain errors All of the input data for the attendance including any non mandatory fields are reproduced in the output The row number field mentioned in the attend file It is unique within the file A variable number of fields containing the error message Each message is the three fields shown in the relational quality file separated
14. 2009_10 Reference Costs Grouper User Manual v1 0 Page 10 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Using the Record Definition File Wizard Step Two Where the user selects Create from a sample file from the dialog box described in Step One the user is prompted to browse for the file after which the dialog box shown below is displayed Record Definition File Wizard Drag items from the mandatory field list to the field Mandata A ete cc det Da below to assign them Unassign fields by PROCODET selecting them and pressing delete PROVSPNO EPIQRDER Number of diagnosis codes 14 ed TAGE Number of procedure codes 12 TOE ADMIMETH DISDEST BISMETH EPIDUR mame e v Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Fie OrgCode SpellNum EpNum Age Sex PatCla AdnSre Adn Preview lt area lt gt The first row of the data file is displayed in the lower part of the dialog box the preview area above it temporary field names Field 1 etc are shown The preview area automatically assigns field positions based on the comma positions in the file For Admitted Patient Care the Number of diagnosis codes and Number of procedure codes values may be edited to allow the processing of files that contain a non standard number of clinical codes Other data types allow similar changes to the numbers of specific fie
15. Admitted Patient Care ensure that the RDF was designed for Admitted Patient Care data Failure to ensure that the data type of the RDF and the database match will lead to grouping errors If a suitable RDF does not already exist for the file being processed then the grouper can be used to edit an existing RDF or to create a new one See the section on the Record Definition File Wizard below 4 From the Tools menu select Process File this opens Process File dialog box 5 Select the input file the data to be grouped using the browse button folder icon next to the input file field Check the Input data has headings check box if the input data includes field names in the first row HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 5 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service 6 Select the name and location for the creation of the output file using the browse button folder icon next to the output file field The output file is the file that will contain the grouped data Check the Add headings to output data checkbox if there is a requirement for all output files to include field names 7 When all selections have been made click the Process button to produce the grouped output file A progress bar is displayed For certain data types grouping is preceded by a data sorting phase a separate progress bar is shown for sorting When gr
16. DF will be opened in the RDF editor allowing checking and any required amendments HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 12 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Record Definition File Editor ic HRG4 2009 10 Reference Costs Grouper File Edit Tools Help QuWoOoeer4aaD C Grouper Testing HRG4 100 Episodes MyTrust APC rdf NHS Field Name Field Title Field No Picture Extract PROCODET PROCODET PROYSPNO PROVSPNO The EPIORDER EPIORDER Information STARTAGE STARTAGE Centre SEX SEX for health and social care CLASSPAT CLASSPAT ADMISORC ADMISORC ADMIMETH ADMIMETH DISDEST DISDEST DISMETH DISMETH 10 EPIDUR EPIDUR 11 as Current Database C Grouper Testings HAG4100 Episodes MyT rust_APC rdf o wuy e w N al w Log empty gt The RDF Editor provides a manual method of assigning field positions and attributes Field Name Field abbreviation This is for internal use and cannot be changed Field Title Field description can be edited by the user to show a meaningful name for the field Field No The field position in a comma separated input file with the first field being number one Picture Allows the user to provide filtering instructions to the Grouper by describing a Picture of the field During the processing the Grouper will apply this picture to the field and only use the specified characters
17. NHS Information Centre All rights reserved 3 File name 4 File name uality csv lt input data gt RowNo Error Message uality rel csv RowNo Iteration Code Type Code Error Message 5 File name summary csv Grouper Version ACC Record Count ACC Record Error Count Run Start Date Time Run End Date Time Input Filename Output Filename RDF path and name The Casemix Service Contains one row for each record that contains errors All of the input data for the record including any non mandatory fields are reproduced in the output The row number field mentioned in the acc file It is unique within the file A variable number of fields containing the error message Each message is the three fields shown in the relational quality file separated by pipe symbols All of the error messages in relational form There are no entries for records that do not contain errors The key into other files In conjunction with RowNo provides a unique key for the record The field type causing the problem Where populated the value of that code causing the problem Explanation of the problem A single row file containing details about the grouping run The version of the grouper that produced the run The number of attendances submitted to the run The number of attendances with errors The date time that the run started The date time that the run finished The path and filename of th
18. See the section Picture later in this document Extract Allows the user to provide filtering instructions to the Grouper by describing an Extract instruction During processing the Grouper will apply this Extract instruction to the field and only the characters that the user has specified See the section Extract later in this document The Insert toolbar button inserts a new field in the RDF This feature is provided so that non mandatory fields can be shown using the Display File feature It is not necessary for the RDF to specify the positions of all the fields in the input file only the mandatory fields need to be specified The Delete toolbar button removes a field from the RDF Mandatory fields cannot be deleted HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 13 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service When the RDF is saved the user will be informed if any validation checks such as conflicting field positions have been failed These issues must be resolved before the file can be saved HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 14 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Process File From the Tools menu select Process File this opens Process File dialog box Select the input file data file using the br
19. abase are displayed within the upper area Default values are entered automatically when the single spell grouping window opens The user can edit or insert data by typing into the Value column Pressing the Enter key displays the code s description where a valid code has been entered A valid record definition file must be selected in order to use single spell grouping The single spell grouping dialog box is shown below ic Single Spell Grouping FCE 1 Field PROCODET PROVSPNO EPIORDER STARTAGE MAINSPEF NEOCARE TRETSPEF Description Click to add episode Male Ordinary admission Usual place of residence unless listed b Waiting list Usual place of residence unless listed b Patient discharged on clinical advice or GENERAL MEDICINE Not Applicable GENERAL MEDICINE Output Field FCE_HRG GroupingMet DominantPro FCE_PBC CalcE pidur ReportingEPI FCE Trimpoint FCEExcessB SpellReportFlag SpellHRG SpellGrouping SpellD ominan SpellPDiag SpellSDiag Description Clicking the Click To Add Episode header bar will open an adjacent set of columns allowing values for a second episode to be entered and grouped as part of the same spell HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 18 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Clicking the Group button will process the values
20. ated Elective APCSpellReport004 rgf _APCSpellReport004 xml Inpatient Bed Days Diagnosis Procedure by HRG4 Spell Truncated Non Elective APCSpellReport005 rgf _APCSpellReport005 xml Inpatient Bed Days by HRG4 Spell Truncated Non Elective APCSpellReport006 rgf _APCSpellReport006 xml Inpatient Bed Days Diagnosis Procedure by HRG4 Spell Excess Inpatient Bed APCSpellReport007 rgf _APCSpellReport007 xml Days by HRG4 HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 21 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Note there is no report 008 for Spells Non elective long stay APCSpellReport009 rof _APCSpellReport009 xml Non elective long stay APCSpellReport010 rof _APCSpellReport010 xml emergency Non elective long stay non APCSpellReport01 1 rgf _APCSpellReport011 xml emergency Non elective short stay APCSpellReport012 rgf _APCSpellReport012 xml Non elective short stay APCSpellReport013 rgf _APCSpellReport013 xml emergency Non elective short stay non APCSpellReport01 4 rgf _APCSpellReport014 xml emergency Non Admitted Consultations Report Title Command line Output file name extension Non Admitted Consultations NACReport001 rgf _NACReport001 xml Excluding Chapter WF by TFC and HRG4 Non Admitted Consultations NACReport002 rgf _NACReport002 xml Chapter WF Only by TFC
21. by pipe symbols All of the input data for the attendance including any non mandatory fields are reproduced in the output RowNo A unique row number field applied when grouping This serves as the key for other output files HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 36 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved 5 File name qualit NAC_HRG GroupingMethodFlag DominantProcedure RowNo Iteration Code Type Code Error Message 6 File name ub rel csv RowNo Iteration UnbundledHRG 7 File name summary csv Grouper Version Database Version Attendance Count Attendance Error Count Run Start Date Time Run End Date Time Input Filename Output Filename RDF path and name rel csv The Casemix Service The Core HRG for the attendance An indication of the grouping method used for the attendance The dominant procedure used for procedure based grouping All of the error messages in relational form There are no entries for attendances that do not contain errors The key into other files In conjunction with RowNo provides a unique key for the record The field type causing the problem Where populated the value of that code causing the problem Explanation of the problem The unbundled HRGs produced during the run There are no entries for attendances that do not have unbundled HRGs The key into o
22. e input file The path and filename of the first output file mentioned above The path and filename of the rdf file used in the run Neonatal Critical Care There are six output files 1 File name csv A single row file containing details about the grouping run 2 File name ncc csv The main grouped output file 3 File name quality csv Contains one row for each record that has errors HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved Page 40 of 41 The Casemix Service 4 File name quality rel csv All of the error messages in relational form 5 File name sort csv A copy of the input data after it has been sorted 6 File name summary csv A single row file containing details about the grouping run Paediatric Critical Care There are six output files File name csv A single row file containing details about the grouping run File name pcc csv The main grouped output file File name quality csv Contains one row for each record that has errors File name quality rel csv All of the error messages in relational form File name sort csv A copy of the input data after it has been sorted File name summary csv A single row file containing details about the grouping run oo eS eS HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 41 of 41 Author Casemix Service Copyright 2010 The NHS In
23. entered and will display the HRG and other derived information in the output lower area Database Selection Screen From the Tools menu select Select Database to open the dialog box shown below Database Selection Database Database Admitted Patient Care Description Tables Table Database Version Description L f This dialog box provides both an alternative mechanism for selecting the current database and a way of exporting database tables The Table drop down box displays a list of data files that make up the currently chosen database Selecting one will show a brief description of it in the accompanying area Clicking Select will set the Grouper to use the selected database Clicking the Export button will export the selected table the user being prompted for a filename and location HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 19 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Reports The reports are created specifically to support the NHS Reference Costs process they are not intended for any other purpose The reports are produced as xml spreadsheets these can be opened using Microsoft Excel version 2002 or later With versions of Excel prior to Excel 2007 worksheet size was limited to 65 536 rows When reports are generated from very large data sets the
24. er as that which is being used for reporting HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 23 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Subtraction of Days from Admitted Patient Care Duration The Grouper facilitates the subtraction of days for Critical Care Rehabilitation and Specialist Palliative Care from finished Consultant Episode and Hospital Provider Spell durations Where the user populates the input data fields with numbers representing the appropriate days of activity these will be used by the grouper to calculate modified output fields In addition the Rehabilitation and Specialist Palliative Care days are used as the multiplier for Rehabilitation and Specialist Palliative Care per diem HRGs Although the fields are mandatory in the input data i e the columns must exist in the file they may be left blank or populated with zeros where appropriate For further guidance on using this facility please see the document Guide to File Preparation which is available from the Casemix website HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 24 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Picture Picture is a feature of the record definition file that can be used to specify the inclusion or exclusion of specific character positions from inp
25. file ProvSpNo The hospital provider spell number from the user s input file Iteration In conjunction with RowNo provides a unique key for the record SpellSSC The SSC derived for the parent spell 10 File name ub rel csv The unbundled HRGs produced during the run There will be no entries for episodes that do not have any unbundled HRGs RowNo The key into other files In this case it will be the row number associated to the episode in the spell Iteration In conjunction with RowNo provides a unique key for the record UnbundledHRGs The unbundled HRG 11 File name summary csv A single row file containing details about the grouping run Grouper Version The version of the grouper that produced the run Database Version The internal HRG database version incorporated in the grouper FCE Count The number of episodes submitted to the run Spell Count The number of spells submitted to the run FCE Error Count The number of episodes with errors Spell Error Count The number of spells with errors Run Start Date Time The data time that the run started Run End Date Time The data time that the run finished Input Filename The path and filename of the input file Output Filename The path and filename of the first output file mentioned above RDF path and name The path and filename of the rdf file used in the run HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 35 of 41 Author Casemix Service Copyright 201
26. formation Centre All rights reserved
27. ginning of the field are the only characters required HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 26 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Extract Extract is a feature of the record definition file that can be used to inform the grouper to ignore certain characters from input fields ic HRG4 2009 10 Reference Costs Grouper File Edit Tools Help eh o raan C Grouper Testing HRG4 100 Episodes MyTrust APC rdf NHS Field Name Field Title Field No Picture Extract PROCODET PROCODET PROVSPNO PROVSPNO The l EPIORDER EPIORDER Information STARTAGE STARTAGE Centre SEX SEX for health and social care CLASSPAT CLASSPAT ADMISORC ADMISORC ADMIMETH ADMIMETH DISDEST DISDEST DISMETH DISMETH 10 EPIDUR EPIDUR at My Current Database C Grouper Testing HAG4 100 Episodes MyT rust_APC rdf o wuy e wh w lt Log empty gt To use Extract enter the character string to be removed in the Extract column of the Record Definition File RDF using the grouper s built in RDF editor accessed via the File Open RDF menu item Because the grouper input files are comma separated it is not possible to extract the comma character using this facility More than one character can be entered in the Extract column This informs the application that any occurrence of any of these characters in that field sho
28. ice Page 31 of 41 Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service SpellCCDays The number of critical care days in the spell UnbundledHRGs A variable number of fields containing unbundled HRGs at episode level Unbundled HRGs are appended to the end of each record there may be zero one or more unbundled HRGs per record For Specialist Palliative Care and Rehabilitation unbundled HRGs where there is more than one daily HRG the field consists of an HRG followed by an asterisk followed by the number of days rather than the HRG repeated for every day E g VC18Z 20 indicates VC18Z for 20 days 4 File name _ spell csv This file can be considered semi relational It contains one row per spell However it also contains all of the Specialised Service Codes SSCs generated for the spell in a flat structure like unbundled HRGs in the FCE output The FCE input data is not reproduced RowNo Refers to the first row number in the sort or FCE output and will always be the first episode in the spell after sorting Unless all spells in the input data each consist of a single episode RowNo in the spell file is not continuous i e some numbers are absent Procodet The organisation code from the user s input file ProvSpNo The hospital provider spell number from the user s input file SpellHRG The spell level Core HRG The first of the spell level output Be careful to avoid double c
29. lds see Guide to File Preparation for details All entries in the Mandatory Fields list must be assigned to fields in the sample file Fields are assigned by dragging the name from the list to the appropriate field in the preview area Fields appear in the Assigned Fields list as they are used The screenshot below shows the process partially completed first three fields assigned HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 11 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Record Definition File Wizard Drag items from the mandatory field list to the paksa dlls giras eit lle field below to assign them Unassign fields by STARTAGE PROCODET selecting them and pressing delete PROVSPNO EPIORDER Number of diagnosis codes 14 Number of procedure codes 1 2 MAINS PEF NEOCARE TRETSPEF BAA PROCODET PROVSPNO EPIORDER Field 4 Field 5 Field 6 Field OrgCode SpellNun EpNun Age Sex PatCla AdmSre gt Multiple fields can be selected using the SHIFT and CTRL keys in combination with mouse clicks The selected collection of fields can then be dragged to the preview area To remove an assigned field select it in the Assigned Fields list and press the Delete key The field will be returned to the bottom of the Mandatory Fields list not its original position When all fields have been assigned click OK to proceed The R
30. of all unbundled HRGs produced for episodes uality csv lt input data gt RowNo Error Message 6 File name FCE rel csv in the spell Contains a row for each episode that contains an error Where one or more episodes within a multi episode spell contain errors all the episodes from the spell including those that do not contain errors are included in the quality file Thus there are records in the quality file that do not include error messages All of the input data for the FCE including any non mandatory fields are reproduced in the output The row number field included in the sort file it is unique within the file A variable number of fields containing the error message Each message is the three fields shown in the relational quality file separated by pipe symbols This file contains the FCE level output in relational form RowNo The row number field mentioned in the sort file It is unique within this file FCE_HRG The episode level Core HRG GroupingMethodFlag An indication of the grouping method used for the episode DominantProcedure P Procedure driven D Diagnosis driven M Multiple trauma The dominant procedure used for procedure based grouping FCE_PBC Programme Budgeting Category This field is populated in reference cost groupers only CalcEpidur The calculated episode duration This is the input Episode duration minus the number of critical care days ente
31. of the input data for the attendance including any non mandatory fields are reproduced in the output RowNo The row number field mentioned in the attend file It is unique within the file Error Message A variable number of fields containing the error message Each message is the three fields shown in the relational quality file separated by pipe symbols 4 File name quality rel csv All of the error messages in relational form There are no entries for records that do not contain errors RowNo The key into other files Iteration In conjunction with RowNo provides a unique key for the record Code Type The field type causing the problem Code Where populated the value of that code causing the problem Error Message Explanation of the problem 5 File name summary csv A single row file containing details about the grouping run Grouper Version The version of the grouper that produced the run HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 38 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved Database Version Attendance Count Attendance Error Count Run Start Date Time Run End Date Time Input Filename Output Filename RDF path and name Adult Critical Care The Casemix Service The internal HRG database version incorporated in the grouper The number of attendances submitted to the run The number of attendances with errors The date time
32. ored by the application when processing that field An input field containing the character string 46 will be interpreted by the application as 46 HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 28 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Contact Information This software and associated materials are the Copyright of the NHS Information Centre Help is available for both technical and general queries from the NHS Information Centre contact centre Telephone 0845 300 6016 Monday Friday 9am 5pm Email enquiries ic nhs uk http www ic nhs uk casemix HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 29 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Appendix Output Files The output files aim to meet the needs of those familiar with relational data as well as those who require non relational files Specific relational outputs include _rel as a part of the output filename Generally a single input file produces a number of output files User requirements determine which files are used some users may not require certain output files In most cases an output field appears in more than one file In the text below the file name supplied by the user during processing is referred to as name Use of RowNo and
33. ort csv This a copy of the input data after it has been sorted into Provider Code Spell Number and Episode Number order prior to grouping It also contains a unique row number added as a final column assigned after the sorting process This row number is intended to be used as the key when using relational data HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 30 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved 3 File name FCE csv lt input data gt RowNo FCE_HRG GroupingMethodFlag DominantProcedure FCE_PBC CalcEpidur ReportingEpidur FCETrimpoint FCEExcessBeddays SpellReportFlag SpellHRG SpellGroupingMethodFlag SpellDominantProcedure SpellPDiag SpellSDiag SpellEpisodeCount SpellLoS ReportingSpellLoS SpellTrimpoint SpellExcessBeddays The Casemix Service This file contains both FCE and spell output fields The spell fields are repeated for each episode in the spell beware of double counting when using spell fields The file structure is as follows All of the input data for the FCE including any non mandatory fields are reproduced in the output The row number field mentioned in the sort file It is unique within the file The episode level Core HRG An indication of the grouping method used for the episode P Procedure driven D Diagnosis driven M Multiple trauma The dominant procedure used for procedure
34. ounting when using spell level fields SpellGroupingMethodFlag An indication of the grouping method used for the episode P Procedure driven D Diagnosis driven M Multiple trauma SpellDominantProcedure DominantProcedure at spell level SpellP Diag The primary diagnosis used for spell grouping SpellSDiag The 1st secondary diagnosis used for spell grouping SpellEpisodeCount The number of episodes in the spell SpellLoS The duration of the spell used for grouping ReportingSpellLoS The length of stay used when generating reports This field is populated in reference cost groupers only SpellTrimpoint The trimpoint for the HRG allocated to the spell This field is populated in reference cost groupers only SpellExcessBeddays The number of days the spell exceeds the trimpoint This field is populated in reference cost groupers only SpellCCDays The number of critical care days in the spell HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 32 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved 5 File name The Casemix Service SpellSSC1 The first candidate SSC produced for the spell The grouper does not check eligibility All SSCs possible are output for organisational SSC eligibility check DH guidance SpellSSC2 The second candidate SSC produced for the spell SpellSSC10 The tenth candidate SSC produced for the spell UnbundledHRGs An aggregate
35. ouping is complete the Process File dialog box will close and the application returns to the Main Screen It is very important that the user examines the entries in the log area after grouping If grouping fails this will be reported in the log area Note that the output file is a text file and may therefore be opened using a variety of applications To open the output file from within the application see the Display File section later in this document HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 6 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service The Grouper Main Screen The Main Screen has a main menu a toolbar a tabbed display and a log area e Main Menu File Edit Tools Help File New RDF Opens the RDF Wizard Open RDF Opens a selected RDF for editing or review within the tabbed display area Save Saves a currently open RDF only available when an RDF is being edited Save As Saves a currently open RDF with the option to rename or change location only available when an RDF is being edited Exit Closes the application Edit Insert Field Inserts a new line in an RDF for user defined fields only available when an RDF is being edited Delete Field Deletes the currently selected user defined field in an RDF only available when an RDF is being edited Tools Process File Opens the Process File dialog box Display File Opens a selec
36. owse button folder icon next to the input file field Note that with the default setting of Input files selected in the Files of type list the Open dialog box accessed via the browse button will list files with csv and txt extensions only Change this value to All Files if the input file has a different extension Check the Input data has headings check box if the input data includes field names in the first row Select the name and location of the output files using the browse button folder icon next to the output file field The output files are the files that will contain the grouped data The output files will be named using the name that the user enters as a file name prefix the grouper appends a special file name suffix to each output file See the Appendix for further information Check the Add headings to output data check box if the output files are required to include field names in the first row Process File Input File Input File Input data has headings Browse buttons Output File Output File Add headings to output data Reports FCE Daycases by TFC and HRG4 FCE Daycases Diagnosis Procedure by TFC and HRG4 FCE Truncated Elective Inpatient Bed Days by TFC and HRG4 FCE Truncated Elective Inpatient Bed Days Diagnosis Procedure by TFC and HRG4 FCE Truncated Non Elective Inpatient Bed Days by TFC and HRG4 FCE Truncated Non Elective Inpatient Bed Days Procedure Diagnosis
37. red ReportingEpidur The episode duration used when generating reports This field is populated in reference cost groupers only HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved Page 33 of 41 FCETrimpoint FCEExcessBeddays SpellReportFlag 7 File name spell _rel csv RowNo Procodet ProvSpNo SpellHRG SpellGroupingMethodFlag SpellDominantProcedure SpellP Diag SpellSDiag SpellEpisodeCount SpellLoS ReportingSpellLoS SpellTrimpoint SpellExcessBeddays SpellCCDays 8 File name quality rel csv The Casemix Service The episode trimpoint for the HRG allocated to the episode This field is populated in reference cost groupers only The number of days that the episode exceeds the trimpoint This field is populated in reference cost groupers only Used when generating reports from grouped data This field is populated in reference cost groupers only Contains the Spell level output in relational form There is one row per spell The key into other files The organisation code from the user s input file The hospital provider spell number from the user s input file The spell level Core HRG The first of the spell level output Be careful to avoid double counting when using spell level fields An indication of the grouping method used for the episode P Procedure driven D Diagnosis driven
38. rouper installation folder The grouper provides methods for creating user defined RDFs see below but the user may find that the sample RDFs provided with the application are sufficient It is not necessary for the RDF to specify the positions of all the fields in the input file only the mandatory fields must be specified For a list of mandatory fields for each data type see the Guide to File Preparation document Where the input file contains fields that are not specified in the RDF the grouper simply ignores these fields during processing and passes them to the output file The only reason to specify non mandatory input fields in the RDF is where the grouper s internal file viewer is used to view output files The internal file viewer displays only those fields that are specified in the RDF Grouping Modes The grouper offers three modes of operation e Non interactive file grouping using the command line e Interactive file grouping using the graphical user interface Interactive record grouping using the graphical user interface single spell grouping Running the Grouper from the Command Line non interactive mode Command line refers to the non graphical command shell user interface of Microsoft Windows The Grouper can process a file using the command line and parameters below mandatory parameters are enclosed within lt angle brackets gt optional parameters are enclosed within square brackets HRGGrouper i lt Inpu
39. t File gt o lt Output File gt d lt Record Definition File gt l lt Grouping Logic gt h t r lt report filename gt The command line parameters are i The path and filename of the input file o The path and filename of the output file d The path and filename of the record definition file The grouping logic see below This is the filename of one of the tre files supplied as part of the grouper installation h Optional Where present indicates that the input file has a header row field names When absent indicates that the first row in the file is a data row HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 3 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service t Optional Where present turns off the generation of output file header rows field names If this parameter is omitted then each of the output files will contain a header row r Optional Where present specifies one of the built in reports see list in reports section below The r flag can be repeated to specify the production of more than one report These are the filenames of rgf files supplied as part of the grouper installation Where there are spaces in paths or filenames the parameter must be enclosed within double quotes The available Grouping Logic parameters are apc_v43rc Admitted Patient Care nap_v43rc Non Admitted Consultations em_v43rce Emergenc
40. t005 xml Inpatient Bed Days by TFC and HRG4 HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 20 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Report Title Command line Output file name extension FCE Truncated Non Elective APCFCEReport006 rgf _APCFCEReport006 xml Inpatient Bed Days Procedure Diagnosis by TFC and HRG4 FCE Excess Inpatient Bed APCFCEReport007 rof _APCFCEReport007 xml Days by TFC and HRG4 Unbundled HRG4 Admitted APCFCEReport008 rof _APCFCEReport008 xml Patient Care Truncated Non elective long APCFCEReport009 rgf _APCFCEReport009 xml stay Truncated Non elective long APCFCEReport010 rgf _APCFCEReport010 xml stay emergency Truncated Non elective long APCFCEReport011 rgf _APCFCEReport011 xml stay non emergency Non elective short stay APCFCEReport012 rgf _APCFCEReport012 xml Non elective short stay APCFCEReport01 3rgf _APCFCEReport013 xml emergency Non elective short stay non APCFCEReport014 rgf _APCFCEReport014 xml emergency Spell Reports Report Title Command line Output file name extension Spell Daycases by HRG4 APCSpellReport001 rgf _APCSpellReport001 xml Spell Daycases APCSpellReport002 rof _APCSpellReport002 xml Diagnosis Procedure by HRG4 Spell Truncated Elective APCSpellReport003 rgf _APCSpellReport003 xml Inpatient Bed Days by HRG4 Spell Trunc
41. ted file within the tabbed display area Single Spell Opens the Single Spell Grouping screen Run Reports Opens the Run Reports dialog box Select Database Opens the Database Selection dialog box Help Index Opens the user manual Latest User Manual Opens a web page where the latest user manual can be opened or downloaded About Opens the About screen to display application version and contact information HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 7 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service e Toolbar la S O raaa o New RDF Opens the RDF Wizard al Open RDF Opens a selected RDF for editing or review within the tabbed display area H Save Saves a currently open RDF only available when an RDF is being edited Insert Field Inserts a new line in an RDF for user defined fields only available when an RDF is being edited 8 Delete Field Deletes the currently selected user defined field in an RDF only available when an RDF is being edited gt Process File Opens the Process File window al Run Reports Opens the Run Reports box al Display File Opens a selected file within the tabbed display area je Single Spell Grouping Opens the Single Spell Grouping screen e Tabbed Display Area This area shows screens that can be viewed by selecting the tabs at the bottom of the window when more than one of the following is open
42. that the run started The date time that the run finished The path and filename of the input file The path and filename of the first output file mentioned above The path and filename of the rdf file used in the run A single input file produces five output files 1 File name csv 2 File name acc csv lt input data gt RowNo ACC_HRG Calc_CC_Days CC_Warning_Flag Validation Checks Contains a list of all the other files produced This file will normally be ignored All of the input data for the attendance including any non mandatory fields are reproduced in the output A unique row number field applied when grouping This serves as the key for other output files The unbundled HRG for the ACC period All ACC HRGs are unbundled The number of CC days derived from the start and end dates entered This will be 1 if there are problems with the dates Set to F for Fail if Calc_CC_Days is 1 or any of the checks mentioned below have failed This is not a part of the cruel input validation A single data row can fail here but also have a valid non U group HRG Calc_CC_Days CC Discharge date CC Start Date 1 Set warning flag if Calc_CC_Days 1 or CCL2 Days CCL3 Days gt Calc_CC_Days or ARSD BRSD gt Calc_CC_Days or ARSD BRSD gt CCL2 Days CCL3 Days HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 39 of 41 Author Casemix Service Copyright 2010 The
43. ther files In conjunction with RowNo provides a unique key for the record The unbundled HRG A sinlge row file containing details about the grouping run The version of the grouper that produced the run The internal HRG database version incorporated in the grouper The number of attendances submitted to the run The number of attendances with errors The date time that the run started The date time that the run finished The path and filename of the input file The path and filename of the first output file mentioned above The path and filename of the rdf file used in the run HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved Page 37 of 41 The Casemix Service Emergency Medicine A single input file produces five output files 1 File name csv Contains a list of all the other files produced This file will normally be ignored 2 File name attend csv This is sometimes known as the attendance flat output Its structure is as follows lt input data gt All of the input data for the attendance including any non mandatory fields are reproduced in the output RowNo A unique row number field applied when grouping This serves as the key for other output files EM _HRG The Core HRG for the attendance 3 File name quality csv Contains a row for each input record that has errors lt input data gt All
44. ture can be used with alpha and numeric fields e Where the number of characters in the field exceeds the number of characters specified in Picture the application will implement the Picture on the left most portion of the field HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 25 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service For this reason care should be taken when using Picture with variable length fields as this may lead to unpredictable results Picture Field Examples In the examples below the characters are shown surrounded by double quotes for clarity The data entered in the Picture column should not include double quotes Example 1 Entering a Picture of AAA AA instructs the Grouper that the first three and the fifth and sixth characters of the field should be used The fourth character is ignored Example 2 Entering a Picture of A AAA instructs the Grouper that the second character and characters four five and six should be used the first and third characters should be ignored Example 3 Entering a Picture of A indicates that the Grouper should use the second character only and ignore the first and third characters Example 4 Entering a Picture of AA indicates that the application should use only the first two characters in the field Note that full stops are not required if consecutive characters from the be
45. uld be ignored in grouping The application does not consider a series of characters as a string of characters to be ignored as a unit each character entered is ignored wherever it appears in the input field Notes e The characters specified will be ignored wherever they appear in the input data field e There is no relationship between the position of the character in the extract field and the position of the characters in the input field e All occurrences of the characters are affected HRG4 2009_10 Reference Costs Grouper User Manual v1 0 Page 27 of 41 Author Casemix Service Copyright 2010 The NHS Information Centre All rights reserved The Casemix Service Extract Field Examples In the examples below the characters are shown surrounded by double quotes for clarity The data entered in the Extract column should not include double quotes unless it is intended that double quotes are ignored in grouping Example 1 Entering an Extract character of informs the application that all occurrences of the full stop should be ignored when processing that field This is a convenient way to remove decimal points from a field in the input file An input field containing the character string abc d will be interpreted by the application as abcd Example 2 Entering the characters in this field informs the application that any occurrences of both the character and the character are to be ign
46. ut fields ic HRG4 2009 10 Reference Costs Grouper File Edit Tools Help eH o aan C Grouper Testing HRG4 100 Episodes MyTrust APC rdf NHS Field Name Field Title Field No Picture Extract PROCODET PROCODET PROVSPNO PROVSPNO The EPIORDER EPIORDER Information STARTAGE STARTAGE Centre SEX SEX for health and social care CLASSPAT CLASSPAT ADMISORC ADMISORC ADMIMETH ADMIMETH DISDEST DISDEST DISMETH DISMETH 10 EPIDUR EPIDUR 11 as Current Database C Grouper Testings HAG4100 Episodes MyT rust_APC rdf o wuya e wh w kLog empty gt Picture allows the user to provide filtering instructions for each field by describing a character template During file processing the application will apply this template to the field by selectively ignoring characters in specific positions within a data field An A character indicates a character position to be included in grouping and a full stop indicates a character position to be ignored in grouping The picture will be imposed on the data field prior to grouping i e the grouping algorithm is provided with the modified version of the field contents To use Picture enter a character template in the Picture column of the Record Definition File RDF using the grouper s built in RDF editor accessed via the File Open RDF menu item Notes e The characters in Picture should not be separated by spaces e Quote marks should not be included e Pic
47. y Medicine acc_v43rc Adult Critical Care pcc_v43rc Paediatric Critical Care ncec_v43rce Neonatal Critical Care Before running the grouper from the command line the working directory should be set to the directory of the Grouper executable HRGGrouper exe Use full path names for the input file the output file and the record definition file where they are located in other directories Any messages generated by the application while running in command line mode e g validation issues the number of records processed are written to the HRG LOG file in the grouper s installation folder Errors in the command line such as specifying a non existent input file cause an entry to be created in the HRG LOG file In addition a non zero exit code is returned This means that a batch file or command file can check whether a command has passed validation by checking the value of errorlevel A sample batch file using the grouper s command line interface is shown below echo off Cs cd C Program Files IC HRG4 2009_10 RC Grouper HRGGrouper i C HRG Data HRG4 1000 episodes 1000 episodes CSV o C HRG Data HRG4 1000 episodes 1000 episodes out csv d HRG4_ sample_APC rdf 1 apc_v43rce h r APCFCEReport003 rgf r APCFCEReport005 rgf F SERRORLEVELS NEQ 0 echo Error in command please check hrg log pause Grouping in Interactive Mode Interactive mode uses the grouper s graphical user interface Start the
Download Pdf Manuals
Related Search