Extract, Transform, and Load (ETL) is a process in data warehousing that involves
* extracting data from outside sources,
* transforming it to fit business needs (which can include quality levels), and ultimately
* loading it into the end target, i.e. the data warehouse.
The Primary Care Home (PCH) programme is delivering a range of benefits for patients, staff and the wider health system, according to a new report released today (Friday 31 March).
The care home residents in Rushcliffe receive an ‘enhanced’ care package as part of the Principia Partners in Health multispecialty community provider vanguard, which includes regular visits from a named GP and independent support from Age UK Nottingham and Nottinghamshire. Greater support for care home managers and community nurses is also provided, for example through a peer-to-peer network.
The Leeds Mental Health Flow aims to deliver radical, system-wide, sustainable change to improve quality of care for patients, improve patient experience and improve the system that supports this. We started this improvement journey in September 2016 with a four day rapid improvement event with around 40 clinicians, health workers and managers from across the Leeds health and social care system.
We heard that the UK government is seeking to improve the working systems between primary care and Accident and Emergency teams in England to help reduce pressure on services and cut waiting times for patients.
So we thought you might like to hear about our experiment that has been coproduced between patients, primary care staff, ambulance staff and emergency room (ER) staff in Jönköping County Region. Our scheme is the first of its kind in Sweden.
Meet Healthwatch Harriet.
The tenacious 10-year-old has turned her sights on the NHS England new care models programme. In her new video, she meets new care models programme director Louise Watson, chair of Tower Hamlets CCG Sir Sam Everington, and Hertfordshire County Council’s director of health and community services Iain MacBeath and asks them: “What on earth is a vanguard?”
Public Accounts Committee publish report on integration of health and social care
Committee describe Better Care Fund as a “ruse” and say that it has made no progress in reducing emergency admissions or delayed transfers of care
We say long term solution to social care funding must bring together NHS trusts and local authorities
The CCG launched reviews of some of the services it commissions in February to ensure that everybody in Shropshire has access to healthcare that is safe, high-quality and affordable for the future. [Includes community services review]
As of April 1 2017, Lancashire Care will work in partnership with Blackburn with Darwen Council and other voluntary sector providers to deliver the new, fully integrated, Healthy Child Programme.
Following a competitive tendering process, the new programme will build on previous achievements in the borough by bringing together health visiting, school nursing, specialist infant feeding and other third sector services to provide a consolidated public health service for children aged 0-19 years.
This report looks at the most promising reform solutions that have been correctly identified by STPs, and also sets out the range of challenges that stand in the way of them realising their vision for improved health and efficiency.
A recent Lancet paper gives an interesting perspective. Researchers looked at elements of dependency including continence, cognition and self-reported activities of daily living in two cohorts of people aged over 65 – one cohort recruited in 1991 and the other in 2011.
The bottom line finding from this research is that the men and women studied in 2011 were living, on average, an additional 2.4 and 3 years respectively with substantial care needs. Even with a radical shift towards healthy active ageing, it’s unlikely that a hypothetical 2031 cohort would show anything but an increase in the total number of older people living with dependency.
The number of admissions to hospital are rising steeply and are outstripping increases in the NHS budget, according to new analysis published today by The King’s Fund.
Now our microbiologists, who are infection specialists, visit the wards every day to see every patient who is receiving intravenous antibiotics. Where appropriate, patients are either switched to oral antibiotics and discharged, or switched to the Outpatient Parenteral Antimicrobial Therapy (OPAT) service and discharged.
The patients recruited to OPAT are provided with an information leaflet and changed to intravenous antibiotics that can be given once per day. They then come to hospital daily as outpatients and hospital transport can be arranged, if required. The OPAT Clinic is a patient-friendly area where patients can relax in comfortable chairs, whilst receiving their treatment. The microbiology team clinically lead the service, direct the antimicrobial treatment and refer to other specialists when appropriate. As the service is infection specialist-led, a wider range of infectious diseases can be accepted for treatment.
As Birmingham and Solihull join the Integrated Personal Commissioning Programme (IPC), John Short explains why he believes IPC will work well for people with enduring mental health needs, as a way to offer people the flexibility they need to find their own route to recovery.
Transforming how health and care services are delivered can be both exhilarating and fiendishly difficult. The recent publication of some sustainability and transformation plans (STPs) has now brought both these issues to the fore. The plans reveal considerable ambitions to integrate services, embrace population-based healthcare and bite the bullet on painful service reconfigurations.