Visual displays of Re Qo L data Tom

Visual displays of Re. Qo. L data Tom Evans Information Analyst Specialist Leeds and York Partnership NHS Foundation Trust thomasevans@nhs. net 29 November 2018 integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Re. Qo. L in Leeds Initial pilot with eight clinical teams from 14 November 2016 to 14 June 2017 • 1 community mental health team (CMHT) • 1 intensive community service (ICS) • 1 female adult acute ward • 1 locked rehabilitation ward • 1 rehabilitation community team • 1 supported rehabilitation ward • 1 independent rehabilitation ward integrity || simplicity || caring Pilot: • • 1291 Re. Qo. Ls offered 1126 Re. Qo. Ls completed 513 service users 8 clinical teams Trust total to date: • • 4012 Re. Qo. Ls offered 3457 Re. Qo. Ls completed 1836 service users 15 clinical teams www. leedsandyorkpft. nhs. uk

Data flow Electronic Patient Record • PARIS (Civica) Data warehouse • Microsoft SQL Server (internal development) Business Intelligence tool integrity || simplicity || caring • Cognos 10. 2 (IBM) www. leedsandyorkpft. nhs. uk

Management / Performance view • How many service users: • Have been offered a Re. Qo. L? • Have completed 2 or more Re. Qo. Ls? • What is the average: • Initial score? • Score change? integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Re. Qo. Ls completed by clinical team integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Average initial scores by clinical team integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Average score change by clinical team integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Re. Qo. L completion distribution integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Rehabilitation & Recovery Service • Single service, three distinct clinical teams: • Supported rehabilitation ward – Asket Croft (20 beds) • Independent rehabilitation ward – Asket House (16 beds) • Community assessment and care co-ordination team (current community caseload of 63 service users, plus 36 inpatients) • Current average length of stay: • Asket Croft – 307 days • Asket House – 407 days • Inpatients have MDT meetings every three weeks • 26 / 35 have completed at least one Re. Qo. L (74%) • 21 / 35 have completed at least two Re. Qo. Ls (60%) • Community caseload • 38 / 63 have completed at least one Re. Qo. L (60%) • 23 / 63 have completed at least two Re. Qo. Ls (37%) • Consider the three teams as a single service integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Clinical / Service user view • Reliable improvement • Score change of +5 or more • Reliable deterioration • Score change of -5 or less • No reliable change • Score change between -5 and +5 • Clinically significant change • Score change of +5 or more • First score between 0 and 24 (clinical range) • Second or later score between 25 and 40 (general population range) integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Rehab & Recovery Service integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Service user scores over time (1) Please note: In the Re. Qo. L guidance, minimum clinical difference is the same as reliable change. integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Service user scores over time (2) Please note: In the Re. Qo. L guidance, minimum clinical difference is the same as reliable change. integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Next steps • Automated delivery of individual service user graphs • HTML or PDF graph of Re. Qo. L scores over time • Delivered the day after the Re. Qo. L is recorded on the electronic patient record • By email • To the clinician recorded as carrying out the assessment • Roll out of Re. Qo. L to more clinical teams • Embed Re. Qo. L within clinical processes • More data! integrity || simplicity || caring www. leedsandyorkpft. nhs. uk

Thank you Any questions? integrity || simplicity || caring www. leedsandyorkpft. nhs. uk