HRG4 Grouper Reference Manual Payment 14/15 The National
Contents
1. Grouper Field Name DD Field Name Notes RENAL TREATMENT a RENALMOD MODALITY CODE Leading zeros are significant RENAL TREATMENT RENALSITE PRIMARY SUPERVISION Leading zeros are significant CODE RENALACCESS RENAL DIALYSIS ACCESS Leading zeros are significant HBV HEPATITIS B ANTIGEN Must be UPPER CASE STATUS RENAL CARE Accepted values are NEG POS and UNK HCV HEPATITIS C ANTIBODY Must be UPPER CASE STATUS RENAL CARE Accepted values are NEG POS and UNK HUMAN HIV IMMUNODEFICIENCY VIRUS Hae neal eee POS and UNK STATUS RENAL CARE eee age il The age of the patient in whole years at the start date of the session AGE Derived Range 0 130 Each row of the input file represents either one haemodialysis session or one day of peritoneal dialysis Copyright 2014 Health and Social Care Information Centre All rights reserved A 6 HRG4 Grouper Reference Manual v0 1 A5 Adult Critical Care Please see the bottom of Section 6 for a comment about critical care grouping The field list below shows the fields required by the Grouper The field order of the input file is defined by the Record Definition File used for the grouping session there is no significance to the order in which the fields are listed below Grouper Field CDS DD Field Name Notes Name CCUF S UNIT Leading zeros are significant BASIC CARDIOVASCULAR f BCSD SUPPORT DAYS Range 0 99999 ADVANCED ACSD CARDIOV2. lt input data gt All input data including any non mandatory fields RowNo Generated row number of the record after sorting name _ncc csv The main grouped output file lt input data gt All input data including any non mandatory fields RowNo Matches the run generated row number NCC_HRG Unbundled HRG for the NCC day All NCC HRGs are unbundled name _quality csv Contains one row for each record that has errors lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number Error Message s A variable number of fields each consisting of Code Type Code and Error Message separated by pipe symbols name _quality_rel csv All of the error messages in relational form RowNo Matches the run generated row number Iteration Ordinal number of the quality message Code Type Type of code that has failed validation Code Code that failed validation blank if code missing from input data Error Message Description of the error name _summary csv A single row file containing details about the grouping session Grouper Version Version of the Grouper that produced the output files Copyright 2014 Health and Social Care Information Centre All rights reserved B 21 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description Dat
3. Code The code that failed validation Blank if code missing from input data Error Message Description of the error name _flag_rel csv This file is not currently populated RowNo Iteration AttendFlag name _ub_rel csv Unbundled HRGs There are no entries for attendances without unbundled HRGs RowNo Matches the run generated row number Iteration The ordinal number of the unbundled HRG Copyright 2014 Health and Social Care Information Centre All rights reserved B 11 File Name Field Name HRG4 Grouper Reference Manual v0 4 Description UnbundledHRG Unbundled HRG There is no significance to the output order name _summary csv A single row file containing details about the grouping session Grouper Version The version of the Grouper that produced the output files Database Version The Grouper s internal HRG database version Attendance Count The number of records submitted Attendance Error Count The number of records having errors Run Start Date Time The date and time that the grouping session started Run End Date Time The date and time that the grouping session finished Input Filename The path and filename of the input file Output Filename The path and filename selected by the user RDF path and name The path and filename of the Record Definition File used
4. Contains one row for each record that contains errors lt input data gt All of the input data for the record including any non mandatory fields RowNo Matches the run generated row number Copyright 2014 Health and Social Care Information Centre All rights reserved B 17 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description Error Message s Variable number of fields consisting of Code Type Code and Error Message separated by pipe symbols name _quality_rel csv All error messages in relational form No entries for records without errors RowNo Matches the run generated row number Iteration The ordinal number of the quality message Code Type The type of code that has failed validation Code Code that failed validation blank if code missing from input data Error Message Description of the error name _summary csv A single row file containing details about the grouping session Grouper Version Version of the Grouper that produced the output files Database Version Grouper s internal HRG database version ACC Period Count Number of records submitted ACC Period Error Count Number of records having errors Run Start Date and time that the grouping session started Date Time Run End Date and time that the grouping session finished Date Time Input Filename Path and filename of the inpu
5. Grouper Version Version of the Grouper that produced the output files Database Version Grouper s internal HRG database version Attendance Count Number of records submitted Copyright 2014 Health and Social Care Information Centre All rights reserved B 13 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description Attendance Error Count Number of records having errors Run Start Date Time Date and time that the grouping session started Run End Date Time Date and time that the grouping session finished Input Filename Path and filename of the input file Output Filename Path and filename selected by the user RDF path and name Path and filename of the RDF used for grouping Copyright 2014 Health and Social Care Information Centre All rights reserved B 14 HRG4 Grouper Reference Manual v0 4 B4 Renal Dialysis National Renal Dataset There are five output files File Name Field Name Description name csv A list of other output files used for validation only name _renal csv The main grouped output file lt input data gt All of the input data including any non mandatory fields RowNo The generated row number of the record NRD_HRG The HRG for the dialysis record name _quality csv Contains one row for each record that contains errors lt input data
6. Health amp Social Care 14 15 hscic Information Centre Q HRG4 Grouper Reference Manual Payment 14 15 The National Casemix Office Published February 2014 HRG4 Grouper Reference Manual v0 4 We are the trusted source of authoritative data and information relating to health and care www hscic gov uk enquiries hscic gov uk Author The National Casemix Office Health and Social Care Information Centre Version V1 0 Date of publication February 2014 Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 Contents 1 Quick Start 1 1 Download and Install the Grouper 1 2 Server Installation 1 3 Grouping Walkthrough Using Sample Data 2 New Features 2 1 New Features in the Payment 14 15 grouper 2 2 New Features in the Consultation 14 15 grouper 2 3 New Features in the Engagement 14 15 grouper 3 Grouping Your Own Data 4 Record Definition File RDF 4 1 Using the Record Definition File Wizard to Create a Custom RDF 4 2 Record Definition File Editor 5 Command Line Initiation 6 Secondary Uses Service Grouping 7 Additional Features 7 1 Single Spell Grouping 7 2 The Internal File Viewer Annex A Input File Preparation A1 Admitted Patient Care A2 Non Admitted Consultations A3 Emergency Medicine A4 Renal Dialysis National Renal Dataset A5 Adult Critical Care A6 Paediatric Critical Care A7 Neonatal Critical Care Annex B Output Files B1 Ad
7. All rights reserved A 3 HRG4 Grouper Reference Manual v0 1 A2 Non Admitted Consultations Non admitted Consultations are outpatient attendances or attendances by patients for nursing care on a ward ward attenders Since April 4st 2005 the Outpatient Attendance CDS has contained both of these types of data The field list below shows the fields required by the Grouper The field order of the input file is defined by the Record Definition File used for the grouping session there is no significance to the order in which the fields are listed below Grouper Field name CDS DD Field Name Notes PROCEDURE OPCS STARTAGE Derived Whole years rounded down APPOINTMENT DATE PERSON BIRTH DATE SEX PERSON GENDER CODE CURRENT CARE PROFESSIONAL MAIN eer SPECIALTY CODE ACTIVITY TREATMENT TEREE FUNCTION CODE FIRSTATT FIRST ATTENDANCE CODE OPER 01 PRIMARY PROCEDURE OPER 99 OPCS and Valid OPCS 4 codes excluding decimal point character or blank Each row of the input file represents a single attendance Diagnosis Codes Diagnostic coding is excluded from the HRG4 algorithm for non admitted consultations Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 1 A3 Emergency Medicine The field list below shows the fields required by the Grouper The field order of the input file is defined by the Record Definition File used
8. Path and filename selected by the user RDF path and name Path and filename of the RDF used for grouping Copyright 2014 Health and Social Care Information Centre All rights reserved B 16 HRG4 Grouper Reference Manual v0 4 B5 Adult Critical Care There are five output files File Name Field Name Description name csv A list of other output files used for validation only name _acc csv The main grouped output file lt input data gt All of the input data including any non mandatory fields RowNo The generated row number of the record ACC_HRG The unbundled HRG for the ACC period All ACC HRGs are unbundled Calc_CC_Days The number of CC days calculated as CC Discharge Date CC Start Date 1 This will be set to 1 if there are problems with the dates CC_Warning_Flag Flag to indicate the result of validation of CC Start Date and CC Discharge Date Date validation failure does not prevent HRG derivation Blank indicates valid date F indicates date validation failure applied if any of the following are true e Calc_CC_Days 1 This indicates that CC Discharge Date is Before CC Start Date CC Start Date or CC Discharge Date Is blank Is not a valid date Does not match the required format e CCL2 Days CCL3 Days gt Calc_CC_Days e ARSD BRSD gt Calc_CC_Days e ARSD BRSD gt CCL2 Days CCL3 Days name _quality csv
9. for the grouping session there is no significance to the order in which the fields are listed below Grouper Field Name CDS DD Field Name Notes AGE Derived Whole years rounded down ARRIVAL DATE PERSON BIRTH DATE Validated but not used in grouping ACCIDENT AND ue ERA AR _ FIRST Valid national code component always 2 characters or blank INV 01 INV 99 and The Local Sub Analysis part should not be submitted 7 ACCIDENT AND Leading zeroes must be included where they form part of the national code EMERGENCY component INVESTIGATION SECOND ACCIDENT AND a ie Valid national code component 2 or 3 characters or blank TREAT_01 and The Local Sub Analysis part should not be submitted TREAT _99 ACCIDENT AND Leading zeroes must be included where they form part of the national code EMERGENCY TREATMENT Component SECOND Each row of the input file represents one Accident and Emergency Attendance Copyright 2014 Health and Social Care Information Centre All rights reserved A 5 HRG4 Grouper Reference Manual v0 1 A4 Renal Dialysis National Renal Dataset Renal Dialysis HRGs are generated using fields from the National Renal Dataset The field list below shows the fields required by the Grouper The field order of the input file is defined by the Record Definition File used for the grouping session there is no significance to the order in which the fields are listed below
10. indicates that the input file has a header row field names Omit this parameter where the first row in the file is a data row t Optional Where present stops generation of field names in the top row of output file If this parameter is omitted then each of the output files will contain a header row r Valid only in Reference Costs Groupers not in use in this grouper Optional Where present directs the Grouper to list the available command line parameters to the hrg log file in the Grouper program folder This parameter cannot be combined with other parameters Where there are spaces in paths or filenames for parameter values the parameter value must be enclosed within double quote characters An example script using the command line is Copyright 2014 Health and Social Care Information Centre All rights reserved 14 HRG4 Grouper Reference Manual v0 4 echo off Cx cd Program Files HSCIC grouperFolderName hrg grouper exe i C HRG Data apcl00 CSV o C HRG Data output csv d HRG4 sample APC rdf 1 APC h r APCFCER eport001 rgf r APCFCEReport002 rgf IF ERRORLEVELS NEQ 0 echo Error in command please check hrg log Pause Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 6 Secondary Uses Service Grouping The results of grouping the same data in SUS or in the corresponding Payment grouper are always the same there is no
11. populated at least for the last episode in the spell SPELL EPIDUR Derived Range 0 99999 Whole days END DATE EPISODE START DATE EPISODE CARE PROFESSIONAL MAIN Wiener SPECIALTY CODE NEOCARE NEONATAL LEVEL OF CARE May be blank CODE ACTIVITY TREATMENT TRETSPER FUNCTION CODE DIAG 01 PRIMARY DIAGNOSIS ICD Valid ICD 10 code excluding decimal point character and any dagger asterisk suffix If this field is blank an error will be generated DIAG_02 DIAG_99 SECONDARY DIAGNOSIS ICD As above but blank allowed Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 1 Grouper Field Name CDS DD Field Name Notes PRIMARY PROCEDURE aie j OPCS and Valid OPCS 4 codes excluding decimal point character or blank a PROCEDURE OPCS CRITICAL Derived Count of distinct days within the episode when the patient was in Critical Care CAREDAYS If the patient was in Critical Care on the last day of an episode that was not the last episode of the spell assign that day to the next episode REHABILITATION DAYS LENGTH OF STAY ADJUSTMENT REHABILITATION Range 0 99999 or blank Non numeric characters treated as zero SPCDAYS LENGTH OF STAY ADJUSTMENT SPECIALIST PALLIATIVE CARE Range 0 99999 or blank Non numeric characters treated as zero Copyright 2014 Health and Social Care Information Centre
12. serves as an introduction to using the Code to Group workbook to perform manual grouping It also details some basic design concepts and provides worked examples of a variety of different grouping scenarios The Specialised Service Identification Code Sets is a spreadsheet containing details about how the Grouper allocates specific identification flags relating to specialised services that may attract a national tariff top up which will then be applied in the National System for Reimbursement SUS PbR The Best Practice Guide is a spreadsheet produced to help users understand how Best Practice flags which are output by the Casemix Groupers are generated Copyright 2014 Health and Social Care Information Centre All rights reserved E 2 HRG4 Grouper Reference Manual v0 4 Published by the Health and Social Care Information Centre Part of the Government Statistical Service Responsible Owner Virginia Jordan Programme Head This publication may be requested in large print or other formats For further information www hscic gov uk 0845 300 6016 enquiries hscic gov uk Copyright 2014 Health and Social Care Information Centre All rights reserved This work remains the sole and exclusive property of the Health and Social Care Information Centre and may only be reproduced where there is explicit reference to the ownership of the Health and Social Care Information Centre This work may be re used by NHS and government organisa
13. to assign them Unassign fields by selecting them and pressing delete PROCODET PROVSPNO EPIORDER STARTAGE Number of diagnosis codes 14 Number of procedure codes 12 CLASSPAT Click drag pam DISDEST and drop 9 EPIDUR MAINSPEF NEOCARE TRETSPEF LCRITICAI CARED AYS Field 8 Field 9 Field 10 Field 11 Field 12 Field 1 Field 1 Field 2 Field 3 Field 4 Field 5 Field 7 PROCODET PROVSPNO EPIORDER STARTAGE SEX ADMISORC ADMIMETH DISDEST DISMETH EPIDUR MAINSPEF NEOCARE zzz 1004595488 1 68 1 1 51 81 19 13 430 8 zzz 1004595489 1 90 2 1 51 81 19 30 430 8 zzz 1004595490 1 85 2 1 51 81 19 1 15 430 8 zzz 1004595491 1 80 2 1 51 81 19 1 45 430 8 January 2014 V1 0 1 3 22 The first few rows of the selected input file are shown in the preview area in the lower part of the form At this stage each field is assigned a temporary field name e g Field 1 Field 2 Depending on the data type the number of repeating occurrences of certain fields can be increased For example if the input file contains 20 diagnosis codes the value in Number of diagnosis codes should be set to 20 rather than the default value of 14 All field names in the Mandatory Fields list must be assigned to fields in the sample input file Fields are assigned by using the mouse to drag the field name from the Mandatory Fields list to the appropriate field in the preview area Fields move from the Mandatory Fields list to t
14. 2 Server Installation For details about installation on servers see Annex D 1 3 Grouping Walkthrough Using Sample Data The following walkthrough describes the process of grouping a sample Admitted Patient Care APC input file available from the Casemix website Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 1 Download the HRG4 Admitted Patient Care Sample Test Data file from this page http www hscic gov uk casemix general 2 Open the Grouper application 3 Select Admitted Patient Care APC HRG4 in the Database drop down list Other grouping types available can be seen in the drop down 4 Click the Browse button folder icon next to the Record Definition File RDF drop down list PANGS 2014715 Pe prang File Tools Window Help Il File Batch Processing t ag Batch 01 x m Database Admitted Patient Care APC HRG4 Liz Description PC ICD 10 OPCS4 Payment Groupe Record Definition File z D E Input File M Mi Input data has headings Output File eB Add headings to output data Error Ratio Processing Message Log 19 02 2014 10 40 35 New batch processing context was created Batch 01 19 02 2014 10 40 35 Batch 01 database definitions were reloaded 7 definitions 19 02 2014 10 41 22 Batch 01 new database definition selected Admitted Patien
15. ASCULAR Range 0 99999 SUPPORT DAYS BASIC RESPIRATORY f BRSD SUPPORT DAYS Range 0 99999 ADVANCED RESPIRATORY ARSD SUPPORT DAYS Range 0 99999 RSD RENAL SUPPORT DAYS Range 0 99999 NEUROLOGICAL SUPPORT f NSD DAYS Range 0 99999 DERMATOLOGICAL DSD SUPPORT DAYS Range 0 99999 LSD LIVER SUPPORT DAYS Range 0 99999 CRITICAL CARE LEVEL 2 CCL2D DAYS Range 0 99999 CRITICAL CARE LEVEL 3 CCL3D DAYS Range 0 99999 Copyright 2014 Health and Social Care Information Centre All rights reserved A 7 HRG4 Grouper Reference Manual v0 1 Grouper Field Name CDS DD Field Name Notes CC_Start_Date elie SARE SLARI Format is CCYYMMDD e g 14 March 2009 20090314 CC_Discharge_Date ap L aa CARE DISCHARGE Format is CCYYMMDD e g 14 March 2009 20090314 Critical Care Start Date and Critical Care Discharge Date fields are used to calculate critical care days in the Grouper output file They are not used in HRG derivation Each row of the input file represents one Adult Critical Care Period Copyright 2014 Health and Social Care Information Centre All rights reserved A 8 HRG4 Grouper Reference Manual v0 1 A6 Paediatric Critical Care Please see the bottom of Section 6 for a comment about critical care grouping The Grouper sorts Paediatric Critical Care data prior to grouping so that records with the same provid
16. OCAR g zzz 1004595488 1 68 1 1 51 81 19 1 13 430 8 zzz 1004595489 1 30 2 1 51 81 19 1 30 430 8 zzz 1004595490 1 85 2 1 51 81 19 1 15 430 8 zzz 1004595491 1 80 2 1 51 81 19 1 45 430 8 zzz 1004595492 1 82 1 1 51 81 19 a 18 430 8 zzz 1004595493 1 68 1 1 51 81 19 1 24 430 8 zzz 1004595494 1 30 1 1 51 81 19 1 13 430 8 zzz 1004595495 1 82 2 1 51 81 19 1 89 430 8 zzz 1004595496 1 89 2 1 51 81 29 1 29 430 8 zzz 1004595497 1 30 1 1 51 81 51 1 11 430 8 zzz 1004595498 1 82 2 1 51 81 54 1 78 430 8 zzz 1004595499 1 83 1 1 51 81 19 1 19 430 8 zzz 1004595500 1 85 2 1 51 81 19 1 30 430 8 zzz 1004595501 1 89 2 1 51 81 19 1 25 430 8 zzz 1004595502 1 74 1 A 51 81 19 1 43 430 8 zzz 1004595503 1 101 2 1 51 81 19 1 10 430 8 zzz 1004595504 85 2 1 51 81 19 1 10 430 8 zzz 1004595505 1 88 2 1 51 81 19 1 9 430 8 zzz 1004595506 1 83 2 1 51 81 51 1 1 430 8 zzz 1004595507 1 72 1 1 51 81 19 1 52 430 8 zzz 1004595508 1 83 1 51 81 19 1 14 430 8 zzz 1004595509 1 85 1 1 51 81 19 1 22 430 8 zzz 1004595510 1 92 2 1 51 81 29 1 33 430 8 zzz 1004595511 1 74 1 1 51 81 19 1 13 430 8 zzz 1004595512 1 88 2 1 51 12 98 8 3 314 8 zzz 1004595513 1 71 1 1 51 81 19 1 12 314 8 January 2014 V1 0 1 3 22 When a file is opened the fields displayed are restricted to those defined in the RDF that is currently active An extra field Other Fields is appended which contains the additional output fields concatenated and comma separated This means that in or
17. _10 DIAG_10 24 DIAG_11 DIAG_11 25 Cea _ Dc 26 i January 2014 V1 0 1 3 22 The editor allows you to modify field positions and field attributes in an RDF The RDF columns are Name Description A field name abbreviation for internal use it cannot be modified for FieldName mandatory fields A field description which can be edited to display a locally defined field Field Title manne The field column number in the input file The screen does not allow the use Field No of duplicate values so when changing order users will need to change failures Specifies whether specific character positions in the field are used or values to larger numbers then back to what is required to avoid validation ignored during processing For example AAA A in which A means keep Picture the character in that position Means remove the character in that position all without quote marks But note procedure and diagnosis codes will have decimal points removed automatically Allows you to specify that specific characters in any position in the field are Extract ignored during processing e g Without quote marks will remove full stops from the field The Insert Field 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 For the purposes of grouping it is not necessary for th
18. abase Version Grouper s internal HRG database version NCC Record Count Number of records submitted NCC Record Error Count Number of records having errors Run Start Date Time Date and time that the grouping session started Run End Date Time Date and time that the grouping session finished Input Filename Path and filename of the input file Output Filename Path and filename selected by the user RDF path and name Path and filename of the RDF used for grouping Copyright 2014 Health and Social Care Information Centre All rights reserved B 22 HRG4 Grouper Reference Manual v0 4 Annex C Errors As part of the grouping process the Grouper carries out validation checks on many of the mandatory input fields Where one or more fields fail validation the Grouper derives the HRG UZ01Z Data Invalid for Grouping For single episode spells where the episode fails validation the error HRG is derived at both episode and spell level For multi episode spells that contain a mixture of episodes that pass validation and episodes that fail validation the error HRG is derived for each episode that fails validation and for every episode in the spell at spell level Details of all errors encountered are reported in a Grouper output file called the quality file The listings in the Output Files section of this document include a description of the quality file for eac
19. admission DominantPro ADMISORC 19 Usual place of residence FCE_PBC PBCO2U1 ADMIMETH 11 Waiting list CalcEpidur 0 DISDEST 19 Usual place of residence ReportingEPI DISMETH 1 Patient discharged on clinical advice or wit FCETnmpoint EPIDUR 0 i FCEExcessBe MAINSPEF 300 GENERAL MEDICINE SpellReportFlag 1 NEOCARE 8 Not Applicable Unbundledi TRETSPEF 300 GENERAL MEDICINE DIAG_02 v Output Spell Copy Content Field Value Description SpellHRG UZ01Z Data Invalid for Grouping SpellGroupin U Sne E SpellDomina IL 4 gt Spell Processing Message Log January 2014 V1 0 1 3 22 As in the previous version some fields are populated with useful values to save some data input effort Users should enter values into appropriate fields then press the Group button Once the group button has been pressed the application will calculate outputs every time an input field is changed the outputs are automatically recalculated Errors are highlighted in yellow in both the Input and Output sections For greater visibility readability the contents of any row in the input or output sections that is clicked appears in the status bar at the bottom of the window With care data can be pasted into the input sub windows The source can be a text string from for instance Notepad containing comma or tab separated data or from cells in Excel laid out horizontally or vertically Use copy short cut Ctrl and C to pi
20. al of spaces in procedure and in diagnosis codes e Better handling of number fields containing non numeric values e Grouper window size adjusted 2 2 New Features in the Consultation 14 15 grouper The following changes have been made to the Consultation 14 15 grouper e Automatic removal of decimal points in procedure codes e Complete redesign of the Single Spell grouper see section 7 e Adjustments to some values in the Grouping Method flag when HRG UZ01Z is produced to better reflect what would have happened if an error had not occurred 2 3 New Features in the Engagement 14 15 grouper Users who are familiar with the HRG4 Grouper will have noticed that this version looks different The Engagement 14 15 grouper is a complete rebuild of the software Where possible we have retained a similar look and feel Other than changes introduced in this version the inputs method of operation and outputs remain the same The main differences that will be noticed are e It is much faster when running using bulk data the recommended method so the grouper priority feature has been removed e Tabs on the front screen will allow multiple simultaneous runs of batch grouping and or single spell grouping When run from the command line it does not open another window Multiple concurrent batch runs can be initiated from the same installation Automatic removal of decimal points in diagnosis codes Change in executable name when using the command
21. calculated by a means equivalent to grouping after removal of all procedures except those starting with X62 In emergency medicine SUS produces a dummy HRG DOA from which a tariff is derived if the A AND E Patient Group contains value 70 meaning Brought in dead For local grouping you are expected to group the appropriate sub sets of ACC NCC and PCC separately and treat their results as un bundled HRGs as a part of the parent episode spell This is necessary because of the difficulties expected for many users when dealing with more complex relational input SUS groups the combination of APC ACC NCC and PCC simultaneously Copyright 2014 Health and Social Care Information Centre All rights reserved 16 HRG4 Grouper Reference Manual v0 4 7 Additional Features 7 1 Single Spell Grouping Single spell grouping enables the grouping of manually input data This can be useful when exploring how certain combinations of clinical codes lead to different HRGs being derived The single spell grouper should not be used as a definitive source of descriptions for input codes Selecting Open Single Spell Processing from the Tools menu or pressing the appropriate button opens a new Single Spell Grouping window Multiple such windows can be opened at the same time each operating independently The rest of this explanation covers Admitted Patient Care APC grouping only Other grouping types are similar Sele
22. casemix It is a comprehensive resource of supporting materials designed to assist users in understanding the design concepts logic and practical use of the Grouper The Casemix Companion is a starting point and general reference for new and existing users providing an introduction to HRGs groupers HRG4 design concepts and grouping logic and useful links to further information The Grouper Reference Manual provides full instructions on how to prepare and group data using the Grouper software application This generic document is updated with every new grouper software toolkit released The Summary of Changes document provides an overview of the main changes between the current grouper design and its predecessor The Roots Workbook is a spreadsheet that identifies new HRGs deleted HRGs and changes to existing HRG Labels between each release of the classification using an easy to follow colour coding system The Chapter Summaries document provides an overview of the scope composition and grouping logic of individual subchapters along with illustrative worked examples Also included in the document are updates on the changes within subchapters The Code to Group Workbook is a spreadsheet that provides details on all mappings between primary classification e g ICD 10 OPCS 4 A amp E codes etc and their respective HRGs Also detailed within the workbook are the logic conditions required to generate the HRGs The Code to Group User Manual
23. cessBeddays Not populated in this grouper SpellReportFlag Identifies the dominant episode SpellHRG The spell HRG SpellGroupingMethod The grouping method used for the spell P Procedure driven D Diagnosis driven M Multiple trauma G Global exception U Error Flag SpellDominant The dominant procedure for the spell Procedure SpellPDiag The primary diagnosis used when spell grouping SpellSDiag The first secondary diagnosis used when spell grouping SpellEpisodeCount The number of episodes in the spell SpellLOS The spell duration used for grouping This is the total of the CalcEpidur fields for the episodes in the spell ReportingSpellLOS Not populated in this grouper SpellTrimpoint Not populated in this grouper SpellExcessBeddays Not populated in this grouper SpellCCDays The number of critical care days in the spell SpellPBC Programme Budgeting Code for the spell Copyright 2014 Health and Social Care Information Centre All rights reserved B 4 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description UnbundledHRGs Variable number of fields containing unbundled HRGs episode level Unbundled HRGs appended to the end of each record There may be zero one or more unbundled HRGs per record There is no significance to the order in which unbundled HRGs are output For Specialist Palliative Care and Rehabil
24. ck up data onto the standard windows clipboard then select the input cell where you want to start pasting and use the short cut Ctrl and V to paste it The cell selected should not be in edit mode it should be blue in colour The paste is only into the current sub window Data can also be copied from the each of the output sub windows by pressing Copy Content This puts the contents of the sub window onto the Windows clipboard Copyright 2014 Health and Social Care Information Centre All rights reserved 18 HRG4 Grouper Reference Manual v0 4 7 2 The Internal File Viewer The Grouper provides a file viewer which can be used to view Grouper output files It is accessible from the RDF editor part of the application To access the file viewer select Open RDF Editor from the Tools menu then Display File from the Tools menu Select an RDF file and input file File Edit Tools Window Help a a ea New RDF 03 X Display File 01 x Record Definition File C Program Files HSCIC HRG4 2014 15 P sample_rdf HRG4_sample_APC rdf lim f Input File C Users bhannah Desktop Grouper Ref Man HRG4_Admitted_Patient_Care_Sample_Test_Data csv yi PROCODET PROVSPNO EPIORDER STARTAGE SEX CLASSPAT ADMISORC ADMIMETH __ DISDEST DISMETH EPIDUR MAINSPEF NEOCAI PROCODET TPROVSPNO EPIORDER STARTAGE sex CLASSPAT ADMISORC ADMIMETH DISDEST DISMETH EPIDUR MAINSPEF NE
25. ct the database and RDF files to be used then press Add Record to create the first record in the spell Adding records after the first will create a new sub window on the left side below the last one that was added NB More than one record can only be added at a time for APC NCC and PCC The window is resizable and movable on the screen using normal Windows methods The window is divided vertically into 2 sections the left section for input data and the right section for outputs as identified in the headings for each section Clicking the heading bars on the sub windows will hide or reveal their contents APC episode input and output sub windows are synchronised for this feature Input sub windows can be deleted by pressing Delete on the header bar APC Spell output appears below all of the episode output sub windows Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 File Edit Window Help Le aa lele i Single Spell 01 X Database Add Record Record Definition File Program Files HSCIC HRG4 2014 15 P sample_rdf HRG4_sample_APC rdf w Input Record 01 Delete v Output Record 01 Copy Content Field Value Description Field Value Description al EPIORDER 1 STARTAGE 25 FCE_HRG UZ01Z Data Invalid for Grouping SEX 1 Male GroupingMet U CLASSPAT 1 Ordinary
26. d in the file hrg log in the grouper directory File Tools Window Help a ica al lele Healt hscic penea Q 14 15 IE File Batch Processing Bathor x Database Description Input File Output File Process Error Ratio Record Definition File Processing Message Log Admitted Patient Care APC HRG4 C Program Files HSCIC HRG4 2014 15 P sample_rdf HRG4_sam ple_APC rdf ma B C Users bhannah Desktop Grouper Ref Man HRG4_Admitted_Patient_Care_Sample_Test_Data csv a Ba Mi Input data has headings C Users bhannah Desktop Grouper Ref Man Output csv I E Mi Add headings to output data 19 02 2014 10 40 35 New Man Output csv batch processin 1g context was created Batch 19 02 2014 10 40 35 Batch 01 database definitions were reloaded 7 defin nitions 19 02 2014 10 41 22 Batch 01 new database definition selected Admitted Patient Care APC HRG4 19 02 2014 10 55 12 Batch 01 new database definition selected Non Admitted Consultations NAC HRG4 19 02 2014 10 55 44 Batch 01 new database definition selected Admitted Patient Care APC HRG4 19 02 2014 10 58 43 Starting batch context Batch 01 processing 19 02 2014 10 58 43 Batch 01 input file C Users bhannah Desktop Grouper Ref Man HRG4_Admitted_Patient_Care_Sample_Test_Data csv 19 02 2014 10 58 43 Batch 01 starting file prepare Input file C Users bhannah De
27. der to use the Display File feature to view the columns that grouping appends during file processing an RDF must be created that includes those fields Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 1 Annex A Input File Preparation This annex provides guidance about preparing input files for processing with the Grouper Note Unless otherwise stated the values in each field are validated against enumerated sets of values generally based on NHS Data Dictionary definitions File Format Input data must be in comma separated value CSV format using the standard American Standard Code for Information Interchange ASCII character set excluding the non printing ASCII characters The input file must not include qualifiers such as quotes surrounding the fields Using Excel for File Preparation If some of the records end with empty fields then a file structure issue can arise when saving a text file using Microsoft Excel for more information please refer to Microsoft Article ID 77295 Column delimiters are missing in an Excel spreadsheet that is saved as text http support microsoft com default aspx scid 77295 To prevent this issue arising ensure that the final rightmost column of data is populated for every record in the file with dummy data such as x A1 Admitted Patient Care The Grouper sorts APC data prior to processing so that records with t
28. difference in the grouping engine Any apparent differences between your grouping of data and that in SUS are likely to be caused by e Exclusions Some episodes are excluded from spells according to DH rules Lack of such records in a spell can affect the spell level grouping results To get the same result you may need to remove excluded episodes from the grouping run e Critical Care Days calculations The SUS derivation of critical care days is much more comprehensive than documented here It also includes a number of validation checks that could result in a slightly different number of CC days being applied which could affect grouping e Spell Construction The local grouper uses the contents of the Provider Code and the Hospital Provider Spell Number fields to ensure FCEs in the spell are grouped together SUS derives its own spell identifier and uses that in place of the Hospital Provider Spell Number This can mean that different sets of episodes are treated as part of a spell in reality there are few such differences e Use of some ICD codes that are invalid for grouping o SUS removes morphology codes before grouping ICD codes containing Py o SUS truncates ICD codes to 4 characters if they are longer than 4 characters and the original code is not in the list of 5 character codes deemed valid by the grouper In non admitted care SUS can produce two HRGs This can occur when the derived HRG is not tariffed An attendance HRG is
29. ding decimal point character and any dagger asterisk and suffix or blank Pigeon i i SECONDARY DIAGNOSIS Not all fields are present by default the number of fields may be specified by ICD the user in the Record Definition File Each Paediatric Critical Care day is represented by a data row in the input file Where a child moves between units with different Critical Care Unit Function Codes a new critical care period starts this may result in the generation of more than one critical care record for the day of transfer and consequently more than one HRG for that day Copyright 2014 Health and Social Care Information Centre All rights reserved A 10 HRG4 Grouper Reference Manual v0 1 A7 Neonatal Critical Care Please see the bottom of Section 6 for a comment about critical care grouping The Grouper sorts Neonatal Critical Care prior to grouping so that records with the same Provider Code and local identifier are placed in activity date order The field list below shows the fields required by the Grouper The field order of the input file is defined by the Record Definition File used for the grouping session there is no significance to the order in which the fields are listed below Tn CDS DD Field Name Notes ame PROCODET ORGANISATION CODE A value must be supplied but is not validated For NHS organisations use the CODE OF PROVIDER first 3 characters for non NHS organisations use a
30. e RDF to specify the positions of all fields in the input file Only mandatory fields need to be specified Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 The Remove Field toolbar button removes a non mandatory field from the RDF Mandatory fields cannot be deleted When you save the RDF you will be informed of any validation checks that have been failed e g conflicting field positions Validation issues must be resolved before the file can be saved 5 Command Line Initiation Command line refers to the character based command shell user interface within Microsoft Windows commonly known as the DOS Window The Grouper can process a file using the command line with parameters shown below Mandatory parameters are enclosed within lt angle brackets gt optional parameters are enclosed within square brackets All parameters consist of a hyphen followed by a lower case letter The command line takes the following form hrg grouper exe i lt Input File gt o lt Output File gt d lt Record Definition File gt 1l lt Grouping Logic gt h t r lt report filename gt Command line parameters 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 l The grouping logic The available values are APC ACC EM NAC PCC NRD NCC h Optional Where present
31. edure for the spell SpellPDiag The primary diagnosis used when spell grouping Copyright 2014 Health and Social Care Information Centre All rights reserved B 7 File Name Field Name HRG4 Grouper Reference Manual v0 4 Description SpellSDiag The first secondary diagnosis used when spell grouping SpellEpisodeCount The number of episodes in the spell SpellLOS The spell duration used for grouping ReportingSpellLOS Not populated in this grouper SpellTrimpoint Not populated in this grouper SpellExcessBeddays Not populated in this grouper SpellCCDays The number of critical care days in the spell SpellPBC Programme Budgeting Code for the spell name _quality_rel csv Relational format includes row for each episode that contains an error RowNo Matches the run generated row number Iteration The ordinal number of the quality message Code Type The type of code that has failed validation Code The value of the code that has failed validation Blank where the code is missing from the input data Error Message Description of the error name _flag_rel csv This file is populated by payment Groupers only Includes all distinct Specialised Service Codes SSCs Best Practice Tariff BPT codes and other flags generated for the spell Where a spell does not generate SSCs BPT codes or Flags this file will contain no records for tha
32. elds see Annex A for the type of data you want to group Although these fields are mandatory you define their order You can also include additional fields which will be ignored by the grouper The easiest way to create an RDF is to use the Wizard 4 1 Using the Record Definition File Wizard to Create a Custom RDF Select Open RDF Editor from the Tools menu Select New RDF from the File menu Select required Database the type of input file with which the RDF will be used Two data definition methods are available these are e Create manually Discussed in the next section e Create from file This method guides the interactive creation of an RDF using a sample input file File Edit Tools Window Help Oe S ed a NewRDFO1 x Full path and name of rdf after save Database Admitted Patient Care APC HRG4 Create manually Create from file Input File z January 2014 V1 0 1 3 22 Click the radio button for Create from File Browse for and select an Input File Click Proceed Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 File Edit Tools Window Help ollella HM E ee NewRDFO1 x Full path and name of rdf after save Database x Mandatory Fields Assigned Fields Drag items from the mandatory field list to the field below
33. er code and local identifier are placed in activity date order The field list below shows the fields required by the Grouper The field order of the input file is defined by the Record Definition File used for the grouping session there is no significance to the order in which the fields are listed below Grouper Field Name CDS DD Field Name Notes ORGANISATION CODE A value must be supplied but is not validated For NHS organisations use the ical CODE OF PROVIDER first 3 characters for non NHS organisations use all 5 characters CCLocallD CRITICAL CARE LOCAL This and the provider field are the key that keeps records for the same patient IDENTIFIER together They must be supplied CCDate nia DAE EU AE Format is CCYYMMDD e g 14 March 2009 20090314 DISDATE ORITICAL CARE DISCHARGE Format is CCYYMMDD e g 14 March 2009 20090314 DISCHARGE METHOD CODE DISMETH HOSPITAL PROVIDER SPELL CRITICAL CARE UNIT saa CCUF FUNCTION Leading zeros are significant CCAC_01 CRITICAL CARE ACTIVITY CCAC_20 CODE Blank is valid OPER_01 Valid OPCS 4 codes excluding decimal point character or blank OPER_20 COS Ector The PCC MDS specifies two appropriate procedure codes only Copyright 2014 Health and Social Care Information Centre All rights reserved A 9 HRG4 Grouper Reference Manual v0 1 Grouper Field Name CDS DD Field Name Notes PRIMARY DIAGNOSIS ICD Valid ICD 10 codes exclu
34. essage s A variable number of fields each consisting of Code Type Code and Error Message separated by pipe symbols name _FCE_rel csv Episode level output in relational form RowNo Matches the run generated row number FCE_HRG The episode HRG GroupingMethodFlag The grouping method used for the spell P Procedure driven D Diagnosis driven M Multiple trauma G Global exception U Error DominantProcedure The dominant procedure used for procedure based grouping FCE_PBC Programme Budgeting Code for the episode CalcEpidur The calculated episode duration This is the input Episode duration minus the number of days in the input fields CRITICALCAREDAYS REHABILITATIONDAYS and SPCDAYS ReportingEPIDUR Not populated in this grouper FCETrimpoint Not populated in this grouper FCEExcessBeddays Not populated in this grouper SpellReportFlag Identifies the dominant episode name _spell_rel csv Contains Spell level output in relational form one row per spell RowNo Matches the run generated row number PROCODET The organisation code from the input file PROVSPNO The hospital provider spell number from the input file SpellHRG The spell HRG SpellGroupingMethod Flag The grouping method used for the spell P Procedure driven D Diagnosis driven M Multiple trauma G Global exception U Error SpellDominant Procedure The Dominant proc
35. for grouping Copyright 2014 Health and Social Care Information Centre All rights reserved B 12 HRG4 Grouper Reference Manual v0 4 B3 Emergency Medicine There are five output files File Name Field Name Description name csv A list of other output files This file is for validation only name _attend csv The main grouped output file lt input data gt All of the input data including any non mandatory fields RowNo The generated row number of the record EM_HRG The attendance HRG name _quality csv Contains a row for each input record that has errors lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number Error Message s A variable number of fields consisting of Code Type Code and Error Message separated by pipe symbols name _quality_rel csv All of the error messages in relational form There are no entries for records that do not contain errors RowNo Matches the run generated row number Iteration The ordinal number of the quality message Code Type The type of code that has failed validation Code The value of the code that has failed validation Blank where the code is missing from the input data Error Message Description of the error name _summary csv A single row file containing details about the grouping session
36. gt All of the input data for the record including any non mandatory fields RowNo Matches the run generated row number Error Message s A variable number of fields each consisting of Code Type Code and Error Message separated by pipe symbols name _quality_rel csv All of the error messages in relational form There are no entries for records that do not contain errors RowNo Matches the run generated row number Iteration The ordinal number of the quality message Code Type The type of code that has failed validation Code Code that failed validation Blank if code missing from input data Error Message Description of the error name _summary csv A single row file containing details about the grouping session Grouper Version Version of the Grouper that produced the output files Database Version Grouper s internal HRG database version NRD Record Count Number of records submitted Copyright 2014 Health and Social Care Information Centre All rights reserved B 15 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description NRD Record Error Count Number of records having errors Run Start Date Time Date and time that the grouping session started Run End Date Time Date and time that the grouping session finished Input Filename Path and filename of the input file Output Filename
37. h of the data types processed by the Grouper The Input File Preparation section provides further information regarding the field validation by the Grouper Details of clinical coding validation can be found in the chapter summary documentation for chapter UZ Undefined Groups which is available for download from the Casemix website Error Message Format Error messages in the quality file are displayed in three sections the sections being separated by a pipe character The format is a follows Code Type Code Error Description Code Type identifies the field or field type Code is the unrecognised value Where an error is due to the absence of a code this section is left blank Error Description explains the nature of the error An example error message is ICD P102 UZ03 Diagnosis Conflicts with Age in DIAG 01 Error Types There are three types of errors 1 Field Validation Errors are generated where field values are missing or are outside of the accepted range of values Example error messages of this type are ICD Primary diagnosis is blank ICD XX68 Code not recognised in DIAG 01 OPCS C992 Code not recognised in OPER 02 2 Spell Validation Errors result from cross checks across records in a spell For example where consistency checks for sex code or age are failed SEX Not the same in all episodes in the spell AGE Falls in FCEs in this Spell 3 Clinical Coding Errors are
38. he Assigned Fields list as they are assigned Multiple fields can be selected by clicking with the mouse while holding down the SHIFT and or CTRL keys The selected fields can then be dragged to the preview area If a field is erroneously assigned it can be removed by selecting it in the Assigned Fields list and pressing the Delete key The field will then appear at the bottom of the Mandatory Fields list When all mandatory fields have been assigned save the file File Save As 4 2 Record Definition File Editor If the radio button for Create Manually had been used or Open RDF from the File menu had been used a window like the one below would be shown Copyright 2014 Health and Social Care Information Centre All rights reserved 12 HRG4 Grouper Reference Manual v0 4 File Edit Tools Window Help a a Ley ee Le lele NewRDFO2 x Full path and name of rdf after save Database Field Name Field Title Field No Picture Extract PROCODET PROCODET 1 PROVSPNO PROVSPNO 2 EPIORDER EPIORDER 3 STARTAGE STARTAGE 4 SEX SEX 5 CLASSPAT CLASSPAT 6 ADMISORC ADMISORC ADMIMETH ADMIMETH 8 DISDEST DISDEST 3 DISMETH DISMETH 10 EPIDUR EPIDUR 11 MAINSPEF MAINSPEF 12 NEOCARE NEOCARE 13 TRETSPEF TRETSPEF 14 DIAG_01 DIAG_01 15 DIAG_02 DIAG_02 16 DIAG_03 DIAG_03 17 DIAG_04 DIAG_04 18 DIAG_05 DIAG_05 19 DIAG_06 DIAG_06 20 DIAG_07 DIAG_07 21 DIAG_08 DIAG_08 22 DIAG_09 DIAG_09 23 DIAG
39. he same Provider Code and Provider Spell Number are placed in Episode Number order Grouper Field Name CDS DD Field Name Notes PROCODET ORGANISATION CODE CODE A value must be supplied but is not validated For NHS organisations use the OF PROVIDER first 3 characters for non NHS organisations use all 5 characters PROVSPNO ee PROVIDED SPELL A value must be supplied but is not validated Maximum length 24 characters EPISODE NUMBER A value must be supplied but is not validated Duplicates within a spell will EPIORDER create an error STARTAGE Derived eee years rounded down START DATE EPISODE PERSON BIRTH PERSON GENDER CODE SEX CURRENT Must be same for all episodes in a Spell Copyright 2014 Health and Social Care Information Centre All rights reserved A 1 HRG4 Grouper Reference Manual v0 1 Grouper Field Name CDS DD Field Name Notes PATIENT CLASSIFICATION CLASSPAT CODE Must be the same for all episodes within a Spell SOURCE OF ADMISSION ADMISORC CODE HOSPITAL PROVIDER Must be the same for all episodes within a Spell SPELL ADMISSION METHOD CODE ADMIMETH HOSPITAL PROVIDER Must be the same for all episodes within a Spell SPELL DISCHARGE DESTINATION DISDEST CODE HOSPITAL PROVIDER Make sure this is properly populated at least for the last episode in the spell SPELL DISCHARGE METHOD CODE DISMETH HOSPITAL PROVIDER Make sure this is properly
40. itation unbundled HRGs where there is more than one daily HRG field consists of an HRG followed by an asterisk followed by number of days rather than HRG repeated for every day e g VC 182Z 20 indicates VC18Z for 20 days name _spell csv Contains one row per spell Includes candidate Specialised Service Codes SSCs Best Practice Tariff BPT codes and other flags generated for the spell RowNo Matches the run generated row number PROCODET The organisation code from the input file PROVSPNO The hospital provider spell number from the input file SpellHRG The spell HRG SpellGroupingMethod The grouping method used for the spell P Procedure driven D Diagnosis driven M Multiple trauma G Global exception U Error Flag SpellDominant The dominant procedure for the spell Procedure SpellPDiag The primary diagnosis used for spell grouping SpellSDiag The first secondary diagnosis used for spell grouping SpellEpisodeCount The number of episodes in the spell Copyright 2014 Health and Social Care Information Centre All rights reserved B 5 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description SpellLOS The spell duration used for grouping ReportingSpellLOS Not populated in this grouper SpellTrimpoint Not populated in this grouper SpellExcessBeddays Not populated in this grouper SpellCCDays The number of critica
41. l care days in the spell SpellPBC Programme Budgeting Code for the spell SpellSSC_ Ct Number of distinct SSCs produced for the spell SpellSSC1 SpellSSC7 Candidate Specialised Service Codes for the spell Populated by Payment Groupers only SpellBP_Ct Number of distinct BPTs produced for the spell SpellBP1 to SpellBP7 Candidate Best Practice Tariff codes for the spell Populated by Payment Groupers only SpellFlag_Ct Number of distinct other flags produced for the spell SpellFlag1 to Candidate other flags for the spell SpellFlag7 Populated by Payment Groupers only UnbundledHRGs All unbundled HRGs produced for episodes in the spell There is no significance to the order in which unbundled HRGs are output name _quality csv 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 lt input data gt All of the input data for the FCE including any non mandatory fields are reproduced in the output RowNo Matches the run generated row number Copyright 2014 Health and Social Care Information Centre All rights reserved B 6 File Name Field Name HRG4 Grouper Reference Manual v0 4 Description Error M
42. lated AttendFlag1 Not populated AttendFlag5 UnbundledHRGs A variable number of fields containing unbundled HRGs appended to the end of each record There is no significance to the order in which unbundled HRGs are output name _quality csv Contains one row for each attendance that contains errors lt input data gt All of the input data including any non mandatory fields Copyright 2014 Health and Social Care Information Centre All rights reserved B 10 File Name Field Name HRG4 Grouper Reference Manual v0 4 Description RowNo Matches the run generated row number Error Message s A variable number of fields consisting of Code Type Code and Error Message separated by pipe symbols name _attend_rel csv Output in relational form lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number NAC_HRG The attendance HRG GroupingMethodFlag Grouping method used P Procedure driven G Global exception O Outpatient Default U Error DominantProcedure The dominant procedure used for procedure based grouping name _quality_rel csv All error messages in relational form None for attendances without errors RowNo Matches the run generated row number Iteration The ordinal number of the quality message Code Type The type of code that has failed validation
43. line Output fields containing the Dominant Procedure can be longer In earlier groupers when combination procedure codes are used in the logic only one code from the combination is shown Now the whole combination code is shown this does not affect final results 3 Grouping Your Own Data In order to group your own data you need to either 1 Ensure that the structure of your data is identical to that as specified in an existing RDF file or 2 Create an RDF file see Section 4 that matches the structure of your data Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 Grouping can be initiated from the front end as shown in the quick start section or from the command line see Section 5 Whichever approach is used the same input rules Annex A grouper processing and output file structures and content Annex B will result Another approach for single records and for single APC multi episode spells is to use the Single Spell Grouper To get an initial appreciation of grouping you are recommended to experiment with the Single Spell Grouper functionality Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 4 Record Definition File RDF The RDF file tells the grouper the structure of the data you want it to process The field content of the RDF file must include all mandatory input fi
44. ll 5 characters CCLocallD CRITICAL CARE LOCAL This and the provider field are the key that keeps records for the same patient IDENTIFIER together They must be supplied CCDate nia DALE SENU RE Format is CCYYMMDD e g 14 March 2009 20090314 DISDATE ORITICAL CARE DISCHARGE Format is CCYYMMDD e g 14 March 2009 20090314 CRITICAL CARE UNIT POES CCUF FUNCTION Leading zeros are significant Whole days rounded down ACTIVITY DATE CRITICAL CARE PERSON AGE_DAYS Derived BIRTH DATE DISCHARGE METHOD CODE DISMETH HOSPITAL PROVIDER SPELL GestLen GESTATION LENGTH AT DELIVERY Copyright 2014 Health and Social Care Information Centre All rights reserved A 11 HRG4 Grouper Reference Manual v0 1 Grouper Field Name CDS DD Field Name Notes Kilograms to 3 decimal places Range greater than zero kg and less than 10 kg PERWT PERSON WEIGHT Bae iag Leading zeroes are accepted for compatibility with NHS Data Dictionary format CCAC_01 CRITICAL CARE ACTIVITY Siankig valid CCAC_20 CODE Each Neonatal Critical Care day is represented by a data row in the input file Where a baby moves between units with different Critical Care Unit Function Codes a new critical care period starts this may result in the generation of more than one critical care record for the day of transfer and consequently more than one HRG for that day Copyright 2014 Health and Social Care Information Centre All right
45. mainly due to the use of clinical codes that do not exist in the coding system violate clinical coding convention or are not useful resource indicators for HRG grouping Copyright 2014 Health and Social Care Information Centre All rights reserved C 1 HRG4 Grouper Reference Manual v0 4 Clinical coding errors produce error messages that contain the error category codes described in the following section Error Categories Error Categories are used mainly for clinical coding errors Critical care grouping error descriptions also include error category codes UZ01 Invalid Primary Diagnosis Diagnosis code is present but should not be used in a primary position according to clinical coding conventions ICD Z509 UZ01 Invalid Primary Diagnosis in DIAG 01 Z509 Care involving use of rehabilitation procedure unspecified UZ02 Poorly Coded Primary Diagnosis Diagnosis code is valid as a primary diagnosis but is too vague to determine the resource use ICD T140 UZ02 Poorly Coded Primary Diagnosis in DIAG 01 T140 Superficial injury of unspecified body region UZ03 Diagnosis Conflicts with Age A paediatric primary diagnosis has been recorded for an adult patient age 19 years and over ICD P704 UZ03 Diagnosis Conflicts with Age in DIAG 01 P704 Other neonatal hypoglycaemia UZ04 Diagnosis Conflicts with Anatomical Site Indicates an invalid combination of primary diagnosis and anatomical site This onl
46. mitted Patient Care B2 Non Admitted Consultations B3 Emergency Medicine Copyright 2014 Health and Social Care Information Centre All rights reserved o oo O aaa oO i N eee e Ce eee O NOORA ON N A ol 10 13 HRG4 Grouper Reference Manual v0 4 B4 Renal Dialysis National Renal Dataset B5 Adult Critical Care B6 Paediatric Critical Care B7 Neonatal Critical Care Annex C Errors Annex D Server Installation Annex E Installation Problems Copyright 2014 Health and Social Care Information Centre All rights reserved 15 17 19 21 HRG4 Grouper Reference Manual v0 4 1 Quick Start This section is intended to provide a brief overview of downloading installing and starting to use the HRG4 Grouper application For more detailed information you are advised to read the whole manual 1 1 Download and Install the Grouper 1 Go here www hscic gov uk casemix downloads 2 Click on either Payment or Costing for the type of the grouper you need Older versions are in the archives 3 For Payment groupers there may be more than one version available pick the version you need 4 Click on the Grouper application link in the Download section at the right of the screen 5 Save the Zip file to an appropriate location on your computer 6 Open the Zip file and extract the Grouper application 7 Double click the Grouper application file and follow the installation setup wizard 1
47. otected by trademark and other pending or existing intellectual property rights in the United States and other countries Additionally we have also been advised as follows We presume that the user account has the necessary permissions to access the grouper directory If installing as an administrator our suggestion is to uninstall and re install but with the Launch application checkbox unchecked at the end of the installation this prevents the installer creating user profile information as an administrator that may lock files for other users Instead start the grouper for the first time as a normal user Copyright 2014 Health and Social Care Information Centre All rights reserved D 1 HRG4 Grouper Reference Manual v0 4 Annex E Installation Problems Upon installation of the Payment Grouper some users may experience an issue whereby the Grouper window will not maximize beyond its tool bar icon If users do experience this issue they are advised to do the following to rectify it Start Task Manager right click on the Payment Grouper and select Maximize If users do experience this issue please can they inform us at casemixhelpdesk hscic gov uk Copyright 2014 Health and Social Care Information Centre All rights reserved E 1 HRG4 Grouper Reference Manual v0 4 The Documentation Suite Below is a list of the various documents which are available to download from the National Casemix Office website www hscic gov uk
48. ping session finished Input Filename Path and filename of the input file Output Filename Path and filename selected by the user RDF path and name Path and filename of the Record Definition File used for grouping Copyright 2014 Health and Social Care Information Centre All rights reserved B 9 HRG4 Grouper Reference Manual v0 4 B2 Non Admitted Consultations There are eight output files File Name Field Name Description name csv A list of other output files used for validation only name _attend csv The main grouped output file lt input data gt All of the input data including any non mandatory fields RowNo The generated row number of the record NAC_HRG The attendance HRG GroupingMethodFlag Grouping method used P Procedure driven G Global exception O Outpatient Default U Error DominantProcedure The dominant procedure used for procedure based grouping AttendSSC_Ct The count of distinct SSCs produced for the attendance always zero because the SSC fields are not populated AttendSSC1 AttendSSC5 Not populated AttendBP_Ct The count of distinct BPT flags produced for the attendance always zero because the BPT fields are not populated AttendBP1 AttendBP5 Not populated AttendFlag_Ct The count of distinct other flags produced for the attendance always zero because the flag fields are not popu
49. rt the Grouper output into a relational database other users may choose to ignore them and vice versa RowNo Field RowNo is an identifier that can be used to link rows in output files to rows in other output files This is particularly useful in the case of the relational output files Use of a system generated row number avoids problems using input values where they may not be unique Note that depending on the file s role in a relationship with another file RowNo may not contain consecutive values i e there may be values missing this is by design For example the RowNo values in the name spell rel csv file will contain non consecutive values where the input data contains multi episode spells Copyright 2014 Health and Social Care Information Centre All rights reserved B 1 HRG4 Grouper Reference Manual v0 4 Iteration Field Iteration appears in some relational output files it is used to distinguish between occurrences within the same key value There is no significance to the numerical values of Iteration the values are assigned in order being numbered 1 2 3 etc Copyright 2014 Health and Social Care Information Centre All rights reserved B 2 HRG4 Grouper Reference Manual v0 4 B1 Admitted Patient Care There are eleven output files File Name Field Name Description name csv A list of all the other output files name _sort csv A copy of the input data af
50. s is a general purpose grouping error for Paediatric Critical Care generated when the input record does not meet any of the criteria in the paediatric critical care grouping algorithm UZ13 ACC Grouping Error This is a general purpose grouping error for Adult Critical Care generated when the input record does not meet any of the criteria in the adult critical care grouping algorithm UZ14 Renal NRD Error This is a general error for grouping renal activity using the national renal dataset and is generated when conditions in the grouping algorithm have not been met UZ21 CCAC Inappropriate in NCC Generated when the Critical Care Activity Code is inappropriate for the Neonatal Critical Care HRG algorithm UZ22 CCAC Inappropriate in PCC Generated when the Critical Care Activity Code is inappropriate for the Paediatric Critical Care HRG algorithm Notes When one error is found in a record the Grouper does not stop the validation process The grouping software aims to identify all errors and output them together In Admitted Patient Care data primary diagnosis is always validated All clinical codes are validated against the Grouper s internal database of codes Copyright 2014 Health and Social Care Information Centre All rights reserved C 3 HRG4 Grouper Reference Manual v0 4 Annex D Server Installation Server Installation problems have been discussed with our supplier Current advice is The most likely issue is that
51. s reserved A 12 HRG4 Grouper Reference Manual v0 4 Annex B Output Files In the text below and the tables in the following pages the output file name supplied by the user during processing is referred to as name the remainder of the file name is a standard suffix that is appended by the Grouper 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 thus enabling users to select the files that best suit their needs Output files are produced as comma separated text These files may be opened with Microsoft Excel but very large files may exceed the maximum number of rows for Excel In these cases an error message such as File not loaded completely will be displayed when attempting to open the file The output files may be opened with a variety of applications including Windows Notepad Relational Outputs Relational output files can be identified by the presence of _re1 as part of the filename They are characterised by the following features e They include row number references in order to allow files to be linked e Where items are repeated e g unbundled HRGs Specialised Service Codes error messages this is represented by the addition of rows rather than columns the data is normalised The relational output files are supplied to support users who wish to impo
52. sktop Grouper Ref Man HRG4_Admitted_Patient_Care_Sample_Test_Data csv output file C Users bhannah Desktop Grouper Ref Man Output_sort csv 19 02 2014 10 58 44 Batch 01 input file prepared Elapsed time 00 00 01 19 02 2014 10 58 44 Batch 01 starting file processing Input file C Users bhannah Desktop Grouper Ref Man Output_sort csv output file C Users bhannah Desktop Grouper Ref 19 02 2014 10 58 45 Batch 01 processing finished Elapsed time 00 00 01 19 02 2014 10 58 45 Batch 01 result Processed 327 records 260 grouped 79 511 67 ungrouped 20 489 Kernel P1415_20131209 20140203 Database P1415_20131209 Spec January 2014 V1 0 App 1 3 22 Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 16 Open Windows Explorer and browse to the folder specified for the output file 17 Open the file ocutput _FCE csv in Microsoft Excel The file is a copy of the input file with HRGs and other related columns appended Other output files are explained in Annex B 18 Scroll to the far right of the file to view the columns that the Grouper has appended Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 2 New Features 2 1 New Features in the Payment 14 15 grouper The following changes have been made to the Payment 14 15 grouper e Automatic remov
53. t Care APC HRG4 Kernel P1415_20131209 20140203 Database P1415_20131209 Spec January 2014 V1 0 App 1 3 22 Copyright 2014 Health and Social Care Information Centre All rights reserved HRG4 Grouper Reference Manual v0 4 5 In the Open form browse for the Sample RDF The sample RDFs are located in the Grouper s installation folder in a sub folder called sample_rdf 6 Open the file HRG4 sample APC rdf An alternative sample RDF file should be used for other grouping database selections The database selection and RDF file should match 7 Click the browse button folder icon to the right of the Input File field 8 In the Open form browse to and select the downloaded sample input file from step 1 above 9 Click Open 10 Ensure that the Input data has headings box is checked 11 Click the browse button folder icon next to the Output File field 12 In the Save As form browse to the folder containing the input file and type output or anything similarly appropriate in the File name box 13 Click Save The path and filename of the output file are displayed in the Output File field 14 Ensure that the Add headings to output data box is checked 15 Click the Process button When finished the log display area shows information about the grouping session including the number of records grouped These details can also be foun
54. t file Output Filename Path and filename selected by the user RDF path and name Path and filename of the RDF used for grouping Copyright 2014 Health and Social Care Information Centre All rights reserved B 18 HRG4 Grouper Reference Manual v0 4 B6 Paediatric Critical Care There are six output files File Name Field Name Description name csv A list of other output files this file is for validation only name _sort csv A copy of the input data after it has been sorted lt input data gt All input data including any non mandatory fields RowNo The generated row number of the record after sorting name _pcc csv The main grouped output file lt input data gt All input data including any non mandatory fields RowNo Matches the run generated row number PCC_HRG Unbundled HRG for the PCC day All PCC HRGs are unbundled name _quality csv Contains one row for each record that has errors lt input data gt All input data including any non mandatory fields RowNo Matches the run generated row number Error Message s A variable number of fields each consisting of Code Type Code and Error Message separated by pipe symbols name _quality_rel csv All of the error messages in relational form RowNo Matches the run generated row number Iteration Ordinal number of the qualit
55. t spell RowNo Matches the run generated row number PROCODET The organisation code from the input file PROVSPNO The hospital provider spell number from the input file Iteration The ordinal number of the SSC BPT or other flag SpellFlag Includes all distinct Specialised Service Codes SSCs Best Practice Tariff BPT codes and other flags generated for the spell Copyright 2014 Health and Social Care Information Centre All rights reserved B 8 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description name _ub_rel csv The unbundled HRGs There are no entries for episodes that do not have any unbundled HRGs RowNo Matches the run generated row number Iteration The ordinal number of the unbundled HRG UnbundledHRGs The unbundled HRGs There is no significance to the order in which unbundled HRGs are output name _summary csv A single row file containing details about the grouping session Grouper Version Version of the Grouper that produced the output files Database Version Grouper s internal HRG database version FCE Count Number of episodes submitted Spell Count Number of spells submitted FCE Error Count Number of episodes having errors Spell Error Count Number of spells having errors Run Start Date Time Date and time that the grouping session started Run End Date Time Date and time that the grou
56. ter it has been sorted by Provider Code Spell Number and Episode Number prior to grouping lt input data gt All of the input data including any non mandatory fields RowNo The generated row number of the record after sorting This will match the equivalent fields in other output files from the same grouper run name _FCE csv Contains both episode and spell output fields The spell fields are repeated for each episode in the spell care must be taken to avoid double counting when using spell fields lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number FCE_HRG The episode HRG GroupingMethodFlag The grouping method used for the spell P Procedure driven D Diagnosis driven M Multiple trauma G Global exception U Error DominantProcedure The dominant procedure used for procedure based grouping FCE_PBC Programme Budgeting Code for the episode CalcEpidur The calculated episode duration This is the input Episode duration minus the number of days in the input fields CRITICALCAREDAYS REHABILITATIONDAYS and SPCDAYS ReportingEPIDUR Not populated in this grouper Copyright 2014 Health and Social Care Information Centre All rights reserved B 3 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description FCETrimpoint Not populated in this grouper FCEEx
57. the user does not have permission to write to the default log directory Whilst the application has been built to minimise this risk by following Microsoft standards and writing output to the Users directory e g C Users username hrg4 grouper profile C1415 there may be instances where local policies will make this difficult and consequently our recommendation is that as a first option users confirm they have their own Users directory on the server and have Full control permission for that directory with their local IT staff Permissions for SYSTEM Allow Deny Full control Modify Read amp execute List folder contents Read Write For special permissions or advanced settings Advanced click Advanced The developers use a Windows Server 2008 R2 SP1 Standard see below for grouping engine development and local testing without UAC triggers so again this may be related to a permissions issue Users may be concerned with changing the User Account Control on the machine if the only alternative is on or off but the link to the technical tip here will help to show how to use the Microsoft Application Compatibility Toolkit to manage UAC for specific executables About Windows xi T H Windows Server 2008 2 Standard Microsoft Windows Server Version 6 1 Build 7601 Service Pack 1 Copyright 2009 Microsoft Corporation All rights reserved The Windows Server 2008 R2 Standard operating system and its user interface are pr
58. tions without permission
59. y applies to specific musculoskeletal codes entered at 5th digit level ICD M6607 UZ04 Diagnosis Conflicts with Anatomical Site in DIAG 01 M6607 Rupture of popliteal cyst Ankle foot UZ05 Invalid Dominant Procedure Indicates invalid dominant procedure e g an anatomical site and includes the entire Y methods of operations and Z anatomical sites codes and also a number of codes in the main body system chapters OPCS 841 UZ05 Invalid Dominant Procedure in OPER 02 OPCS W450 UZ05 Invalid Dominant Procedure in OPER 02 Y841 Gas and air analgesia in labour W540 Conversion from previous prosthetic replacement of articulation of bone NEC Copyright 2014 Health and Social Care Information Centre All rights reserved C 2 HRG4 Grouper Reference Manual v0 4 UZ06 Poorly Coded Procedure Indicates a dominant or unbundled procedure that is too vague and unspecific to determine resource use from an HRG design perspective OPCS A579 UZ06 Poorly Coded Procedure in OPER 02 OPCS U019 UZ06 Poorly Coded Procedure in OPER 01 A579 Unspecified operations on spinal nerve root U019 Unspecified diagnostic imaging of whole body UZ11 Neonatal Critical Care Error This is a general purpose grouping error for Neonatal Critical Care generated when the input record does not meet any of the criteria in the neonatal critical care grouping algorithm UZ12 Paediatric Critical Care Error Thi
60. y message Code Type Type of code that has failed validation Code Code that failed validation blank if code missing from input data Error Message Description of the error name _summary csv A single row file containing details about the grouping session Grouper Version Version of the Grouper that produced the output files Copyright 2014 Health and Social Care Information Centre All rights reserved B 19 HRG4 Grouper Reference Manual v0 4 File Name Field Name Description Database Version Grouper s internal HRG database version PCC Record Count Number of records submitted PCC Record Error Count Number of records having errors Run Start Date Time Date and time that the grouping session started Run End Date Time Date and time that the grouping session finished Input Filename Path and filename of the input file Output Filename Path and filename selected by the user RDF path and name Path and filename of the RDF used for grouping Copyright 2014 Health and Social Care Information Centre All rights reserved B 20 HRG4 Grouper Reference Manual v0 4 B7 Neonatal Critical Care There are six output files File Name Field Name Description name csv A list of other output files this file is for validation only name _sort csv A copy of the input data after it has been sorted
Download Pdf Manuals
Related Search
Related Contents
Tyre Basics Passenger Car Tyres Peak Lite - PL-220/PL-320 Makita HR2450F User's Manual Thomson 32" LCD TV Hi-Pix Veranda BRDVC BW 20-10PK Use and Care Manual Samsung SAMSUNG ST2014F manual do usuário Guide d`Assemblage Manual do aparelho SENTRON Multimedidor PAC3100 7KM3133 ハンディプログラマJW-14PG取扱説明書 Plantronics SupraPlus SDS 2490- https://telegra.ph/Calculate-Length-from-Voltage-Drop-d12987f9-11-16
- https://telegra.ph/1-5-10-Concrete-Mix-Calculator-7f3fc59b-11-17
- https://telegra.ph/1-4-8-Concrete-Mix-Calculator-ae3818b8-11-17
- https://telegra.ph/Square-Slab-Concrete-Volume-Calculator-a94b45b0-11-17
- https://telegra.ph/Footer-Concrete-Volume-Calculator-ac8a9fcd-11-17
- https://telegra.ph/Wall-Concrete-Volume-Calculator-5847c931-11-13
- https://telegra.ph/Round-Column-Concrete-Volume-Calculator-cb5c03a8-11-13
- https://telegra.ph/Wire-Size-Calculator-From-Voltage-Drop-d3629810-11-17
- https://telegra.ph/Calculate-Current-from-Voltage-Drop-4ec542f0-11-18
- https://telegra.ph/Calculate-Current-from-Voltage-Drop-b94d203f-11-18