| Literature DB >> 35443953 |
Emily Eyles1,2, Maria Theresa Redaniel3,2, Tim Jones3,2, Marion Prat4, Tim Keen5.
Abstract
OBJECTIVES: The main objective of the study was to develop more accurate and precise short-term forecasting models for admissions and bed occupancy for an NHS Trust located in Bristol, England. Subforecasts for the medical and surgical specialties, and for different lengths of stay were realisedEntities:
Keywords: ACCIDENT & EMERGENCY MEDICINE; EPIDEMIOLOGY; HEALTH SERVICES ADMINISTRATION & MANAGEMENT; STATISTICS & RESEARCH METHODS
Mesh:
Year: 2022 PMID: 35443953 PMCID: PMC9021768 DOI: 10.1136/bmjopen-2021-056523
Source DB: PubMed Journal: BMJ Open ISSN: 2044-6055 Impact factor: 3.006
Figure 1Monthly ratio of elective to non-elective admissions, September 2016 to February 2020.
Outcome variables and explanatory variables
| Variable | Definition |
| Outcomes | |
| Admissions | Count of admissions to hospital, for a non-zero length of stay, that is, overnight stays |
| Bed occupancy | Count of hospital beds occupied, calculated as a count between admission and discharge dates, for non-zero lengths of stay |
| Explanatory variables | |
| Day of the week | Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday |
| Temperature last year | The average temperature in Celsius on the same day last year |
| Precipitation last year | The precipitation in millimetres on the same day last year |
| Holiday | Whether a day was a bank holiday, over Christmas week, or during the Easter holiday weekend |
Model specifications
| Outcome | Treatment specialty | Length of stay |
| Admissions | All | All |
| ≤48 hours | ||
| >48 hours | ||
| Medicine | All | |
| ≤48 hours | ||
| >48 hours | ||
| Surgery | All | |
| ≤48 hours | ||
| >48 hours | ||
| Bed occupancy | All | All |
| ≤48 hours | ||
| >48 hours | ||
| Medicine | All | |
| ≤48 hours | ||
| >48 hours | ||
| Surgery | All | |
| ≤48 hours | ||
| >48 hours |
Model specifications and accuracy
| Model | Outcome | (Sub)forecast | SARIMA (p, d, q) (P, D, Q) | Model accuracy (strict/moderate thresholds) | RMSE | MAPE | Mean of outcome | SD of outcome |
| 1 | Admissions | All data overall | (3,0,0) (1,0,0) | 60.0%/88.9% | 9.59 | 8.66 | 94.04 | 14.98 |
| 2 | Admissions | All medical | (3,0,2) (2,0,2) | 51.1%/84.4% | 8.98 | 9.44 | 79.14 | 19.32 |
| 3 | Admissions | All surgical | (1,0,2) (0,0,0) | 28.9%/57.8% | 4.59 | 19.86 | 20.65 | 5.31 |
| 4 | Admissions | All under 48-hour length of stay | (1,0,0) (1,0,0) | 28.9%/71.1% | 6.81 | 16.53 | 35.38 | 9.06 |
| 5 | Admissions | All over 48-hour length of stay | (3,0,1) (1,0,1) | 62.2%/88.9% | 7.22 | 10.78 | 55.14 | 10.04 |
| 6 | Admissions | Under 48-hour length of stay, medical | (4,0,0) (2,0,0) | 24.4%/48.9% | 6.45 | 18.64 | 30.59 | 10.21 |
| 7 | Admissions | Under 48-hour length of stay, surgical | (0,0,1) (0,0,0) | 11.1%/31.1% | 7.82 | 44.19 | 20.99 | 8.39 |
| 8 | Admissions | Over 48-hour length of stay, medical | (5,0,1) (2,0,0) | 53.3%/82.2% | 6.88 | 11.97 | 48.55 | 12.06 |
| 9 | Admissions | Over 48-hour length of stay, surgical | (3,0,3) (1,0,2) | 25.8%/46.7% | 3.40 | 27.45 | 11.87 | 3.74 |
| 10 | Bed occupancy | All data overall | (0,0,1) (1,0,0) | 40.0%/77.8% | 158.24 | 15.57 | 823.36 | 165.22 |
| 11 | Bed occupancy | All medical | (4,0,0) (2,0,0) | 37.8%/60.0% | 151.69 | 17.06 | 760.03 | 189.22 |
| 12 | Bed occupancy | All surgical | (0,0,1) (0,0,0) | 24.4%/37.8% | 64.50 | 35.40 | 162.62 | 67.71 |
| 13 | Bed occupancy | All under 48-hour length of stay | (3,0,0) (2,0,1) | 28.9%/66.7% | 15.72 | 16.41 | 82.3 | 21.06 |
| 14 | Bed occupancy | All over 48-hour length of stay | (0,0,1) (1,0,0) | 40.0%/75.6% | 159.55 | 17.6 | 767.41 | 177.2 |
| 15 | Bed occupancy | Under 48-hour length of stay, medical | (4,0,0) (2,0,0) | 22.2%/48.9% | 14.95 | 18.63 | 70.83 | 23.95 |
| 16 | Bed occupancy | Under 48-hour length of stay, surgical | (0,0,1) (0,0,0) | 15.6%/28.9% | 7.82 | 44.19 | 21 | 8.38 |
| 17 | Bed occupancy | Over 48-hour length of stay, medical | (2,0,1) (0,0,0) | 35.6%/57.8% | 152.7 | 19.15 | 673.24 | 181.24 |
| 18 | Bed occupancy | Over 48-hour length of stay, surgical | (0,0,1) (0,0,0) | 20.0%/35.6% | 64.95 | 44.22 | 141.63 | 67.49 |
Figure 2Autoregressive Integrated Moving Average (ARIMA) forecast for overall admissions to North Bristol NHS Trust (NBT).
Figure 3Forecast predictions for overall admissions (model 1) compared with the actual values and the North Bristol NHS Trust (NBT) model. ARIMA, Autoregressive Integrated Moving Average.