{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Version Control","Validation Rules","Mapping to Input Data Item"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":4,"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":"Version Control","index":0,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[16,2,16,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[30,0,30,1],[30,2,30,3],[31,0,31,3],[33,0,33,4],[34,0,34,4],[28,2,28,3],[29,0,29,1],[29,2,29,3],[21,0,28,1],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[17,0,17,4],[19,0,19,4],[25,2,25,3],[26,2,26,3],[27,2,27,3],[11,2,11,3],[1,3,1,4],[2,3,2,4],[5,0,5,4],[7,0,7,4],[9,0,9,4]]}
[]
[null,null,null,"Improving Access to Psychological Therapies (IAPT) User Guidance"]
[null,null,null,"Appendix 1 - IAPT Data Quality Measures"]
[]
[]
["Purpose of this document"]
[]
["The purpose of this document is to highlight the Data Quality Measures which will be used for Improving Access to Psychological Therapies (IAPT). "]
[]
["Document version history"]
[]
["Version","Date","Brief Summary of Change",null,"Owners Name"]
["0.1","2013-02-28","Draft version",null,"Ben Osborne"]
["1.0","2013-03-06","Final version",null,"Ben Osborne"]
[1.1000000000000001,"2013-04-08","DQM 26-30 rule and corporate logo update",null,"Ben Osborne"]
[1.2,"2014-11-05","V1.5 update",null,"William Adam"]
[1.3,"2015-02-16","Corrected DQM44 valid and invalid definition to be 0-68 for Social Phobia Inventory score, not 0-8.",null,"William Adam"]
[]
[]
["Author information"]
[]
["For more information on the status of this document, please see the covering letter or contact:",null,"Mental Health and Community Care Team"]
[null,null,"Health & Social Care Information Centre"]
[null,null,"1 Trevelyan Square"]
[null,null,"Boar Lane"]
[null,null,"Leeds, LS1 6AE"]
[null,null,"Tel: 0300 303 5678"]
[null,null,"E-mail: iapt@hscic.gov.uk"]
[null,null,"Internet: www.hscic.gov.uk"]
["Date of Issue",null,"2014-11-21"]
["Reference"]
["Copyright ©  2014 Health & Social Care Information Centre, All Rights Reserved"]

