Linking observational data from general practice, hospital admissions and diabetes clinic databases: can it be used to predict hospital admission?

backgroundLinking process of care data from general practice (GP) and hospital data may provide more information about the risk of hospital admission and re-admission for people with type-2 diabetes mellitus (T2DM). This study aimed to extract and link data from a hospital, a diabetes clinic (DC). A second aim was to determine whether the data could be used to predict hospital admission for people with T2DM.

methodsData were extracted using the GRHANITE™ extraction and linkage tool. The data from nine GPs and the DC included data from the two years prior to the hospital admission. The date of the first hospital admission for patients with one or more admissions was the index admission. For those patients without an admission, the census date 31/03/2014 was used in all outputs requiring results prior to an admission. Readmission was any admission following the index admission. The data were summarised to provide a comparison between two groups of patients: 1) Patients with a diagnosis of T2DM who had been treated at a GP and had a hospital admission and 2) Patients with a diagnosis of T2DM who had been treated at a GP and did not have a hospital admission.

resultsData were extracted for 161,575 patients from the three data sources, 644 patients with T2DM had data linked between the GPs and the hospital. Of these, 170 also had data linked with the DC. Combining the data from the different data sources improved the overall data quality for some attributes particularly those attributes that were recorded consistently in the hospital admission data. The results from the modelling to predict hospital admission were plausible given the issues with data completeness.

conclusionThis project has established the methodology (tools and processes) to extract, link, aggregate and analyse data from general practices, hospital admission data and DC data. This study methodology involved the establishment of a comparator/control group from the same sites to compare and contrast the predictors of admission, addressing a limitation of most published risk stratification and admission prediction studies. Data completeness needs to be improved for this to be useful to predict hospital admissions.