Improving social care hospital discharges

The project is awarded £82,000 in funding through Round 6 of the Local Digital Fund to begin a discovery phase.

The project has recently begun its discovery phase and the project team have met with key stakeholders from the health and social care sector, including the charity sector, to outline their goals. The team has run workshops to understand the hospital discharge process, involving a group of around 15 people.

The team has also identified data leads for each part of the process and started meeting with them to better understand data availability and quality. They are trying to identify quick wins and determine which part of the process to focus on for the most significant impact in the least amount of time. The partner councils, Manchester and Oldham, have been involved in some of the workshops, and the team is exploring whether there is a common solution for process and data issues.

Due to the school half term holiday, progress for the Stockport project team has been slower compared to previous sprints. However, they have been focussed on ensuring social care and Transfer of Care Hub colleagues can access the online form to begin capturing the necessary data from the three remaining sites. They have also been working on Information Governance (IG) aspects, including drafting the DPIA, which is currently under review by colleagues.

To build a data history for future planning, the team has developed a method to archive the captured data. They are also providing health colleagues with access to this data, ensuring compliance with IG regulations.

During the next sprint, the dashboard will be used for the time during a weekly system steering group, where senior health and care colleagues will provide valuable feedback.

The Stockport project team have published the prototype dashboard and received feedback on capacity, length of stay, and reasons for delayed discharge. The team found the capacity and length of stay data useful, particularly when broken down by location.

Towards the end of July, the Stockport project team have primarily worked on improving the data capture form by adding new fields. The redesigned form now contains key questions about delayed discharge, such as medications, transport, social care and Continuing Healthcare (CHC). Another new development includes an ‘active bed’ flag to identify whether a bed is occupied or not, which was an issue the initial prototype faced.

In the upcoming weeks, they will ensure everyone has access to the form to capture data daily. The focus throughout Spring will be monitoring the data quality and the dashboard. This will also be shared with wider colleagues for feedback on its usefulness.

The team have completed a number of training sessions with therapists, therapy leads and assistants, discharge coordinators and ward trackers. The sessions covered how to enter data correctly into the online form and what the data will be used for. Data is now available for the majority of beds, however there are a few data quality issues to resolve.

In addition to this, the team has also spent time ‘replumbing’ the dashboard from NHS to council infrastructure. Once the data has been fully populated and is updated regularly, trend information will be available to monitor changes over time and impact and identify improvements.

The team have now delivered several training sessions, and most of the required data has been successfully entered. This has enabled the team to establish a baseline assessment for all available beds. Regular data updates are ongoing, with summaries presented at weekly meetings for senior colleagues’ review.

With most of the essential data now available, the project team plans to gather initial feedback from senior stakeholders on the new intelligence. They are also preparing for the analysis phase, where they will collect more detailed feedback from all team members involved, including those entering the data and customers of the data. This feedback gathering is scheduled for the next 4–6 weeks.

The project team is currently in the testing phase, assessing the data’s usefulness and making necessary adjustments to the dashboard. Team members are using this data for discussions, particularly around capacity and client status change.

In addition, the team are evaluating the prototypes through surveys and meetings, gaining valuable insights, and looking for feedback from Manchester and Oldham to join the next project phase. The scope of this next phase will be determined during the next sprint.

The project team has successfully resolved data quality issues and made improvements to their dashboard.

The updated dashboard is now being used regularly by colleagues, informing discussions around capacity and reasons for client status not changing. They are sharing dashboard updates with key colleagues across the NHS and the local authority daily.

The Stockport project team has developed the Tableau Dashboard to include trend data and structured this to send automated email distribution as a PDF for key stakeholders. They’ve implemented a routine for loading the data several times a day, ensuring the dashboard refreshes automatically with new data.

Additionally, they’ve created a proof of concept for a form linked to a SharePoint list to reduce input errors and improve data quality.

Currently, the team is concluding the discovery project and actively engaging with stakeholders to share insights and collect feedback. The next step involves drafting a summary slide desk based on their findings.

The Stockport project team have completed their discovery project and are currently finalising and sharing their learning.