{"sheet":"Validation Rules","index":1,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[46,0,46,9],[8,0,8,9],[43,0,43,3],[7,0,7,1]]}
[]
[]
[]
[]
[]
[]
["Rules for IAPT Data Quality Measures"]
["http://www.hscic.gov.uk/iapt"]
["NOTE: Both the numerator and the denominator only include DISTINCT referrals, so incorrectly submitted duplicate referrals are not included in the result. Results for data items from the person table are based on distinct referral level data because the data quality measures are published at both commissioner and provider level and commissioner data is only available at referral level."]
[]
["DQ Measure Number","DQ Measure","Data Item(s)","Denominator","Valid","Other","Default","Invalid","Missing"]
["DQM1","NHS Number","NHSNO_FLAG","All referral records","Records with an NHS Number Flag of Y","N/A","N/A","N/A","Records with an NHS Number Flag of N "]
["DQM2","Postcode of Usual Address","POSTCODE_DISTRICT and CCG_OF_RESIDENCE","All referral records","Records with a Postcode District and CCG of Residence entry and where the Postcode District is not 'ZZ99'","N/A","Records with a Postcode District of 'ZZ99'","Records with no CCG of Residence and where the Postcode District is not 'ZZ99'","Records with no Postcode District"]
["DQM4","Person Gender Code Current","GENDER","All referral records","Records with a Person Gender Current code of 1 or 2","Records with a Person Gender Current code of 9","Records with a Person Gender Current code of 0","Records with a Person Gender Current code not equal to 0, 1, 2 or 9","Records with no Person Gender Current code"]
["DQM6","Ethnic Category","ETHNICITY","All referral records","Records where the first character of the patient's ethnic category equals A-H, J-N, P, R or S","Records where the first character of the patient's Ethnic Category equals Z","Records with a patient's Ethnic Category of 99","Records where the first character of the patient's ethnic category does not equal A-H, J-N, P, R, S, Z and where the patient's Ethnic Category is not equal to 99","Records with no patient's Ethnic Category"]
["DQM7","Organisation Code of Commissioner","ORGCODECOMM","All referral records","Records with an Organisation Code of Commissioner that could be matched to a Clinical Commissioning Group Organisation Code in the ODS Organisation reference data (ORG_DAILY where ORG_TYPE_CODE equals 'CC' and BUSINESS_END_DATE is null), which was still open at the end of the reporting period","Records with an Organisation Code of Commissioner that could be matched to a Clinical Commissioning Group Organisation Code in the ODS Organisation refeference data (ORG_DAILY where ORG_TYPE_CODE equals 'CC' and BUSINESS_END_DATE is null), which was closed during or one day before the start of the reporting period","N/A","Records with an Organisation Code of Commissioner that could not be matched to a Clinical Commissioning Group Organisation Code in the ODS Organisation reference data (ORG_DAILY where ORG_TYPE_CODE equals 'CC' and BUSINESS_END_DATE is null) or which was matched to an Organisation Code which was closed prior to the day before the start of the reporting period","Records with no Organisation Code of Commissioner"]
["DQM8","General Medical Practice Code","GMPC","All referral records, except those where the General Medical Practice Code starts with an S (representing Scottish Practices)","Records with a General Medical Practice code (not equal to V81999, V81998 or V81997) that could be matched to a GP Practice in the ODS GP Practice reference data (PRACTICES_WEEKLY where BUSINESS_END_DATE is null), which was still open at the end of the reporting period.","Records with a General Medical Practice code (not equal to V81999, V81998 or V81997) that could be matched to a GP Practice in the ODS GP Practice reference data (PRACTICES_WEEKLY where BUSINESS_END_DATE is null), which was closed during or one day before the start of the reporting period","Records with a General Medical Practice code equal to V81999, V81998 or V81997","Records with a  General Medical Practice code (not equal to V81999, V81998 or V81997) that could not be matched to a GP Practice in the ODS GP Practice reference data (PRACTICES_WEEKLY where BUSINESS_END_DATE is null),  or which was matched to a Practice which was closed prior to the day before the start of the reporting period","Records with no General Medical Practice code"]
["DQM19","Mental Health Care Cluster","CARECLUSTER","All referral records with at least one attended assessment appointment in the pathway (Attendance is 5 or 6 and Appointment Purpose is 01 or 03 and Appointment Date between Referral Request Received Date and Date of End of IAPT Care Pathway)","Records with a Care Cluster between 00-08 or 10-21","N/A","N/A","Records with a Care Cluster not between 00-08 and not between 10-21","Records with no Care Cluster code"]
["DQM21","Religious or Other Belief Affiliation System","RELIGION","All referral records","Records with a Religious Group Code of A-L","Records with a Religious Group Code of M","Records with a Religious Group Code of N","Records with a Religious or Other Belief System Affiliation Code which is not equal to A-N","Records with no provider code Religious or Other Belief System Affiliation Code"]
["DQM22","Sexual Orientation","SEXUALORIENTATION","All referral records","Records with a sexual orientation code of 1, 2 or 3","Records with a sexual orientation code of 4 or Z","Records with a sexual orientation code of 9","Records with a sexual orientation code which is not equal to 1,2,3,4,9 or Z","Records with no sexual orientation code"]
["DQM24","Provisional Diagnosis","PROVDIAG","All referral records with at least one attended assessment appointment in the pathway (Attendance is 5 or 6 and Appointment Purpose is 01 or 03 and Appointment Date between Referral Request Received Date and Date of End of IAPT Care Pathway)","Records where the first 3 characters of the Provisional Diagnosis match the first 3 characters of a valid ICD10 code and the Provisional Diagnosis is not equal to R69X","N/A","Records with a Provisional Diagnosis of R69X","Records where the first 3 characters of the Provisional Diagnosis does not match the first 3 character of a valid ICD10 code","Records with no Provisional Diagnosis"]
["DQM25","Source of Referral","SOURCEREFERRAL","All referral records","Records with a Source of Referral for Mental Health Code of A1-A3, B1-B2, C1-C2, D1, E1-E5, F1-F3, G1-G4,H1-H2, I1-I2, J1-J4, K1-K5, L1-L2, M1-M5 or N1-N2 ","Records with a Sourcereferral for Mental Health Code of M6","N/A","Records with a Source of Referral for Mental Health Code not equal to A1-A3, B1-B2, C1-C2, D1, E1-E5, F1-F3, G1-G4,H1-H2, I1-I2, J1-J4, K1-K5, L1-L2, M1-M6 or N1-N2","Records with no Source of Referral for Mental Health Code"]
["DQM26","Patient Health Questionnaire (PHQ9) Score","PHQ9_SCORE","All attended appointment records (Attendance is 5 or 6)","Records with a PHQ9 score between 0 - 27","N/A","N/A","Records with a PHQ9 score which is not between 0 - 27","Records where no PHQ9 score is present"]
["DQM27","Generalised Anxiety Disorder (GAD7) Score","GAD7SCORE","All attended appointment records (Attendance is 5 or 6)","Records with a GAD7 score between 0 - 21","N/A","N/A","Records with a GAD7 score which is not between 0 - 21","Records where no GAD7 score is present"]
["DQM29","Appointment Purpose","APPTYPE","All attended appointment records (Attendance is 5 or 6)","Records with an appointment type of 01 - 06","Records with an appointment type of 07","Records with an appointment type of 08","Records with an appointment type not equal to 01 - 08","N/A"]
["DQM30","Therapy Type (Treatments)","THERTYPE1, THERTYPE2, THERTYPE3 and THERTYPE4","Attended treatment appointment records (Attendance is 5 or 6 and AppType is 02,03 or 05)","Records with at least one therapy type present and where all of the supplied therapy types 1-4 have a code of 20-27, 29, 40-47 or 49-51","Records with at least one therapy type present and where any of the supplied therapy types 1-4 have a code of 28 or 48 and any others present have a code of 20-29 or 40-51","N/A","Records where any of the therapy types 1-4 present have a code which is not equal to 20-29 or 40-51","Records with no therapy type 1-4 present"]
["DQM31","Disability","DISABILITY","All disability records","Records with a Disability Code of 01 - 10 or XX","Records with a Disability Code of NN or ZZ","N/A","Records with a Disability Code which is not equal to 01 - 10 or XX, NN or ZZ","Records with no Disability Code"]
["DQM33","Reason for End of IAPT Care Pathway","ENDCODE","All discharged referral records (EndDate is not null)","Discharged records with an Endcode of 10-15 or 40-45","N/A","Discharged records with an Endcode of 97 or 98","Discharged records with an Endcode which is not equal to 10-15, 40-45 or 97 or 98","Discharged records with no Endcode"]
["DQM34","Organisation Code (IAPT Stepped To Provider)","ORGCODEPROVIDSTEPTO","All referral records where the end reason of the pathway is stepped to low intensity or high intensity IAPT service (endcode is 40 or 41)","Records with an Organisation Code that could be matched to an Organisation Code in the ODS Organisational tables, which was still open at the end of the reporting period","Records with an Organisation Code that could be matched to an Organisation Code in the ODS Organisational tables, which was closed during or one day before the start of the reporting period","N/A","Records with an Organisation Code that could be matched to an Organisation Code in the ODS Organisational tables,  or which was matched to an Organisation Code which was closed prior to the day before the start of the reporting period","Records with no Organisation Code"]
["DQM35","Stepped Care Intensity Delivered","STEPINTENSITY","All attended appointment records (Attendance is 5 or 6)","Records with a Stepped Care intensity delivered code of 01-04","N/A","N/A","Records with a Stepped Care intensity delivered code which is not equal to 01-04","Records with no Stepped Care intensity delivered code"]
["DQM36","Employment Status","EMPSTATUS","All attended appointment records (Attendance is 5 or 6)","Records with a Employment Status of 01 - 08 ","Records with a Employment Status of ZZ","N/A","Records with a Employment Status which is not equal to 01 - 08 or ZZ ","Records with no Employment Status"]
["DQM37","Use of Psychotropic Medication ","PSYCHMED","All attended appointment records (Attendance is 5 or 6)","Records with a Use of Psychotropic Medication code of 01-03","Records with a Use of Psychotropic Medication of ZZ","Records with a Use of Psychotropic Medication of UU","Records with a Use of Psychotropic Medication which is not equal to 01-03 or NN or ZZ","Records with no Use of Psychotropic Medication"]
["DQM38","Statutory Sickpay Indicator","SSPIND","All attended appointment records (Attendance is 5 or 6)","Records with a Statutory Sickpay Indicator code of Y or N","Records with a Statutory Sickpay Indicator of Z","Records with a Statutory Sickpay Indicator of U","Records with a Statutory Sickpay Indicator code not equal to Y, N, Z, U","Records with no Statutory Sickpay Indicator code"]
["DQM39","Work and Social Adjustment Scale (WSAS) Work Score","WSASWSCORE","All attended appointment records (Attendance is 5 or 6)","Records with a WSAS Work score between 0-9","N/A","N/A","Records with a WSAS Work score which is not between 0-9","Records with no WSAS Work score"]
["DQM40","Work and Social Adjustment Scale (WSAS) Home Management Score","WSASHMSCORE","All attended appointment records (Attendance is 5 or 6)","Records with a WSAS Home management score between 0-8","N/A","N/A","Records with a WSAS Home management score which is not between 0-8","Records with no WSAS Home management score"]
["DQM41","Work and Social Adjustment Scale (WSAS) Social Leisure Activities Score","WSASSLASCORE","All attended appointment records (Attendance is 5 or 6)","Records with a WSAS Social Leisure activities score between 0-8","N/A","N/A","Records with a WSAS Social Leisure activities score which is not between 0-8","Records with no WSAS Social Leisure activities score"]
["DQM42","Work and Social Adjustment Scale (WSAS) Private Leisure Activities Score","WSASPLASCORE","All attended appointment records (Attendance is 5 or 6)","Records with a WSAS Private leisure activities score between 0-8","N/A","N/A","Records with a WSAS Private leisure activities score which is not between 0-8","Records with no WSAS Private leisure activities score"]
["DQM43","Work and Social Adjustment Scale (WSAS) Relationships Score","WSASRSCORE","All attended appointment records (Attendance is 5 or 6)","Records with a WSAS Relationships score between 0-8","N/A","N/A","Records with a WSAS Relationships score which is not between 0-8","Records with no WSAS Relationships score"]
["DQM44","Anxiety Disorder Specific Measure Scores","IC_PROVDIAG, AGORASCOREALONE, SOCPHOBIAINVSCORE, OCDSCORE, PTSD_SCORE, HEALTHANXSCORE","All attended appointment records associated with a referral with a specific anxiety disorder provisional diagnosis (cleansed Provisional Diagnosis is F400, F401, F431, F452 or like F42% and Attendance is 5 or 6)","Records with a Provisional Diagnosis (cleansed) of F400 and Agoraphobia Mobility Alone Inventory score between 0.00 - 5.00 or\nProvisional Diagnosis (cleansed) of F401 and Social Phobia Inventory score between 0-68 or\nProvisional Diagnosis (cleansed) of like F42% and Obsessive Compulsive Inventory score between 0-168 or\nProvisional Diagnosis (cleansed) of F431 and Impact of Events Scale score between 0-88 or\nProvisional Diagnosis (cleansed) of F452 and Health Anxiety Inventory (Short Week) score beween 0-54","N/A","N/A","Records with a Provisional Diagnosis (cleansed) of F400 and Agoraphobia Mobility Alone Inventory score which is not between 0.00 - 5.00 or\nProvisional Diagnosis (cleansed) F401 and Social Phobia Inventory score which is not between between 0-68 or\nProvisional Diagnosis (cleansed) like F42% and Obsessive Compulsive Inventory score which is not between 0-168 or\nProvisional Diagnosis (cleansed) F431 and Impact of Events Scale score between which is not between 0-88 or \nProvisional Diagnosis (cleansed) F452 and Health Anxiety Inventory (Short Week) score which is not between beween 0-54","Records with a Provisional Diagnosis (cleansed) of F400 and with no Agoraphobia Mobility Alone Inventory score or\nProvisional Diagnosis (cleansed) F401 and with no Social Phobia Inventory score or\nProvisional Diagnosis (cleansed) like F42% and with no Obsessive Compulsive Inventory score or\nProvisional Diagnosis (cleansed) F431 and with no Impact of Events Scale score or \nProvisional Diagnosis (cleansed) F452 and with no Health Anxiety Inventory (Short Week) score"]
["DQM45","Activity Suspension Reason","PAUSEREASON","All pause records","Records with a Activity Suspension reason code of 01-03","N/A","N/A","Records with a Activity Suspension reason code which is not equal to 01-03","Records with no Activity Suspension reason code"]
[]
["1. The NHS IC does not receive person identifiable data. We therefore use other derived data items to determine the validity of person identifiable data items."]
["2. All code lists are outlined in the latest ISB IAPT specification (see url below) and NHS data dictionary."]
["http://www.isb.nhs.uk/documents/isb-1520/amd-02-2013/152022013spec.pdf"]
[]
["Further Note: "]
["For data items which are wider than just IAPT (where we have no scope to influence the list of code options available) and where it is believed that the potential codes available are not exhaustive, then codes which represent 'other…' will be categorised as 'Valid' (e.g. Ethnicity and Disability).  For IAPT specific data items, where we are able to amend the code list in the future (e.g. Therapy Type) 'other…' will be categorised as 'Other'. If values are encountered which are not available in such code list, these should be fed back to the Health and Social Care Information Centre Mental Health/IAPT team so they can be incorporated for future versions.\n"]
["Copyright © 2014, Health and Social Care Information Centre, Mental Health and Community Care Team.  All rights reserved."]

