Skip to main content
Clinical Epidemiology logoLink to Clinical Epidemiology
. 2021 Mar 16;13:215–223. doi: 10.2147/CLEP.S300663

Establishment of the SingHealth Diabetes Registry

Daniel Yan Zheng Lim 1, Sing Yi Chia 1, Hanis Abdul Kadir 1, Nur Nasyitah Mohamed Salim 1, Yong Mong Bee 2,3,
PMCID: PMC7982443  PMID: 33762850

Abstract

Purpose

To describe the inception and structure of the SingHealth Diabetes Registry (SDR) as well as the methodology used to set up the registry. The SDR was established to facilitate systematic and standardized data collection for diabetes mellitus within Singapore Health Services (SingHealth), which is an Academic Medical Center (AMC) and Singapore’s largest group of healthcare institutions. The diabetes casemix and outcome variables within the registry cohort are also provided.

Materials and Methods

The SDR is built from SingHealth’s electronic medical records (EMR) and clinical databases. It covers all individuals aged 18 and above with diabetes mellitus, excluding those with pre-diabetes. Cases are annually ascertained using criteria that include diagnosis codes, prescription records and laboratory test records. Data collection of casemix and outcome variables for the period 2013 to 2019 is complete.

Results

The SDR stands at 208,102 ascertained individuals, distributed across 8 healthcare sites within the AMC. The cohort is broadly reflective of the local gender and ethnic compositions but has a high proportion of older individuals with a mean age of 65.8 ± 13.7 years. Majority (>99%) have type 2 diabetes mellitus, with multiple other comorbidities (hypertension 84.1%, hyperlipidemia 86.2%, established cardiovascular disease 34.1%). At present, majority of individuals are able to meet key process indicators and 52.7% have a mean HbA1c of <7% (53 mmol/mol). Areas of potential improvement include increasing eye and foot screening rates, as well as glycemic control for the 19.5% of individuals with mean HbA1c >8% (64 mmol/mol).

Conclusion

The SDR is a large-scale, comprehensive, and representative diabetes registry that incorporates EMR data across the primary and hospital-based care continuum, in a major AMC in Singapore. The SDR has identified areas of improvement in diabetes processes and outcomes. It will support future quality assessment and improvements in diabetes care.

Keywords: diabetes mellitus, electronic data processing, epidemiology

Introduction

Diabetes is a major and growing health problem worldwide. In Singapore, the prevalence of diabetes among adult Singaporeans aged 18 to 69 years is at a high of 8.6% in 2017.1 Diabetes also accounted for 10.4% of the total burden of disease in the nation, resulting in approximately 57,000 years of life lost to death or ill health.2 There is an urgent need to improve diabetes outcomes in order to reduce the burden on patients and the health system.

High-quality, real-world data are necessary for health systems to improve diabetes care. Measurement of diabetes-related morbidity, comorbidity, outcomes of care, and causes for variation can allow targeting of appropriate health services improvements to high-risk populations and areas where service gaps exist.3,4 Systematic monitoring of treatment and outcomes over time also allows objective assessment of the quality of diabetes care and facilitates broader healthcare decision-making. Real-world clinical practices can be audited and benchmarked at the individual level, institution level and population level.5,6

Diabetes registries address the above needs through systematic and standardized data collection. Internationally, the only standard promulgated is defined by the International Consortium on Health Outcome Measurement (ICHOM).7 It specifies a set of casemix variables and outcome measures that can be used in setting up a diabetes registry. The standardized set allows comparison between different registries. However, each registry must determine how the relevant fields can be systematically populated from available data. Various diabetes registries have been set up internationally, with varying degrees of completeness and success.8

In Singapore, other diabetes registries include the National Healthcare Group Diabetes Registry (NHGDR),9 and the National Diabetes Database.10 The NHGDR has published data from a cohort spanning the years 2005 to 2008 comprising 170,513 individuals identified from electronic medical records, but more recent epidemiology has not been published. The National Diabetes Database was established in 2016 by the Ministry of Health as part of the local “War on Diabetes” to support healthcare policy, but its data is not publicly available for use in research or quality improvement. We hoped to expand on local efforts to capture up-to-date information on diabetes in the general population, taking into account the major changes in diabetes care over the past decade (viz new diagnostic criteria based on HbA1c,11,12 new drug class such as sodium-glucose cotransporter 2 (SGLT2) inhibitors, changes in type 2 diabetes treatment algorithms),13 and improving availability of such data.

