Skip to main content
Top
Published in: BMC Medical Informatics and Decision Making 1/2014

Open Access 01-12-2014 | Research article

Predicting length of stay from an electronic patient record system: a primary total knee replacement example

Authors: Evelene M Carter, Henry WW Potts

Published in: BMC Medical Informatics and Decision Making | Issue 1/2014

Login to get access

Abstract

Background

To investigate whether factors can be identified that significantly affect hospital length of stay from those available in an electronic patient record system, using primary total knee replacements as an example. To investigate whether a model can be produced to predict the length of stay based on these factors to help resource planning and patient expectations on their length of stay.

Methods

Data were extracted from the electronic patient record system for discharges from primary total knee operations from January 2007 to December 2011 (n = 2,130) at one UK hospital and analysed for their effect on length of stay using Mann-Whitney and Kruskal-Wallis tests for discrete data and Spearman’s correlation coefficient for continuous data. Models for predicting length of stay for primary total knee replacements were tested using the Poisson regression and the negative binomial modelling techniques.

Results

Factors found to have a significant effect on length of stay were age, gender, consultant, discharge destination, deprivation and ethnicity. Applying a negative binomial model to these variables was successful. The model predicted the length of stay of those patients who stayed 4–6 days (~50% of admissions) with 75% accuracy within 2 days (model data). Overall, the model predicted the total days stayed over 5 years to be only 88 days more than actual, a 6.9% uplift (test data).

Conclusions

