Searching multiple clinical information systems for longer time periods found more prevalent cases of asthma

J Clin Epidemiol. 2004 Apr;57(4):392-7. doi: 10.1016/j.jclinepi.2003.08.014.


Objective: The development of a reliable asthma registry is an important first step for conducting population-based asthma disease management. This study developed a computerized algorithm for defining prevalent asthma, identified operational difficulties, and summarized data on asthma prevalence in the study population.

Study design and setting: As part of a study of the incidence of occupational asthma, we used the electronic databases of a large health maintenance organization to develop a computerized algorithm for defining prevalent asthma and validated it against chart review. The predictive values of eight health care utilization profiles were validated by chart review to establish the algorithm.

Results: The 1-year treated prevalence of asthma was 4.1% among members aged 15-55; the pharmacy database identified 61% of cases, and the outpatient care database 66%. Extending the outpatient care window from 1 year to 2 years increased estimated prevalence to 5.3%, with 81% now found in the outpatient care database.

Conclusion: This analysis illustrates the benefit of using multiple databases for more accurate enumeration of cases and the impact of extending the search in time. These results are useful for researchers who can use such databases in selecting algorithms to define and identify asthma for their own purposes.

Publication types

  • Research Support, U.S. Gov't, P.H.S.
  • Validation Study

MeSH terms

  • Adolescent
  • Adult
  • Age Distribution
  • Algorithms
  • Asthma / epidemiology*
  • Databases, Factual
  • Drug Prescriptions / statistics & numerical data
  • Female
  • Health Services / statistics & numerical data
  • Humans
  • Male
  • Medical Records Systems, Computerized / statistics & numerical data
  • Middle Aged
  • Occupational Diseases / epidemiology*
  • Oregon / epidemiology
  • Prevalence
  • Registries
  • Reproducibility of Results
  • Sex Distribution