Our institution, Singapore Health Services (SingHealth), is an Academic Medical Centre (AMC) and is the largest of the three healthcare clusters in Singapore. It consists of four acute hospitals, five national specialty centers, three community hospitals and eight primary care clinics (SingHealth Polyclinics),14 which cumulatively provide health services to approximately 50% of the population of Singapore. SingHealth has a comprehensive electronic medical records (EMR) system that spans the continuum of primary to quaternary care, with inpatient and outpatient data. The SingHealth Diabetes Registry (SDR) was populated from EMR systems and integrated data from existing clinical databases within the AMC. The aim was to provide a comprehensive overview of individuals with diabetes from available digital systems, to support clinical audit and quality improvement projects. This paper describes the methodology used to set up the SDR and provides an overview of the diabetes casemix within the registry cohort.

Materials and Methods

Administration and Governance of the SingHealth Diabetes Registry

The SDR covers all Singapore Citizens and Singapore Permanent Residents with diabetes mellitus, aged at least 18 years, that had healthcare encounters in any SingHealth institution. It was initiated in the year 2015 and has been populated with data backwards and forwards to cover the period 2013 to 2019. Individuals with pre-diabetes are excluded from this registry.

The establishment of the SDR was given overall approval by the SingHealth Centralised Institutional Review Board (CIRB). For this registry, participation requires no data collection beyond that of routine clinical care and poses no additional risks to clinical providers or their patients. Identifying information is only used to join data from different databases and is masked from all researchers querying the data. Hence, a waiver of written informed consent was granted by the CIRB. This study was also endorsed by the SDR Disease Registry Committee. The registry operates in compliance with Singapore's Personal Data Protection Act and the Human Biomedical Research Act, as well as other ethical guidelines based on the Declaration of Helsinki.15-17

Data Pipeline of the SingHealth Diabetes Registry

In Singapore, information technology for the public healthcare sector is centrally managed by the Integrated Health Information Systems (IHiS) agency. IHiS administers the SingHealth-IHiS Electronic Health INtelligence System (eHINTS), which is an enterprise data repository that integrates information from multiple healthcare transactional systems including clinical, administrative, and other ancillary systems. This includes the SingHealth EMR system, which has been the Sunrise Clinical Manager (SCM) EMR from Allscripts Healthcare Solutions since 1999.

Within SingHealth, other large disease-specific databases are maintained by tertiary medical institutes. We acquired and merged data regarding cardiovascular comorbidity from the Singapore Cardiac Data Bank (SCDB), a national cardiac disease and outcomes registry hosted by the National Heart Center Singapore.18,19 The same process was done for diabetic retinopathy screening data from the Singapore Integrated Diabetic Retinopathy Program (SiDRP) hosted by the Singapore National Eye Center.20

Ascertained individuals with diabetes are drawn into the SDR on an annual basis at the start of the following calendar year. The common key for data from the various systems is the Singapore National Registration Identification (NRIC) number, which is a national identifier that is unique to each individual. All data are staged in eHINTS before being uploaded into the registry. There is no manual data entry. All data is kept securely within an approved access-controlled facility in SingHealth, in a manner compliant with local privacy and data protection laws.

Diabetes Case Ascertainment Criteria

Individuals with diabetes mellitus, aged 18 and above, are identified electronically from the SingHealth EMR data via pre-specified case ascertainment criteria, which are described in Table 1. The criteria include diagnosis codes, prescription records and laboratory test records. As the different healthcare settings in our healthcare cluster use different standardized diagnosis codes (ICD9/10 CM for inpatients, SNOMED-CT for outpatients in tertiary institutions, and SingHealth Polyclinic (SHP) Working Diagnosis Codes for primary care clinics), we manually defined the relevant diagnostic codes for each setting. Prescription and laboratory test records are standardized across the healthcare cluster, and so a common definition was used. The laboratory definition of diabetes has been standardized to include fasting plasma glucose, 2-hour plasma glucose (oral glucose tolerance test), and HbA1c results, aligning to local Ministry of Health guidelines.11 HbA1c has been used as a diagnostic test for diabetes with a cut point of 6.5% for diagnosing diabetes.12,21,22 However, HbA1c test is used only as a screening test for diabetes in Singapore. Individuals with an HbA1c of 6.0–6.9% are recommended to undergo a conventional fasting plasma glucose test or oral glucose tolerance test (OGTT) and would be diagnosed accordingly. Regardless, based on local epidemiologic data, HbA1c 7.0% is a reasonable level to “rule in” the diagnosis of diabetes without further testing.23 We have hence adopted the 7.0% cut point in our ascertainment criteria.

