| Literature DB >> 29544481 |
Chiara Anna Parente1, Domenico Salvatore2, Giampiero Maria Gallo3, Fabrizio Cipollini4.
Abstract
BACKGROUND: In almost all healthcare systems, no-shows (scheduled appointments missed without any notice from patients) have a negative impact on waiting lists, costs and resource utilization, impairing the quality and quantity of cares that could be provided, as well as the revenues from the corresponding activity. Overbooking is a tool healthcare providers can resort to reduce the impact of no-shows.Entities:
Keywords: Healthcare; Logistic regression; No-show; Overbooking; Scheduling; Simulation
Mesh:
Year: 2018 PMID: 29544481 PMCID: PMC5856203 DOI: 10.1186/s12913-018-2979-z
Source DB: PubMed Journal: BMC Health Serv Res ISSN: 1472-6963 Impact factor: 2.655
Definition of the variables included in the analyses
| Variable | Description |
|---|---|
| No-show | Missing a scheduled appointment without canceling it. When a patient cancelled his reservation, in fact, this was removed just from the dependent variable because a cancelled appointment could not be classified as a no-show because the slot was made available for another patient. |
| Insurance status | In Italy, the majority of the examinations is covered by the NHS, but there is a portion that is privately paid by patients |
| Rate of previous cancellations | Number of cancellations divided by number of reservations in previous examinations of the booked patient since 2012 in any ward |
| Rate of previous no-shows | Number of no-show divided by number of reservations in previous examinations of the booked patient since 2012 in any ward |
| Booking confirmation | An automated phone service calls patients aged over 65 2 days before the appointment to get a confirmation |
| Type of booking | Method of reservation used by patients |
| Time of the day | MR and CT wards had an opening time ranging from 6 AM to 2 AM (+1d); all remaining wards had opening time 8 AM - 8 PM. Accordingly, we considered the following time of the day: |
| Long weekend | It indicated whether the day of the appointment fell in a week with a public holiday |
| Weather forecast | An automated system downloads every day from the web ( |
| Text message reminder service | Two days before the examination, an automated service sends a text message to all patients aged between 18 and 65 (active since April 2014) |
| No NHS coverage period | In Italy, the NHS covers most of the examinations until a cap on the NHS budget was reached, causing a stop in the coverage. This happened, usually, in the last weeks of the year |
| Price of the examination | Price paid by the patient. It was set to zero for the examinations covered by NHS and to the whole price otherwise |
| Waiting list | Number of days between the booking and the examination |
| Time allowed | Expected duration of the examination |
| Hourly revenue | The revenues of all examinations divided by the product between the number of working hours and the number of active MR scanners |
| Waiting time | Difference between the time when the patient starts his/her examination and the latest between the scheduled time of the appointment and the arrival time at the healthcare center |
| Idle time | Idle time of the scanners across the appointments |
| Overtime | Staff overtime at the end of the day |
Descriptive statistics
| Variable | Total | No-Show | Show | Test statistic |
|---|---|---|---|---|
|
| ||||
| Gender | 20.56 *** | |||
| Male | 45.78%(35,152) | 45.78 (35152) | 46.11%(30,374) | |
| Female | 54.22%(41,629) | 56.23%(6137) | 53.89%(35,492) | |
| Age group | 224.26 *** | |||
| 0–18 | 4.26%(3268) | 4.56%(498) | 4.21%(2770) | |
| 19–45 | 35.2%(27,030) | 40.35%(4404) | 34.35%(22,626) | |
| 46–64 | 37.64%(28,901) | 36.78%(4014) | 37.78%(24,887) | |
| 65–79 | 20.31%(15,597) | 15.9%(1736) | 21.04%(13,861) | |
| 80+ | 2.59%(1985) | 2.41%(263) | 2.61%(1722) | |
| Insurance status | 10.68 ** | |||
| NHS | 86.31%(66,270) | 87.31%(9530) | 86.14%(56,740) | |
| Private | 13.69%(10,511) | 12.69%(1385) | 13.86%(9126) | |
| Rate of previous cancellations | 0.21 ± 0.26 | 0.19 ± 0.25 | 0.21 ± 0.26 | 6.22 *** |
| Rate of previous no-shows | 0.04 ± 0.11 | 0.05 ± 0.13 | 0.03 ± 0.1 | −14.11 *** |
| Type of patient | 443.76 *** | |||
| New patient | 37.25%(28,602) | 46.28%(5052) | 35.75%(23,550) | |
| Returned patient | 62.75%(48,179) | 53.72%(5863) | 64.25%(42,316) | |
| Booking confirmation | 1294.47 *** | |||
| Not confirmed | 58.61%(45,005) | 74.33%(8113) | 56.01%(36,892) | |
| Confirmed | 41.39%(31,776) | 25.67%(2802) | 43.99%(28,974) | |
| Type of booking | 42.05 *** | |||
| Contact center | 99.8%(76,629) | 99.54%(10,865) | 99.85%(65,764) | |
| Web | 0.2%(152) | 0.46%(50) | 0.15%(102) | |
|
| ||||
| Day of the week | 44.49 *** | |||
| Monday | 15.61%(11,985) | 16.76%(1829) | 15.42%(10,156) | |
| Tuesday | 16.82%(12,918) | 16.56%(1807) | 16.87%(11,111) | |
| Wednesday | 16.19%(12,432) | 15.72%(1716) | 16.27%(10,716) | |
| Thursday | 16.61%(12,751) | 16.68%(1821) | 16.59%(10,930) | |
| Friday | 16.53%(12,694) | 15.62%(1705) | 16.68%(10,989) | |
| Saturday | 12.22%(9380) | 11.64%(1270) | 12.31%(8110) | |
| Sunday | 6.02%(4621) | 7.03%(767) | 5.85%(3854) | |
| Month of the year | 46.1 *** | |||
| January | 9.72%(7466) | 9.73%(1062) | 9.72%(6404) | |
| February | 10.34%(7940) | 10.93%(1193) | 10.24%(6747) | |
| March | 11.34%(8709) | 11.74%(1281) | 11.28%(7428) | |
| April | 9.69%(7437) | 9.69%(1058) | 9.68%(6379) | |
| May | 11.23%(8619) | 10.43%(1138) | 11.36%(7481) | |
| June | 10.15%(7797) | 10.46%(1142) | 10.1%(6655) | |
| July | 9.74%(7478) | 9.69%(1058) | 9.75%(6420) | |
| August | 5.58%(4285) | 5.34%(583) | 5.62%(3702) | |
| September | 9.47%(7270) | 8.84%(965) | 9.57%(6305) | |
| October | 7.12%(5464) | 7.95%(868) | 6.98%(4596) | |
| November | 3.55%(2726) | 2.99%(326) | 3.64%(2400) | |
| December | 2.07%(1590) | 2.21%(241) | 2.05%(1349) | |
| Year | 83.09 *** | |||
| 2012 | 28.81%(22,122) | 32.24%(3519) | 28.24%(18,603) | |
| 2013 | 34.55%(26,530) | 34.08%(3720) | 34.63%(22,810) | |
| 2014 | 36.64%(28,129) | 33.68%(3676) | 37.13%(24,453) | |
| Time of the day | 186.99 *** | |||
| 6 AM–8 AM | 12.02%(9229) | 11.66%(1273) | 12.08%(7956) | |
| 8 AM-1 PM | 35.92%(27,582) | 31.54%(3443) | 36.65%(24,139) | |
| 1 PM–8 PM | 39.46%(30,299) | 40.88%(4462) | 39.23%(25,837) | |
| 8 PM-2 AM (+1d) | 12.6%(9671) | 15.91%(1737) | 12.05%(7934) | |
| Long weekend | 0.69 | |||
| No | 85.64%(65,753) | 85.9%(9376) | 85.59%(56,377) | |
| Yes | 14.36%(11,028) | 14.1%(1539) | 14.41%(9489) | |
| Weather forecast | 0.84 | |||
| Clear | 63.04%(48,406) | 62.69%(6843) | 63.1%(41,563) | |
| Rain | 24.76%(19,014) | 25.1%(2740) | 24.71%(16,274) | |
| Storm | 12.19%(9361) | 12.2%(1332) | 12.19%(8029) | |
| Text message reminder service | 20.54 *** | |||
| Not yet activated | 75.29%(57,806) | 76.86%(8389) | 75.03%(49,417) | |
| Activated but not sent | 16.04%(12,312) | 14.61%(1595) | 16.27%(10,717) | |
| Sent | 8.68%(6663) | 8.53%(931) | 8.7%(5732) | |
|
| ||||
| No NHS coverage period | 0.002 | |||
| No | 90.36%(69,379) | 90.34%(9861) | 90.36%(59,518) | |
| Yes | 9.64%(7402) | 9.66%(1054) | 9.64%(6348) | |
| Contrast agent | 31.36 *** | |||
| No | 75%(57,583) | 77.15%(8421) | 74.64%(49,162) | |
| Yes | 25%(19,198) | 22.85%(2494) | 25.36%(16,704) | |
| Price of the examination | 6.96 *** | |||
| Insured Patients | 0 ± 0 | 0 ± 0 | 0 ± 0 | |
| Other Patients | 258.16 ± 117.44 | 234.99 ± 110.22 | 261.67 ± 118.11 | |
| Waiting list | 7.35 ± 7.72 | 7.92 ± 9.23 | 7.25 ± 7.44 | −7.13 *** |
| Time allowed | 38.43 ± 22.99 | 38.25 ± 21.29 | 38.46 ± 23.26 | 0.35 |
Descriptive statistics are reported as percentages and number of observations (in parentheses) for categorical variables, as mean ± SD for continuous variables. The last column reports the t-value or the χ2-value together with the significance symbols
Base Levels for the categorical variables included in the regression model
| Variable | Base Level |
|---|---|
| Gender | Male |
| Age group | 46–64 |
| Insurance Status | NHS |
| Type of patient | New Patient |
| Booking confirmation | Not confirmed |
| Type of booking | Contact Center |
| Day of the week | Wednesday |
| Month of the year | March |
| Year | 2012 |
| Time of the day | 8 AM-1 PM |
| Long weekend | No |
| Weather forecast | Clear |
| Text message reminder service | Not yet activated |
| No NHS coverage period | No |
| Contrast agent | No |
Logistic regression results
| Variable | Magnetic Resonance | All wards (average) | |
|---|---|---|---|
| Intercept | −1.684 (−42.67)*** | ||
|
| |||
| Gender | Female | 0.113 (7.62) *** | 50% |
| Age group | 0–18 | −0.003 (− 0.09) | 43% |
| ” | 19–45 | 0.105 (6.2) *** | 71% |
| ” | 65–79 | −0.118 (−5.39) *** | 57% |
| ” | 80+ | 0.066 (1.38) | 29% |
| Insurance status | Private | 0.371 (4.3) *** | 100% |
| Rate of previous cancellations | 0.198 (5.82) *** | 29% | |
| Rate of previous no-shows | 1.465 (19.97) *** | 71% | |
| Type of patient | Returned patient | − 0.45 (−28.27) *** | 100% |
| Booking confirmation | Confirmed | −0.98 (−53.38) *** | 100% |
| Type of booking | Web | 0.933 (9.5) *** | 29% |
|
| |||
| Day of the week | Monday | 0.065 (2.63) ** | 14% |
| ” | Tuesday | 0.04 (1.61) | 57% |
| ” | Thursday | 0.063 (2.53) * | 14% |
| ” | Friday | 0.008 (0.32) | 0% |
| ” | Saturday | 0.085 (3.11) ** | 43% |
| ” | Sunday | 0.337 (9.79) *** | 50% |
| Month of the year | January | −0.033 (−0.98) | 0% |
| ” | February | 0.052 (1.59) | 0% |
| ” | April | −0.054 (−1.53) | 0% |
| ” | May | −0.087 (−2.63) ** | 0% |
| ” | June | 0.037 (1.1) | 14% |
| ” | July | 0.001 (0.03) | 0% |
| ” | August | −0.029 (−0.74) | 0% |
| ” | September | −0.099 (−2.91) ** | 0% |
| ” | October | 0.067 (1.53) | 0% |
| ” | November | −0.22 (−3.35) *** | 14% |
| ” | December | 0.046 (0.63) | 0% |
| Year | 2013 | −0.122 (−6.07) *** | 17% |
| ” | 2014 | −0.395 (−12.68) *** | 29% |
| Time of the day | 6 AM–8 AM | 0.165 (6.31) *** | 100% |
| ” | 1 PM–8 PM | 0.235 (13.58) *** | 57% |
| ” | 8 PM-2 AM (+1d) | 0.507 (20.42) *** | 100% |
| Long weekend | Yes | −0.041 (−1.9) | 0% |
| Weather forecast | Rain | 0.056 (3.13) ** | 29% |
| ” | Storm | 0.027 (1.23) | 0% |
| Text message reminder service | Activated but not sent | 0.063 (1.84) | 0% |
| ” | Sent | −0.178 (−4.9) *** | 67% |
|
| |||
| No NHS coverage period | Yes | 0.27 (4.6) *** | 86% |
| Contrast agent | Yes | 0.018 (0.97) | 0% |
| Price of the examination | −0.002 (−7.14) *** | 50% | |
| Waiting list | 0.024 (21.79) *** | 71% | |
| Time allowed | 0.002 (5.7) *** | 43% | |
|
| Magnetic Resonance | All wards(average) | |
| R2 | 0.05 | 0.19 | |
| Hosmer-Lemeshow | 25.76 | 15.11 | |
| AIC | 59,787.9 | 16,085.55 | |
| AUC | 0.66 | 0.77 | |
|
| Magnetic Resonance | All wards (average) | |
| Hosmer-Lemeshow | 38.31 | 26.52 | |
| AUC | 0.65 | 0.75 | |
For the MR ward, estimated parameters, z-value (in parentheses) and significance symbols are reported. For the remaining wards, we reported how many times, in percentage, each variable is significant at α = 0.05. Significance codes: 0’***’ 0.001’**’ 0.01’*’ 0.05
Overbooking quasi experiment. (OB=Overbooking)
| Variable | Perc. difference (with - without OB) | Difference (with - without OB) | t-stats |
|---|---|---|---|
| Hourly Revenue (Eur) | 15.4 | 6.9 | 2.76 |
| Waiting time (Min) | 3.66 | 6.2 | 0.34 |
| Idle time (Min) | −1.42 | −9.1 | −1.33 |
| Overtime (Min) | 4.05 | 10 | 0.3 |
| Number of days with OB | 112 | ||
| of days without OB | 62 | ||
Simulation analysis with one scanner and different levels of no-show
| Hourly Revenue (Eur) | Waiting time (Min) | Idle time (Min) | Overtime (Min) | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No-show (%) | Diff. (%) | Average t-stats | Reject (%) | Diff. | Average t-stats | Reject (%) | Diff. | Average t-stats | Reject (%) | Diff. | Average t-stats | Reject (%) |
| 5 | 2.9 | 5.76 | 100 | 1.2 | 2.26 | 56 | −0.9 | −4.12 | 100 | 0.2 | 0.18 | 6 |
| 10 | 7.8 | 11.13 | 100 | 2.6 | 4.85 | 100 | −2.5 | −9.19 | 100 | 0.2 | 1.17 | 7 |
| 15 | 12.6 | 14.35 | 100 | 3.6 | 6.44 | 100 | −4.1 | −12.30 | 100 | 0.5 | 0.44 | 7 |
| 30 | 26.2 | 18.87 | 100 | 4.9 | 8.10 | 100 | −9.3 | −16.27 | 100 | 0.8 | 0.75 | 8 |
| 45 | 40.0 | 20.91 | 100 | 4.6 | 7.33 | 100 | −16.6 | −16.97 | 100 | 0.9 | 1.06 | 18 |
Reject indicates the percentage of rejections of the t-test at 5%. Difference is computed as with minus without overbooking
Simulation analysis with fixed no-show level at 15% and different number of active MR scanners
| Hourly Revenue (Eur) | Waiting time (Min) | Idle time (Min) | Overtime (Min) | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MR scanners | Diff. (%) | Average t-stats | Reject (%) | Diff. | Average t-stats | Reject (%) | Diff. | Average t-stats | Reject (%) | Diff. | Average t-stats | Reject (%) |
| 1 | 12.4 | 6.26 | 100 | 6.7 | 7.08 | 100 | −3.3 | −12.36 | 100 | 0.6 | 0.79 | 12 |
| 2 | 13.3 | 10.32 | 100 | 4.4 | 8.61 | 100 | − 3.5 | −18.75 | 100 | 0.8 | 0.47 | 9 |
| 3 | 13.6 | 13.30 | 100 | 3.5 | 9.02 | 100 | −3.6 | −23.19 | 100 | 1.1 | 0.58 | 9 |
| 4 | 13.7 | 15.56 | 100 | 3.0 | 9.66 | 100 | −3.6 | −27.34 | 100 | 1.3 | 0.57 | 12 |
| 5 | 13.8 | 17.52 | 100 | 2.7 | 9.75 | 100 | −3.6 | −30.46 | 100 | 2.0 | 0.78 | 12 |
Reject indicates the percentage of rejections of the t-test at 5%. Difference is computed as with minus without overbooking