{"sheet":"Mapping to Input Data Item","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Mapping of IAPT Data Items Used In Data Quality Measures to The Source Access Data Item"]
[]
[]
["IAPT Data Item Name","Derived or Submitted","Source Access Data Item Name","Source Access Table"]
["NHS Number","Derived","Derived from NHSNO","Patient"]
["Postcode of Usual Address","Derived","Derived from POSTCODE","Patient"]
["Person Gender Code Current","Submitted","GENDER","Patient"]
["Ethnic Category","Submitted","ETHNICITY","Patient"]
["Organisation Code of Commissioner","Submitted","ORGCODECOMM","Referral"]
["General Medical Practice Code","Submitted","GMPC","Patient"]
["Mental Health Care Cluster","Submitted","CARECLUSTER","Referral"]
["Religious or Other Belief Affiliation System","Submitted","RELIGIOUSGROUP","Patient"]
["Sexual Orientation","Submitted","SEXUALORIENTATION","Patient"]
["Provisional Diagnosis","Submitted","PROVDIAG","Referral"]
["Source of Referral","Submitted","SOURCEREFERRAL","Referral"]
["Patient Health Questionnaire (PHQ9) Score","Submitted","PHQ9_SCORE","Appointment"]
["Generalised Anxiety Disorder (GAD7) Score","Submitted","GAD7SCORE","Appointment"]
["Appointment Purpose","Submitted","APPTYPE","Appointment"]
["Therapy Type (Treatments)","Submitted","THERTYPE1-4","Appointment"]
["Disability","Submitted","DISABILITY","Disability"]
["Reason for End of IAPT Care Pathway","Submitted","ENDCODE","Referral"]
["Organisation Code (IAPT Stepped To Provider)","Submitted","ORGCODEPROVIDSTEPTO","Referral"]
["Stepped Care Intensity Delivered","Submitted","STEPINTENSITY","Appointment"]
["Employment Status","Submitted","EMPSTATUS","Appointment"]
["Use of Psychotropic Medication ","Submitted","PSYCHMED","Appointment"]
["Statutory Sickpay Indicator","Submitted","SSPIND","Appointment"]
["Work and Social Adjustment Scale (WSAS) Work Score","Submitted","WSASWSCORE","Appointment"]
["Work and Social Adjustment Scale (WSAS) Home Management Score","Submitted","WSASHMSCORE","Appointment"]
["Work and Social Adjustment Scale (WSAS) Social Leisure Activities Score","Submitted","WSASSLASCORE","Appointment"]
["Work and Social Adjustment Scale (WSAS) Private Leisure Activities Score","Submitted","WSASPLASCORE","Appointment"]
["Work and Social Adjustment Scale (WSAS) Relationships Score","Submitted","WSASRSCORE","Appointment"]
["Anxiety Disorder Specific Measure Scores","Derived","Derived from IC_PROVDIAG, AGORASCOREALONE, SOCPHOBIAINVSCORE, OCDSCORE, PTSD_SCORE, HEALTHANXSCORE","Referral and Appointment"]
["Activity Suspension Reason","Submitted","PAUSEREASON","Waitingtimes"]