Table 1.

Criteria Used for Case Ascertainment

Criteria Details Healthcare Setting
Diagnosis codes At least one primary or secondary ICD-9-CMa diagnosis codes of 250.xx, 362.0x, 357.2 or 366.41 Inpatient (pre-2012)
At least one primary or secondary ICD-10-CMa diagnosis codes starting with E10, E11, E13 or E14 Inpatient (2012 onwards)
At least one SNOMED-CT diagnosis code related to diabetes mellitus. (List of codes in Supplementary Table 1) Outpatient
At least one SingHealth Polyclinic (SHP) Working Diagnosis Codes for diabetes mellitus. (List of codes in Supplementary Table 2) Outpatient
Prescription records At least one glucose lowering drug (GLD) prescribed. Inpatient and outpatient
GLDs include biguanides, sulphonylureas, meglitinides, alpha-glucosidase inhibitors, thiazolidinediones, DPP-4 inhibitors, SGLT2 inhibitors, GLP-1 receptor agonists, and insulin preparations.
Laboratory test records Any one of the following: Inpatient and outpatient
- Positive oral glucose tolerance test (OGTT)
> fasting plasma glucose >/= 7.0 mmol/L and/or
> plasma glucose >/= 11.1 mmol/L at 2 hours
- HbA1c >/= 7.0%

Note: aICD-10-CM replaced the ICD-9-CM in 2012.

Data Collected by the SingHealth Diabetes Registry

For each individual, the SDR includes casemix variables and outcome variables. These were drawn from structured data fields within data source systems, and the definitions rigorously validated by domain experts within SingHealth. All extracted data undergo internal validation with inspection by data analysts and domain experts for anomalous values. Each individual also has process indicators examining the quality of diabetes management, which are derived from the above casemix and outcome variables.

We report in the results section the counts of individuals meeting diabetes case ascertainment criteria and summary statistics for casemix variables, as well as the summary of patients' meeting process indicators for each year. We also report the breakdown of HbA1c for each year, which is a major outcome measure for glycemic control.

Casemix variables include the following, and are detailed in Table 2:

  1. Demographics and lifestyle factors

  2. Diagnosis profile

  3. Treatment factors

  4. Anthropometric variables

Table 2.

Details of Casemix Variables

Category Items
Demographics and lifestyle factors Gender
Date of birth (used to calculate age)
Ethnicity (Chinese, Indian, Malay, Others)
Nationality
Postal code, housing type (derived from postal code)
Death date
Smoking status
Diagnosis Profile Diabetes type
Year of diagnosis
Comorbidities (Hypertension, hypercholesterolemia, established cardiovascular diseasea, ischemic heart disease, myocardial infarction, unstable angina, coronary artery bypass graft, cardiac catheterization, percutaneous coronary intervention, peripheral artery disease, cerebrovascular disease, ischemic stroke, hemorrhagic stroke, transient ischemic attack, angina pectoris, heart failure, atrial fibrillation)
Treatment factors Glucose lowering drugs (GLDs)
Anti-lipids
Anti-hypertensives
Anti-platelet
Anthropometric Height, weight, body mass index
Systolic blood pressure, diastolic blood pressure
Heart rate

Outcome variables include the following, and are detailed in Table 3:

  1. Laboratory results relating to diabetes control and other comorbidities

  2. Clinical episodes

  3. Surgical procedures

  4. Vaccinations

Table 3.

Details of Outcome Variables

