Data and Management information

What are the benefits?

Case study

What should be collected and why?

Who needs it?

 

What are the benefits?

Successful planning, commissioning, budgeting and continuous improvement are all dependent on the collection and interpretation of reliable data and the management of performance which follows. However, the Joint Review team regularly find that local authorities simply do not know how many people receive social services of what quality and at what cost

Analysis of finance and activity data is necessary to the process of budgeting for and costing of social care. Click here for an explanation of the Joint Review Team's finance and activity tool.

Management information is necessary for the monitoring of current performance and the planning of future service delivery

Performance indicators provide the authority with information on a range of issues necessary to understand whether it is adequately managing demand. These can be viewed on the KIGS database The indicators also compare the authority's performance against other authorities similar to itself.

Pefromance Indicators for English authorities

Click below to view national indicators for cost and efficiency

Households receiving intensive home care as a percentage of all adults and older people in residential/nursing care or receiving intensive home care

Cost of intensive care for adults and older people

Unit cost of residential and nursing care for older people

Unit cost of residential and nursing care for adults with learning disabilities

Unit cost of residential care for adults with mental health problems

Unit cost of residential care for adults with physical disabilities

Unit cost of home care for adults and older people

Click below to view national budget indicators

PSS budget for older people per head of population aged 65 and over

PSS budget for adults with physical disabilities per head of population aged 18-64

PSS budget for adults with learning disabilities per head of population aged 18-64

PSS budget for adults with mental health problems per head of population aged 18-64

PSS budget for service, strategy and regulation per head of population

Total PSS budget per head of population

PSS budget for expenditure not reported elsewhere per head of population

PSS budget allocated to asylum seekers per head of population

PSS budget allocated to other adult services per head of population

Click below to view national quality indicators

Percentage of users who said they got help quickly

Percentage of people going into residential/nursing care who were allocated single rooms

Percentage of items of equipment costing less than £1,000 delivered within 3 weeks

Percentage of people receiving a statement of their needs and how they will be met

Percentage of adults and older people receiving a review

Percentage of people in an acute hospital bed whose discharge was delayed

Percentage of all assessments undertaken that were for carers

Percentage of adults and older people waiting for 6 week or more for a care package

Performance Indicators for Welsh authorities

There are differences in the Performance Indicators in Wales - data is available from the Local Government Data Unit, http://www.lgdu-wales.gov.uk/eng/Data.asp

CASE STUDY

Using comparator data to understand why a budget is overspending

Authority X has a significant predicted overspend on older people's services and staff have been told by members that this will have to be managed down before the end of the financial year. Users and frontline staff say that neighbouring authorities provide more and better quality services for older people and are not talking about further reductions.

Stage 1 - Comparative Costs. Managers compare data on overall spend on older people, spend per capita and the costs of providing different sorts of services with other comparable/neighbouring authorities.

Stage 2 - Comparative Activity. Managers compare their activity with other authorities, looking at things like the numbers in residential/nursing care, the numbers receiving support to remain at home etc.

Stage 3 - Analysis. Managers use this data to make sense of why they appear to be able to provide less of a service. Is it about the level of overall expenditure, or expenditure on a particular bit of the service which may be particularly expensive? Is it about the numbers of people receiving a service as a whole, or the numbers receiving a more expensive service? Is it because they appear to be paying more than neighbouring authorities for similar services? Or is the information they are basing their analysis on so inadequate that they are unable at this point to reach any conclusion. Or is it a combination?

Getting through these three stages should not take too long, and taking a report back to members, staff and users at this point should enable a much more informed analysis of the problem and therefore a better informed solution. In this instance authority X identifies its major problems as being focused on the high use and cost of residential and nursing care

Stage 4 involves further more sophisticated analysis of the activity and costs data together with colleagues in health and in the provider units to confirm the accuracy of the data that is being used.

Stage 5 involves an audit of the decision making that led to residential and nursing home placements to see why these placements were chosen and what alternative services might have reduced the demand for residential and nursing care.

Stage 6 involves greater analysis of the costs of care and how these might be better managed through the commissioning process in partnership with local providers. At this point proposals should be taken to members on the strategy to reduce the costs/numbers of placements for older people.

Stage 7 will be the monitoring of the new strategy. This will also be an opportunity to test the effectiveness of analytical work that has been done and bring this back into wider learning about the use of data within the authority.

Stage 8 involves the development of more complex activity/cost monitoring systems, which enable the authority to monitor activity/expenditure on a day to day basis for instance tracking moves in and out of care to identify seasonal patterns, differential practice between teams, effectiveness of different community based services etc in order to improve the quality of care management and the responsiveness of the supply side

What should be collected and why?

  • Accurate information on all finance and activity data should be collected regularly and analysed. Some data needs to be looked at more frequently than others but monitor all budgets where there is significant activity monthly (see more).
  • Make sure that the data you collect is analysed by those who are close to the activity (for accuracy and to help inform them about how they are doing) as well as by those with strategic responsibilities

Who needs it?

  • Managers need information to plan the services they are going to deliver, to make sure the appropriate resources are available and to monitor delivery of those services.
  • A range of government departments require data from local authorities and use these Performance Indicators along with direct inspections of services to track national trends, ensure government policies are being delivered by individual authorities, value for money achieved and continuous improvements planned.
  • The Social Services Inspectorate, in England, soon to be merged with the National Care Standards Commission as the Commission for Social Care Inspection, provide assessment and inspection frameworks which ensure all local authorities meet required standards of care and have annual improvement plans. In Wales, the Social Services Inspectorate for Wales and the Care Standards Inspectorate for Wales remain independent of one another, although both remain accountable to the National Assembly for Wales. They are helped in this process by the Audit Commission both locally and nationally.

For more on information systems in social care click here

GOOD PRACTICE TIPS

Developing a performance management culture

  • Involve frontline staff in developing performance monitoring
  • Develop a culture at all levels in the authority that recognises the value of good information
  • Tell all staff about your performance, include your successes as well as your weaknesses
  • Audit data quality regularly, not just when there appears to be a big problem
  • Develop your own targets beyond Department of Health indicators to focus on areas where there are particular problems
  • Don't assume new IT systems will solve everything
  • Create systems that can link finance and activity data
  • Work with partners on information systems to ensure your developments will be compatible
  • Capitalise on new developments like the recent Improving Information Management Grant. E government and electronic records are high government priorities