Construction of a linked health and social care database resource: lessons on process, content and culture

Miles D. Witham (Lead / Corresponding author), Helen Frost, Marion McMurdo, Peter T. Donnan, Mark McGilchrist

    Research output: Contribution to journalArticle

    8 Citations (Scopus)

    Abstract

    Background: Combining routinely collected health and social care data on older people is essential to advance both service delivery and research for this client group. Little data is available on how to combine health and social care data; this article provides an overview of a successful data linkage process and discusses potential barriers to executing such projects.
    Methods and results: We successfully obtained and linked data on older people within Dundee from three sources: Dundee Social Work Department database (30 000 individuals aged 65 years and over), healthcare data held on NHS Tayside patients by the Health Informatics Centre (400 000 individuals), Dundee, and the Dundee of Medicine for the Elderly rehabilitation database (4300 individuals). Data were linked, anonymized and transferred to a Safe Haven environment to ensuring confidentiality and strict access control. Challenges were faced around workflows, culture and documentation. Exploiting the resultant data set raises further challenges centered on database documentation, understanding the way data were collected, dealing with missing data, data validity and collection at different time periods.
    Conclusion: Routinely collected health and social care data sets can be linked, but significant process barriers must be overcome to allow successful linkage and integration of data and its full exploitation.
    Original languageEnglish
    Pages (from-to)229-239
    Number of pages11
    JournalInformatics for Health and Social Care
    Volume40
    Issue number3
    Early online date20 Mar 2014
    DOIs
    Publication statusPublished - 1 Sep 2015

    Fingerprint

    Databases
    Delivery of Health Care
    Information Storage and Retrieval
    Documentation
    Informatics
    Workflow
    Confidentiality
    Social Work
    Rehabilitation
    Medicine
    Health
    Research
    Datasets

    Keywords

    • Database
    • Medical record linkage
    • Older
    • Social work

    Cite this

    @article{5182fbae04cc48cb87f04f95918d1e49,
    title = "Construction of a linked health and social care database resource: lessons on process, content and culture",
    abstract = "Background: Combining routinely collected health and social care data on older people is essential to advance both service delivery and research for this client group. Little data is available on how to combine health and social care data; this article provides an overview of a successful data linkage process and discusses potential barriers to executing such projects.Methods and results: We successfully obtained and linked data on older people within Dundee from three sources: Dundee Social Work Department database (30 000 individuals aged 65 years and over), healthcare data held on NHS Tayside patients by the Health Informatics Centre (400 000 individuals), Dundee, and the Dundee of Medicine for the Elderly rehabilitation database (4300 individuals). Data were linked, anonymized and transferred to a Safe Haven environment to ensuring confidentiality and strict access control. Challenges were faced around workflows, culture and documentation. Exploiting the resultant data set raises further challenges centered on database documentation, understanding the way data were collected, dealing with missing data, data validity and collection at different time periods.Conclusion: Routinely collected health and social care data sets can be linked, but significant process barriers must be overcome to allow successful linkage and integration of data and its full exploitation.",
    keywords = "Database, Medical record linkage, Older, Social work",
    author = "Witham, {Miles D.} and Helen Frost and Marion McMurdo and Donnan, {Peter T.} and Mark McGilchrist",
    year = "2015",
    month = "9",
    day = "1",
    doi = "10.3109/17538157.2014.892491",
    language = "English",
    volume = "40",
    pages = "229--239",
    journal = "Informatics for Health and Social Care",
    issn = "1753-8157",
    publisher = "Taylor & Francis",
    number = "3",

    }

    TY - JOUR

    T1 - Construction of a linked health and social care database resource

    T2 - lessons on process, content and culture

    AU - Witham, Miles D.

    AU - Frost, Helen

    AU - McMurdo, Marion

    AU - Donnan, Peter T.

    AU - McGilchrist, Mark

    PY - 2015/9/1

    Y1 - 2015/9/1

    N2 - Background: Combining routinely collected health and social care data on older people is essential to advance both service delivery and research for this client group. Little data is available on how to combine health and social care data; this article provides an overview of a successful data linkage process and discusses potential barriers to executing such projects.Methods and results: We successfully obtained and linked data on older people within Dundee from three sources: Dundee Social Work Department database (30 000 individuals aged 65 years and over), healthcare data held on NHS Tayside patients by the Health Informatics Centre (400 000 individuals), Dundee, and the Dundee of Medicine for the Elderly rehabilitation database (4300 individuals). Data were linked, anonymized and transferred to a Safe Haven environment to ensuring confidentiality and strict access control. Challenges were faced around workflows, culture and documentation. Exploiting the resultant data set raises further challenges centered on database documentation, understanding the way data were collected, dealing with missing data, data validity and collection at different time periods.Conclusion: Routinely collected health and social care data sets can be linked, but significant process barriers must be overcome to allow successful linkage and integration of data and its full exploitation.

    AB - Background: Combining routinely collected health and social care data on older people is essential to advance both service delivery and research for this client group. Little data is available on how to combine health and social care data; this article provides an overview of a successful data linkage process and discusses potential barriers to executing such projects.Methods and results: We successfully obtained and linked data on older people within Dundee from three sources: Dundee Social Work Department database (30 000 individuals aged 65 years and over), healthcare data held on NHS Tayside patients by the Health Informatics Centre (400 000 individuals), Dundee, and the Dundee of Medicine for the Elderly rehabilitation database (4300 individuals). Data were linked, anonymized and transferred to a Safe Haven environment to ensuring confidentiality and strict access control. Challenges were faced around workflows, culture and documentation. Exploiting the resultant data set raises further challenges centered on database documentation, understanding the way data were collected, dealing with missing data, data validity and collection at different time periods.Conclusion: Routinely collected health and social care data sets can be linked, but significant process barriers must be overcome to allow successful linkage and integration of data and its full exploitation.

    KW - Database

    KW - Medical record linkage

    KW - Older

    KW - Social work

    UR - http://www.scopus.com/inward/record.url?scp=84937217814&partnerID=8YFLogxK

    U2 - 10.3109/17538157.2014.892491

    DO - 10.3109/17538157.2014.892491

    M3 - Article

    C2 - 24650248

    VL - 40

    SP - 229

    EP - 239

    JO - Informatics for Health and Social Care

    JF - Informatics for Health and Social Care

    SN - 1753-8157

    IS - 3

    ER -