{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Front Sheet","Version Control","Monthly Data Measures","MHMDS v4.1 derivations","Glossary"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":29,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Front Sheet","index":0,"n_rows":47,"n_cols":2,"rows_kept":47,"cut":false,"hidden":false,"merged":[[32,1,32,3],[27,1,27,3],[29,1,29,3],[31,1,31,3],[24,1,24,3],[26,1,26,3],[28,1,28,3],[30,1,30,3],[47,1,47,7],[49,1,49,7],[51,1,51,7],[17,1,17,6],[19,1,19,6],[46,1,46,6],[18,1,18,3],[36,1,36,3],[38,1,38,6],[40,1,40,7],[42,1,42,7],[44,1,44,7],[20,1,20,3],[21,1,21,3],[23,1,23,3],[25,1,25,3],[16,1,16,3],[0,1,0,2],[2,1,2,5],[4,1,4,4],[6,1,6,6],[8,1,8,6],[10,1,10,6],[12,1,12,6],[14,1,14,6],[11,1,11,6],[13,1,13,6],[15,1,15,6]]}
[]
[]
[null,"Monthly Mental Health Minimum Dataset (MHMDS) data file"]
[]
[]
[null,"Metadata"]
[]
[null,"Introduction"]
[null,"This document describes the content of the monthly MHMDS data file in the Monthly MHMDS Reports publication, published for the first time in September 2013 starting with information for April 2013.  The monthly data file replaces analysis previously included in the Routine Monthly MHMDS Reports.  Further information about these changes can be found in the related Methodological Change paper."]
[null,"What is the monthly MHMDS data file?"]
[null,"The monthly MHMDS data file contains 56 measures produced from analysis of providers’ monthly MHMDS submissions.  These measures include some information that was previously included in Summary Statistics and Experimental Analysis within the Routine Quarterly MHMDS Reports until Q4 2012/13, as well as new measures that show caseload and activity in NHS funded adult mental health services.  They provide the basis for local discussions between providers and commissioners about services being delivered to patients.  Basic measures underpinning seven Payment by Results Quality and Outcome measures recommended for use in 2013/14 are also included to promote understanding of how these are constructed."]
[null,"The measures are presented at provider/Clinical Commissioning Group (CCG) level to show where patients who fall within each CCG are receiving services and the volume of activity for each pair of organisations.  The unit of measurement for the majority of measures is a service user’s open spell of care in adult Mental Health services ‘as at’ the end of the month .  These measures are effectively a count of open caseload, categorised by the type of service being received at the end of the month.  The file also includes a set of ‘in month’ activity counts, showing the volume of services provided within the month.  Taken as a whole these measures provide the building blocks of information to help stakeholders understand what services are being delivered and to whom.  "]
[null,"Some of the measures can be combined to calculated percentages which could be used for making comparisons at various levels, such as by provider, by CCG, or by other aggregated health geographies.  However, the data are not presented as official indicators; these will be released through separate publications (e.g. the CCG Outcomes Indicator Set)."]
[null,"All the measures can be produced from analysis of the monthly extracts supplied to providers and commissioners with access to the Bureau Service on the Open Exeter system. All except 6 of the measures can be produced from a single month’s submissions.  "]
[null,"What is included in the metadata file?"]
[null,"The document provides for each field in the monthly MHMDS file:\n\n• A reference number, name and description (data items in the NHS Data Dictionary are underlined for reference) for each measure and whether it is included in the Executive Summary national totals; \n• The name of the data item in the monthly file;\n• Cross references to data derivations used in the analysis;\n• A construction describing the logic used in the analysis, referencing data items in providers’ and commissioners’ record level MHMDS data extracts and any derivations produced by the Health and Social Care Information Centre (HSCIC) used in the analysis;\n• Descriptions of the derivations produced by the HSCIC to make the production of these measures more efficient, so that users of record level monthly MHMDS data can apply the same logic to their analysis;\n• Further notes to describe the status and uses of the measure and whether it is a new or existing measure (further details on changes in methodology can be found in the Methodological Change Paper);\n• A glossary of abbreviations, special terms and acronyms. \n"]
[null,"Who is it intended for and how will it be used?"]
[null,"The primary use of this metadata is to provide clear descriptions of the measures presented in this file, which can be understood by key stakeholders.  This information should be used in combination advice on assessing the reliability of individual measures, which is provided in the Background Quality Report.\nThe metadata will also help people with access to record level MHMDS extracts from the Bureau Service who wish to reproduce these measures from record level monthly MHMDS.\nWe welcome feedback on how this document and any suggestions for changes.\n"]
[null,"Useful Links"]
[null,"• More about Monthly MHMDS Reports, including the Background Quality Report    \n"]
[null,"http://www.hscic.gov.uk/mhmdsmonthly"]
[null,"• Methodological Change Paper for Routine Quarterly MHMDS Reports      "]
[null,"http://www.hscic.gov.uk/media/12484/Monthly-Mental-Health-Minimum-Dataset-Reports/pdf/MethChange201307_MonthlyMHMDS.pdf"]
[null,"• MHMDS version 4.1 Data Specification and User Guidance  "]
[null,"http://www.hscic.gov.uk/mhmds/spec"]
[null,"• NHS Data Dictionary: MHMDS "]
[null,"http://www.datadictionary.nhs.uk/data_dictionary/messages/clinical_data_sets/data_sets/mental_health_minimum_data_set_(version%204-1)_fr.asp?shownav=1"]
[null,"• MHMDS monthly submission deadlines   "]
[null," http://www.hscic.gov.uk/mhmds/submissiontimetable"]
[null,"• Codes for NHS organisations   "]
[null,"http://systems.hscic.gov.uk/data/ods/datadownloads"]
[null,"• Mental health PbR: guidance for 2013 to 2014 "]
[null,"https://www.gov.uk/government/publications/mental-health-payment-by-results-arrangements-for-2013-14"]
[]
[]
[]
[null,"ISBN: 978-1-84-636935-3 "]
[]
[null,"www.hscic.gov.uk/mhmdsmonthly "]
[]
[null,"Responsible Statistician\nTony Childs\n\nThe Contact Centre\nHealth and Social Care Information Centre\n1 Trevelyan Square\nBoar Lane\nLeeds\nWest Yorkshire  \nLS1 6AE\n\nTelephone: 0845 300 6016\nEmail:enquiries@hscic.gov.uk\n\nPress enquiries should be made to:\nMedia Relations Manager:\nTelephone: 0845 300 6016 \nEmail: enquiries@hscic.gov.uk"]
[null,"enquiries@hscic.gov.uk"]
[null,"Data source: Mental Health Minimum Dataset (MHMDS) monthly data"]
[]
[null,"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.This work is subject to the Re-Use of Public Sector Information Regulations and permission for commercial use must be obtained from the copyright holder.Copyright © 2014, The Health and Social Care Information Centre. All rights reserved."]
[]
[null,"Data source: Monthly Mental Health Minimum Dataset (MHMDS), version 4.1\n(‘Monthly MHMDS’ is a different product to ‘Cumulative, year to date MHMDS’;  the latter is the data source for standard data extracts via the HSCIC Data Extract and Linkage service, annual statistics and other less frequent statistical releases.)\n"]

{"sheet":"Version Control","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,0,4,0],[3,1,4,1],[3,2,4,2]]}
["Mental Health Minimum Dataset (MHMDS)"]
["Metadata file Version History"]
[]
["Version","Date Issued","Summary Of Changes"]
[]
["1.0","03/09/2013","Introduction of the MHMDS metadata file"]
[1.1000000000000001,"2014-01-15","Descriptions of mm15 and mm18 amended to reference mm03 as denominator."]

{"sheet":"Monthly Data Measures","index":2,"n_rows":71,"n_cols":8,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,1,0,2],[5,0,5,7],[27,0,27,7],[69,0,69,6]]}
[null,"Name and where used"]
["Monthly measure reference number ","Executive Summary (National)","Monthly CSV data file (Provider/CCG)","Monthly data file field name","IC derivation reference number","Description of measure\n(where possible measures are described in terms of the classes of information defined in NHS Data Dictionary)","Construction","Notes"]
[null,null,"Month","Reporting Period","-","The Reporting month"]
[null,null,"CCG Code","CCG Code","RC01","The CCG used is the CCG of GP practice or, if GP practice was not recorded, the CCG derived from the patient’s postcode.  ","IC_Rec_CCG","Commissioner extracts from the Bureau Service are filtered by ‘Org Code of Commissioner’, not by the field 'CCG of GP Practice'. The commissioner recorded in an MHMDS record may not be a CCG so there may be differences between analysis of commissioner extracts and analysis by CCG in this file, depending on how the provider recorded the Org Code of Commissioner."]
[null,null,"Provider Code","Provider Code","-","Code of  Service Provider"]
["End of month counts of people"]
["mm01","People in contact with services","People in contact with services at the end of the Reporting Period","People in contact with services","HE01","People with an open Adult Mental Health Care Spell in NHS funded adult specialist mental health services at the end of the Reporting Period (RP)","Count of MHD_MHMDS_Record_Number where MHD_End_Date_MHCS is NULL","New experimental measure – denominator measure for recommended Payment by Results Quality and Outcome indicator [The accommodation status of all users;  The completeness of ethnicity recording; The proportion of users in each cluster who are on CPA]. This is provided to promote understanding of how the basic measures will be produced but the final indicators are likely to be restricted to patients assigned to specific clusters, not all patients on the caseload.  Whilst the method for this measure has been confirmed, it  has not been published before and local knowledge may be required to assess accuracy. In respect of coverage it should be treated as experimental analysis.  "]
["mm02",null,"People on CPA  at the end of the RP period","People on CPA","RC04","People with an open Care Programme Approach Episode at the end of the RP ","Count of distinct MHD_MHMDS_Record_Number where IC_Rec_endRP_CPA_Flag = 'Y'","New experimental measure – numerator measure for recommended Payment by Results Quality and Outcome indicator [The proportion of users in each cluster who are on CPA]. This is provided to promote understanding of how the basic measures will be produced but the final indicators are likely to be restricted to patients assigned to specific clusters, not all patients on the caseload.  Whilst the method for this measure has been confirmed, actual figures have not been published before and local knowledge may be required to assess accuracy. In respect of coverage it should be treated as experimental analysis.    "]
["mm03",null,"People on CPA aged 18-69  at the end of the RP","People on CPA aged 18-69","RC04","People aged 18-69 with an open Care Programme Approach Episode at the end of the RP ","Count of distinct MHD_MHMDS_Record_Number where IC_Rec_endRP_CPA_Flag = 'Y' and\nMHD_Age_Start_Reporting_Period >=18 and MHD_Age_Start_Reporting_Period <= 69 ","Denominator for indicators 1 and 2 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method."]
["mm04",null,"People on CPA at the end of the RP with HoNOS recorded ","People on CPA with HoNOS recorded","RC07, RC46, EV03","People with an open Care Programme Approach Episode at the end of the RP  who had Health of the Nation Outcomes Score (HoNOS) or HoNOS 65+ or HoNOS (Children and Adolescents) or HoNOS (SECURE) or MENTAL HEALTH CLUSTERING TOOL\n recorded within the previous 12 months","Count of distinct MHD_MHMDS_Record_Number where IC_Rec_endRP_CPA_Flag = 'Y' and IC_Rec_endRP_HONOS_Assessment_within_12mnths = 'Y' and\nMHD_End_Date_MHCS is null\n","Numerator for indicator 4 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method.  "]
["mm05",null,"People on CPA for 12 months at the end of the RP","People on CPA for 12 months","RC46","People with an open Care Programme Approach Episode at the end of the RP that started at least 12 months earlier.","Sum of IC_Rec_EndRP_CPA_Epi_12_Months","Denominator for indicator 5 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method."]
["mm06",null,"People on CPA for 12 months with review at the end of the RP","People on CPA for 12 months with review","RC05","People with an open Care Programme Approach Episode at the end of the RP that started at least 12 months earlier,  who have had a Care Programme Approach Review within the previous 12 months.","Count of distinct MHD_MHMDS_Record_Number where\nIC_Rec_EndRP_CPA_Epi_12_Months='Y' and IC_Rec_endRP_CPA_Review_within_12mnths='Y'","Numerator for indicator 5 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method."]
["mm07","People with an open hospital spell","People with an open hospital spell","People with an open hospital spell","RC48","People with an open Hospital Provider Spell at the end of the RP.  This may include people on leave.","Count of distinct  MHD_MHMDS_Record_Number  where IC_Rec_endRP_Hospital_Spell_Flag = 'Y'","New measure"]
["mm08",null,"People subject to the Mental Health Act at the end of the RP","People subject to the Mental Health Act","RC49","The number of people in NHS funded specialist adult mental health services at the end of the RP who were subject to the Mental Health Act.  This number includes people in these discrete categories (on a single day a person can only be in one category): people subject to detention (see mm09) people subject to CTO (see mm10), as well as people subject to short term holding powers under sections 4, 5(2), 5(4), 135 or 136 and people subject to Guardianship but not on a CTO.","Count of distinct MHD_MHMDS_Record_Number where\n(( IC_Rec_endRP_MHA_Flag='Y' and ic_rec_endRp_Hospital_spell_flag='Y' and \nIC_Rec_endRP_LegalStat_Cleansed IN ('02','03','07','08','09','10','12','13','14','15','16','17','18','21','32','34')\nand IC_Rec_endRP_SCT_Flag<>'Y' and IC_Rec_endRP_Recall_Flag<>'Y'))  OR\n( (IC_Rec_endRP_SCT_Flag='Y' or IC_Rec_endRP_Recall_Flag='Y' ) ) OR \n( IC_Rec_endRP_MHA_Flag='Y' and IC_Rec_endRP_LegalStat_Cleansed IN ('04','05','06','19','20')\nand IC_Rec_endRP_SCT_Flag<>'Y' and IC_Rec_endRP_Recall_Flag<>'Y'  )  OR\n( IC_Rec_endRP_MHA_Flag='Y' and IC_Rec_endRP_LegalStat_Cleansed IN ('35','36')\nand IC_Rec_endRP_SCT_Flag<>'Y' and IC_Rec_endRP_Recall_Flag<>'Y' ) ","New experimental measure - The method for producing this analysis from MHMDS has been confirmed, but the measure has not been published before and local knowledge may be required to assess its accuracy . It is therefore considered experimental analysis.  \n\nThis figure replicates the sum of 'People subject to CTO' and 'People subject to detention' in Table 8 of the National Statistic (NS) publication currently produced from KP90 collection."]
["mm09","People subject to detention at the end of the RP",null,"n/a","RC08, RC10, RC11, RC48, RC49","People detained in hospital under a civil or criminal justice section, including sections 2,3, 35, 36, 37 (with or without restrictions), 38, 44, 46, 47 and 48 (with or without restrictions), 45A or Formally detained under Criminal Proceedings Act 1964 or under other Acts at the end of the RP.  These patients must also have an open hospital spell or ward stay at end of RP","Count of distinct  MHD_MHMDS_Record_Number where \nIC_Rec_endRP_MHA_Flag='Y' and IC_Rec_endRP_Hospital_spell_flag='Y' and \nIC_Rec_endRP_LegalStat_Cleansed IN ('02','03','07','08','09','10','12','13','14','15','16','17','18','21','32','34')\nand IC_Rec_endRP_SCT_Flag<>'Y' and IC_Rec_endRP_Recall_Flag<>'Y' )","New experimental measure - this measure partially replicates the National Statistic (NS) measure [People subject to detention] currently produced from KP90 collection [Reference table 8 in the annual publication].  It does not include 'people subject to short term holding powers', however, which may be presented as a separate line in future NS publications. The method for producing this analysis from MHMDS has been confirmed, but the measure has not been published before and it is therefore considered experimental analysis  "]
["mm10","People subject to CTO at the end of the RP",null,"n/a","RC10, RC11","People in contact with NHS funded adult secondary mental health services who are subject to the Community Treatment Order at the end of the RP","Count of distinct  MHD_MHMDS_Record_Number where \nIC_Rec_endRP_Recall_Flag='Y'  or IC_Rec_endRP_SCT_Flag='Y'","New experimental measure - this measure replicates the National Statistic measure [People subject to CTO at 31 March] currently produced from KP90 collection [Reference table 8 in the annual publication]. The method for producing this analysis from MHMDS has been confirmed, but the measure has not been published before and it is therefore considered experimental analysis  "]
["mm11",null,"People being treated by Early Intervention teams at the end of the RP","People being treated by Early Intervention Teams","RC47","People with an open Team Episode at the end of the RP,  where the team is an Early Intervention team.","Count of distinct  MHD_MHMDS_Record_Number where IC_Rec_endRP_EIT_Flag ='Y'","Measure from Experimental Analysis Line 2 previously published as part of Routine Quarterly MHMDS Reports.  This measure is still considered experimental and is subject to further refinement."]
["mm12",null,"People being treated by Assertive Outreach teams at the end of the RP","People being treated by Assertive Outreach Teams","RC44","People with an open Team Episode at the end of the RP,  where the team is an Assertive Outreach team.","Count of distinct  MHD_MHMDS_Record_Number where IC_Rec_endRP_AOT_Flag='Y'","Measure from Experimental Analysis Line 3 previously published as part of Routine Quarterly MHMDS Reports.  This measure is still considered experimental and is subject to further refinement."]
["mm13",null,"People in contact with NHS funded adults secondary mental health services at the end of the RP with accommodation status recorded. ","People with accommodation status recorded","RC12","People with an open Adult Mental Health Care Spell at the end of the Reporting Period (RP) who had Accommodation Status recorded in the previous 12 months.","Count of distinct MHD_MHMDS_Record_Number where IC_Rec_endRP_Settled_Accommodation_Indicator  is not null","New experimental measure – numerator measure for recommended Payment by Results Quality and Outcome indicator [The accommodation status of all users]. This is provided to promote understanding of how the basic measures will be produced but the final indicators are likely to be restricted to patients assigned to specific clusters, not all patients on the caseload.  Whilst the method for this measure has been confirmed, actual figures have not been published before and local knowledge may be required to assess accuracy. In respect of coverage it should be treated as experimental analysis.    "]
["mm14",null,"People aged 18-69 on CPA at the end of the RP in settled accommodation","People aged 18-69 on CPA in settled accommodation","RC04, RC12, EV03","People aged 18-69 with an open Care Programme Approach Episode at the end of the RP  whose most recent record of Accommodation Status in the previous  12 months showed they were in settled accommodation. ","Count of distinct MHD_MHMDS_Record_Number where IC_Rec_endRP_CPA_Flag='Y' and MHD_Age_Start_Reporting_Period >=18 and MHD_Age_Start_Reporting_Period <=  69 and\n(IC_Rec_endRP_Settled_Accommodation_Indicator = '1' OR\nIC_Rec_endRP_Settled_Accommodation_Indicator = '01' ) ","Numerator for indicator 1 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method."]
["mm15","Proportion of people aged 18-69 on CPA in settled accommodation",null,null,null,"Divide mm14 by mm03 and show as a percentage",null,"Indicator 1 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method.  Organisation level percentage values can be calculated from mm14 and mm03."]
["mm16",null,"People with employment status recorded at the end of the RP","People with employment recorded","EV03, RC06","People with an open Adult Mental Health Care Spell at the end of the Reporting Period (RP) who had Employment Status recorded in the previous 12 months.","Count of distinct MHD_MHMDS_Record_Number where \nIC_Rec_endRP_Employment_Status  is not null","New measure"]
["mm17",null,"People aged 18-69 on CPA at the end of the RP in employment.","People aged 18-69 on CPA in employement","RC04, RC06, EV03","People aged 18-69 with an open Care Programme Approach Episode at the end of the RP  whose most recent record of Employment Status in the previous  12 months showed they were employed. ","Count of distinct MHD_MHMDS_Record_Number where IC_Rec_endRP_CPA_Flag ='Y' and MHD_Age_End_Reporting_Period >=18 and MHD_Age_End_Reporting_Period< =69  and (IC_Rec_endRP_Employment_Status = '1' OR\nIC_Rec_endRP_Employment_Status = '01')","Numerator for indicator 2 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method."]
["mm18","Proportion of people aged 18-69 on CPA in employment",null,null,null,"Divide mm17 by mm03 and show as a percentage",null,"Indicator 2 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method.  Organisation level percentage values can be calculated from mm17 and mm03. There are currently no exclusions for patients who are detained or in High Secure services and this should be borned in mind if calculating provider level percentages for comparison purposes as such patients should potentially be excluded."]
["mm19",null,"People with a crisis plan in place at the end of the RP","People with a crisis plan in place","-","People with an open Adult Mental Health Care Spell at the end of the RP for whom a record of an open Mental Health Crisis Plan was submitted in the month.","Count of distinct  MHD_MHMDS_Record_Number where MHD_CrisisPlanCreat_Date is not null","New experimental measure – numerator measure for recommended Payment by Results Quality and Outcome indicator [The proportion of users on CPA with a crisis plan in place]. This is provided to promote understanding of how the basic measures will be produced but the final indicators are likely to be restricted to patients assigned to specific clusters, not all patients on the caseload.  Whilst the method for this measure has been confirmed, actual figures have not been published before and local knowledge may be required to assess accuracy. In respect of coverage it should be treated as experimental analysis.   "]
["mm20",null,"People in contact with services at the end of the RP  with a diagnosis recorded","People with a diagnosis recorded","RC09","People with an open Adult Mental Health Care Spell at the end of the Reporting Period (RP) who had Primary Diagnosis recorded in the previous 12 months.","Count of distinct  MHD_MHMDS_Record_Number where IC_Rec_endRP_PDIAG_Flag is not null","New experimental measure – numerator measure for recommended Payment by Results Quality and Outcome indicator [The proportion of users who have a valid ICD10 recorded]. This is provided to promote understanding of how the basic measures will be produced but the final indicators are likely to be restricted to patients assigned to specific clusters, not all patients on the caseload.  Whilst the method for this measure has been confirmed, actual figures have not been published before and local knowledge may be required to assess accuracy. In respect of coverage it should be treated as experimental analysis.    "]
["mm21",null,"People assigned to cluster at the end of the RP","People assigned to a cluster","RC03","People with an open Mental Health Care Cluster Assignment Period at the end of the RP. ","Count of distinct  MHD_MHMDS_Record_Number where \nIC_Rec_End_RP_Cluster_Flag ='Y'","Measure from Experimental Analysis Line 4 previously published as part of Routine Quarterly MHMDS Reports.  This measure is still considered experimental and is subject to further refinement."]
["In month activity counts"]
["mm22",null,"Adult Mental Health Spell days in RP","Spell Days","RC54","The total number of days in  Adult Mental Health Care Spells in the RP based on the start and end dates of the  Adult Mental Health Care Spell and the start and end of the RP.  Where the spell start date is before the start or the RP, the start of the reporting period is used.  Where end date is not present, the end of the RP is used. ","Sum of IC_Spell_RP_Days","New experimental measure – denominator measure for recommended Payment by Results Quality and Outcome indicator [Intensity of Care]. This is provided to promote understanding of how the basic measures will be produced but the final indicators are likely to be restricted to patients assigned to specific clusters, not all patients on the caseload.  Whilst the method for this measure has been confirmed, it  has not been published before and local knowledge may be required to assess to assess accuracy. In respect of coverage it should be treated as experimental analysis.  "]
["mm23","Spells starting","Adult Mental Health Spells starting in RP","Spells starting","-","The number of  Adult Mental Health Care Spells that started in the RP.","Count of distinct  MHD_MHMDS_Record_Number where (MHD_Start_Date_MHCS >=Start_Date and MHD_Start_Date_MHCS <=end_Date)","New measure "]
["mm24",null,"Bed days in RP","Bed days","RC41","The number of Bed Days in the RP calculated from the start and end dates of Ward Stays Within Hospital Provider Spell and the start and end dates of the RP, as mm22","Sum of IC_Rec_RP_Wrdst_Days_Gross","Measure currently produced in annual Mental Health Bulletin. This is also potentially the numerator measure for recommended Payment by Results Quality and Outcome indicator [Intensity of Care].  This is provided promote understanding of how the basic measures will be produced but the final indicators are likely to be restricted to patients assigned to specific clusters, not all patients on teh caseload.  As the numerator measure it should be treated as experimental analysis."]
["mm25",null,"Bed days less leave in RP","Bed days net leave","RC42","The number of Bed Days between the start and end date of a Wardstay episode within the reporting period and subtracts Homeleave","Sum of IC_Rec_RP_Wrdst_Days_Net","New measure"]
["mm26","Admissions to hospital ","Admissions to hospital in RP","Admissions to hospital","RC19","The number of admissions to hospital in the RP, calculated from the start dates of Hospital Provider Spells","Sum of IC_Rec_RP_Admission  ","Measure from Experimental Analysis Line 6 previously published as part of Routine Quarterly MHMDS Reports.  This measure is no longer considered experimental."]
["mm27",null,"Detentions on admission to hospital in RP","Detentions on admission to hospital","RC20","The number of detentions under the Mental Health Act (1983) on admission to hospital in the RP. Uses of short term sections and holding powers and Place of Safety Orders that coincided with the day of admission are excluded.  Detentions on day of admission includes uses of sections 2, 3, 35, 36, 37 (with or without s41 restrictions) 38,44, 46, 45A and 47 and 48 \n(with or without s49 restrictions), and detentions under previous legislation (Fifth Schedule) and other Acts","Sum of IC_Rec_RP_Admission_Formal","Measure from Experimental Analysis Line 6 previously published as part of Routine Quarterly MHMDS Reports.  This measure replicates the National Statistic measure [Detentions on admission to hospital] currently produced from KP90 collection [Reference table 1 in the annual publication] The method for producing this analysis from MHMDS has been confirmed, but the measure has not been published before and local knowledge may be required to assess its accuracy . It is therefore considered experimental analysis."]
["mm28",null,"Discharges from hospital in RP","Discharges from hospital","RC31","The number of discharges from hospital in the RP, calculated from the end dates of Hospital Provider Spells","Sum of IC_Rec_RP_Discharges_Gross","Measure currently produced in annual Mental Health Bulletin."]
["mm29",null,"Discharges from hospital, net, in RP","Discharges from hospital net","RC32","The number of inpatient discharges from hospital in the reporting period, excluding:\nThe last 7 days or\nWhere the method of discharge is null or is not 'client died'. \nThere must also be a episode of type REF that is open in the reporting period or is discharged in the  reporting period, excluding the last 7 days,  and not discharged due to transfer to another provider.\nThe date of hospital discharge must not be the same as the date of referral discharge.","Sum of IC_Rec_RP_Discharges_Net","Measure from Experimental Analysis Line 7 previously published as part of Routine Quarterly MHMDS Reports.  The methodology for calculating this measure is still under review and the measure is therefore considered experimental."]
["mm30",null,"Discharges from hospital, net, followed up within 7 days in RP","Discharges from hospital net  followed up within 7 days","RC30","The number of net discharges (mm29) that were followed up within 7 days within the same provider.","Sum of IC_Rec_RP_Disch_Net_Followup","Measure from Experimental Analysis Line 7 previously published as part of Routine Quarterly MHMDS Reports.  The methodology for calculating this measure is still under review and the measure is therefore considered experimental."]
["mm31","Proportion of discharges from hospital followed up within 7 days",null,null,null,"Divide mm29 by mm30 and show as a percentage",null,"Experimental indicator.  Organisation level percentage values can be calculated from mm29 and mm30"]
["mm32",null,"Contacts and daycare attendances in RP","Contacts and daycare attendances","RC26, RC52","The number of Health Care Professional Contacts and NHS Day Care Facility Attendances in the RP","Sum of (IC_Rec_DAYATT_Contacts + IC_Rec_RP_Contacts)","Measure currently produced in annual Mental Health Bulletin"]
["mm33",null,"Attended contacts and daycare attendances in RP","Attended contacts and daycare attendances","RC27, RC53","The number of attended Health Care Professional Contacts and NHS Day Care Facility Attendances in the RP","Sum of (IC_Rec_DAYATT_Contacts_Att + IC_Rec_RP_Contacts_Att)","Measure currently produced in annual Mental Health Bulletin"]
["mm34",null,"Days of delayed discharge in RP","Days of delayed discharge","RC29","The number of days between the start and end date of a Delayed Discharge within the RP.","Sum of IC_Rec_RP_DDisc_Days","New measure"]
["mm35",null,"MHCT assessments in RP","MHCT assessments","RC34","The number of Mental Health Clustering Tool assessments in the RP","Sum of IC_Rec_RP_MHCT_Gross","New measure"]
["mm36",null,"MHCT assessments new referral in RP","MHCT assessments new referral","RC35","The number of Mental Health Clustering Tool assessments that were recorded as  new referrals in the RP","Sum of IC_Rec_RP_MHCT_NewRef","New measure"]
["mm37",null,"Clusters started in RP","Clusters ended","RC23","The number of Mental Health Care Cluster Assignment Periods started in the RP","Sum of IC_Rec_RP_Cluster_Start\n","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm38",null,"Clusters ended in RP","Clusters started","RC25","The number of Mental Health Care Cluster Assignment Periods ended  in the RP","Sum of IC_Rec_RP_Cluster_End\n\n ","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm39",null,"AWOL episodes in RP","AWOL episodes","RC50","The number of Mental Health Absence Without Leave episodes that start in the reporting period and that lasted for more than 1 day","Sum of IC_Rec_RP_AWOL","Numerator for indicator 7 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports, see Methodological Change paper for changes in method."]
["mm40",null,"Under 16 bed days in RP","Under 16 bed days","RC41","The number of Bed Days, for patients under the age of 16,  in the RP","SUM of IC_Rec_RP_Wrdst_Days_Gross where MHD_Age_End_Reporting_Period<16","Indicator 10 of the former DH Performance Framework for mental health trusts, previously published as part of Summary Statistics in Routine Quarterly MHMDS Reports."]
["mm41",null,"Days on cluster 00 in RP","Days on Cluster 00","EP01","The total number of days on PbR cluster 00 in the RP, calculated from the start and end dates of Mental Health Care Cluster Assignment Periods and the start and end of the RP.","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='00'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm42",null,"Days on cluster 01 in RP","Days on Cluster 01","EP01","see mm41","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='01'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm43",null,"Days on cluster 02 in RP","Days on Cluster 02","EP01","see mm42","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='02'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm44",null,"Days on cluster 03 in RP","Days on Cluster 03","EP01","see mm43","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='03'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm45",null,"Days on cluster 04 in RP","Days on Cluster 04","EP01","see mm44","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='04'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm46",null,"Days on cluster 05 in RP","Days on Cluster 05","EP01","see mm45","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='05'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm47",null,"Days on cluster 06 in RP","Days on Cluster 06","EP01","see mm46","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='06'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm48",null,"Days on cluster 07 in RP","Days on Cluster 07","EP01","see mm47","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='07'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm49",null,"Days on cluster 08 in RP","Days on Cluster 08","EP01","see mm48","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='08'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm50",null,"Days on cluster 10 in RP","Days on Cluster 10","EP01","see mm49","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='10'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm51",null,"Days on cluster 11 in RP","Days on Cluster 11","EP01","see mm50","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='11'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm52",null,"Days on cluster 12 in RP","Days on Cluster 12","EP01","see mm51","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='12'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm53",null,"Days on cluster 13 in RP","Days on Cluster 13","EP01","see mm52","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='13'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm54",null,"Days on cluster 14 in RP","Days on Cluster 14","EP01","see mm53","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='14'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm55",null,"Days on cluster 15 in RP","Days on Cluster 15","EP01","see mm54","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='15'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm56",null,"Days on cluster 16 in RP","Days on Cluster 16","EP01","see mm55","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='16'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm57",null,"Days on cluster 17 in RP","Days on Cluster 17","EP01","see mm56","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='17'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm58",null,"Days on cluster 18 in RP","Days on Cluster 18","EP01","see mm57","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='18","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm59",null,"Days on cluster 19 in RP","Days on Cluster 19","EP01","see mm58","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='19'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm60",null,"Days on cluster 20 in RP","Days on Cluster 20","EP01","see mm59","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='20'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
["mm61",null,"Days on cluster 21 in RP","Days on Cluster 21","EP01","see mm60","Sum of IC_Epi_RP_Days where MHD_PbR_Cluster='21'","New measure – the same measure is calculated on individual provider and commissioner data and provided as part of a set of Cluster Reports on Open Exeter"]
[]
["Data source: Mental Health Minimum Dataset (MHMDS) monthly data"]
["Copyright © 2014, The Health and Social Care Information Centre. All rights reserved."]

{"sheet":"MHMDS v4.1 derivations","index":3,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,0,41,6]]}
[]
["Table","V4 data item name","Proposed Deviation Number",null,"Data type","Description","Rule","Derived/transformed","Based on data item","Publications ","Known uses/potential uses"]
["Header","IC_Use_Submission_Flag","HE01",null,"varchar(1)","Prioritises the type of submission per provider and reporting period.  Where a refresh submission exists for the same provider and same reporting period, the refresh header record will be flagged.  Where there is only a primary record present that will be flagged.  Each provider has only one submission flagged per reporting period.","For each Provider_Org_Code and TIME_ID where file type of 'Refresh' and 'Primary' exists then SET IC_Use_Submission_Flag = 'Y' Where File_Type = 'Refresh'.  If only File_Type of 'Refresh' or 'Primary' exists then SET IC_Use_Submission_Flag = 'Y' to whichever of these records is present.  Flag is applied when each submission is passed into live.","Derived","Provider_Org_Code, File_Type, TIME_ID",null,"Compiling a 'final' set of data per reporting period"]
["Record","IC_Rec_CCG","RC01",23,"varchar(5)","This field is derived during processing.  It shows the CCG of GP practice, for the patient, or if that was not provided, the CCG of residence.","IC_Rec_CCG = MHD_CCG_of_GP_Practice where MHD_CCG_of_GP_Practice is not null, otherwise MHD_CCG_of_Residence.","Transformed","Record.MHD_PCT_of_GP_Practice, Record.MHD_PCT_of_Residence","Bulletin Commissioner analysis","Bulletin commissioner analysis"]
["Record","IC_Rec_endRP_Cluster_Flag","RC03",36,"varchar(1)","Indicates whether the record has an open Cluster episode at the end of the Reporting Period.","Set to 'Y' where MHD_EpiType = ('CLUST') and MHD_EpiEndDate is null and MHD_PbR_Cluster in ('00','01','02','03','04','05','06','07','08','10','11','12','13','14','15','16','17','18','19','20','21')","Derived","Episode.MHD_EpiType"]
["Record","IC_Rec_endRP_CPA_Flag","RC04",24,"varchar(1)","Indicates whether the record has an open CPA  episode at the end of the Reporting Period.","Set to 'Y' where MHD_EpiType = ('CPA') and MHD_EpiEndDate is null ","Derived","Episode.MHD_EpiType",null,"Service Performance Indicators"]
["Record","IC_Rec_endRP_CPA_Review_within_12mnths","RC05",33,"varchar(1)","Indicates whether the record has an open spell at the end of the Reporting Period and a CPA review within the last 12 months","Set to 'Y' where MHD_EventType = ('REV') and IC_Eve_Most_Recent_Flag = 'Y'  and MHD_End_Date_MHCS is null","Derived","IC_Eve_Prov_Person_CPA_Review_Most_Recent_Flag",null,"Service Performance Indicators"]
["Record","IC_Rec_endRP_Employment_Status","RC06",30,"varchar(2)","Shows the employment status for the most recent 'EMP' event within the last 12 months for each record with an open spell at the end of the reporting period","Return MHD_Employment_Status where MHD_EventType = ('EMP') and IC_Eve_Most_Recent_Flag = 'Y'  and MHD_End_Date_MHCS is null","Derived","IC_Eve_Prov_Person_Employment_Most_Recent_Flag",null,"Service Performance Indicators"]
["Record","IC_Rec_endRP_HONOS_Assessment_within_12mnths","RC07",32,"varchar(1)","Indicates whether the record has an open spell at the end of the Reporting Period and a HoNOS assessment within the last 12 months","Set to 'Y' where MHD_EventType in ('HNS','HNS65','HNSCA','HNSSC','MHCT') and IC_Eve_Most_Recent_Flag = 'Y'  and MHD_End_Date_MHCS is null","Derived","IC_Eve_Prov_Person_HONOS_Most_Recent_Flag",null,"Service Performance Indicators"]
["Record","IC_Rec_endRP_MHA_Flag","RC08",25,"varchar(1)","Indicates whether the record has an open MHA episode at the end of the Reporting Period, where it has a valid legal status and has not expired.","Set to 'Y' where MHD_LegStat_Code=IC_Rec_endRP_LegalStat_Cleansed\n  and MHD_EpiType = 'MHA' and MHD_EpiEnd_Date is null and\n  ( MHD_ExpiryDate  IS null or MHD_ExpiryDate>Reporting End_Date)","Derived","Episode.MHD_EpiType"]
["Record","IC_Rec_endRP_Pdiag_Flag","RC09",29,"varchar(6)","Indicates whether the record has an open spell at the end of the Reporting Period and a valid recorded primary diagnosis within the last 12 months","Return IC_Eve_PrimaryDiagnosis where MHD_EventType = ('PDIAG') and IC_Eve_Most_Recent_Flag = 'Y'  and MHD_End_Date_MHCS is null and IC_Eve_PrimaryDiagnosis is not null","Derived","IC_Eve_Prov_Person_PDIAG_Most_Recent_Flag"]
["Record","IC_Rec_endRP_Recall_Flag","RC10",27,"varchar(1)","Indicates whether the record has an open recall episode at the end of the Reporting Period and where the RECALL has not expired.","Set to 'Y' where MHD_EpiType = ('RCALL') and MHD_EpiEndDate is null","Derived","Record.MHD_MHMDS_Person_ID,Record.MHD_MHMDS_Record_Number,Record.IC_Provider_Org_Code,Episode.MHD_EpiType,Episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date"]
["Record","IC_Rec_endRP_SCT_Flag","RC11",26,"varchar(1)","Indicates whether the record has an open SCT  episode at the end of the Reporting Period.","Set to 'Y' where MHD_EpiType = ('SCT') and MHD_EpiEndDate is null   and MHD_EpiEnd_Date is null and\n  ( MHD_ExpiryDate  IS null or MHD_ExpiryDate>Reporting End_Date)","Derived","Episode.MHD_EpiType"]
["Record","IC_Rec_endRP_Settled_Accommodation_Indicator","RC12",31,"varchar(2)","Shows the settled accommodation Indicator for the most recent 'ACCOM' event within the last 12 months for each record with an open spell at the end of the reporting period","Return MHD_Settled_Accommodation_Indicator where MHD_EventType = ('ACCOM') and IC_Eve_Most_Recent_Flag = 'Y' and MHD_End_Date_MHCS is null","Derived","IC_Eve_Prov_Person_Accommodation_Most_Recent_Flag",null,"Service Performance Indicators"]
["Record","IC_Rec_Ethnicity","RC13",4,"varchar(2)","The cleansed ethnicity of a PERSON. Removes the second character (where value is not equal 9 or 99) which is optional for use locally leaving the national code. Otherwise 99.","IC_Rec_Ethnicity = FIRST CHARACTER OF MHD_Ethnicity where MHD_Ethnicity is not equal to 9 or 99, otherwise 99.","Transformed","Record.MHD_Ethnicity","Bulletin","Demographics analysis"]
["Record","IC_Rec_RP_Admission","RC19",41,"smallint","Calculates the total number of admissions for the record in the reporting period. ","Count of distinct MHD_Episode_ID where  mhd_epistart_date>=Reporting Period Start Date and mhd_epistart_date<=Reporting period End Date and  MHD_EpiType ='PROSP''\n","Derived","Episode.MHD_Episode_ID, Episode.MHD_EpiType, episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date, Header.Start_Date, Header.End_Date"]
["Record","IC_Rec_RP_Admission_Formal","RC20",42,"smallint","Counts the number of admissions to hospital (MHD_EpiType = 'PROSP') where the patient was detained under the Mental Health Act (1983) on admission (MHD_EpiType = 'MHA').  Uses of short term sections and holding powers and Place of Safety Orders that coincided with the day of admission are excluded.  Detentions on day of admission includes uses of sections 2, 3, 35, 36, 37 (with or without s41 restrictions) 38,44, 46, 45A and 47 and 48 \n(with or without s49 restrictions), and detentions under previous legislation (Fifth Schedule) and other Acts"," Count of distinct MHD_Episode_ID where  mhd_epistart_date>=Reporting Period Start Date and mhd_epistart_date<=Reporting period End Date and  MHD_EpiType ='PROSP' where there is, for the same mhd_spell_id, an MHA episode  (MHD_EpiType = 'MHA') with the same mhd_epistart_date and MHD_LegStat_Code IN ('2', '02', ' 2', '3', '03', ' 3', '7', '07', ' 7', '8', '08', ' 8', '9', '09', ' 9', '10', '12', '13', '14', '15', '16', '17', '18', '31', '32', '34') ","Derived","Episode.MHD_Episode_ID, Episode.MHD_EpiType, episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date, Header.Start_Date, Header.End_Date,MHD_LegStat_Code"]
["Record","IC_Rec_RP_Cluster_End","RC23",58,"smallint","Calculates the total number of Clusters that end in the reporting period for the record.","Count of distinct MHD_Episode_ID where   mhd_epiend_date>=Reporting Period Start Date and mhd_epiend_date<=Reporting period End Date  and MHD_EpiType ='CLUST'  and MHD_PbR_Cluster in ('00','01','02','03','04','05','06','07','08','10','11','12','13','14','15','16','17','18','19','20','21')\n\n ","Derived","Episode.MHD_Episode_ID, Episode.MHD_EpiType, Episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date, Episode.MHD_PbR_Cluster"]
["Record","IC_Rec_RP_Cluster_Start","RC25",57,"smallint","Calculates the total number of Clusters that start in the reporting period  for the record.","Count of distinct MHD_Episode_ID where  mhd_epistart_date>=Reporting Period Start Date and mhd_epistart_date<=Reporting period End Date  and  MHD_EpiType ='CLUST' and MHD_PbR_Cluster in ('00','01','02','03','04','05','06','07','08','10','11','12','13','14','15','16','17','18','19','20','21')\n","Derived","Episode.MHD_Episode_ID, Episode.MHD_EpiType, Episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date, Episode.MHD_PbR_Cluster"]
["Record","IC_Rec_RP_DDisc_Days","RC29",49,"smallint","Calculates the total numbers of days between the start and end date of a Delayed Discharge (DDISC) episode within the reporting period for the record regardless of overlapping episodes.","Sum of  Days Difference  (Episode.MHD_EpiEnd_Date - episode.MHD_EpiStart_Date) +1  where MHD_EpiType ='DDISC'","Derived","Episode.MHD_EpiType, Episode.IC_IC_Epi_Days"]
["Record","IC_Rec_RP_Disch_Net_Followup","RC30",46,"smallint","Calculates the number of IC_Rec_RP_Discharges_Net  for the record where there is an event of type HPCON with a MHD_ConsultMedium not in ('05','06')\nand the MHD_EventDate is between the discharge date and discharge date+7","Count of distinct MHD_Episode_ID for records where IC_Rec_RP_Discharges_Net>0 and  MHD_EventType = 'HPCON' and (MHD_ConsultMedium not in ('05', '06','5','6',' 5',' 6' ) or MHD_ConsultMedium is null) ","Derived","Episode.MHD_Episode_ID, Event.MHD_EventType, Event.MHD_ConsultMedium"]
["Record","IC_Rec_RP_Discharges_Gross","RC31",44,"smallint","Calculates the total number of hospital discharges in the reporting period for the record.","Count of distinct MHD_Episode_ID where  MHD_EpiEnd_Date is not null and MHD_EpiEnd_Date>=h.start_date and MHD_EpiEnd_Date<=h.end_date and  MHD_EpiType ='PROSP''\n","Derived","Episode.MHD_Episode_ID, Episode.MHD_EpiType, episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date, Header.Start_Date, Header.End_Date"]
["Record","IC_Rec_RP_Discharges_Net","RC32",45,"smallint","Calculates the number of hospital discharges in the reporting period, excluding the last 7 days,\nwhere the method of discharge is null or is not 'client died'. \nThere must also be a episode of type REF that is open in the reporting period or is discharged in the  reporting period, excluding the last 7 days, \nand not discharged due to transfer to another provider.\nThe date of hospital discharge must not be the same as the date of referral discharge.","Count of distinct MHD_Episode_ID \nwhere (MHD_EpiType = 'PROSP'\nand MHD_EpiEnd_Date between h.Start_Date and dateadd (dd, -7, h.End_Date)\nand (MHD_DischMet <> '4' or MHD_DischMet is null))\nand ( MHD_EpiType = 'REF'\nand ((MHD_DischDate between h.Start_Date and dateadd (dd, -7, h.End_Date)) or MHD_DischDate is NULL)\nand (MHD_DischReason not in ('4', '04', '5', '05', '6', '06', ' 4', ' 5', ' 6')  or MHD_DischReason is NULL) )                            \nand (Prosp.MHD_EpiEnd_Date <> Ref.MHD_DischDate) or ref.MHD_DischDate is null)","Derived","Episode.MHD_Episode_ID, Episode.MHD_EpiType, episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date, Header.Start_Date, Header.End_Date,Episode.MHD_DischMet, Episode.MHD_DischReason"]
["Record","IC_Rec_RP_MHCT_Gross","RC34",50,"smallint","Calculates the total number of MHCT assessments in the reporting period for the record.","Count of distinct MHD_event_ID where WHERE MHD_Eventtype in ('MHCT')\n","Derived","Event.MHD_Event_ID,Event.MHD_EpiType, MHD_Eventtype"]
["Record","IC_Rec_RP_MHCT_NewRef","RC35",51,"smallint","Calculates the total number of MHCT assessments for the reason of New Referral in the reporting period for the record.","Count of distinct MHD_event_ID where WHERE MHD_Eventtype in ('MHCT') and  MHD_ClusteringTool_Assessment_Reason='01'\n","Derived","Event.MHD_Event_ID,Event.MHD_EpiType, MHD_Eventtype, Eventtype.MHD_ClusteringTool_Assessment_Reason"]
["Record","IC_Rec_RP_Wrdst_Days_Gross","RC41",13,"smallint","Calculates the total numbers of days between the start and end date of a Wardstay episode within the reporting period regardless of overlapping episodes and Homeleave.","Sum of IC_RP_Epi_Days where MHD_EpiType = WRDST","Derived","Episode.MHD_EpiType, episode.IC_IC_Epi_Days",null,"data.gov (activity)"]
["Record","IC_Rec_RP_Wrdst_Days_Net","RC42",15,"smallint","Calculates the total number of days between the start and end date of a Wardstay episode within the reporting period and subtracts Homeleave using the number generated in the Cleansed Wardstays field.","Sum of (episode.MHD_EpiEnd_Date - episode.MHD_EpiStart_Date) +1) where MHD_EpiType = WRDST. For any overlapping episodes MHD_EpiEnd_Date is the latest MHD_EpiEnd_Date and MHD_EpiStart_Date is the earliest  MHD_EpiStart_Date - Sum of (episode.MHD_EpiEnd_Date - episode.MHD_EpiStart_Date) +1) where MHD_EpiType = HOMEL. For any overlapping episodes MHD_EpiEnd_Date is the latest MHD_EpiEnd_Date and MHD_EpiStart_Date is the earliest  MHD_EpiStart_Date.","Derived","Episode.MHD_EpiType, episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date",null,"final quarterly data extract"]
["Record","IC_Rec_endRP_AOT_Flag","RC44",35,"varchar(1)","Indicates whether the record has an open Team episode with an AOT team at the end of the Reporting Period.","Set to 'Y' MHD_EpiType = 'TMEP' and MHD_TeamType = 'A05' and MHD_EpiEnd_Date is null","Derived","Episode.MHD_EpiType, Episode.MHD_TeamType"]
["Record","IC_Rec_EndRP_CPA_Epi_12_Months","RC46",40,"varchar(1)","Indicates where the record has an open CPA episode that has been open for 365 days or more","Set to 'Y' where MHD_EpiType='CPA' and MHD_EpiEnd_Date is null and IC_Episode_epi_Days>=365","Derived","Episode.MHD_EpiType,Episode.MHD_EpiEnd_Date,"]
["Record","IC_Rec_endRP_EIT_Flag","RC47",34,"varchar(1)","Indicates whether the record has an open Team episode with an EIT team at the end of the Reporting Period.","Set to 'Y' MHD_EpiType = 'TMEP' and MHD_TeamType = 'A14' and MHD_EpiEnd_Date is null","Derived","Episode.MHD_EpiType, Episode.MHD_TeamType,Episode.MHD_EpiEnd_Date"]
["Record","IC_Rec_endRP_Hospital_Spell_Flag","RC48",37,"varchar(1)","Indicates where the record has an open WRDST or PROSP episode at the end of the reporting period","Set to 'Y' where MHD_EpiType in ('WRDST','PROSP') and MHD_EpiEndDate is null ","Derived","Episode.MHD_Episode_ID,Episode.MHD_EpiType, Episode.MHD_EpiEnd_Date"]
["Record","IC_Rec_endRP_LegalStat_Cleansed","RC49",59,"varchar(2)","For all MHA episodes that are open at the end of the reporting period,  for the record, it cleans the legal status code by adding 0 to any code that has a missing leading 0 and excluding any 'invalid' codes. \nWhere there are more than 1 open episode they are ranked by .MHD_Epistart_Date desc, MHD_Episode_ID  desc","Return MHD_LegStat_Code\n  where MHD_LegStat_Code IN \n  ('01','02','03','04','05','06','07','08','09','10','12','13','14','15','16','17','18','19',\n  '20','31','32','34','35','36').\nReturn  '0'+ MHD_LegStat_Code  where MHD_LegStat_Code IN \n  ('1','2','3','4','5','6','7','8','9') \n  WHERE MHD_EpiType IN ('MHA')   and MHD_EpiEnd_Date is null ","Derived","Episode.MHD_EpiType, Episode.MHD_Legal_Stat_Code, Episode.MHD_EpiEnd_Date"]
["Record","IC_Rec_RP_AWOL","RC50",55,"smallint","Indicates where the record has an AWOL episode that starts in the reporting period and that lasts for more than 1 day","Count of distinct MHD_Episode_ID where (mhd_epistart_date>=h.start_date and mhd_epistart_date<=h.end_date  and mhd_epiend_date is null )\nor  mhd_epistart_date>=h.start_date and mhd_epistart_date<=h.end_date and\n  datediff(d,mhd_epistart_date,mhd_epiend_date)>0","Derived","Episode.MHD_Episode_ID,Episode.MHD_EpiType, Episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date, Header.Start_Date, Header.End_Date,"]
["Record","IC_Rec_RP_DAYATT_Contacts","RC52",53,"smallint","Calculates the total number of day attendance contacts in the reporting period for the record.","Count of distinct MHD_event_ID where WHERE MHD_Eventtype ='DAYATT'\n","Derived","Event.MHD_Event_ID,Event.MHD_EpiType, MHD_Eventtype"]
["Record","IC_Rec_RP_DAYATT_Contacts_Att","RC53",54,"smallint","Calculates the number of attended day attendance contacts in the reporting period for the record.","Count of distinct MHD_event_ID where WHERE MHD_Eventtype='DAYATT' and MHD_Attended_Indicator in (5,6)\n","Derived","Event.MHD_Event_ID,Event.MHD_EpiType, MHD_Eventtype, MHD_Attended_Indicator"]
["Record","IC_Spell_RP_Days","RC54",38,"smallint","Indicates the length of an spell in days based on the start and end dates of the spell.  Where the spell start date is before the start or the reporting period, the start of the reporting period is used.  Where end date is not present, the end of the reporting period is used.","(MHD_End_Date_MHCS -MHD_Start_Date_MHCS) +1","Derived","Record.MHD_Start_Date_MHCS, Record.MHD_End_Date_MHCS"]
[" Episode","IC_Episode_Epi_Days","EP01",null,"smallint","Indicates the length of an episode in days based on the start and end dates of the episode.  Where end date is not present, the end of the reporting period is used.","If Episode.MHD_EpiType = REF OR DDISC then NULL, Otherwise (Episode.MHD_EpiEnd_Date - episode.MHD_EpiStart_Date) +1","Derived","Episode.MHD_EpiType, Episode.MHD_EpiStart_Date, Episode.MHD_EpiEnd_Date,"]
["Event","IC_Eve_PrimaryDiagnosis","EV01",null,"varchar(6)","Cleans primary diagnosis code using these steps; (a) clean code by removing full-stops (HES rule 460).  (b) truncates code, replaces Os with 0s and removes codes shorter than three characters in length. (c) adds X to the end of three character codes, cleans codes with an X in 3rd position and change codes without a match within ICD 10 reference data to end in X. (d) change codes ending in X to 9 if no matching description. (e) class unmatched records as Invalid.","(a) clean code, remove full-stops (rule 460).  (b) truncate code, replace Os with 0s and remove codes shorter than three in length. (c) add X to the end of three character codes, clean codes with an X in 3rd position and change codes without a match to end in X. (d) change codes ending in X to 9 if no matching description. (e) class unmatched records as Invalid.","Transformed","Event.MHD_PrimaryDiagnosis"]
["Event","IC_Eve_SecondaryDiagnosis","EV02",null,"varchar(6)","Cleans secondary diagnosis code using these steps; (a) clean code by removing full-stops (HES rule 460).  (b) truncates code, replaces Os with 0s and removes codes shorter than three characters in length. (c) adds X to the end of three character codes, cleans codes with an X in 3rd position and change codes without a match within ICD 10 reference data to end in X. (d) change codes ending in X to 9 if no matching description. (e) class unmatched records as Invalid.","(a) clean code, remove full-stops (rule 460).  (b) truncate code, replace Os with 0s and remove codes shorter than three in length. (c) add X to the end of three character codes, clean codes with an X in 3rd position and change codes without a match to end in X. (d) change codes ending in X to 9 if no matching description. (e) class unmatched records as Invalid.","Transformed","Event.MHD_SecondaryDiagnosis"]
["Event","IC_Eve_Most_Recent_Flag","EV03",null,"varchar(1)","Flags records with the most recent EMP/ACCOM/HNS/REV/PDIAG/MHCT events which are within the last 12 months for each person in each provider organisation.","Ranks events for each MHD_EventType of EMP/ACCOM/HNS/REV by MHD_EventDate desc>TIME_ID desc>File_Type desc>MHD_Event_ID desc where MHD_EventType in ('EMP','ACCOM','HNS','REV','PDIAG','MHCT') and IC_Submission_Flag is 'Y' and MHD_MHMDS_Record_Number != 99999999 and MHD_Employment_Status/MHD_Settled_Accommodation_Indicator is not null and MHD_EventDate >= Dateadd(yy,-1,@Reporting Period_ENDDATE) with @Reporting Period_ENDDATE being the latest submission's reporting period end date. The top ranked event is assigned a 'Y', everything else NULL.","Derived","Record.MHD_MHMDS_Person_ID,Record.MHD_MHMDS_Record_Number,Record.IC_Provider_Org_Code,Event.MHD_EventType,Event.MHD_EventDate"]
[]
["Data source: Mental Health Minimum Dataset (MHMDS) monthly data"]
["Copyright © 2014, The Health and Social Care Information Centre. All rights reserved."]

{"sheet":"Glossary","index":4,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,0,12,6]]}
[]
["Below is a list of all acronyms detailed in the metadata file"]
[]
["Acronym","Long Description"]
["CCG","Clinical Commissioning Group"]
["RP","Reporting Period"]
["CPA","Care Programme Approach"]
["HoNOS","Health of the Nation Score"]
["MHA","Mental Health Act"]
["MHCT","Mental Health Clustering Tool"]
["AWOL","Absent Without Leave"]
[]
["Data source: Mental Health Minimum Dataset (MHMDS) monthly data"]
["Copyright © 2014, The Health and Social Care Information Centre. All rights reserved."]