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 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.
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
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.
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?”
The objective was to provide real, honest insight into the challenges and hurdles that had been faced when designing new services. It also gave the opportunity to showcase some of the successes achieved so far.
The diagnosis then, as now, was that our problem was not quality or efficiency but our ability to effectively meet the rising demand of a largely ageing and affluent population. Chris urged us to take action and to learn the lessons of integration from around the world, particularly the experiences in Canterbury, New Zealand.
In this welcome update, Anna Charles builds on Nick Timmins and Chris Ham’s initial review of the experiences of Canterbury and reflects on the implications for new models of care and for sustainability and transformation partnerships. It is a must read for anyone developing models of community integration.
Over the past five years, the government and national NHS bodies have conducted a unique experiment: running health services as a planned system against the backdrop of a contradictory legislative framework, one that envisages arm’s length contracting relationships between purchasers and providers, independent provider organisations, and a significant role for competition. In doing so, they have turned their backs not just on the Health and Social Care Act 2012, but on almost three decades of reforms: separate commissioners, foundation trusts, payment for activity and patient choice among others.
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 STP has been updated recently to build on our earlier progress and it takes account of feedback we have received from many of our key stakeholders.
This paper presents NHS bed data from across the UK in one place. The data demonstrates the increasing pressures on the system in each nation. It provides evidence of the underlying cracks within the NHS.
As the new care models programme begins its third year, people working across the programme, both nationally and locally have been exploring how they can ensure the success of the new care models are spread across health and care services.
Samantha Jones, director of the new care models programme recently shared her top tips for vanguards and others developing new models of care on how they might help do this.
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).
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.