An Improvement in the Appointment Scheduling in Primary Health Care Centers Using Data Mining

  • Juan José CubillasEmail author
  • M. Isabel Ramos
  • Francisco R. Feito
  • Tomás Ureña
Systems-Level Quality Improvement
Part of the following topical collections:
  1. Systems-Level Quality Improvement


An optimal resource management in health care centers implies the use of an appropriate timetabling scheme to schedule appointments. Timetables of health centers are usually divided into time slots whose duration is equal to time required for clinical attendance. However doctors perform a series of tasks that are not always clinical in nature: issuing prescriptions or prescribing sick leave certificates. In this sense the time spent in attending a clinical or an administrative matter is different. This last required less time to attend the patient. This study is focused in the administrative task. A predictive model is generated to provide daily information on how many patients will go to the health center for an administrative issue. The accuracy of the model is less than 4,6 % absolute error and the improvement in scheduling appointments is a time saving of 21,73 %.


Appointment scheduling Primary health care Data mining 



This work has been partially supported by the Andalusian Health Service. Department of Equality, Health and Social Policies of the Junta of Andalusia, Spain.


  1. 1.
    Haux, R., Introduction of health information system to progress in the organization of health care. International Journal of Medical Informatics. 75(3–4):268–281, 2006.PubMedCrossRefGoogle Scholar
  2. 2.
    Rozenblum, R., Donzé, P. M., Hockey, G. E., Labuzetta, M. A., Zimlichman, E., et al., The impact of medical informatics on patient satisfaction: A USA-based literature review. International Journal of Medical Informatics. 82(3):141–158, 2013.PubMedCrossRefGoogle Scholar
  3. 3.
    Patrick, J., A Markov decision model for determining optimal outpatient scheduling. Health Care Management Science. 15:91–102, 2012.PubMedCrossRefGoogle Scholar
  4. 4.
    Wang, W. Y., and Gupta, D., Adaptive appointment systems with patient preferences. Manufacturing & Service Operations Management. 13(3):373–389, 2011.CrossRefGoogle Scholar
  5. 5.
    Kaandorp, G. C., and Koole, G., Optimal outpatient appointment scheduling. Health Care Management Science. 10:217–229, 2007.PubMedCrossRefGoogle Scholar
  6. 6.
    Gupta, D., and Denton, B., Appointment scheduling in health care: Challenges and opportunities. IIE Transactions. 40(9):800–819, 2008.CrossRefGoogle Scholar
  7. 7.
    Heaney DJ, Howe JG, Porter AM (1991). Factors influencing waiting times and consultation times in general practice. In: British Journal of General PracticeGoogle Scholar
  8. 8.
  9. 9.
  10. 10.
    Schwartz, J., Samet, J. M., and Patz, J. A., Hospital Admissions for Heart Disease: The Effects of Temperature and Humidity. Epidemiology. 15(6):755–761, 2004.PubMedCrossRefGoogle Scholar
  11. 11.
    Hong, Y. C., Rha, J. H., Lee, J. T., et al., Ischemic stroke associated with decrease in temperature. Epidemiology. 14:473–8, 2003.PubMedGoogle Scholar
  12. 12.
    Anderson, B. G., and Bell, M. L., Weather-Related Mortality. How Heat, Cold, and Heat Waves Affect Mortality in the United States. Epidemiology 20(2):205–213, 2009.PubMedCentralPubMedCrossRefGoogle Scholar
  13. 13.
    Reddy, V. M., Judd, O., and Khalils, H., Investigation of the influence of ambient temperature, atmospheric pressure and water vapour pressure on epistaxis admission rate. Rhinology. 48:348–351, 2010.PubMedGoogle Scholar
  14. 14.
    Dawson, J., Weir, C., Wright, F., et al., Associations between meteorological variables and acute stroke hospital admissions in the west of Scotland. Acta Neurologica Scandinavica. 117:85–89, 2008.PubMedGoogle Scholar
  15. 15.
    Harper, P. R., and Gamlin Adfaf, H. M., Reduced outpatient waiting times with improved appointment scheduling: a simulation modelling approach. OR Spectrum. 25:207–222, 2003.CrossRefGoogle Scholar
  16. 16.
    Bourdais, S., Galinier, P., and Pesant, G., Hibiscus: A constraint programming application to staff scheduling in Health Care. In: Rossi, F. (Ed.), CP 2003, LNCS 2833. Springer, Berlin Heidelberg, pp. 153–167, 2003.Google Scholar
  17. 17.
    Cayirli, T., Veral, E., and Rosen, H., Designing appointment scheduling systems for ambulatory care services. Health Care Manage Science. 9:47–58, 2006.CrossRefGoogle Scholar
  18. 18.
    Kaandorp, G. C., and Koole, G., Optimal outpatient appointment scheduling. Health Care Manage Science. 10:217–229, 2007.CrossRefGoogle Scholar
  19. 19.
    Glowacka, K. J., Henry, R. M., and May, J. H., A hybrid data mining/simulation approach for modeling outpatient no-shows in clinic scheduling. Journal of the Operational Research Society. 60:1056–1068, 2009.CrossRefGoogle Scholar
  20. 20.
    Liu, N., Ziya, S., and Kulkarni, V. G., Dynamic scheduling of outpatient appointments under patient no-shows and cancellations. Manufacturing & Service Operations Management. 12(2):347–364, 2010.CrossRefGoogle Scholar
  21. 21.
    D’amato, G., and Cecchi, L., Effects of climate change on environmental factors in respiratory allergic diseases. Clinical & Experimental Allergy. 38(8):1264–1274, 2008.CrossRefGoogle Scholar
  22. 22.
    Shea, K. M., Truckner, R. T., Weber, R. W., and Peden, D. B., Climate change and allergic disease. Journal of Allergy and Clinical Immunology. 122(3):443–453, 2008.PubMedCrossRefGoogle Scholar
  23. 23.
  24. 24.
    Zhang R, Zhang S, Lan Y, Jiang J (2008) Network Anomaly Detection Using One Class Support Vector Machine. In: International multiconference of engineers and computer scientistsGoogle Scholar
  25. 25.
    Chatterjee, S., and Hadi, A. S., Regression Analysis By Example, 5th edition. Wiley, New York, 2012.Google Scholar
  26. 26.
    Mandel J (2012). The statistical analysis of experimental data. Courier Dover PublicationsGoogle Scholar
  27. 27.
    Cameron AC, Trivedi PK (2012). Regression analysis of count data. Cambridge University PressGoogle Scholar
  28. 28.
    Grünwald P (2010) Advances in Minimum Description Length: Theory and Applications. In: Jae Myung, Mark A. Pitt, Peter D. Grunwald, eds. MIT PressGoogle Scholar
  29. 29.
    Dobson AJ (2002) An Introduction to Generalized Linear Models. In Chatfield C and Zidek J, eds. Texts in Statistical Science Series. Chapman & Hall/CRC: 90–100.Google Scholar
  30. 30.
    Myers RH, Montgomery DC, Vining GG, Robinson TJ (2012). Generalized Linear Models: with Applications in Engineering and the Sciences. John Wiley & SonsGoogle Scholar
  31. 31.
    Smola, A. J., and Schölkopf, B., A tutorial on support vector regression. Statistics and computing. 14:199–222, 2004.CrossRefGoogle Scholar
  32. 32.
    Press WH et al. (2007) Section Support vector machines. In Press WH, Teukolsky SA, Vetterling WT and Flannery BP, eds. Numerical recipes: The Art of Scientific Computing. New York: Cambridge University: 16.5.Google Scholar
  33. 33.
    Cristianini N, Shawe-Taylor J (2000) An introduction to support vector machines and other kernel based methods. In Cristianini N and Shawe-Taylor J. Cambridge: Cambridge University Press: 6.Google Scholar
  34. 34.
    Sukenik, S. D., and Flusser, A.-S. M., The role of spa therapy in various rheumatic diseases. Rheumatic Disease Clinics of North America. 25(4):883–897, 1999.PubMedCrossRefGoogle Scholar
  35. 35.
    Ackerstaff, A. H., Fuller, D., Irvin, M., et al., Multicenter study assessing effects of heat and moisture exchanger use on respiratory symptoms and voice quality in laryngectomized individuals. Otolaryngology-Head and Neck Surgery. 129(6):705–712, 2003.PubMedCrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media New York 2014

Authors and Affiliations

  • Juan José Cubillas
    • 1
    Email author
  • M. Isabel Ramos
    • 2
  • Francisco R. Feito
    • 3
  • Tomás Ureña
    • 4
  1. 1.TIC-144 Andalusian Research Plan (PAI), Department of Computer ScienceUniversity of JaenJaenSpain
  2. 2.Department of Cartography, Geodesy and Photogrammetry EngineeringUniversity of JaenJaenSpain
  3. 3.Department of Computer ScienceUniversity of JaenJaenSpain
  4. 4.Jaen Sanitary DistrictAndalusian Health ServiceJaenSpain

Personalised recommendations