{"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":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[11,2,11,3],[1,3,1,6],[2,3,2,6],[5,0,5,4],[7,0,7,4],[9,0,9,4],[16,0,16,4],[18,0,18,4],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,0,28,1],[28,2,28,3],[20,0,27,1],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[29,0,29,1],[29,2,29,3],[30,0,30,3],[32,0,32,4],[33,0,33,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,"Owner’s 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"]
[]
[]
[]
["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: 0845 300 6016"]
[null,null,"E-mail: iapt@hscic.gov.uk"]
[null,null,"Internet: www.hscic.gov.uk"]
["Date of Issue",null,"01/03/2013"]
["Reference"]
["Copyright ©  2013 Health & Social Care Information Centre, All Rights Reserved"]

{"sheet":"Validation Rules","index":1,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,0,34,9],[8,0,8,9],[31,0,31,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","Description","Data Item(s)3","Denominator","Valid","Other","Default","Invalid","Missing"]
["DQM2","Postcode of Usual Address  1 (Derived from Postcode District and PCT of Residence because Postcode is not available to the information centre)","The Postcode of Usual Address in each record is tested using postcode district and PCT of Residence.","Postcode_District And Pct_Of_Residence","All distinct service referral records.","Derived by taking the missing and invalid records from the total record count","N/A","Records with a postcode district of 'ZZ99'","Records where the Postcode District is not blank or ZZ99 but the PCT of Residence is blank.","Records with no entry in the Postcode District field"]
["DQM3","Birth Date 1 ","Birth Date is tested using the Age at Reporting Period End Date","Age_End_Reporting_Period","All distinct service referral records.","Records where the Age at Reporting Period End Date is between 16 and 120. ","Records where the Age at Reporting Period End Date is between 0 and 15 years.","N/A","Records where the Age at Reporting Period End Date is greater than 120. ","Records with no Age at Reporting Period End Date. "]
["DQM4","Person Gender Current ","Person Gender Current is tested against the Person Gender code list2 ","Gender","All distinct service referral records.","Records with a Person Gender Current code 1 or 2.","Records with a Person Gender Current code 9.","Records with a Person Gender Current code 0.","Records with a Person Gender Current code not 0, 1, 2 or 9","Records with no Person Gender Current code"]
["DQM6","Ethnic Category","The Patient's Ethnic Category is tested against the Ethnic Category code list2. (Only the first character is tested for the Valid and Other categories).","Ethnicity","All distinct service 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 to Z.","Records with a Patient's Ethnic Category 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"]
["DQM8","General Medical Practice Code (Patient Registration)","The General Medical Practice code is tested against the ODS Current GP Practices table (Scottish GP Practices are not checked).","Pct_Of_Gp_Practice","All distinct service 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 Current GP Practices table, 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 Current GP Practices table, 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 Current GP Practices table,  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"]
["DQM20","NHS Number Status Indicator","The NHS Number Status Indicator is tested against the NHS Number Status Indicator code list.","Nhsnostatus","All distinct service referral records.","Records with an NHS Status Indicator Code of 01","Records with an NHS Status Indicator Code of 02, 03, 04, 05, 06, 07 or 08","N/A","Records with an NHS Status Indicator Code which is not 01, 02, 03,04, 05, 06, 07 or 08","Records with no NHS Status Indicator Code."]
["DQM21","Religious or Other Belief Affiliation System","Religious or Other Belief Affiliation System is tested against the Religious or Other Belief Affiliation System code list2 ","Religion","All distinct service referral records.","Records with a Religious or Other Belief System Affiliation Code of A1, B1-B8, C1-C80, D1-D6, E1, F1-F8, G1-G6, H1-H9, I1,J1,K1-K33, L1-L2","Records with a Religious or Other Belief System Affiliation Code of M1","Records with a Religious or Other Belief System Affiliation Code of N1","Records with a Religious or Other Belief System Affiliation Code which is not in A1, B1-B8, C1-C80, D1-D6, E1, F1-F8, G1-G6, H1-H9, I1,J1,K1-K33, L1-L2, M1 or N1.","Records with no provider code Religious or Other Belief System Affiliation Code."]
["DQM22","Sexual Orientation","Sexual Orientation is tested against the Sexual Orientation code list2 ","Sexualorientation","All distinct service 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 1,2,3,4,9 or Z","Records with no sexual orientation code."]
["DQM23","Long Term Physical Health Condition","Long Term Physical Health Condition is tested against the Long Term Physical Health Condition code list2 ","Ltcondition","All distinct service referral records.","Records with a Long Term Physical Health Condition Indicator of Y or N","Records with a Long Term Physical Health Condition Indicator of U or Z. ","N/A","Records with a Long Term Physical Health Condition Indicator which is not Y,N,U or Z.","Records with no Long Term Physical Health Condition Indicator."]
["DQM24","Provisional Diagnosis","The first three characters of the Provisional Diagnosis is tested against a list of valid ICD-10 codes.","Provdiag","All distinct service referral records.","Records where the first 3 characters of the Provisional Diagnosis matches the first 3 character of a valid ICD10 code.","N/A","Records with a Provisional Diagnosis 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","Source of Referral is tested against the Source of Referral code list2 ","Sourcereferral","All distinct service referral records.","Records with a Source of Referral for Mental Health Code within A1-A3, B1-B2, C1-C2, D1, E1-E5, F1-F3, G1-G4,H1-H2, I1-I2, J1-J4, K1-K5, L1-L2 or M1-M5","M6","N/A","Records with a Source of Referral for Mental Health Code not within A1-A3, B1-B2, C1-C2, D1, E1-E5, F1-F3, G1-G4,H1-H2, I1-I2, J1-J4, K1-K5, L1-L2 or M1-M6","Records with no Source of Referral for Mental Health Code."]
["DQM26","Patient Health Questionnaire (PHQ 9) Score","PHQ9 Score is tested against the PHQ9 Score code list2 ","Phq9_Score","All attended appointment records","Attended records with a PHQ9  score between 0 - 27. ","N/A","N/A","Attended records with a PHQ9 score which is not between 0 - 27.","Attended records where no PHQ9 score is present."]
["DQM27","Generalised Anxiety Disorder (GAD 7) Score","GAD 7 score is tested against the GAD 7 Score code list2 ","Gad7Score","All attended appointment records","Attended records with a GAD7 score between 0 - 21.","N/A","N/A","Attended records with a GAD7 score which is not between 0 - 21.","Attended records where no GAD7 score is present."]
["DQM28","Work and Social Adjustment Scale Score","Work and Social Adjustment Scale Score is tested against the Work and Social Adjustment Scale Score code list2 ","Wsasscore","All attended appointment records","Attended records with a Work and Social Adjustment Scale Score between 0 - 40.","N/A","N/A","Attended records with a Work and Social Adjustment Scale Score not between 0 - 40.","Attended records where no Work and Social Adjustment Scale score is present."]
["DQM29","Appointment Type","Appointment Type is tested against the Appointment Type code list2 ","Apptype","All attended appointment records","Attended records with an appointment type between 01 - 06","Attended records with an appointment type of 07","Attended records with an appointment type of 08","Attended records with an appointment type not between 01 - 08","Attended records with no appointment type present."]
["DQM30","Therapy Type (Treatments)","Therapy Type is tested against the Therapy Type code list2 ","Thertype1, Thertype2, Thertype3 And Thertype4","Attended appointment records where the appointment type is 02,03 or 05.","Attended records with at least one therapy type present and where all of the therapy types 1-4, which are present have a code between 01 - 10 or 12 - 14.","Attended records with at least one therapy type present and where any of the therapy types 1-4, which are present have a code of 11 and any others present have a code of 01-14","N/A","Attended records where any of the therapy types 1-4, which are present have a code which is not between 01 - 14.","Attended records with no therapy type 1-4 present."]
["DQM31","Disability","Disability is tested against the Disability code list2 ","Disability","All Disability Records","Records with a Disability Code between 01 - 10 or XX","Records with a Disability Code NN or ZZ","N/A","Records with a Disability Code which is not between 01 - 10 or XX, NN or ZZ.","Records with no Disability 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-29-2011/1520292011spec.pdf"]
[]
["Further Note: "]
["For data item 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 © 2013, 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":26,"n_cols":4,"rows_kept":26,"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"]
["Postcode_District","Derived","Derived from Patient table Postcode of usual address and Gridall","Patients"]
["Pct_Of_Residence","Derived","Derived from postcode of usual address","Patients"]
["Age_End_Reporting_Period","Derived","Derived from Person birth date and reporting period end date","Patients"]
["Ethnicity","Submitted","Ethnicity","Patients"]
["Pct_Of_Gp_Practice","Derived","Derived from code of General Medical Practice code (Patients registration) and Gridall file","Patients"]
["Nhsnostatus","Submitted","NHSNOStatus","Patients"]
["Religion","Submitted","Religion","Patients"]
["Sexualorientation","Submitted","SexualOrientation","Patients"]
["Ltcondition","Submitted","LTCondition","Patients"]
["Provdiag","Submitted","ProvDiag","Referrals"]
["Sourcereferral","Submitted","SourceReferral","Referrals"]
["Phq9_Score","Submitted","PHQ9Score","Appointments"]
["Gad7Score","Submitted","GAD7Score","Appointments"]
["Wsasscore","Submitted","WSASScore","Appointments"]
["Apptype","Submitted","AppType","Appointments"]
["Thertype1, Thertype2, Thertype3 And Thertype4","Submitted","TherType1-4","Appointments"]
["Disability","Submitted","Disability","Disabilities"]