Table 2

Algorithms to detect diseases and levels of severityhttp://dx.doi.org/10.1136/bmjopen-2016-012413

Algorithm for the diseaseAlgorithms for levels of severity
Type 2 diabetes mellitus
[(DM) OR (GFR) OR (DM TESTS)] AND NOT (DM1)Algorithm for the disease
AND (DM UNCOMPLICATED)
AND NOT [(INSULIN) OR (DM2 CHRONIC COMPLICATIONS)
OR (DM2 ASYMPTOMATIC COMPLICATIONS) OR (CVD)]
Algorithm for the disease
AND (DM UNCOMPLICATED)
AND (INSULIN)
AND NOT [(DM2 CHRONIC COMPLICATIONS) OR (DM2 ASYMPTOMATIC COMPLICATIONS) OR (CVD)]
Algorithm for the disease
AND [(DM CHRONIC COMPLICATIONS) OR (DM ASYMPTOMATIC COMPLICATIONS) OR (CVD)]
AND NOT (INSULIN)
Algorithm for the disease AND [(DM CHRONIC COMPLICATIONS) OR (DM ASYMPTOMATIC COMPLICATIONS) OR (CVD)]
AND (INSULIN)
Hypertension
(HYPERTENSION) OR (BP) Algorithm for the disease
AND NOT
[LEVEL 2 OR LEVEL 3]
Algorithm for the disease
AND [(DM2) OR (HYPERTENSION COMPLICATIONS) OR (HYPERTENSIVE RETINOPATHY) OR (CHRONIC KIDNEY DISEASE) OR (ATHEROSCLEROTIC ARTERIOPATHY) OR (CAROTID ATHEROSCLEROSIS) OR (HYPERTENSIVE ENCEPHALOPATHY) OR (AORTIC ANEURYSM)]
AND NOT [(HF) OR (LVEF)]
Algorithm for the disease
AND [(HF) OR (LVEF) OR (VENTRICULAR DYSFUNCTION)]
Ischaemic heart disease
(CHD)Algorithm for the disease
AND (CHD NO AMI)
AND NOT [(AMI) OR (PAST AMI) OR (CORONARY REVASCULARIZATION ICD9CM) OR (CORONARY REVASCULARIZATION FREE TEXT) OR (HF) OR (LVEF) OR (VENTRICULAR DYSFUNCTION)]
Algorithm for the disease
AND [(CORONARY REVASCULARIZATION ICD9CM) OR (CORONARY REVASCULARIZATION FREE TEXT)]
AND NOT [(AMI) OR (PAST AMI) OR (HF) OR (LVEF) OR (VENTRICULAR DYSFUNCTION)]
Algorithm for the disease
AND [(AMI) OR (PAST AMI)]
AND NOT [(CORONARY REVASCULARIZATION ICD9CM) OR (CORONARY REVASCULARIZATION FREE TEXT) OR (HF) OR (LVEF) OR (VENTRICULAR DYSFUNCTION)]
Algorithm for the disease
AND [(AMI) OR (PAST AMI) OR (CORONARY REVASCULARIZATION ICD9CM) OR (CORONARY REVASCULARIZATION FREE TEXT)]
AND NOT [(HF) OR (LVEF) OR (VENTRICULAR DYSFUNCTION)]
Algorithm for the disease
AND [(HF) OR (LVEF)]
Heart failure
(HF) OR (LVEF) OR (VENTRICULAR DYSFUNCTION) None
  • The algorithms are described by means of subqueries, represented by keywords in upper case between parentheses, whose details are in online supplementary table 1. In particular, measurements are as follows: glomerular filtration rate (GFR) <mL/min/1.73 m2; systolic blood pressure (SBP) >140 mm Hg at least twice ever or diastolic blood pressure (DBP) >90 mm Hg at least twice ever; Left ventricular ejection fraction (LVEF) <50%; DM TESTS: plasma glucose >200 mg/dL after an oral load of 75 g glucose or fasting plasma glucose ≥126 mg/dL or glycated haemoglobin ≥6.5%. In all subqueries, records labelled with ‘suspect’ were excluded, except in the case of the subquery (acute myocardial infarction, AMI) used to detect levels of severity 3 and 4 of ischaemic heart disease (IHD).