- Research article
- Open Access
- Open Peer Review
This article has Open Peer Review reports available.
Validation of diabetes mellitus and hypertension diagnosis in computerized medical records in primary health care
© de Burgos-Lunar et al; licensee BioMed Central Ltd. 2011
Received: 28 December 2010
Accepted: 28 October 2011
Published: 28 October 2011
Computerized Clinical Records, which are incorporated in primary health care practice, have great potential for research. In order to use this information, data quality and reliability must be assessed to prevent compromising the validity of the results.
The aim of this study is to validate the diagnosis of hypertension and diabetes mellitus in the computerized clinical records of primary health care, taking the diagnosis criteria established in the most prominently used clinical guidelines as the gold standard against which what measure the sensitivity, specificity, and determine the predictive values.
The gold standard for diabetes mellitus was the diagnostic criteria established in 2003 American Diabetes Association Consensus Statement for diabetic subjects. The gold standard for hypertension was the diagnostic criteria established in the Joint National Committee published in 2003.
A cross-sectional multicentre validation study of diabetes mellitus and hypertension diagnoses in computerized clinical records of primary health care was carried out. Diagnostic criteria from the most prominently clinical practice guidelines were considered for standard reference.
Sensitivity, specificity, positive and negative predictive values, and global agreement (with kappa index), were calculated. Results were shown overall and stratified by sex and age groups.
The agreement for diabetes mellitus with the reference standard as determined by the guideline was almost perfect (κ = 0.990), with a sensitivity of 99.53%, a specificity of 99.49%, a positive predictive value of 91.23% and a negative predictive value of 99.98%.
Hypertension diagnosis showed substantial agreement with the reference standard as determined by the guideline (κ = 0.778), the sensitivity was 85.22%, the specificity 96.95%, the positive predictive value 85.24%, and the negative predictive value was 96.95%. Sensitivity results were worse in patients who also had diabetes and in those aged 70 years or over.
Our results substantiate the validity of using diagnoses of diabetes and hypertension found within the computerized clinical records for epidemiologic studies.
In recent decades, Computerized Clinical Records (CCR) are being used in the routine medical practice of primary health care (PHC) in the Spanish National Health System (NHS). Indeed, by 2007, 98.8% of general practices were computerized and 88% of the population had a primary care electronic health records . There are many software systems to manage the CCR. In Spain the most frequently implemented CCR is the OMI-AP® program.
Other countries like Canada, the United States of America, and some European Countries have a significant experience using computerized health databases obtained with PHC records [2–4]. The most widely used is the GPRD (General Practice Research Database), which contains information introduced prospectively since 1987 by more than 1,500 general practitioners (GPs) in the PHC of the United Kingdom and includes 7% of the population . The GPRD has been widely used for research studies, with over 700 associated papers published up to date in peer-reviewed journals .
Electronic Health Records provide great potential for research, because of their ability to provide data for large populations. Even though the CCR can be used for research, it is important to note that the data are collected primarily for routine clinical rather than for researching purposes. Data quality and reliability must be assessed by researchers who use the resources found in the CCR in order to prevent compromising the results.
There are several approaches found in the literature but there is not an agreed upon standard approach to evaluate the quality and accuracy.
Related validation studies have attempted to show whether the cases with diagnostic codes indeed have that condition. Two recent systematic reviews of validation studies within the GPRD have shown that most (90%) of the coded diagnoses, from many diseases, are 'validated'[6, 7]. In order to perform these validations, 83% of them used sources of information external to the GPRD, mostly questionnaires from GPs, hospital reports, copies of the Medical history or comparisons with disease rates obtained from other registries.
The validation of the diagnosis information included in BIFAP (Base de Datos para la Investigación Farmacoepidemiológica en Atención Primaria), population-based database in Spain containing information of more than 2.5 million patients, was carried out by sending questionnaires to collaborating doctors requiring hospital reports and other information in paper format of the clinical history and doctor's activities reports . External validations were also carried out comparing the results with other sources of information, such as the national health survey and the death registry.
In order to guarantee the quality of the studies performed with the data from the CCR and because few studies have evaluated the quality of those registries, it is necessary to check their validity in our setting. The abovementioned methodology, that used the medical records of the second health care level as the standard reference, does not seem appropriate for chronic diseases such as hypertension (HTN) and diabetes mellitus (DM), which mainly were diagnosed and followed up in the PHC.
The aim of this study is to validate the diagnosis of HTN and DM coded in the CCR of PHC, taking the diagnosis criteria established in the most prominently used clinical guidelines as the gold standard.
Cross-sectional validation study of the diagnoses of DM and HTN in the CCR of PHC.
The study was carried out in the 21 health centers of the health area 4, in the northeast urban zone of the Community of Madrid, which serves a population of 777,426 people. All health centers have computerized patient records since at least for 10 years.
Sources of information
The CCR administered by the software OMI-AP® were structured around a list of episodes (problems in the bio-psycho-social sphere, reasons for consultation, etc). The episodes are listed with an alphanumeric code, which corresponds to the International Classification of Primary Care (ICPC), and a description or clinical label. The same code can be described by using many different clinical labels.
It is possible to link these episodes with diagnostic tests, prescriptions, protocols, therapeutic interventions, referrals, temporary incapacity to work reports, and free-text annotations. The laboratory results are automatically recorded in the CCR.
In PHC, text and codes are entered by the GPs during clinical care, as part of their routine clinical practice. The CCR incorporates a user-friendly instrument to encode episodes in order to make it acceptable and useful to the GPs, who are not professional coders. This instrument is a search system based on clinical labels that assigns the code automatically. The program allows the modification of the descriptions, but not the code which could be substituted or erased if deemed necessary.
Data extraction was conducted using the ICPC code from the CCR of patients.
Inclusion and exclusion criteria
The study population comprised those patients who met the following inclusion criteria: had at least one record within the CCR in the health centers of health area 4 as of January 1st 2010; over 18 years of age; had an ICPC code in their CCR corresponding to DM (32,377 patients with code T90) or to HTN (91,065 patients with codes K86 or K87), respectively.
Patients were not included if they met any of the following exclusion criteria: had not at least one plasma glucose measurement (7.3%) or two Blood pressure (BP) measurements (22.9%) in their CCR for the validation of DM and HTN, respectively.
Given the absence of reference information over the proportion of incorrectly classified cases (false negatives or false positives), the maximum indetermination was assumed (p = (1-p) = 0.5).
With this assumption, and in order to obtain a confidence of 95% and a precision of 5%, the required sample size was 384 patients for each variable. We increased it up to 423 to adjust for a foreseeable loss of 10% between the sampling and validation of the diagnosis (change of address, death or other reasons).
Four different samples of patients were obtained: with DM code (sample 1), without DM code (sample 2), with HTN code (sample 3), and without HTN code (sample 4) in the CCR. The first two were used to validate the episodes of DM and the latter two were used to validate the episodes of HTN.
Samples 1 and 3 were obtained by simple random way whilst samples samples 2 and 4 were obtained by individual matching by age and sex with samples 1 and 3, respectively.
Diagnostic test aims to correctly classify patients and healthy for a disease or clinical condition. The validation of a diagnostic test is performed by comparing their results, both positives and negatives, with those obtained by the best instrument for measuring the phenomenon under study (gold standard).
In this study, documented diagnosis of DM and HTN were considered as the diagnostic tests. In order to perform the validation, they were compared against the gold standards.
Diabetes Mellitus diagnostic criteria.
Diabetes mellitus diagnostic criteria
• Fasting plasma glucose ≥ 126 mg/dl (7.0 mmol/l).
• Symptoms of hyperglycemia (polyuria, polydipsia, and unexplained weight loss) and a casual (random) plasma glucose ≥ 200 mg/dl (11.1 mmol/l).
• 2-h plasma glucose ≥ 200 mg/dl (11.1 mmol/l) during the 75 g oral glucose tolerance test.
• On therapy for Diabetes mellitus and previous diagnosis of Diabetes Mellitus in medical records.
• Gestational diabetes mellitus:
- To make a diagnosis of Gestational diabetes mellitus, at least two of the following plasma glucose values must be found in the 100 g oral glucose tolerance test:
■ Fasting plasma glucose: ≥ 95 mg/dl
■ 1 h: ≥ 180 mg/dl
■ 2 h: ≥ 155 mg/dl
■ 3 h: ≥ 140 mg/dl.
- On therapy for Diabetes mellitus and diagnosis of Gestational diabetes mellitus in medical records.
Hypertension diagnostic criteria.
Hypertension diagnostic criteria
• Average of two or more properly measured, systolic blood pressure readings on each of two or more office visits ≥ 140 mmHg (≥ 130 mmHg for patients with diabetes and chronic kidney disease)
• Average of two or more properly measured, diastolic blood pressure readings on each of two or more office visits ≥ 90 mmHg (≥ 80 mmHg for patients with diabetes and chronic kidney disease)
• On therapy with antihypertensive medications and diagnosis of Hypertension in medical records.
These criteria agree with recommendations given by other major scientific societies, such as the World Health Organization , the European Society for the Study of Diabetes (EASD) , the European Society of Hypertension (ESH) [13, 14], the European Society of Cardiology , the Canadian Diabetes Association  and with the recommended guidelines in Spain [16–19].
Subjects of samples 1 and 2 were considered with DM as long as they fulfilled at least one of the criteria described in Table 1. Subjects from samples 3 and 4 that fulfilled any criteria from Table 2 were considered patients with HTN.
The evaluation team consisted of three general practitioners, with experience using the OMI-AP program. We conducted a peer evaluation with two reviewers and a third evaluator who resolved discrepancies.
A descriptive analysis of the study population and samples was carried out. The age was expressed by means of average percentiles 25 and 75, and the qualitative variables were summarized with their relative frequency.
Sensitivity (Sn), specificity (Sp), positive predictive values (PPV) and negative predictive values (NPV) were calculated, with their confidence intervals at 95% (CI), overall and stratified by gender, age group and DM.
In addition, a sensitivity analysis was performed determining the relative impact on predictive values of varying assumptions regarding the prevalence of DM and HTN.
The Sn is the proportion of cases with DM or HTN codes in the CCR among those that fulfilled the diagnosis criteria of Tables 1, respectively. The Sp is the proportion of cases without DM or HTN code in the CCR among those that did not fulfill the diagnosis criteria. Positive predictive value is the probability that people with DM or HTN code in the CCR meet the diagnostic criteria, while negative predictive value is the probability that people without DM or HTN code do not meet the criteria.
We checked whether the Sn and Sp were different by gender, age group and DM Through the homogeneity test based on a χ2 statistic. In case that the application conditions of the test were not met (any expected cell count under 5), then the Fisher's exact bilateral test was used.
The degree of overall agreement between the registered diagnosis and the reference standard, as well as the inter-observer agreement, was determined by the kappa index with their CI. According to this value, the agreement was considered slight (≤ 0.20), fair (0.21-0.40), moderate, (0.41-0.60), substantial (0.61-0.80) or almost perfect agreement (≥ 0.81) .
The statistic analysis of the information was performed with SPSS software (version 15.0, SPSS Inc., Chicago, Illinois), the CI of the kappa index and the predictive values were calculated with macros for SPSS of the Applied Statistics Laboratory in Universidad Autónoma de Barcelona: !KAPPA and !DT, respectively [22, 23].
In order to ensure the confidentiality, the study was developed as stipulated in the Spanish Personal Data Protection Law. The protocol of the study was approved by the ethics committee of the Hospital Carlos III in Madrid and all of the evaluators signed a confidentiality clause.
Main demographic characteristics of the population of patients over 18 years old attended in Health Area 4 and of samples.
Age ≥ 70 years
Patients with diagnosis code of diabetes (T-90)
Sample of patients with diagnosis code of diabetes (sample 1)
- Correct diagnosis (TP)
- Incorrect diagnosis (FP)
Patients without diagnosis code of diabetes (T-90)
Sample of patients without diagnosis code of diabetes (sample 2)
- Correct diagnosis (TN)
- Incorrect diagnosis (FN)
Patients with diagnosis code of hypertension (K-86 ó K-87)
Sample of patients with diagnosis code of hypertension (sample 3)
- Correct diagnosis (TP)
- Incorrect diagnosis (FP)
64.00 (55.18- 76.86)
Patients without diagnosis code of hypertension (K-86 or K-87)
Sample of patients diagnosis code of hypertension (sample 4)
- Correct diagnosis (TN)
- Incorrect diagnosis (FN)
The 7.3% of patients from sample 2 (without DM code) had to be excluded because there was not at least one fasting plasma glucose. They were 64.5% males with a mean age of 73.6 (SD 14.4) years. There were significant differences in mean age between patients excluded and not excluded.
The 22.9% of patients from sample 4 (without HTN code) had to be excluded because there were not at least two BP measurements. They were 36.1% males with a mean age of 69.1 (SD 11.6) years. There were no significant differences in mean age and female proportion between patients excluded and not excluded from the sample.
The prevalence of patients diagnosed with DM was 5.02%, slightly higher in males and in patients aged 65 years or older. The prevalence of patients with diagnosis of HTN was 14.11%, higher in women, in people aged 70 years or older and in patients with diagnosis of DM.
In our study, the diagnosis of DM was confirmed in 99.5% of the cases (sensitivity) and in 99.49% of those without diagnosis of DM did not meet the diagnosis criteria (specificity). There were no significant differences when stratifying by age groups or sex.
Sensivity, specificity and agreement for diabetes mellitus and hypertension.
kappa (CI 95%)
kappa (CI 95%)
0.988 (0.977 - 0.998)
99.53 (98.29 - 99.87)
99.49 (98.16 - 99.86)
0.990 (0.981 - 1)
0.985 (0.968 - 1)
99.52 (97.33 - 99.92)
99.52 (97.34 - 99.92)
0.990 (0.976 - 1)
0.990 (0.977 - 1)
99.54 (97.41 - 99.92)
99.53 (97.40 - 99.92)
0.990 (0.977 - 1)
- Age < 70
0.980 (0.961 - 1)
99.52 (97.33 - 99.92)
99.50 (97.21 - 99.91)
0.990 (0.977 - 1)
- Age ≥ 70
0.995 (0.985 - 1)
99.54 (97.41 - 99.92)
99.48 (97.12 - 99.91)
0.990 (0.977 - 1)
0.941 (0.916 - 0.967)
85.22 (81.79 - 88.09)
96.95 (94.09 - 98.45)
0.778 (0.732 - 0.823)
0.937 (0.897 - 0.978)
96.95 (94.09 - 98.45)
97.30 (92.35 - 99.08)
0.770 (0.700 - 0.841)
0.944 (0.911 - 0.977)
85.87 (81.33 - 89.45)
96.69 (92.48 - 98.58)
0.783 (0.724 - 0.842)
- Age < 70
0.96 (0.928 - 0.992)
90.58 (85.6 - 93.96)
95.97 (90.91 - 98.27)
0.850 (0.791 - 0.909)
- Age ≥ 70
0.926 (0.888 - 0.964)
81.76 (76.96 - 85.74)
97.83 (93.80 - 99.26)
0.724 (0.660 - 0.789)
- Without DM
0.947 (0.921 - 0.974)
87.15 (83.29 - 90.23)
97.07 (94.08 - 98.57)
0.947 (0.921 - 0.974)
- With DM
0.882 (0.781 - 0.983)
79.85 (72.11 - 85.86)
95.65 (79.01 - 99.23)
0.522 (0.376 - 0.668)
The degree of overall agreement between the diagnosis in the CCR and the standard of reference, measured as the kappa index, was almost perfect for DM (κ = 0.990), and substantial agreement for the HTN (κ = 0.778), as shown in Table 4. The worst result was obtained for HTN in the subgroup of patients with diagnosis of diabetes.
The degree of global inter-observers agreement, measured with the kappa index was very high, both for DM (κ = 0.988) and HTN (κ = 0.941), and for the different categories of sex, age groups and diagnosed diabetes. In all cases, the kappa index was higher than 0.880.
Apparent prevalence (diagnosis in the CCR), true prevalence (fulfillment of the diagnosis criteria) and predictive values of diabetes and hypertension.
Apparent prevalence *
True prevalence **
PPV (CI 95%)
NPV (CI 95%)
5.02 (4.96 - 5.07)
5.06 (5.01 - 5.12)
91.23 (72.30 - 97.64)
99.98 (99.90 - 99.99)
5.61 (5.53 - 5.70)
5.67 (5.58 - 5.75)
92.59 (63.89 - 98.88)
99.97 (99.80 - 100)
4.55 (4.48 - 4.62)
4.59 (4.52 - 4.66)
91.11(59.19 - 98.64)
99.98 (99.84 - 100)
- Age < 70
2.89 (2.84 - 2.93)
2.91 (2.87 - 2.96)
85.58 (45.66 - 97.67)
99.99 (99.90 - 100)
- Age ≥ 70
15.72 (15.50 - 15.94)
15.87 (15.65 - 16.09)
97.32(83.69 - 99.61)
99.91 (99.38 - 99.99)
14.11 (14.03 - 14.20)
17.14 (17.05 - 17.23)
85.24 (74.46 - 91.96)
96.94 (96.24 - 97.52)
13.31 (13.18 - 13.43)
16.27 (16.13 - 16.41)
85.84 (66.47 - 94.88)
96.96 (95.87 - 97.78)
14.75 (14.63 - 14.86)
17.82 (17.70 - 17.95)
84.90 (70.34 - 93.02)
96.93 (95.94 - 97.68)
- Age < 70
7.75 (7.68 - 7.82)
8.91 (8.84 - 8.99)
68.72 (48.18 - 83.85)
99.05 (98.53 - 99.39)
- Age ≥ 70
46.07 (45.77 - 46.36)
57.86 (57.56 - 58.15)
98.10 (94.40 - 99.37)
79.61 (75.40 - 83.27)
- Without DM
11.66 (11.58 - 11.74)
13.81 (13.72 - 13.89)
82.52 (69.44 - 90.74)
97.94 (97.32 - 98.42)
- With DM
60.60 (60.07 - 61.14)
80.22 (79.78 - 80.65)
98.68 (91.62 - 99.80)
53.92 (45.09 - 62.52)
Predictive values for hypertension and diabetes for different prevalences (sensitivity analysis).
PPV (CI 95%)
NPV (CI 95%)
PPV (CI 95%)
NPV (CI 95%)
89.05 (67.11 - 97.01)
99.98 (99.92 - 100)
53.76 (36.99 - 69.72)
99.37 (99.22 - 99.49)
90.19 (69.76 - 97.34)
99.98 (99.91 - 99.99)
56.80 (39.91 - 72.26)
99.29 (99.12 - 99.42)
91.13 (72.04 - 97.61)
99.98 (99.90 - 99.99)
59.50 (42.59 - 74.42)
99.20 (99.02 - 99.36)
91.91 (74.02 - 97.84)
99.97 (99.89 - 99.99)
61.89 (45.06 - 76.29)
99.12 (98.91 - 99.29)
92.57 (75.76 - 98.02)
99.97 (99.88 - 99.99)
64.05 (47.36 - 77.91)
99.04 (98.81 - 99.22)
93.13 (77.29 - 98.18)
99.97 (99.87 - 99.99)
65.99 (49.49 - 79.35)
98.95 (98.70 - 99.15)
93.62 (78.66 - 98.32)
99.96 (99.86 - 99.99)
67.75 (51.47 - 80.62)
98.87 (98.60 - 99.08)
94.05 (79.88 - 98.44)
99.96 (99.85 - 99.99)
69.35 (53.33 - 81.76)
98.78 (98.49 - 99.01)
94.43 (80.98 - 98.54)
99.96 (99.84 - 99.99)
70.82 (55.07 - 82.78)
98.69 (98.38 - 98.94)
94.77 (81.98 - 98.63)
99.96 (99.82 - 99.99)
72.17 (56.69 - 83.70)
98.60 (98.28 - 98.87)
95.07 (82.88 - 98.72)
99.95 (99.81 - 99.99)
73.41 (58.22 - 84.54)
98.51 (98.17 - 98.80)
95.34 (83.71 - 98.79)
99.95 (99.80 - 99.99)
74.55 (59.67 - 85.30)
98.42 (98.06 - 98.72)
95.59 (84.47 - 98.86)
99.95 (99.79 - 99.99)
75.62 (61.03 - 86.00)
98.33 (97.94 - 98.65)
96.02 (85.82 - 98.97)
99.94 (99.77 - 99.99)
77.53 (63.53 - 87.23)
98.15 (97.72 - 98.50)
96.38 (86.97 - 99.07)
99.94 (99.74 - 99.98)
79.19 (65.77 - 88.29)
97.96 (97.49 - 98.35)
96.68 (87.98 - 99.15)
99.93 (99.72 - 99.98)
80.66 (67.80 - 89.20)
97.77 (97.25 - 98.19)
96.95 (88.85 - 99.22)
99.92 (99.69 - 99.98)
81.96 (69.64 - 90.00)
97.58 (97.02 - 98.04)
97.18 (89.63 - 99.28)
99.92 (99.67 - 99.98)
83.12 (71.32 - 90.70)
97.38 (96.77 - 97.87)
97.99 (92.45 - 99.49)
99.88 (99.53 - 99.97)
87.46 (77.89 - 93.25)
96.33 (95.49 - 97.02)
98.49 (94.23 - 99.62)
99.84 (99.37 - 99.96)
90.29 (82.45 - 94.85)
95.16 (94.08 - 96.06)
98.82 (95.45 - 99.70)
99.80 (99.20 - 99.95)
92.28 (85.80 - 95.95)
93.87 (92.51 - 94.99)
99.06 (96.35 - 99.76)
99.75 (98.99 - 99.94)
93.76 (88.36 - 96.75)
92.41 (90.77 - 93.78)
99.24 (97.03 - 99.81)
99.68 (98.75 - 99.92)
94.90 (90.38 - 97.36)
90.77 (88.81 - 92.42)
99.38 (97.56 - 99.84)
99.61 (98.47 - 99.90)
95.80 (92.02 - 97.84)
88.91 (86.61 - 90.85)
99.49 (98.00 - 99.87)
99.53 (98.14 - 99.88)
96.54 (93.37 - 98.22)
86.77 (84.11 - 89.04)
The results of the study show a very high agreement of the diagnosis of DM in the CCR with the gold standard, and also a high sensitivity and specificity of the diagnosis of DM. The information obtained from the CCR provides a good estimation of the true prevalence of the illness, overall and in each category of sex and age groups.
For HTN, there was also a good overall agreement of the diagnosis in the CCR with the gold standard, high Sp and Sn, but lower than for diabetes. In patients with DM subgroup, the agreement was strikingly lower especially at the expense of Sn, because the under-diagnosis of HTN is much higher and the NPV, very influenced by the prevalence, is ostensibly lower. Similar results, of less magnitude, are found in the subgroup of patients aged 70 or over.
In our study the DM diagnosis was confirmed in 99.53% of the cases and HTN in 98.11%.
The systematic review of GPRD validation studies by Herrett and cols  shows that the different diagnoses studied were confirmed in 89% of the cases, although DM and HTN were not validated. Only a small proportion of the studies provided quantitative estimates of validity such as sensitivity and specificity.
We have not found published studies that used similar methodology to ours for the validation of HTN and DM diagnoses. For this reason, our results can only be compared with most similar validation studies, which used self-reported diagnosis by patients compared to biometric measures as reference standards.
The Sn obtained in our study for the diagnosis of DM (99.53%) is much higher than 69.7% they found in the DINO study , which validates the self-reported diagnosis of diabetes, HTN and hyperlipidemia of a population of 20 years and older in southern Spain. Published studies in other countries, also performed with self-reported diagnosis, present great heterogeneity, with Sn of DM between 58.9% in a Dutch study  and 85.2% in Taiwan .
Regarding the diagnosis of HTN, our Sn was a little bit lower (85.22%). In Spain, the DINO study estimated the Sn in 49.4% , in a subsample of the SUN study the Sn was 90.3% , and the EPIC Murcia cohort study obtained a sensitivity of 63.5% , taking medical records as the reference standard. In other countries, we found values that oscillate between 34.5% in the Dutch study aforementioned , and 82% found in a North-American study .
The high specificity obtained for the diagnosis of DM (99.49%) is consistent with the findings of other published studies, where the Sp is situated between 95.2%  and 99.6% . The Sp obtained for the HTN (96.95%) is slightly above what was found by other authors, which oscillated between 80%  up to 96.8% .
The agreement found between the diagnosis of DM registered in the CCR and the fulfillment of the diagnosis criteria were very good (k = 0.990), above the one obtained in the DINO study (K = 0.78) .
The validation indexes obtained in our study are higher than those found by other authors, possibly because we have checked the diagnosis done by physicians and not those self-reported by patients.
Our study confirms the hypothesis found in other publications in which DM diagnosis has higher validity than HTN diagnosis [25, 30, 32]. This could be related to the perceived higher seriousness of physicians for DM than for HTN, and due to the DM diagnostic criteria that were changed less frequently and more uniform than those for HTN. In general, the parameters of validity found enable us to realize a precise estimation of the prevalence of diabetes  but a sub-estimation of the prevalence of HTN.
The under-diagnosis of HTN is a well-known phenomenon whose magnitude varies greatly in published studies. In a systematic review of 44 studies from different countries published in 2009 , the proportion of undiagnosed HTN on a worldwide level was estimated to be 46.2% for men and 58.5% for women. Different Spanish studies offer results from 14.9% in Navarra , to 49.4% in Galicia  and 31.74% obtained in the PREDIMERC study in Madrid . In our study, we found 21.45% in global and 32.36% in the subgroup of patients with diabetes.
Very little is known about the prevalence of undiagnosed HTN in diabetic patients. In Spain, the DIAPA study found that 56.8% of patients with type 2 DM had BP > 130/85 mmHg, even though they were not previously diagnosed with HTN . The lack of HTN diagnosis in patients with DM could be related to the cutoff values of diagnosis, which are lower for these patients (BP ≥ 130/80 mmHg) , and it is possible that some GPs had been using the diagnostic criteria of the general population (BP ≥ 140/90 mmHg).
When stratifying by sex and age groups, there were significant differences in the Sn of HTN with worse results in patients with DM and in those over 69 years, despite the fact that these patients are subject to a large number of revisions and so there were more chances to detect HTN. These results are different than other studies [24, 25, 27, 28, 30, 32], where better results were obtained in older and diabetic patients. One possible explanation could be that other studies were done through questionnaires with volunteer participants. The methods used may have resulted in a selection bias, since the patients who are more worried about their health and those who have worse perception of their health may be more predisposed to participate.
The true prevalence of DM in our study was 5.06%, which is very similar to the obtained with the BIFAP database (5.8%)  and in the Spanish National Health Survey (4.79%)  but lower than 8.1% in the PREDIMERC study in Madrid .
The true prevalence of HTN in our study (17.14%) is similar to those obtained with the BIFAP database (16.1%)  and in the Spanish National Health Survey (18.89%)  but also lower than the findings in other studies in Spain. These studies found about 35% in the adult population  and 29.3% in the PREDIMERC study .
This differences observed in the magnitude of the prevalences could be due to the age of the patients included in PREDIMERC . The patient range age was between 30 and 74 whereas our study includes all those aged 18 and over. If we had selected people aged 30 or over in our database, the true prevalence would have been 6.87% for DM and 23.72% for HTN.
Moreover, PREDIMERC was undertaken with volunteers, with an overall response rate of 56.4%, which may have produced a selection bias as was mentioned before. Furthermore, we cannot assure that false positives were due to misdiagnosis, simply that the verification of diagnostic criteria could not be met. This may have led to an underestimation of the prevalence in our study.
The study presents some limitations. These are that the information included may not have been completely exhaustive. Because of this a potential selection bias may exist. This is particularly true in view of the proportion of adults in nursing homes, chronic disease hospitals, or those treated in private practice. In addition, as the health area 4 in Madrid covers only urban population, patients living in rural areas were not represented in this study.
Alternatively, more than 95% of citizens have public health coverage with the Spanish National Health System , so we suppose that the proportion of assigned persons in the health area 4 who are not included in our study is low.
The high proportion of patients without available information to perform the validation (7.3% had not at least one plasma glucose level and 22.9% had not two or more BP measurements) could be due to the fact that these patients do not usually go to health centers. At least one or two years of active data are basically required in order to include clinical patient records in a study.
In both the GPRD and the BIFAP, GPs who voluntarily participate in the projects are the ones that refer the information, possibly introducing a selection bias (e.g. the pattern of patients care can differ among volunteer physicians and those who are not volunteers). Furthermore, the response rate of physicians to questionnaires can be low, as occurred in BIFAP with the validation of Upper Gastrointestinal Bleeding with a rate of the 58.4% . Our database is exhaustive, containing information from the entire population attended in the health area, and registered by all the professionals, avoiding the possibility of the mentioned biases.
Published studies related to validation are aimed to show whether cases with diagnostic codes indeed have that condition. The use of the PPV as the only measurement presents the inconvenience that it depends on the prevalence of the disease, as shown in Table 6. Another weakness of these validation studies is that, with a few exceptions, they do not address the question of false negatives, which are cases of the disease who have not received a diagnostic code. There were missed cases in which the GPs did not make the diagnosis or when made diagnosis but encoded it wrong . We argue that in any validation study, PPV, NPV, Sn, and Sp should be identified, as far as possible.
The validation of the diagnosis of CCR of PHC has facilitated the detection of areas of improvement in the clinical practice, such as under-diagnosis of HTN with differential classification bias for patients who also suffers diabetes.
These findings can be used to alert clinicians of subgroups for which the interventions could be more beneficial.
The use of secondary sources of information stored in computerized databases enables access data from large populations. This can facilitate the rapid identification of patients for observational studies or inclusion in interventions and may reduce the time and resources needed to obtain results. This greater efficiency constitutes one of the main advantages for using the databases as epidemiological research tools.
The results obtained in this validation enable the usage of both DM and HTN diagnoses codes of the computerized clinical records of PHC as a valid tool, which can be used with confidence to perform epidemiological studies.
However, the HTN diagnosis in the CCR has lower sensitivity than DM diagnosis, especially in diabetic patients. Therefore, in this group of patients, the code of HTN diagnosis in the CCR is not enough in order to detect people without HTN since there would be selected a high amount of false negative results.
We thank Javier Díez Castro and Enrique Carrillo de Santa Pau for their useful contributions to the manuscript.
- Ministry of Health and Social Policy: ICT in the Health System. The Healthcare Online program. Progress update January 2010. [http://red.es]
- Jick H, Madsen S, Nudelman PM, Perera DR, Stergachis A: Postmarketing follow-up at Group Health Cooperative of Puget Sound. Pharmacotherapy. 1984, 4 (2): 99-100.View ArticlePubMedGoogle Scholar
- Malcolm E, Downey W, Strand L, McNutt M, West R: Saskatchewan Health's linkable data bases and pharmacoepidemiology. PMS. 1993, 6: 175-264.Google Scholar
- Ray WA, Griffin MR: Use of Medicaid data pharmacoepidemiology. Am J Epidemiol. 1989, 129 (4): 837-49.PubMedGoogle Scholar
- General Practice Research Database [Internet]. [http://www.gprd.com]
- Herrett E, Thomas SL, Schoonen WM, Smeeth L, Hall AJ: Validation and validity of diagnoses in the General Practice Research Database: a systematic review. Br J Clin Pharmacol. 2010, 69 (1): 4-14. 10.1111/j.1365-2125.2009.03537.x.View ArticlePubMedPubMed CentralGoogle Scholar
- Khan NF, Harrison SE, Rose PW: Validity of diagnostic coding within the General Practice Research Database: a systematic review. Br J Gen Pract. 2010, 60 (572): 128-136. 10.3399/bjgp10X483562.View ArticleGoogle Scholar
- Base de datos para la Investigación Farmacoepidemiológica en Atención Primaria BIFAP. [http://www.bifap.org/]
- American Diabetes Association: Treatment of hypertension in adults with diabetes (Position Statement). Diabetes Care. 2003, 26 (Suppl 1): S80-S82.Google Scholar
- Chobanian AV, Bakris GL, Black HR, Cushman WC, Green LA, Izzo JL, et al: The Seventh Report of the Joint National Committee on Prevention, Detection, Evaluation, and Treatment of High Blood Pressure. JAMA. 2003, 289: 2560-71. 10.1001/jama.289.19.2560.View ArticlePubMedGoogle Scholar
- World Health Organization: Definition, Diagnosis and classification of diabetes mellitus and its complications: Report of a WHO Consultation. Part 1: Diagnosis and clasification of diabetes mellitus. 1999, Geneve: World Heath Organization, 539-53.Google Scholar
- European Diabetes Policy Group 1999: A desktop guide to type 2 diabetes Mellitus. Diabet Med. 1999, 16 (9): 716-30. 10.1046/j.1464-5491.1999.00166.x.View ArticleGoogle Scholar
- The Task Force for the Management of Arterial Hypertension of the European Society of Hypertension (ESH) and of the European Society of Cardiology (ESC): 2007 Guidelines for the Management of Arterial Hypertension. J Hypert. 2007, 25: 1005-87.Google Scholar
- Mancia G, Laurent S, Agabiti-Rosei E, Ambrosioni E, Burnier M, Caulfield MJ, et al: Reappraisal of European guidelines on hypertension management: a European Society of Hypertension Task Force document. J Hypertens. 2009, 27: 2121-58. 10.1097/HJH.0b013e328333146d.View ArticlePubMedGoogle Scholar
- Canadian Diabetes Association: Canadian Diabetes Association 2008 clinical practice guidelines for the prevention and management of diabetes in Canada. Can J Diabetes. 2008, 32: S1-201.Google Scholar
- Grupo de trabajo de la Guía de Práctica Clínica sobre Diabetes tipo 2: Guía de Práctica Clínica sobre Diabetes tipo 2. Madrid: Plan Nacional para el SNS del MSC. 2008, Agencia de Evaluación de Tecnologías Sanitarias de El País Vasco, Guías de Práctica Clínica en el SNS: OSTEBA N° 2006/08Google Scholar
- Marín R, de la Sierra A, Armario P, Campo C, Banegas JR, Gorostidi M: Guía sobre el diagnóstico y tratamiento de la hipertensión arterial en España 2005. Med Clin(Barc). 2005, 125: 24-34. 10.1157/13076402.View ArticleGoogle Scholar
- Coca A, Aranda P, Bertomeu V, Bonet A, Esmatjes E, Guillén F, et al: Strategies for effective control of arterial hypertension in Spain. Consensus document. Rev ClinEsp. 2006, 206: 510-4.Google Scholar
- De la Sierra A, Gorostidi M, Marín R, Redón J, Banegas JR, Armario P, et al: Evaluación y tratamiento de la hipertensión arterial en España. Documento de consenso. Med Clin (Barc). 2008, 131 (3): 104-16. 10.1157/13124015.View ArticleGoogle Scholar
- Rogan WJ, Gladen B: Estimating prevalence from the results of a screening test. Am J Epidemiol. 1978, 107: 71-6.PubMedGoogle Scholar
- Landis JR, Koch GG: The measurement of observer agreement for categorical data. Biometrics. 1977, 33: 159-174. 10.2307/2529310.View ArticlePubMedGoogle Scholar
- Domenech JM, Granero R: Macro !KAPPA for SPSS Statistics. Weighted Kappa [computer program]. V2009.07.31. 2009, Bellaterra: Universitat Autonoma de Barcelona, [http://www.metodo.uab.cat/macros.htm]Google Scholar
- Domenech JM: SPSS Macro !DT. Diagnostic Tests [computer program]. V2008.05.27. 2008, Bellaterra: Universitat Autònoma de Barcelona, [http://www.metodo.uab.cat/macros.htm]Google Scholar
- Huerta JM, Tormo MJ, Egea-Caparrós JM, Ortolá-Devesa JB, Navarro C: Validez del diagnóstico referido de diabetes, hipertensión e hiperlipemia en población adulta española. Resultados del estudio DINO. Rev Esp Cardiol. 2009, 62: 143-52.View ArticleGoogle Scholar
- Molenaar EA, Van Ameijden EJ, Grobbee DE, Numans ME: Comparison of routine care self-reported and biometrical data on hypertension and diabetes: results of the Utrecht Health Project. Eur J Public Health. 2007, 17: 199-205. 10.1093/eurpub/ckl113.View ArticlePubMedGoogle Scholar
- Goldman N, Lin IF, Weinstein M, Lin YH: Evaluating the quality of self-reports of hypertension and diabetes. J Clin Epidemiol. 2003, 56 (2): 148-54. 10.1016/S0895-4356(02)00580-2.View ArticlePubMedGoogle Scholar
- Alonso A, Beunza JJ, Delgado-Rodríguez M, Martínez-González MA: Validation of self reported diagnosis of hypertension in a cohort of university graduates in Spain. BMC Public Health. 2005, 5: 94-10.1186/1471-2458-5-94.View ArticlePubMedPubMed CentralGoogle Scholar
- Tormo MJ, Navarro C, Chirlaque MD, Barber X: Validation of self diagnosis of high blood pressure in a sample of the Spanish EPIC cohort: overall agreement and predictive values. EPIC Group of Spain. J Epidemiol Community Health. 2000, 54: 221-6. 10.1136/jech.54.3.221.View ArticlePubMedPubMed CentralGoogle Scholar
- Giles WH, Croft JB, Keenan NL, Lane MJ, Wheeler FC: The validity of self-reported hypertension and correlates of hypertension awareness among blacks and whites within the stroke belt. J Prev Med. 1995, 11 (3): 163-9.Google Scholar
- Wu SC, Li CY, Ke DS: The agreement between self-reporting and clinical diagnosis for selected medical conditions among the elderly in Taiwan. Public Health. 2000, 114 (2): 137-42. 10.1016/S0033-3506(00)00323-1.View ArticlePubMedGoogle Scholar
- Johansson J, Hellenius ML, Elofsson S, Krakau I: Self-report as a selection instrument in screening for cardiovascular disease risk. Am J Prev Med. 1999, 16 (4): 322-4. 10.1016/S0749-3797(99)00019-7.View ArticlePubMedGoogle Scholar
- Bowlin SJ, Morrill BD, Nafziger AN, Lewis C, Pearson TA: Reliability and changes in validity of self-reported cardiovascular disease risk factors using dual response: the behavioral risk factor survey. J Clin Epidemiol. 1996, 49: 511-17. 10.1016/0895-4356(96)00010-8.View ArticlePubMedGoogle Scholar
- Bays HE, Bazata DD, Clark NG, Gavin JR, Green AJ, Lewis SJ, Reed ML, Stewart W, Chapman RH, Fox KM, Grandy S: Prevalence of self-reported diagnosis of diabetes mellitus and associated risk factors in a national survey in the US population: SHIELD (Study to Help Improve Early evaluation and management of risk factors Leading to Diabetes). BMC Public Health. 2007, 3;7: 277-View ArticleGoogle Scholar
- Pereira M, Lunet N, Azevedo A, Barros H: Differences in prevalence, awareness, treatment and control of hypertension between developing and developed countries. J Hypertens. 2009, 27 (5): 963-75. 10.1097/HJH.0b013e3283282f65.View ArticlePubMedGoogle Scholar
- Perez-Fernandez R, Mariño AF, Cadarso-Suarez C, Botana MA, Tome MA, Solache I, et al: Prevalence, awareness, treatment and control of hypertension in Galicia (Spain) and association with related diseases. J Hum Hypertens. 2007, 21 (5): 366-73.PubMedGoogle Scholar
- Zorrilla B, De la Calle H, Martínez M, Gil E, Sánchez JL, Nogales P, et al: Prevalencia de diabetes mellitus en la Comunidad de Madrid: estudio PREDIMERC. Av Diabetol. 2008, 24 (Suppl 1): 45-112.Google Scholar
- García Vallejo O, Vicente Lozano J, Vegazo O, Jiménez Jiménez FJ, Llisterri Caro JL, Redón J: Control de la presión arterial de los pacientes diabéticos en el ámbito de atención primaria. Estudio DIAPA. Med Clin (Barc). 2003, 120 (14): 529-34. 10.1157/13045871.View ArticleGoogle Scholar
- Ministerio de Sanidad y Política social: Spanish National Health Survey 2006. [Internet database]. [http://www.msps.es/estadEstudios/estadisticas/encuestaNacional/ense.htm]
- Banegas JR: Epidemiología de la hipertensión arterial en España. Situación actual y perspectivas. Hipertensión. 2005, 22: 353-62.View ArticleGoogle Scholar
- Kannel WB, Wilson PW, Zhang TJ: The epidemiology of impaired glucose tolerance and hypertension. Am Heart J. 1991, 121: 1268-73. 10.1016/0002-8703(91)90432-H.View ArticlePubMedGoogle Scholar
- Fernández Cuenca R: Análisis de los servicios sanitarios. Sociedad Española de Salud Pública y Administración Sanitaria. Informe SESPAS 1998: La salud pública y el futuro del estado de bienestar. 1998, Granada: Escuela Andaluza de Salud Pública, 249-98.Google Scholar
- Nicholson A, Tate AR, Koeling R, Cassell JA: What does validation of cases in electronic record databases mean? The potential contribution of free text. Pharmacoepidemiol Drug Saf. 2011, 20 (3): 321-4. 10.1002/pds.2086.View ArticlePubMedPubMed CentralGoogle Scholar
- The pre-publication history for this paper can be accessed here:http://www.biomedcentral.com/1471-2288/11/146/prepub
This article is published under license to BioMed Central Ltd. This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.