Category Items
Laboratory results Glycemic indices: HbA1c, Glucose
Lipid panel (Total Cholesterol, HDL-cholesterol, LDL-cholesterol, Triglycerides)
Liver indices (Serum ALTa, ASTb, GGTc, albumin)
Renal indices (Serum urea, creatinine, potassium)
Urinalysis (Urine microalbumin/creatinine ratio, urine protein/creatinine ratio)
Hematological indices (Hemoglobin, white blood cell count, platelet count)
Serum creatine kinase
Serum NT-proBNP
Clinical episodes Hospital admissions, emergency department visits
Outpatient visits
Surgical procedures Bariatric surgeries
Lower extremity amputation
Lower limb bypass and revascularization
Coronary artery bypass grafting
Percutaneous coronary interventions
Vaccinations Influenza vaccination

Process indicators include the following:

  1. Body weight measurement

  2. HbA1c test

  3. Blood pressure measurement

  4. LDL-cholesterol measurement

  5. Eye assessment

  6. Kidney assessment

  7. Foot assessment

Use of the SingHealth Diabetes Registry for Research

We have implemented a formal workflow for requests of SDR data for research. All research requires ethical approval from the local Institutional Review Board, and concurrent review and approval by the SDR Disease Registry Committee. All data are anonymized before release to researchers, and researchers must sign a data use agreement that prohibits reidentification, and unauthorized data redistribution.

Results

The SDR presently stands at a total of 208,102 individuals. The breakdown of individuals identified by the ascertainment criteria of laboratory results, diagnosis codes, and medications are depicted in the form of a Venn diagram in Figure 1. The majority of individuals were observed to meet all three ascertainment criteria.

Figure 1.

Figure 1

Venn diagram of individuals identified by ascertainment criteria.

The individuals comprising the SDR were distributed among the various healthcare sites within our AMC. The healthcare site is defined as the hospital, specialty center, or primary care site that an individual had visited and received outpatient diabetes care defined by either a GLD prescription or having an HbA1c test done. We adopted this practical definition to identify individuals who are followed up at our AMC for routine diabetes care. Individuals who met diabetes case ascertainment criteria but could not be associated with any healthcare site within the AMC are labelled as having an “external” healthcare site. These individuals likely received routine diabetes care outside of our AMC.

The total number of individuals contributed by each healthcare site, and a short description of each healthcare site, are enclosed in Table 4. 52.1% were managed in a primary healthcare site, SingHealth Polyclinics (SHP), while 22.8% were managed in a tertiary healthcare site. The remaining individuals were deemed to be managed at external sites.

Table 4.

Total Counts of Individuals

Healthcare Site Acronym Description Individuals Contributed, n (%)
SHP SingHealth Polyclinics, comprising 8 primary healthcare clinics 116,576 (56.0)
SGH Singapore General Hospital, tertiary referral hospital 25,317 (12.2)
CGH Changi General Hospital, tertiary referral hospital 14,501 (7.0)
SKH Sengkang General Hospital, tertiary referral hospital 3611 (1.7)
KKH KK Women’s and Children’s Hospital, national pediatric and women’s hospital 2260 (1.1)
NHCS National Heart Center Singapore, national cardiac referral center 7672 (3.7)
NCCS National Cancer Center Singapore, national cancer referral center 640 (0.3)
SNEC Singapore National Eye Center, national ophthalmology referral center 72 (0)
External None of the above sites 37,453 (18.0)

We report in Table 5 the casemix. Important demographic variables (age, sex, ethnicity, smoking status), diagnosis profile (diabetes type, diabetes medications), and selected major comorbidities are reported.

Table 5.

Summary Statistics of All Individuals

