title: Developing and validating a diabetes database in a large health system.
abstract: BACKGROUND
  One component of clinical information systems is a registry of patients. Registries allow providers to identify gaps in care at the population level. Registries also allow for rapid cycle continuous quality improvement, targeted practice change and improved outcomes. Most registries are built based on membership with an insurer or other selection criteria. Little, if any data exist on registries representing demographically heterogeneous populations.
  
  
  METHODS
  Administrative and clinical data for the period 1/1/2000-12/30/03 were examined. In total, 46,082,941 lab reports, 233,292,544 medical records, and 9,351,415 medical record abstracts, representing approximately 2 million unique patients were searched. The diabetes source population was identified by presence of any one of the following criteria: ICD-9 code 250 (diabetes) for inpatient, emergency room or outpatient visits; any hemoglobin A1c result; blood glucose >200mg/dl; or diabetes medication. A diagnosis of diabetes was verified by trained chart reviewers on a sample of patients. Single indicators and combinations were examined to determine optimal identification of these cases.
  
  
  RESULTS
  In two separate validation studies, using two or more indicators or outpatient diagnosis maximized positive predictive value (PPV) (96 and 97%) and sensitivity (99 and 100%) and identified 55,807 individuals. When all patients with a single indicator of outpatient diagnosis (which had the highest single PPV of 94 and 95%) were included together with those having >or=2 indicators, the final sample size was 65,725.
  
  
  CONCLUSIONS
  Two or more indicators or an out-patient-diagnosis identifies a sizeable and unselective diabetes database which can be used to track processes and outcomes.
authors.affiliation: University of Pittsburgh, Department of Epidemiology, Graduate School of Public Health, Pittsburgh, United States. zgiborj@upmc.edu
authors.forename: Janice C
authors.initials: JC
authors.lastname: Zgibor
authors.forename: Trevor J
authors.initials: TJ
authors.lastname: Orchard
authors.forename: Melissa
authors.initials: M
authors.lastname: Saul
authors.forename: Gretchen
authors.initials: G
authors.lastname: Piatt
authors.forename: Kristine
authors.initials: K
authors.lastname: Ruppert
authors.forename: Andrew
authors.initials: A
authors.lastname: Stewart
authors.forename: Linda M
authors.initials: LM
authors.lastname: Siminerio
mesh_terms: D016208:Databases, Factual; D003920:Diabetes Mellitus / Q000097:blood / Q000188:drug therapy / Q000453:epidemiology*; D006442:Glycated Hemoglobin / Q000032:analysis; D006801:Humans; D007004:Hypoglycemic Agents / Q000627:therapeutic use; D008499:Medical Records; D010414:Pennsylvania / Q000453:epidemiology; D012042:Registries; D015203:Reproducibility of Results
chemical_list: D006442:Glycated Hemoglobin; D007004:Hypoglycemic Agents