Valuable information can be found about length of stay from the analysis of variables easily extracted from an electronic patient record system. Models can be successfully created to help improve resource planning and from which a simple decision support system can be produced to help patient expectation on their length of stay.
Appendix
Available only for authorised users
Literature
2.
go back to reference Webb A: The long goodbye. Health Serv J. in press Webb A: The long goodbye. Health Serv J. in press
4.
go back to reference Kulinskaya E, Kornbrot D, Gao H: Length of stay as a performance indicator: robust statistical methodology. IMA J Manag Math. 2005, 16: 369-381. 10.1093/imaman/dpi015.CrossRef Kulinskaya E, Kornbrot D, Gao H: Length of stay as a performance indicator: robust statistical methodology. IMA J Manag Math. 2005, 16: 369-381. 10.1093/imaman/dpi015.CrossRef
5.
go back to reference Smith ID, Elton R, Ballantyne JA, Brenkel IJ: Pre-operative predictors of the length of hospital stay in total knee replacement. J Bone Joint Surg. 2008, 90: 1435-1440.CrossRef Smith ID, Elton R, Ballantyne JA, Brenkel IJ: Pre-operative predictors of the length of hospital stay in total knee replacement. J Bone Joint Surg. 2008, 90: 1435-1440.CrossRef
6.
go back to reference Lorch SA, Zhang X, Rosenbaum PR, Evan-Shoshan O, Silber JH: Equivalent lengths of stay of pediatric patients hospitalized in rural and nonrural hospitals. Pediatrics. 2004, 114: e400-e408. 10.1542/peds.2004-0891.CrossRefPubMed Lorch SA, Zhang X, Rosenbaum PR, Evan-Shoshan O, Silber JH: Equivalent lengths of stay of pediatric patients hospitalized in rural and nonrural hospitals. Pediatrics. 2004, 114: e400-e408. 10.1542/peds.2004-0891.CrossRefPubMed
7.
go back to reference Almeida AI, Correia M, Camilo M, Ravasco P: Length of stay in surgical patients: nutritional predictive parameters revisited. Br J Nutr. 2012, 1: 1-7. Almeida AI, Correia M, Camilo M, Ravasco P: Length of stay in surgical patients: nutritional predictive parameters revisited. Br J Nutr. 2012, 1: 1-7.
8.
go back to reference Yasunaga H, Tsuchiya K, Matsuyama Y, Ohe K: Analysis of factors affecting operating time, postoperative complications, and length of stay for total knee arthroplasty: nationwide web-based survey. J Orthop Sci. 2012, 14: 10-16.CrossRef Yasunaga H, Tsuchiya K, Matsuyama Y, Ohe K: Analysis of factors affecting operating time, postoperative complications, and length of stay for total knee arthroplasty: nationwide web-based survey. J Orthop Sci. 2012, 14: 10-16.CrossRef
9.
go back to reference Jonas SC, Smith HK, Blair PS, Dacombe P, Weale AE: Factors influencing length of stay following primary total knee replacement in a UK specialist orthopaedic centre. Knee. 2012, 10: 1-6. Jonas SC, Smith HK, Blair PS, Dacombe P, Weale AE: Factors influencing length of stay following primary total knee replacement in a UK specialist orthopaedic centre. Knee. 2012, 10: 1-6.
10.
go back to reference Salinas FV, Liu SS, Mulroy MF: The effect of single-injection femoral nerve block versus continuous femoral nerve block after total knee arthroplasty on hospital length of stay and long-term functional recovery within an established clinical pathway. Anesth Analg. 2006, 102: 1234-1239. 10.1213/01.ane.0000198675.20279.81.CrossRefPubMed Salinas FV, Liu SS, Mulroy MF: The effect of single-injection femoral nerve block versus continuous femoral nerve block after total knee arthroplasty on hospital length of stay and long-term functional recovery within an established clinical pathway. Anesth Analg. 2006, 102: 1234-1239. 10.1213/01.ane.0000198675.20279.81.CrossRefPubMed
11.
go back to reference Huang SW, Chen PH, Chou YH: Effects of a preoperative simplified home rehabilitation education program on length of stay of total knee arthroplasty patients. Orthop Traumatol Surg Res. 2012, 98: 259-264. 10.1016/j.otsr.2011.12.004.CrossRefPubMed Huang SW, Chen PH, Chou YH: Effects of a preoperative simplified home rehabilitation education program on length of stay of total knee arthroplasty patients. Orthop Traumatol Surg Res. 2012, 98: 259-264. 10.1016/j.otsr.2011.12.004.CrossRefPubMed
12.
go back to reference Zheng F, Cammisa FP, Sandhu HS, Girardi FP, Khan SN: Factors predicting hospital stay, operative time, blood loss, and transfusion in patients undergoing revision posterior lumbar spine decompression, fusion, and segmental instrumentation. Spine. 2002, 27: 818-824. 10.1097/00007632-200204150-00008.CrossRefPubMed Zheng F, Cammisa FP, Sandhu HS, Girardi FP, Khan SN: Factors predicting hospital stay, operative time, blood loss, and transfusion in patients undergoing revision posterior lumbar spine decompression, fusion, and segmental instrumentation. Spine. 2002, 27: 818-824. 10.1097/00007632-200204150-00008.CrossRefPubMed
13.
go back to reference Mahadevan D, Challand C, Keenan J: Revision total hip replacement: predictors of blood loss, transfusion requirements, and length of hospitalisation. J Orthop Traumatol. 2010, 11: 159-165. 10.1007/s10195-010-0105-z.CrossRefPubMedPubMedCentral Mahadevan D, Challand C, Keenan J: Revision total hip replacement: predictors of blood loss, transfusion requirements, and length of hospitalisation. J Orthop Traumatol. 2010, 11: 159-165. 10.1007/s10195-010-0105-z.CrossRefPubMedPubMedCentral
16.
go back to reference Reed SD, Blough DK, Meyer K, Jarvik JG: Inpatient costs, length of stay, and mortality for cerebrovascular events in community hospitals. Neurology. 2001, 57: 305-314. 10.1212/WNL.57.2.305.CrossRefPubMed Reed SD, Blough DK, Meyer K, Jarvik JG: Inpatient costs, length of stay, and mortality for cerebrovascular events in community hospitals. Neurology. 2001, 57: 305-314. 10.1212/WNL.57.2.305.CrossRefPubMed
19.
go back to reference Lindsey JK, Jones B: Choosing among generalized linear models applied to medical data. Stat Med. 1998, 17: 59-68. 10.1002/(SICI)1097-0258(19980115)17:1<59::AID-SIM733>3.0.CO;2-7.CrossRefPubMed Lindsey JK, Jones B: Choosing among generalized linear models applied to medical data. Stat Med. 1998, 17: 59-68. 10.1002/(SICI)1097-0258(19980115)17:1<59::AID-SIM733>3.0.CO;2-7.CrossRefPubMed
20.
go back to reference Sharma A, Muir R, Johnston R, Carter E, Bowden G, Wilson-MacDonald J: Diabetes is predictive of longer hospital stay and increased rate of Clavien complications in spinal surgery in the UK. Ann R Coll Surg Engl. 2013, 95: 275-279. 10.1308/003588413X13511609958299.CrossRefPubMedPubMedCentral Sharma A, Muir R, Johnston R, Carter E, Bowden G, Wilson-MacDonald J: Diabetes is predictive of longer hospital stay and increased rate of Clavien complications in spinal surgery in the UK. Ann R Coll Surg Engl. 2013, 95: 275-279. 10.1308/003588413X13511609958299.CrossRefPubMedPubMedCentral
21.
go back to reference Crawford DA, Scully W, McFadden L, Manoso M: Preoperative predictors of length of hospital stay and discharge disposition following primary total knee arthroplasty at a military medical centre. Mil Med. 2011, 176: 304-307. 10.7205/MILMED-D-10-00042.CrossRefPubMed Crawford DA, Scully W, McFadden L, Manoso M: Preoperative predictors of length of hospital stay and discharge disposition following primary total knee arthroplasty at a military medical centre. Mil Med. 2011, 176: 304-307. 10.7205/MILMED-D-10-00042.CrossRefPubMed
22.
go back to reference Escalante A, Beardmore TD: Predicting length of stay after hip or knee replacement for rheumatoid arthritis. J Rheumatol. 1997, 24: 146-152.PubMed Escalante A, Beardmore TD: Predicting length of stay after hip or knee replacement for rheumatoid arthritis. J Rheumatol. 1997, 24: 146-152.PubMed
23.
go back to reference Baker DW, Hasnain-Wynia R, Kandula NR, Thompson J, Brown ER: Attitudes toward health care providers, collecting information about patients’ race, ethnicity, and language. Med Care. 2007, 44: 1034-1042.CrossRef Baker DW, Hasnain-Wynia R, Kandula NR, Thompson J, Brown ER: Attitudes toward health care providers, collecting information about patients’ race, ethnicity, and language. Med Care. 2007, 44: 1034-1042.CrossRef
24.
go back to reference Tavare A: Performance data: ready for the public?. BMJ. 2012, 345: 21-23. Tavare A: Performance data: ready for the public?. BMJ. 2012, 345: 21-23.
25.
go back to reference Watkins JR, Bryan S, Muris NM, Buxton MJ: Examining the influence of picture archiving communication systems and other factors upon the length of stay for patients with total hip and total knee replacements. Int J Technol Assess Health Care. 1999, 15: 497-505.PubMed Watkins JR, Bryan S, Muris NM, Buxton MJ: Examining the influence of picture archiving communication systems and other factors upon the length of stay for patients with total hip and total knee replacements. Int J Technol Assess Health Care. 1999, 15: 497-505.PubMed
26.
go back to reference Cookson R, Laudicella M: Do the poor cost much more? The relationship between small area income deprivation and length of stay for elective hip replacement in the English NHS from 2001 to 2008. Soc Sci Med. 2011, 72: 173-184. 10.1016/j.socscimed.2010.11.001.CrossRefPubMed Cookson R, Laudicella M: Do the poor cost much more? The relationship between small area income deprivation and length of stay for elective hip replacement in the English NHS from 2001 to 2008. Soc Sci Med. 2011, 72: 173-184. 10.1016/j.socscimed.2010.11.001.CrossRefPubMed
27.
go back to reference Barker KL, Reilly KA, Lowe CM, Beard DJ: Patient satisfaction with accelerated discharge following unilateral knee replacement. Int J Ther Rehabil. 2006, 13: 247-253.CrossRef Barker KL, Reilly KA, Lowe CM, Beard DJ: Patient satisfaction with accelerated discharge following unilateral knee replacement. Int J Ther Rehabil. 2006, 13: 247-253.CrossRef
28.
go back to reference Husted H, Holm G, Jacobsen S: Predictors of length of stay and patient satisfaction after hip and knee replacement surgery. Acta Orthop. 2008, 78: 168-173.CrossRef Husted H, Holm G, Jacobsen S: Predictors of length of stay and patient satisfaction after hip and knee replacement surgery. Acta Orthop. 2008, 78: 168-173.CrossRef
29.
go back to reference Raut S, Mertes SC, Muniz-Terrera G, Khanduja V: Factors associated with prolonged length of stay following a total knee replacement in patients aged over 75. Int Orthop. 2012, 36: 1601-1608. 10.1007/s00264-012-1538-1.CrossRefPubMedPubMedCentral Raut S, Mertes SC, Muniz-Terrera G, Khanduja V: Factors associated with prolonged length of stay following a total knee replacement in patients aged over 75. Int Orthop. 2012, 36: 1601-1608. 10.1007/s00264-012-1538-1.CrossRefPubMedPubMedCentral
Metadata
Title
Predicting length of stay from an electronic patient record system: a primary total knee replacement example
Authors
Evelene M Carter
Henry WW Potts
Publication date
01-12-2014
Publisher
BioMed Central
Published in
BMC Medical Informatics and Decision Making / Issue 1/2014
Electronic ISSN: 1472-6947
DOI
https://doi.org/10.1186/1472-6947-14-26

Other articles of this Issue 1/2014

BMC Medical Informatics and Decision Making 1/2014 Go to the issue