Variable Overall Cohort (N=208,102) Cohort Excluding Patients Managed at External Site (n=170,649)
Mean age, years (SD) 65.8 (13.7) 65.9 (13.5)
Sex, n (%) Male 106,657 (51.3) 88,154 (51.7)
Ethnicity, n (%) Chinese 144,482 (69.4) 118,274 (69.3)
Malay 31,482 (15.1) 26,265 (15.4)
Indian 22,930 (11.0) 18,442 (10.8)
Others 9208 (4.4) 7668 (4.5)
Smoker, n (%) 16,948 (8.1) 14,668 (8.6)
Diabetes type, n (%) Type 2 206,591 (99.3) 169,407 (99.3)
Type 1 1271 (0.6) 1009 (0.6)
Other (eg gestational, monogenic, drug-induced, secondary diabetes) 240 (0.1) 233 (0.1)
Diabetes medications, n (%) Oral glucose-lowering medications only 129,124 (62.1) 119,236 (69.9)
Insulin preparations only 7419 (3.6) 6624 (3.9)
Oral glucose-lowering medications and insulin preparations 35,067 (16.9) 32,819 (19.2)
Hypertension, n (%) 175,059 (84.1) 150,443 (88.2)
Mean systolic blood pressure, mm Hg (SD) 133.7 (14.8) 133.7 (14.6)
Mean diastolic blood pressure, mm Hg (SD) 70.4 (8.2) 70.4 (8.2)
Hyperlipidemia, n (%) 179,434 (86.2) 157,862 (92.5)
Established cardiovascular disease, n (%) 70,952 (34.1) 61,680 (36.1)

For individuals who were managed within the AMC, we document below the counts and percentages of those meeting relevant process indicators in each year in Table 6.

Table 6.

Individuals Meeting Process Indicators

Process Indicator 2013 2014 2015 2016 2017 2018 2019
≥ 2 Body weight measurements 14,173 (17.4) 53,404 (60.0) 61,271 (65.1) 67,892 (68.8) 80,331 (82.0) 98,263 (83.7) 103,193 (83.5)
≥ 2 HbA1c tests 68,877 (84.7) 72,320 (81.3) 77,508 (82.3) 82,324 (83.4) 84,460 (86.2) 96,288 (82.0) 100,090 (81.0)
≥ 2 blood pressure measurements 69,491 (85.5) 66,035 (74.2) 75,089 (79.7) 79,086 (80.1) 89,114 (90.9) 109,443 (93.2) 115,218 (93.2)
≥ 1 LDL-c measurements 71,229 (87.6) 75,285 (84.6) 80,960 (86.0) 85,882 (87.0) 86,285 (88.1) 100,703 (85.8) 105,146 (85.1)
≥ 1 Eye assessmenta 50,455 (62.1) 57,056 (64.1) 60,853 (64.6) 65,744 (66.6) 65,465 (66.8) 70,671 (60.2) 74,944 (60.6)
≥ 1 Kidney assessmentb 74,633 (91.8) 80,245 (90.2) 86,089 (91.4) 91,131 (92.3) 91,605 (93.5) 109,720 (93.5) 115,969 (93.8)
≥ 1 Foot assessmentc 47,182 (58.0) 48,654 (54.7) 53,562 (56.9) 59,822 (60.6) 58,275 (59.5) 63,601 (54.2) 62,679 (50.7)

Notes: aEye assessment = Diabetic retinal photography (DRP) AND/OR visit to an ophthalmologist. bKidney assessment = Serum creatinine/eGFR AND/OR urine albumin–creatinine ratio (UACR) AND/OR urine protein–creatinine ratio (UPCR). cFoot assessment = Diabetic foot screen (DFS) AND/OR visit to a podiatrist.

Finally, we report in Figure 2 the distribution of mean HbA1c of the individuals managed within the AMC for each year. The mean HbA1c values are categorised into ranges reflecting differing levels of glycemic control. For the most recent year (2019), 64,296 individuals (52.7%) met the target of mean HbA1c <7% (53 mmol/mol), while 34,031 individuals (27.9%) had a mean HbA1c from 7–8% (53–64 mmol/mol), and 23,747 (19.5%) had a mean HbA1c >8% (64 mmol/mol).

Figure 2.

Figure 2

Distribution of mean HbA1c for individuals in the SDR in each year.

Discussion

Our registry relies on large-scale data collection via automated retrieval from EMR source databases and clinical databases. The main advantage of this approach is that manual data entry is not required, thus eliminating the need for inputs from healthcare staff beyond usual clinical care and reducing the burden of database maintenance. Minimal direct handling of patient records also decreases the risk of data privacy and security breaches. We are also able to achieve cross-disciplinary integration of data, for a more comprehensive view of the various facets of diabetes comorbidity and care.

