Home

HRG4+ 2016/17 Engagement Grouper

1. File Name Field Name Description Contains one of three values APC E Episode level Type aggregates APC S Spell level aggregates APC U Unbundled HRG aggregates Provider The PROCEDET input field The FCE_HRG SpellHRG or UB_HRG output fields as HRG appropriate for the Type TretSpef The TRETSPEF input field For APC S type it is the p TRETSPEF of the dominant episode in the spell ClassPat The CLASSPAT input field For APC S type it is the CLASSPAT of the first episode in the spell AdmiMeth The ADMIMETH input field For APC S type it is the ADMIMETH of the first episode in the spell TrimPoint Mean LOS The mean of the input EPIDUR Adj Mean LOS The mean of the output CalcEPIDUR The sum of the output CalcEPIDUR or SpellLOS minus the Inlier Beddays output FCEExcessBedDays or SpellExcessBeddays as appropriate The sum of the output FCEExcessBeddays or POE PENERE SpellExcessBeddays as appropriate Count The count of episodes spells or records Non Admitted Consultations NAC There are nine output files File Name Field Name Description name csv A list of other output files 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 defau
2. Output Filename The path and filename selected by the user RDF path and name The path and filename of the Record Definition File used for grouping name _report csv An aggregated report file This file is produced by Reference Costs Groupers only Type Contains the value EM Provider Blank HRG The EM_HRG TretSpef Blank ClassPat Blank AdmiMeth Blank TrimPoint Blank Mean LOS Blank Adj Mean LOS Blank Inlier Beddays Blank Excess Beddays Blank Count The count of attendances Renal Dialysis NRD There are six output files File Name Field Name Description name csv A list of other output files 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 Page 28 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name NRD_HRG Description The HRG for the dialysis record na me _quality csv Contains one row for each record that contains errors lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number Error Message A variable number of fields consisting of Code T
3. RowNo Matches the run generated row number Error Message A variable number of fields consisting of Code Type Code and Error Message separated by pipe symbols na me _quality_rel csv All error messages in relational form Page 31 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description 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 ad The code that failed validation Blank if code missing from input data Error Message Description of the error na me _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 PCC Record Count The number of records submitted PCC Record 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 an
4. DOONIO UIA WN amp NeoCare TRG PriDiag DIAG_02 DIAG_03 DIAG_04 DIAG_05 DIAG_06 1617 E 8 The editor allows you to modify field positions and field attributes in an RDF The RDF columns are Name Field Name Description A field name abbreviation for internal use it cannot be modified A field description which can be edited to display a locally defined field Field Title Field No name The field column number in the input file Specifies whether specific character positions in the field are used or Picture ignored during processing It must be specified as a string of A and where A means keep the character in that position and means ignore the character in that position For example AAA A means ignore the 4th character and process characters in positions 1 2 3 and 5 as if it is a 4 character code so that W58 1 gets processed as W581 Note that it is no longer necessary to use Picture to remove full stops from procedure and diagnosis codes because these now get removed automatically Allows you to specify that specific characters in any position in the field are Extract ignored during processing For example without quote marks will remove all full stops from the field Page 8 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 The
5. fer Health amp Social Care hscic Information Centre HRG4 2016 17 Engagement Grouper User Manual Published August 2015 HRG4 2016 17 Engagement Grouper User Manual v1 0 We are the trusted national provider of high quality information data and IT systems for health and social care www hscic gov uk enquiries hscic gov uk hscic Author The National Casemix Office Health and Social Care Information Centre Version V1 0 Date of publication August 2015 Page 1 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 Contents Quick Start Download and Install the Grouper Walkthrough Using Sample Data Grouping Your Data Record Definition File RDF Using the Record Definition File Wizard to Create a Custom RDF Record Definition File Editor Command Line Initiation Additional Features Single Spell Grouping The Internal File Viewer Input File Preparation Admitted Patient Care APC Non Admitted Consultations NAC Emergency Medicine EM Renal Dialysis NRD Adult Critical Care ACC Paediatric Critical Care PCC Neonatal Critical Care NCC Output Files Admitted Patient Care APC Non Admitted Consultations NAC Emergency Medicine EM Renal Dialysis NRD Adult Critical Care ACC Paediatric Critical Care PCC Neonatal Critical Care NCC Errors and Validation The Documentation S
6. Batch 01 input file prepared Elapsed time 00 00 01 12 08 2015 15 01 23 Batch 01 starting file processing Input file C Temp data output_apc_sample_sort csv output file C Temp data output_apc_sample csv 12 08 2015 15 01 26 Batch 01 processing finished Elapsed time 00 00 03 5 Health amp Social Care 12 08 2015 15 01 26 Batch 01 result Processed 327 records 259 grouped 79 205 68 ungrouped 20 hscic Information Centre 795 1617 E 8 e Open Windows Explorer and browse to the folder specified for the output file e Open the file output _apc_ sample 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 the Output Files section of this document Grouping Your Data In order to group your own data you need to either e Ensure that the structure of your data is identical to that specified in an existing record definition file RDF or e Create an RDF that matches the structure of your data Page 5 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 Grouping can be initiated from the graphical user interface GUI or from the command line Whichever approach is used the same input rules grouper processing and output file structures and content will result Another approach for single re
7. Create from file Input File C Temp data G4_Admitte are_Sample_Test_Data csv Clear Mandatory Fields Assigned Fields Drag items from the mandatory field list to PROCODET the field below to assign them Unassign fields by selecting them and pressing delete PROVSPNO EPIORDER Number of diagnosis codes 14 STARTAGE SEX CLASSPAT ADMISORC ADMIMETH DISDEST LDISMETH Number of procedure codes 12 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Field 8 Field 9 SpellID EpiOrder Age PatClass AdmiSource AdmiMethod DisDest 1004595488 1 68 1 51 1004595489 1 1 1004595490 1 1 51 1004595491 1 1 81 19 51 81 19 81 19 51 81 19 1617 E 8 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 or decreased 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 li
8. Iteration The ordinal number of the unbundled HRG The unbundled HRGs There is no significance to the order in which unbundled HRGs are output UnbundledHRGs For Specialist Palliative Care and Rehabilitation HRGs are generated on a per diem basis so there will be a row for each day na me _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 The Grouper s internal HRG database version FCE Count The number of episodes submitted Spell Count The number of spells submitted FCE Error Count The number of episodes having errors Spell Error Count The number of spells 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 for grouping na me _report csv An aggregated report file This file is produced by Reference Costs Groupers only Page 24 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0
9. error for each episode 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 Page 23 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description 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 na me _flag_rel csv This file is populated by Payment Groupers only 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 Includes all distinct Specialised Service Codes SSCs Best SpellFlag Practice Tariff BPT codes and other flags generated for the spell na me _FCE_flag_rel csv This file is populated by Reference Costs Groupers only RowNo Matches the run generated row number Iteration The ordinal number of the SSC FCEFlag Includes all distinct Specialised Service Codes SSCs na me _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
10. 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 Page 36 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 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 errors cascade up to the next level If an episode HRG is UZ01Z then the spell HRG will be UZ01Z If an unbundled HRG is UZ01Z then both the episode and the spell HRGs will be UZ01Z Errors do not cascade downwards so if one episode gets UZ01Z then it will not stop the other episode HRGs from being generated In Admitted Patient Care data Specialised Service Codes and Be
11. the order in which unbundled HRGs are output UnbundledHRGs 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 HRG being repeated for every day For example VC18Z 20 indicates VC18Z for 20 days name _spell csv Contains 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 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 SpellLOS The spell duration used for grouping ReportingSpellLOS Reference Costs Groupers only The total of the ReportingEPIDUR fields for the episodes in the spell Page 21 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description SpellTrimpoint Reference Costs Groupers only
12. 51 81 ZZZ 1004595502 74 51 81 ZZZ 1004595503 101 51 81 ZZZ 1004595504 85 51 81 ZZZ 1004595505 88 51 81 ZZZ 1004595506 83 51 81 ZZZ 1004595507 72 51 81 w 0 x RIN NON N EINN e N BN Nehe RB NNN 1617 E 8 Selecting a Record Definition File and an Input File will display the input file data organised into the columns specified in the RDF Input File Preparation This section 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 Page 11 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Format Input data must be in comma separated value CSV format using the 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
13. Also included in the document are updates on the changes within subchapters The Worked Examples document contains subchapter specific worked examples to highlight how the different types of grouping logic implemented within each subchapter works 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 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 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 Published by the Health and Social Care Information Centre Part of the Government Statistical Service This publicat
14. Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 Some fields are populated with useful values to save some data input effort and the user can edit these and populate other fields as appropriate The output values will be updated to reflect any changes Any errors are highlighted in yellow in both the Input and Output sections The content of any row in the input or output sections will be displayed in the status bar at the bottom of the window when selected The Internal File Viewer The Grouper provides a file viewer which can be used to view input or output files To access the file viewer select Display File from the Tools menu in the RDF Editor Parcs 2016 17 E File Edit Tools Window Help Deele i e Record Definition File C Program Files HSCIC HRG4 2016 17 E sample_rdf HRG4 _sample_APC rdf NA E Input File _C Temp data HRG4_Admitted_Patient_Care_Sample_Test_Data csv x e PROCODET PROVSPNO EPIORDER STARTAGE SEX CLASSPAT ADMISORC ADMIMETH DISDES OrgCode SpellID EpiOrder Age PatClass AdmiSource AdmiMethod DisDest ZZZ 1004595488 1 68 51 81 ZZZ 1004595489 90 51 81 ZZZ 1004595490 85 51 81 ZZZ 1004595491 80 51 81 ZZZ 1004595492 82 51 81 ZZZ 1004595493 68 51 81 ZZZ 1004595494 90 51 81 ZZZ 1004595495 82 51 81 ZZZ 1004595496 89 51 81 ZZZ 1004595497 90 51 81 ZZZ 1004595498 82 51 81 ZZZ 1004595499 83 51 81 ZZZ 1004595500 85 51 81 i ZZZ 1004595501 89
15. ECONDARY DIAGNOSIS ICD Valid ICD 10 codes or blank 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 Page 17 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 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 Neonatal Critical Care NCC 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 Grouper Field Name CDS DD Field Name Notes organisation A else PROCODET CODE CODE OF o 9 the first 3 characters for non NHS PROVIDER ae organisations use all 5 characters This and the provider field are the key CCLocallD ae hacen that keeps records for the same patient together They must be supplied CCDate ACTIVITY DATE Format is YYYYMMDD e g 14 March CRITICAL CARE 2014 20140314 DISDATE CRITICAL CARE Fo
16. Insert Field toolbar button or Edit menu option 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 the RDF to specify the position of all fields in the input file Only mandatory fields need to be specified The Remove Field toolbar button or Edit menu option removes a non mandatory field from the RDF Mandatory fields cannot be deleted 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 grouperc exe i lt Input File gt o lt Output File gt d lt Record Definition File gt 1 lt Grouping Logic gt h t 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 1 The grouping logic The available values are APC ACC EM NAC PCC NRD NCC h Optional Where present indicates that the input file has a header row field names Omit this parameter wh
17. ROVIDER SPELL ADMISSION METHOD ADMIMETH CODE HOSPITAL Must be the same for all episodes in a PROVIDER SPELL SPell Page 12 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 Grouper Field Name CDS DD Field Name Notes DISCHARGE DESTINATION CODE DISDEST HOSPITAL PROVIDER SPELL DISCHARGE METHOD DISMETH CODE HOSPITAL PROVIDER SPELL Range 0 99999 Whole days END EPIDUR Derived DATE EPISODE START DATE EPISODE CARE MAINSPEF PROFESSIONAL MAIN SPECIALTY CODE NEONATAL LEVEL OF NEOCARE CARE CODE May be blank ACTIVITY TRETSPEF TREATMENT FUNCTION CODE DIAG 01 PRIMARY DIAGNOSIS Valid ICD 10 code If this field is blank ICD an error will be generated DIAG_02 DIAG_99 SECONDARY DIAGNOSIS ICD As above but blank allowed OPER_01 OPER_99 PRIMARY PROCEDURE OPCS and PROCEDURE OPCS Valid OPCS 4 codes or blank CRITICALCAREDAYS Derived Range 0 99999 or blank Count of distinct days within the episode when the patient was in Critical Care 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 REHABILITATIONDAYS LENGTH OF STAY ADJUSTMENT REHABILITATION Range 0 99999 or blank SPCDAYS LENGTH OF STAY ADJUSTMENT SPECIALI
18. ST PALLIATIVE CARE Range 0 99999 or blank Non Admitted Consultations NAC Non admitted consultations are outpatient attendances or attendances by patients for nursing care on a ward ward attenders Since 1 April 2005 the Outpatient Attendance CDS has contained both of these types of data Page 13 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 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 STARTAGE Derived Whole years rounded down APPOINTMENT DATE PERSON BIRTH DATE SEX PERSON GENDER CODE CURRENT MAINSPEF CARE PROFESSIONAL MAIN SPECIALTY CODE TRETSPEF ACTIVITY TREATMENT FUNCTION CODE FIRSTATT FIRST ATTENDANCE CODE OPER_01 OPER_99 PRIMARY PROCEDURE OPCS and PROCEDURE OPCS Valid OPCS 4 codes 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 Emergency Medicine EM The field list below shows the fields required by the Grouper The field order of the input file is defined b
19. 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 for grouping name _report csv An aggregated report file This file is produced by Reference Costs Groupers only Type Contains the value ACC Provider Blank HRG The ACC_HRG TretSpef Blank ClassPat Blank AdmiMeth Blank TrimPoint Blank CC Days The output Calc_CC_Days field Adj Mean LOS Blank Inlier Beddays Blank Excess Beddays Blank Count The count of periods Paediatric Critical Care PCC There are seven output files File Name Field Name Description na me csv A list of other output files na me _sort csv A copy of the input data after it has been sorted lt input data gt All of the input data including any non mandatory fields RowNo The generated row number of the record after sorting na me _pcc csv The main grouped output file lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number PCC_HRG The unbundled HRG for the Paediatric Critical Care day na me _quality csv Contains one row for each record that contains errors lt input data gt All of the input data including any non mandatory fields
20. The trimpoint for the spell HRG SpellExcessBeddays Reference Costs Groupers only The number of days by which the SpellLOS exceeds the trimpoint SpellCCDays The number of critical care days in the spell SpellPBC Programme Budgeting Code for the spell SpellSSC_Ct Number of distinct SSCs produced for the spell SpellSSC1to Payment Groupers only SpellSSC7 Candidate Specialised Service Codes for the spell SpellBP_Ct Number of distinct BPTs produced for the spell SpellBP1 to SpellBP7 Payment Groupers only Candidate Best Practice Tariff codes for the spell SpellFlag_Ct Number of distinct other flags produced for the spell SpellFlag1 to Payment Groupers only SpellFlag7 Other flags for the spell Variable number of fields containing unbundled HRGs spell level There is no significance to the order in which unbundled HRGs are output UnbundledHRGs 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 HRG being repeated for every day For example VC18Z 20 indicates VC 18Z for 20 days 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 Th
21. ce Costs Groupers only FCEExcessBeddays The number of days by which CalcEpidur exceeds the trimpoint SpellReportFlag Identifies the dominant episode name _spell_rel csv 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 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 ReportingSpellLOS Reference Costs Groupers only The total of the ReportingEPIDUR fields for the episodes in the spell SpellTrimpoint Reference Costs Groupers only The trimpoint for the spell HRG SpellExcessBeddays Reference Costs Groupers only The number of days by which the SpellLOS exceeds the trimpoint SpellCCDays The number of critical care days in the spell SpellPBC Programme Budgeting Code for the spell na me _quality_rel csv Relational format includes a row for each
22. ch 01 x Database Select database type Record Definition File Input File W Input data has headings Output File L Add headings to output data Progress Error Ratio Processing Message Log 12 08 2015 14 59 07 New batch processing context was created Batch 01 12 08 2015 14 59 08 Batch 01 database definitions were reloaded 7 definitions Health amp Social Care nation Cen hscic ha 1617 E 8 e Select Admitted Patient Care APC E1617 in the Database drop down list Other grouping types available can be seen in the drop down e Click the browse button folder icon next to the Record Definition File drop down list e Inthe Open RDF File dialog box browse for the sample RDF The sample RDFs are located in the Grouper s installation folder in a sub folder called sample _ rdf e 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 e Click the browse button folder icon to the right of the Input File field e Inthe Open Input File dialog box browse to and select the downloaded sample input file e Ensure that the Input data has headings box is checked e Click the browse button folder icon next to the Output File field e Inthe Save Output File dialog box browse to the folder containing the input file and type
23. cords and for single admitted patient care APC multi episode spells is to use the Single Spell Grouper available from the Tools menu To get an initial appreciation of grouping you are recommended to experiment with the Single Spell Grouper functionality Record Definition File RDF The RDF tells the grouper the structure of the data you want it to process The field content of the RDF must include all mandatory input fields 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 Using the Record Definition File Wizard to Create a Custom RDF e Select Open RDF Editor from the Tools menu e Select the required Database the type of input file with which the RDF will be used e You can choose to Create manually which uses the RDF Editor discussed in the following section or Create from file which uses an input data file to base the RDF on e Select Create from file click the browse button folder icon and in the Open CSV File dialog box browse to and select your input data file and click Proceed Page 6 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 ele ie lille New RDF 01 x Full path and name of rdf after save Database Create manually
24. csv Contains a row for each input record that contains errors lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number Error Message A variable number of fields consisting of Code Type Code and Error Message separated by pipe symbols na me _quality_rel csv All error messages in relational form 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 Gods The code that failed validation Blank if code missing from input data Error Message Description of the error na me _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 ACC Period Count The number of records submitted ACC Period Error Count The number of records having errors Page 30 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Run Start Date Time Description The date and time that the grouping session started Run End Date Time The date and time that the grouping session finished Input Filename
25. d filename of the Record Definition File used for grouping na me _report csv An aggregated report file This file is produced by Reference Costs Groupers only Type Contains the value PCC Provider The PROCEDET input field HRG The PCC_HRG TretSpef Blank ClassPat Blank AdmiMeth Blank TrimPoint Blank CC Days Always 1 for single day PCC records Adj Mean LOS Blank Inlier Beddays Blank Excess Beddays Blank Count The count of records Neonatal Critical Care NCC There are seven output files File Name Field Name Description name csv A list of other output files name _sort csv A copy of the input data after it has been sorted Page 32 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name lt input data gt Description All of the input data including any non mandatory fields RowNo Generated row number of the record after sorting na me _ncc csv The main grouped output file lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number NCC_HRG The unbundled HRG for the Neonatal Critical Care day na me _quality csv Contains one row for each record that contains errors lt input data gt Al
26. e 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 Page 35 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 OPCS Y841 UZ05 Invalid procedure for Casemix grouping purposes in OPER 02 OPCS W450 UZ05 Invalid procedure for Casemix grouping purposes in OPER 02 Y841 Gas and air analgesia in labour W540 Conversion from previous prosthetic replacement of articulation of bone NEC UZ06 Poorly coded procedure for Casemix grouping purposes 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 for Casemix grouping purposes in OPER 02 OPCS U019 UZ06 Poorly coded procedure for Casemix grouping purposes 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 This is a general purpose grouping error for Paediatric Critical Care generated when the input record does not meet any of
27. e 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 The grouping method used for the episode P Procedure GroupingMethodFlag driven D Diagnosis driven M Multiple trauma G Global exception U Error DominantProcedure The dominant procedure FCE_ PBC Programme Budgeting Code for the episode The calculated episode duration This is the input Episode duration minus the number of days in the input fields CRITICALCAREDAYS REHABILITATIONDAYS and CalcEpidur SPCDAYS If the sum of these deductions is larger than the episode duration then CalcEpidur will be zero ReportingEPIDUR Reference Costs Groupers only For ordinary admissions Patient Classification 1 if CalcEpidur is zero days ReportingEPIDUR is set to one day Otherwise ReportingEPIDUR is the same as CalcEpidur Reference Costs Groupers only Ae i The trimpoint for the episode HRG Reference Costs Groupers only FCEExcessBeddays The number of days by which CalcEpidur exceeds the trimpoint SpellReportFlag Populated with 1 if the episode contains the grouping variable used for deriving the spell HRG Dominant Episode or 0 for other episodes in the spell Reference Costs Groupers only p
28. ere the first row in the file is a data row t Optional Where present stops generation of field names in the top row of the output file If this parameter is omitted then each of the output files will contain a header row Optional Where present directs the Grouper to list the available command line parameters to the hrg 1og file which may be in the Grouper s installation folder or a folder called hrg4 grouper profile E1617 in your user profile depending on how your Windows is configured 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 Page 9 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 echo off Cs cd Program Files HSCIC HRG4 2016 17 E hrg grouperc exe i C Temp data apc csv o C Temp data output csv d HRG4 sample APC rdf 1 APC h IF SERRORLEVELS NEQ 0 echo Error in command please check hrg log Pause Additional Features 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 It can be accessed from the toolbar button or by selecting Open Single Spell Processing fr
29. 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 import 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 usi
30. he order in which the fields are listed below Grouper Field Name CDS DD Field Name Notes CRITICAL CARE UNIT CCUF FUNCTION Leading zeros are significant BASIC BCSD CARDIOVASCULAR Range 0 99999 SUPPORT DAYS ADVANCED ACSD CARDIOVASCULAR Range 0 99999 SUPPORT DAYS BASIC BRSD RESPIRATORY Range 0 99999 SUPPORT DAYS ADVANCED ARSD RESPIRATORY Range 0 99999 SUPPORT DAYS RENAL SUPPORT RSD DAYS Range 0 99999 NEUROLOGICAL NSD SUPPORT DAYS Range 0 99999 DERMATOLOGICAL DSD SUPPORT DAYS Range 0 99999 LIVER SUPPORT LSD DAYS Range 0 99999 CRITICAL CARE CCL2D LEVEL 2 DAYS Range 0 99999 CRITICAL CARE f CCL3D LEVEL 3 DAYS Range 0 99999 CC Start Date CRITICAL CARE Format is YYYYMMDD e g 14 March START DATE 2015 20150314 Ge Discharge Date CRITICAL CARE Format is YYYYMMDD e g 14 March z ge_ DISCHARGE DATE 2015 20150314 Page 16 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 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 Paediatric Critical Care PCC The Grouper sorts Paediatric Critical Care data prior to grouping so that records with the sa
31. ile is produced by Reference Costs Groupers only Type Contains the value NCC Provider The PROCEDET input field HRG The NCC_HRG TretSpef Blank ClassPat Blank AdmiMeth Blank TrimPoint Blank Page 33 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description CC Days Always 1 for single day NCC records Adj Mean LOS Blank Inlier Beddays Blank Excess Beddays Blank Count The count of records Errors and Validation 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 at spell level Details of all errors are reported in the output quality file The listings in the Output Files section of this document include a description of the quality file for each of the data types processed by the Grouper The Input File Preparation section provides further information about valid values for various input fields Details of clinical c
32. int Blank Mean LOS Blank Adj Mean LOS Blank Inlier Beddays Blank Excess Beddays Blank Count The count of records Page 29 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 Adult Critical Care ACC Ther e are six output files File Name Field Name Description name csv A list of other output files 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 Adult Critical Care period The number of Critical Care days calculated as Calc_CC_Days 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 dates and respiratory support days fields Failure does not prevent HRG derivation Blank indicates passing validation F indicates date validation failure applied if any of the following are true Calc_CC_Days 1 This indicates that CC Discharge Date is before CC Start Date or CC Start Date or CC Discharge Date is blank is not a valid date or does not match the required format CCL2 Days CCL3 Days gt Calc_CC_Days ARSD BRSD gt Calc_CC_Days ARSD BRSD gt CCL2 Days CCL3 Days na me _quality
33. ion may be requested in large print or other formats For further information www hscic gov uk 0845 300 6016 enquiries hscic gov uk Copyright 2015 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 organisations without permission Copyright 2015 Health and Social Care Information Centre All rights reserved
34. l of the input data including any non mandatory fields RowNo Matches the run generated row number Error Message A variable number of fields consisting of Code Type Code and Error Message separated by pipe symbols na me _quality_rel csv All error messages in relational form 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 Gode The code that failed validation Blank if code missing from input data Error Message Description of the error na me _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 NCC Record Count The number of records submitted NCC Record 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 for grouping An aggregated report file inamel reporesy This f
35. lag Grouping method used P Procedure driven G Global exception O Outpatient default U Error DominantProcedure The dominant procedure na me _quality_rel csv All error messages in relational form 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 code that failed validation Blank if code missing from input data Error Message Description of the error na me _flag_rel csv This file is not currently populated RowNo Iteration AttendFlag na me _ub_rel csv The 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 UnbundledHRGs The unbundled HRGs There is no significance to the output order na me _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 Page 26 of 40 Copyright 2015 Health and Social Care Infor
36. lt U Error DominantProcedure The dominant procedure AttendSSC_Ct The count of distinct SSCs produced for the attendance AttendSSC1 to AttendSSC5 Not currently populated AttendBP_Ct The count of distinct BPT flags produced for the attendance AttendBP1 to AttendBP5 Not currently populated AttendFlag_Ct The count of distinct other flags produced for the attendance Page 25 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description AttendFlag1 to AttendFlag5 Not currently populated 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 a row for each attendance that contains errors lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number Error Message 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 GroupingMethodF
37. mation Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description 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 for grouping na me _report csv An aggregated report file This file is produced by Reference Costs Groupers only Contains one of two values NAC Attendance aggregates ype NAC U Unbundled HRG aggregates Provider Blank HRG The NAC_HRG or UB_HRG output fields as appropriate for the Type TretSpef The TRETSPEF input field ClassPat Blank AdmiMeth Blank TrimPoint Blank Mean LOS Blank Adj Mean LOS Blank Inlier Beddays Blank Excess Beddays Blank Count The count of attendances or records Emergency Medicine EM There are six output files File Name Field Name Description na me csv A list of other output files na me _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 na me _quality csv Contains a row for each input record
38. me 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 Grouper Field Name CDS DD Field Name Notes ORGANISATION A value must be supplied but is not validated For NHS organisations use PROPHET CODE CODE OF the first 3 characters for non NHS PROVIDER oe organisations use all 5 characters This and the provider field are the key CCLocallD a A EES that keeps records for the same patient together They must be supplied CCDate ACTIVITY DATE Format is YYYYMMDD e g 14 March CRITICAL CARE 2014 20140314 DISDATE CRITICAL CARE Format is YYYYMMDD e g 14 March DISCHARGE DATE 2014 20140314 DISCHARGE METHOD CODE DISMETH HOSPITAL PROVIDER SPELL CRITICAL CARE UNIT BEEE CCUF FUNCTION Leading zeros are significant Valid CCAC code from list in Paediatric CCAC 01 CRITICAL CARE Critical Care Minimum Dataset PCC ACTIVITY CODE MDS If this field is blank an error will be generated CRITICAL CARE CCAC_02 CCAC_20 ACTIVITY CODE May be blank OPER_01 OPER_20 HIGH COST DRUGS OPCS Valid OPCS 4 codes or blank The PCC MDS specifies two appropriate procedure codes only DIAG_01 DIAG_99 PRIMARY DIAGNOSIS ICD and S
39. ng 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 Iteration Field Iteration appears in some relational output files where 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 Admitted Patient Care APC There are thirteen output files File Name Field Name Description name csv A list of all the other output files Page 19 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description name _sort csv A copy of the input data after 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 Th
40. oding 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 separated by a pipe character Code Type Code Error Message 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 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 Page 34 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 OPCS C992 Code not recognised in OPER 02 Spell Validation Errors result from cross checks across records in a spell For example where consistency checks for sex or age fail SEX Not the same in all episodes in the spell AGE Falls in FCEs in this Spell Clinical Coding Errors are mainly due to the use of clinical codes that violate clinical coding convention or are not useful resource indicators fo
41. oe A count of derived SSCs at episode level FCESSC1 to Reference Costs Groupers only FCESSC7 SSCs derived at episode level 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 Page 20 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description 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 Reference Costs Groupers only The total of the ReportingEPIDUR fields for the episodes in the spell SpellTrimpoint Reference Costs Groupers only The trimpoint for the spell HRG SpellExcessBeddays Reference Costs Groupers only The number of days by which the SpellLOS exceeds the trimpoint SpellCCDays The number of critical care days in the spell SpellPBC Programme Budgeting Code for the spell Variable number of fields containing unbundled HRGs episode level There is no significance to
42. om the Tools menu Ca ied le le Single Spell 01 x Database C Program Files HSCIC HRG4 2016 17 E sample_rdf HRG4 _sample_APC rc Y v Output Record 01 Copy Content Record Definition File v Input Record 01 Field Value EPIORDER 1 1 STARTAGE 25 Delete Description Field Value Description FCE_HRG UZ01Z Data Invalid for Grouping SEX 1 CLASSPAT 1 ADMISORC 19 ADMIMETH 11 DISDEST 19 DISMETH 1 EPIDUR 0 MAINSPEF 300 NEOCARE 8 TRETSPEF 300 DIAG_02 Male Ordinary admission Usual place of residence Waiting list Usual place of residence Patient discharged on clinical advice or wit GENERAL MEDICINE Not Applicable GENERAL MEDICINE GroupingMet U DominantPro FCE_PBC PBCO2U1 CalcEpidur 0 ReportingEPI FCETrimpoint i FCEExcessBe SpellReportFlag 1 UnbundledH Error Primary diagnosis not recognised v Output Spell UZ01Z SpellGroupin U SneliDamina Copy Content Data Invalid for Grouping gt Spell Processing Message Log SpellHRG UZ01Z Data Invalid for Grouping 1617 E 8 Once a Database and Record Definition File have been selected you can Add Record For Admitted Patient Care it is possible to build up a spell consisting of multiple episodes by adding further records Page 10 of 40 Copyright 2015 Health and Social Care Information
43. output _apc_sample or anything similarly appropriate in the File name box e Click Save The path and filename of the output file are displayed in the Output File field e Ensure that the Add headings to output data box is checked Page 4 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 e Click the Process button e When finished the log display area shows information about the grouping session including the number of records grouped These details can also be found in the file hrg log Depending on how Windows is configured on your machine this may be in the Grouper s installation folder or a folder called hrg4 grouper profile RC1415 in your user profile File Tools Window Help aa laa lle IE File Batch Processing Aw Database _ Admitted Patient Care APC E1617 Record Definition File C Program Files HSCIC HRG4 le_rdf HRG4 _sample_APC rdf Input File C Temp data HRG4_Admitted_Patient_Care_Sample_Test_Data W Input data has headings Output File C Temp data output_apc_sample csv W Add headings to output data Progress Error Ratio Processing Message Log csv J 12 08 2015 15 01 22 Batch 01 starting file prepare Input file C Temp data HRG4_Admitted_Patient_Care_Sample_Test_Data csv output file C Temp data output_apc_sample_sort csv 12 08 2015 15 01 23
44. 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 Admitted Patient Care APC The Grouper sorts APC data prior to processing so that records with the same Provider Code and Provider Spell Number are placed in Episode Number 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 A value must be supplied but is not PROCODET CODE CODE OF validated For NHS organisations use PROVIDER the first 3 characters for non NHS organisations use all 5 characters A value must be supplied but is not HOSPITAL PROVIDER validated PROVSPNO SPELL NUMBER It is possible to use an alternative spell or alternative identifier as PROVSPNO in place of the Hospital Provider Spell Number EPIORDER EPISODE NUMBER ati within a spell will create an Whole years rounded down START STARTAGE Derived DATE EPISODE PERSON BIRTH DATE SEX PERSON GENDER Must be the same for all episodes ina CODE CURRENT spell PATIENT CLASSPAT CLASSIFICATION Must be the same for all episodes in a CODE spell SOURCE OF ADMISSION CODE Must be the same for all episodes in a ao HOSPITAL spell P
45. r HRG grouping 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 2509 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 only applies to specific musculoskeletal codes entered at 5th digit level ICD M7217 UZ04 Diagnosis Conflicts with Anatomical Site in DIAG 01 M7217 Knuckle pads Ankle and foot UZ05 Invalid procedure for Casemix grouping purposes Indicates invalid dominant procedur
46. rmat is YYYYMMDD e g 14 March DISCHARGE DATE 2014 20140314 CRITICAL CARE UNIT wt CCUF FUNCTION Leading zeros are significant Whole days rounded down ACTIVITY AGE_DAYS Derived DATE CRITICAL CARE PERSON BIRTH DATE DISCHARGE METHOD CODE DISMETI HOSPITAL PROVIDER SPELL Gestlen GESTATION LENGTH AT DELIVERY Kilograms to 3 decimal places PERWT PERSON WEIGHT Range greater than zero kg and less than 10 kg Leading zeroes are accepted Valid CCAC code from list in Neonatal CCAC_01 pe appa ie Critical Care Minimum Dataset If this ACTIVITY CODE ne field is blank an error will be generated CRITICAL CARE CCAC_02 CCAC_20 ACTIVITY CODE May be blank 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 Page 18 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 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
47. st Practice Tariff codes are suppressed if the spell HRG is UZ01Z In Admitted Patient Care data the primary diagnosis is always validated All clinical codes are validated against the Grouper s internal database of codes Page 37 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 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 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 including worked examples of each one grouping logic and useful links to further information The Grouper User 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 Chapter Summaries document provides an overview of the scope composition and relevant grouping logic of individual subchapters along with the design concepts incorporated
48. st to the 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 the RDF can be saved by selecting the appropriate option from the File menu Record Definition File Editor Choosing to Create Manually or selecting Open RDF from the File menu presents a different view of a record definition file Page 7 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Edit Tools Window Help Hea lee la le New RDF 01 X Database Full path and name of rdf after save Ad tted Patient Care APC E161 Create manually Create from file Clear Field Name Field Title Field No Picture Extract l PROCODET PROVSPNO EPIORDER STARTAGE SEX CLASSPAT ADMISORC ADMIMETH DISDEST DISMETH EPIDUR MAINSPEF NEOCARE TRETSPEF DIAG_01 DIAG_02 DIAG_03 DIAG_04 DIAG_05 DIAG_06 OrgCode SpellID EpiOrder Age Sex PatClass AdmiSource AdmiMethod DisDest DisMeth EpiDur MSC
49. that contains errors lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number Error Message A variable number of fields consisting of Code Type Code and Error Message separated by pipe symbols na me _quality_rel csv All error messages in relational form RowNo Matches the run generated row number Iteration The ordinal number of the quality message Page 27 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Code Type Description The type of code that has failed validation Code The 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 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
50. uite N O O Q oouo Q 10 10 11 11 12 13 14 15 16 17 18 19 19 25 27 28 30 31 32 34 38 Page 2 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 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 Download and Install the Grouper Go to www hscic gov uk casemix downloads Click on Payment There may be more than one version available Older versions are on the archive pages Click on the Grouper application link in the Download section at the right of the screen Save the Zip file to an appropriate location on your computer Open the Zip file and extract the installer Double click the installer file and follow the installation setup wizard Walkthrough Using Sample Data The following walkthrough describes processing a sample Admitted Patient Care APC input file available from the Casemix website Download the HRG4 Admitted Patient Care Sample Test Data file from this page http www hscic gov uk casemix general Open the Grouper application Page 3 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 I File Batch Processing Bat
51. uper 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 VIRUS STATUS RENAL CARE Grouper Field Name DD Field Name Notes RENAL TREATMENT ee RENALMOD MODALITY CODE Leading zeros are significant RENAL TREATMENT RENALSITE PRIMARY Leading zeros are significant SUPERVISION CODE RENAL DIALYSIS So ec RENALACCESS AGCESS TYPE Leading zeros are significant HEPATITIS B Must be UPPER CASE HBV ANTIGEN STATUS Accepted values are NEG POS and RENAL CARE UNK HEPATITIS C Must be UPPER CASE HCV ANTIBODY STATUS Accepted values are NEG POS and RENAL CARE UNK HUMAN Must be UPPER CASE HIV Doe ENGY Accepted values are NEG POS and UNK Page 15 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 Grouper Field Name DD Field Name Notes The age of the patient in whole years at AGE Derived the start date of the session Range 0 130 Each row of the input file represents either one haemodialysis session or one day of peritoneal dialysis Adult Critical Care ACC 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 t
52. us there are records in the quality file that do not include error messages lt input data gt All of the input data including any non mandatory fields RowNo Matches the run generated row number Error Message 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 The grouping method used for the episode P Procedure GroupingMethodFlag driven D Diagnosis driven M Multiple trauma G Global exception U Error DominantProcedure The dominant procedure FCE_PBC Programme Budgeting Code for the episode Page 22 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 File Name Field Name Description 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 Reference Costs Groupers only For ordinary admissions Patient Classification 1 if CalcEpidur is zero days ReportingEPIDUR is set to one day Otherwise ReportingEPIDUR is the same as CalcEpidur Reference Costs Groupers only Pee Timpe The trimpoint for the episode HRG Referen
53. y 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 Whole years rounded down ARRIVAL GROUP AGE Derived DATE PERSON BIRTH DATE Validated but not used in grouping AEPATIENTGROUP AANDEPATIENT May be blank Page 14 of 40 Copyright 2015 Health and Social Care Information Centre All rights reserved HRG4 2016 17 Engagement Grouper User Manual v1 0 Grouper Field Name CDS DD Field Name Notes ACCIDENT AND EMERGENCY Valid national code component always INVESTIGATION 2 characters or blank FIRST The Local Sub Analysis part should INV_01 INV_99 and not be submitted ACCIDENT AND Leading zeroes must be included EMERGENCY where they form part of the national INVESTIGATION code component SECOND ATAT Valid national code component 2 or 3 EMERGENCY characters or blank TREATMENT FIRST j a and The Local Sub Analysis part should TREAT_01 TREAT_99 ACCIDENT AND not be submitted Leading zeroes must be included EE where they form part of the national LONS ode ee a SECOND pone Each row of the input file represents one Accident and Emergency Attendance Renal Dialysis NRD Renal Dialysis HRGs are generated using fields from the National Renal Dataset The field list below shows the fields required by the Gro
54. ype Code and Error Message separated by pipe symbols na me _quality_rel csv All error messages in relational form 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 Goede The code that failed validation Blank if code missing from input data Error Message Description of the error na me _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 NRD Record Count The number of records submitted NRD Record 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 for grouping na me _report csv An aggregated report file This file is produced by Reference Costs Groupers only Type Contains the value NRD Provider Blank HRG The NRD_HRG TretSpef Blank ClassPat Blank AdmiMeth Blank TrimPo

HRG4+ 2016/17 Engagement Grouper

Contents

Download Pdf Manuals

Related Search

Related Contents