1 / 22

Data linking – Project update

Data linking – Project update. 27th February 2014 – Social care event Atlantic Quay Ellen Lynch & Euan Patterson. Overview. Project aims Pilot update Pilot aims Participating local authorities Pilot phase 3 time scales Planned analysis Project roll out Planned analysis

kenley
Download Presentation

Data linking – Project update

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Data linking – Project update 27th February 2014 – Social care event Atlantic Quay Ellen Lynch & Euan Patterson

  2. Overview • Project aims • Pilot update • Pilot aims • Participating local authorities • Pilot phase 3 time scales • Planned analysis • Project roll out • Planned analysis • Future social care data linkage developments • Health & social care integration • Breakout Session

  3. Aims of project • Evidence the interactions between social care, housing support and health • Evidence for service planning and service evaluation • Evidence the outcomes of people who use these services • Evidence for indicators • Share and link data based on international data linking best practice • e.g. separation of personal data to attribute data • Develop statistical/research skills of analysts across Scottish Government (SG), Information Services Division (ISD), NHS Boards and local authorities • Collaborate with other researchers to maximise the use of data and increase our range of evidence

  4. Pilot Update • Scottish Government (SG) wrote to Directors of Social Work in Autumn 2011 asking for volunteers to participate in the pilot. • Data sharing agreement issued (September 2012) to local authorities who volunteered to participate in the pilot. • 12 local authorities have returned signed data sharing agreements. • Pilot dataset contains data for Clackmannanshire, Edinburgh, South Ayrshire, South Lanarkshire and Stirling. • Next pilot phase will add Argyll & Bute, East Renfrewshire, Eilean Siar, Highland , North Ayrshire, East Dunbartonshire and Scottish Borders

  5. Next steps for remaining Pilot LA’s • Send 2010 & 2011 client information to ISD for CHI Indexing and creation of encrypted linkage ID (March 2014) • Check file returned and match linkage ID’s to original Client ID’s • Send required ID’s to SG via ProcXed (April 2014) • SG conduct cross checks and create attribute (payload) files for sending to ISD (May 2014) • Data added to linked pilot datasets (May 2014)

  6. Review of pilot (so far) • Instructions document improved • Templates tested successfully • Issues with data transfer from LA to ISD identified • IT issues, such as installing required software and firewall reconfiguration • Developing alternative secure data transfer methods with ISD • Data transfer from SG to ISD tested successfully • Create derived variables • Finalise first full release of metadata (Spring 2014)

  7. Review of pilot (so far) cont…... • Initial Analysis (2014-) • Review pilot (2014) • Establish code bank (2014) • Establish analytical network?? • Produce analytical papers with colleagues in local authorities/NHS Boards • Disseminate analyses across Scottish Government, NHS Boards, local authorities (2014)

  8. Lessons learnt • The pilot has demonstrated a number of direct benefits of linking data including: • Improved analytical evidence around the interactions between social care, housing support and health. • Improved sharing of knowledge between analysts across organisations. • Improved data quality (particularly for the social care data). • Improved analytical skills.

  9. Lessons learnt • Actions for ALL • Preparation of data: Data cleaning, removal of duplicates. • Read PIA document • Data Sharing Agreement • Read instructions for data sharing process • Complex project: • Multiple organisations • Multiple teams • Deadlines • Important to try and meet as impact on every team and across multiple organisations • If you can’t meet the deadline, please get in touch as early as possible • A lot of the preparation can be done in advance.

  10. Full project roll out • Required to provide the Privacy Advisory Committee a report of the pilot. If granted approval, 2012 data onwards can be linked and project will be rolled out across remaining local authorities. • For 2014 Social Care data - CHI Indexing of data - CHI provided for operation use once data sharing agreement in place • From Autumn 2014 (Historic Data) • Home care and Direct payments data for 2010, 2011, 2012 • Social care data 2013 • Mental Health Benchmarking

  11. Analytical plan (1) • 3 initial main areas of analysis: • Improving the analytical evidence around people with dementia • Using social care, SMR 01, SMR 04 and prescribing data to derive a dementia flag • Evidence dementia patient health & social care pathways

  12. Analytical plan (2) • Improve the analytical evidence around people with mental health problems and for those who have died by probable suicide • Using social care, SMR 01, SMR 04 and deaths data to derive a mental health flag and a suicide flag. • Evidence health & social care pathways

  13. Analytical plan (3) • To evidence if patients with multiple unplanned admissions to hospital have a social care package in place and/or on multiple prescriptions, and how changes in social care packages/multiple prescriptions impact on unplanned admissions. • Includes estimating costs of health & social care packages

  14. Analytical plan cont….. • Papers will contain local authority/NHS Board level analysis where possible. • Dashboard • Those local authority/NHS Board analysts who have noted interest in accessing data via safe haven then Scottish Government will be in touch over the next couple of months about next steps/requirements. • Suggestions of future analysis welcome!

  15. Future social care data linkage development • Care Home flag based upon postcode recorded upon CHI. Will identify periods when an individual is resident in a care home. • Include Scottish Care Home Census long stay residents • Personal identifiers added to census from 2012/2013 • Potential project to link social care data to the 2011 population census to study: • formal and informal care • Household composition (e.g. single person households) • Project is flexible to enable further social care data to be linked if your partnership wishes (and indeed other datasets)

  16. Other data developments • Community health • Intermediate care • Scottish Primary Care Information Resource (SPIRE) • http://www.spire.scot.nhs.uk/ • Aiming to be live by the end of 2014/15

  17. Other research projects utilising social care data • SG have promoted the use of social care and the linked data to the academic community to enhance the evidence around social care and health.

  18. Health & social care integration (1) • The Public Bodies (Joint Working) (Scotland) Bill provides the legislative framework for integration of health and social care in Scotland. • The legislation will require Health Boards and Local Authorities to put in place integrated governance arrangements for adult health and social care. • New integrated health and social care partnerships will oversee development and delivery of joint strategic commissioning plans that focus on preventative and anticipatory care, and the wellbeing of patients, service users, carers and families, within the context of national outcomes for health and wellbeing that are defined in legislation and integrated budgets for health and social care .

  19. Health & social care integration (2) • Health Boards and Local Authorities will integrate health and social care services from April 2015. • Local partnerships are now establishing shadow arrangements, and work is currently underway to produce joint strategic commissioning plans. • You can find more information about the Bill here: • http://www.scottish.parliament.uk/parliamentarybusiness/Bills/63845.aspx

  20. Breakout session: Health & Social Care Integration 1 • Are you aware of your local integration model? • Body corporate model • Delegation between partners model (sometimes known as a lead agency model) • Are we collecting the right information to inform strategic planning which is a main focus in the bill? • Do we need to make any changes to the Social Care data collection? • Will the bill have any impact on how data is collected? e.g. are you planning to have joint systems with Health? • Are you linking health & social care data locally? • Are you analysing linked health & social care data locally? • Are you working in partnership with NHS Board colleagues to do this? • Are you working with universities to do this?

  21. Breakout Session – Linked data analysis • Initial Analysis from pilot • Social Care data for 2010 and 2011 linked for the first time • Dementia Cohort • Feedback • Format/Style • Functionality • Drill down options • Comparisons • Mapping?? • What you’d like to see? • Would any LA information officers/analysts wish to collaborate with us? • Could be to: • Develop methodology • Develop syntax • Develop ways to present analysis • Email SWStat@scotland.gsi.gov.uk

  22. Further information • Linking social care, housing & health data project: • http://www.scotland.gov.uk/Topics/Statistics/Browse/Health/Datalinking/HealthSocialCareandHousin • Ellen Lynch / Euan Patterson / Julie Rintoul / David Scott • SWStat@scotland.gsi.gov.uk

More Related