However, we recognize that an EMR-based approach does have limitations.24 Records external to the electronic data systems drawn on cannot be directly captured, for example, laboratory results and prescriptions done at a different healthcare cluster. Furthermore, despite extensive internal validation of the data fields used in defining the registry, we acknowledge that it may be difficult to determine the accuracy of some data (eg comorbidities) without further external validation. Additional relevant information may also reside in unstructured free text records, which are challenging to parse and were not included in the current registry. These factors can cause unmeasured bias within the SDR, as with any other EMR-based registry. These potential limitations must be recognized by future studies. However, there are no other practicable ways to achieve such data collection at scale, and the large scale of data in itself can allow valid conclusions even if there are small sources of bias.

We believe that our ascertainment of patients with diabetes has high validity, given the general concordance between the three broad categories of ascertainment criteria (laboratory results, diagnosis codes, and medications). 66.6% of patients met all three criteria. However, we do note that small proportions of patients could only be identified with a single ascertainment criterion (8.7% diagnosis code only, 3.6% medications only, and 1.0% laboratory results only). It is thus important to consider all aspects of the digital footprint of individuals with diabetes, and other diabetes registry owners should take this into account during registry construction to avoid under-identification of their diabetes cohorts.

Our casemix is broadly reflective of the national gender and ethnic distributions.25 Individuals in this cohort are older, with a mean age of 65.8 ± 13.7 years. The overwhelming majority (>99%) have type 2 diabetes, and many have comorbid hypertension, hyperlipidemia, and established cardiovascular disease. This is congruent with recent literature on multimorbidity in Singapore,26 which shows that diabetes has a high co-occurrence rate with hypertension, hyperlipidemia, and cardiovascular disease. An important limitation to the analysis of casemix is that information on the socioeconomic status of individuals in the SDR is not directly available. This should be taken into consideration by future researchers, given that multimorbidity in Singapore has been shown to correlate with lower socioeconomic status. Additionally, although the vast majority of healthcare in Singapore is consumed within the public sector, it is possible that individuals of a higher socioeconomic status within the geographic catchment area have chosen privately managed healthcare. This is a potential minor contributor to selection bias in our casemix.

We note that the NHGDR,9 another local diabetes registry last described in 2008, also described frequent co-occurrence of diabetes with hypertension, hyperlipidemia, and cardiovascular disease, albeit in only 20–30% of individuals included. This stands in contrast to the SDR, which has 30–90% of patients having co-occurring cardiovascular morbidities. This may reflect better capture of co-morbidities due to widespread digitization over the past 10 years, with a complete transition to EMR within the SingHealth AMC. The patients in the SDR are also older, reflecting demographic transitions that have occurred during this period, and would also be expected to have a higher burden of comorbid disease.

Overall, the majority of the individuals in the SDR have met the process indicators. There have been sustained improvements in indicators, such as body weight measurement, blood pressure measurement, and biochemical measurements (eg HbA1c, LDL-cholesterol, estimated glomerular filtration rate, albuminuria). However, the current rates of eye and foot assessments are areas in which the AMC is aiming for improvement. Likewise, the distribution of HbA1c values has shown gradual improvement through the years, but almost 50% of individuals have not achieved a mean HbA1c of <7% (53 mmol/mol). While individuals in our cohort are older and have more liberal HbA1c targets, approximately 20% still have a mean HbA1c of >8% (64 mmol/mol). This is another area of improvement for the AMC.

Conclusion

The SDR is a large-scale and comprehensive diabetes registry that incorporates EMR data across the primary and hospital-based care continuum, in a major AMC in Singapore. The current cohort within the registry is representative of the national ethnic and gender distributions. The SDR has identified areas of improvement in the diabetes process and outcomes for improvement. It is hoped the SDR will continue to support quality assessment and improvements in diabetes care.

Acknowledgments

We acknowledge the support of the Health Service Research Unit (Singapore General Hospital), the Singapore Cardiac Data Bank (National Heart Center Singapore) and the Singapore Integrated Diabetic Retinopathy Program (Singapore National Eye Center).

Funding Statement

The establishment of the SDR was supported by the SingHealth Duke-NUS Medicine Academic Clinical Programme Clinical Innovation Support Programme Grant.

Disclosure

The authors report no conflicts of interest in this work.

References


Articles from Clinical Epidemiology are provided here courtesy of Dove Press

RESOURCES