| Literature DB >> 36011177 |
Justin Chu1, Chung-Ho Hsieh2, Yi-Nuo Shih1, Chia-Chun Wu3, Anandakumar Singaravelan3, Lun-Ping Hung4, Jia-Lien Hsu1.
Abstract
Effectively handling the limited number of surgery operating rooms equipped with expensive equipment is a challenging task for hospital management such as reducing the case-time duration and reducing idle time. Improving the efficiency of operating room usage via reducing the idle time with better scheduling would rely on accurate estimation of surgery duration. Our model can achieve a good prediction result on surgery duration with a dozen of features. We have found the result of our best performing department-specific XGBoost model with the values 31.6 min, 18.71 min, 0.71, 28% and 27% for the metrics of root-mean-square error (RMSE), mean absolute error (MAE), coefficient of determination (R2), mean absolute percentage error (MAPE) and proportion of estimated result within 10% variation, respectively. We have presented each department-specific result with our estimated results between 5 and 10 min deviation would be more informative to the users in the real application. Our study shows comparable performance with previous studies, and the machine learning methods use fewer features that are better suited for universal usability.Entities:
Keywords: XGBoost; machine learning; operating room usage time; scheduling
Year: 2022 PMID: 36011177 PMCID: PMC9408683 DOI: 10.3390/healthcare10081518
Source DB: PubMed Journal: Healthcare (Basel) ISSN: 2227-9032
Data demographic.
| Dept. | Sample Count | Doctors | Nurses | Unique OPs |
|---|---|---|---|---|
| 16 | 21,968 | 58 | 182 | 367 |
| 29 | 20,476 | 52 | 169 | 266 |
| 14 | 14,763 | 52 | 185 | 602 |
| 17 | 13,566 | 72 | 179 | 652 |
| 22 | 13,338 | 60 | 178 | 674 |
| 24 | 12,410 | 69 | 185 | 279 |
| 11 | 9874 | 39 | 175 | 123 |
| 28 | 7670 | 46 | 168 | 448 |
| 13 | 4017 | 43 | 170 | 213 |
| 15 | 1965 | 8 | 155 | 141 |
| 12 | 1800 | 34 | 164 | 176 |
| 66 | 635 | 25 | 141 | 136 |
| 31 | 521 | 6 | 113 | 22 |
| 30 | 454 | 26 | 130 | 155 |
| 5 | 13 | 4 | 29 | 7 |
| 25 | 4 | 2 | 12 | 4 |
| 18 | 2 | 2 | 6 | 3 |
| All | 123,476 | 158 | 202 | 1916 |
Figure 1Feature demographic.
Figure 2Process flowchart of data and model.
Figure 3ANN model structure.
Figure 41dCNN model structure (Visual representation of the model architecture with two one-dimensional CNN layers followed by three fully connected layers used in this study).
Results of all-inclusive models.
| Method | RMSE | MAPE | MAE |
|
|
|---|---|---|---|---|---|
| (min) | (%) | (min) | (%) | ||
| XGBoost | 37.2 | 31 | 21.05 | 0.72 | 25 |
| Random Forest | 36.0 | 29 | 20.49 | 0.76 | 26 |
| ANN | 47.6 | 45 | 20.14 | 0.64 | 26 |
| 1-d CNN | 48.6 | 47 | 27.57 | 0.63 | 19 |
Figure 5All-inclusive model with XGBoost (The visualization of training and testing data for all-inclusive model with XGBoost).
Figure 6All-inclusive model with Random Forest (The visualization of training and testing data for all-inclusive model with random forest).
Figure 7All-inclusive model with 1dCNN (The visualization of training and testing data for all-inclusive model with 1dCNN).
Figure 8All-inclusive model with ANN (The visualization of training and testing data for all-inclusive model with ANN).
Department-Specific Model Result.
| (a) Random Forest Model Results | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
|
|
|
|
| < | < |
|
|
|
|
|
|
|
|
|
| |||
| 16 | 26.58 | 14.51 | 30 | 0.72 | 24 | 59 | 33 | 77 | 60 | 21,968 |
| 29 | 11.74 | 6.81 | 29 | 0.87 | 27 | 80 | 60 | 91 | 77 | 20,476 |
| 14 | 38.00 | 21.63 | 31 | 0.64 | 24 | 44 | 24 | 67 | 55 | 14,763 |
| 17 | 42.51 | 26.80 | 24 | 0.66 | 28 | 34 | 18 | 63 | 53 | 13,566 |
| 22 | 38.42 | 24.84 | 26 | 0.48 | 29 | 34 | 19 | 62 | 52 | 13,338 |
| 24 | 20.43 | 13.72 | 19 | 0.79 | 34 | 52 | 28 | 73 | 58 | 12,410 |
| 11 | 32.33 | 18.81 | 30 | 0.85 | 27 | 48 | 28 | 68 | 55 | 9874 |
| 28 | 47.86 | 25.88 | 31 | 0.68 | 26 | 40 | 22 | 66 | 56 | 7670 |
| 13 | 74.73 | 49.76 | 24 | 0.47 | 33 | 17 | 09 | 52 | 48 | 4017 |
| 15 | 35.63 | 15.11 | 21 | −0.26 | 32 | 54 | 28 | 76 | 61 | 1965 |
| 12 | 62.21 | 43.15 | 28 | 0.67 | 24 | 22 | 10 | 53 | 45 | 1800 |
| Average | 31.98 | 19.15 | 27 | 0.69 | 27 | 50 | 30 | 72 | 59 | 121,847 |
|
| ||||||||||
|
|
|
|
|
|
|
|
| < | < |
|
|
|
|
|
|
|
|
|
| |||
| 16 | 29.94 | 14.65 | 30 | 0.66 | 23 | 60 | 35 | 79 | 62 | 21,968 |
| 29 | 13.20 | 7.42 | 32 | 0.85 | 27 | 78 | 56 | 90 | 76 | 20,476 |
| 14 | 32.30 | 19.98 | 30 | 0.68 | 23 | 43 | 23 | 68 | 56 | 14,763 |
| 17 | 39.77 | 24.55 | 24 | 0.70 | 30 | 37 | 19 | 64 | 54 | 13,566 |
| 22 | 35.32 | 23.70 | 25 | 0.62 | 30 | 33 | 18 | 62 | 54 | 13,338 |
| 24 | 22.34 | 14.01 | 19 | 0.76 | 36 | 54 | 28 | 74 | 58 | 12,410 |
| 11 | 33.48 | 19.10 | 28 | 0.87 | 25 | 46 | 25 | 71 | 58 | 9874 |
| 28 | 51.31 | 28.14 | 33 | 0.71 | 22 | 36 | 18 | 64 | 54 | 7670 |
| 13 | 65.05 | 45.95 | 23 | 0.64 | 30 | 21 | 12 | 55 | 51 | 4017 |
| 15 | 35.50 | 15.55 | 22 | −0.24 | 30 | 52 | 24 | 73 | 59 | 1965 |
| 12 | 56.67 | 38.27 | 26 | 0.73 | 31 | 25 | 09 | 56 | 47 | 1800 |
| Average | 31.60 | 18.71 | 28 | 0.71 | 27 | 50 | 30 | 73 | 60 | 121,847 |
* proportion of samples within the ± variation; ** proportion of predicted samples within acceptable overtime in minutes.
Figure 9Total time distribution of the top 5 commonly performed procedures for each department.
Comparison with previous studies.
| Approach | RMSE | MAPE | MAE |
| ±10% |
|---|---|---|---|---|---|
| (min) | (%) | (min) | (%) | ||
| Linear Regression [ | 48.64 | n/a | 31.3 | n/a | n/a |
| Ref. XGBoost [ | n/a | 27 | n/a | 0.77 | 32 |
| Ref. Random Forest [ | n/a | 39 | n/a | 0.93 | 23 |
| XGBoost-HY [ | 36.64 | 35.16 | 21.52 | n/a | n/a |
| XGBoost-SH [ | 40.26 | 35.11 | 25.23 | n/a | n/a |
| XGBoost - Department Specific ( | 31.60 | 28 | 18.71 | 0.71 | 27 |
| Random Forest - Department Specific ( | 31.98 | 27 | 19.15 | 0.69 | 27 |
| ANN - All inclusive | 47.6 | 45 | 20.14 | 0.64 | 26 |
| 1-d CNN - All inclusive | 48.6 | 47 | 28.77 | 0.65 | 17 |
Raw data feature columns with descriptions.
| Column Namea | Descriptions |
|---|---|
| ODR_LOGN | Surgery serial number |
| ODR_CHRT | Chart Number |
| ODR_TXDT | Date |
| ODR_OPRM | Operating Room ID |
| ODR_DEPT | Department |
| ODR_PSRC | Patient Source (O: Outpatient, I: Inpatient, E: Emergency room) |
| ODR_BDNO | Bed number |
| ODR_EFLG | Emergency Surgery |
| ODR_IPNO | Inpatient Number |
| ODR_AS_D | Anesthesia Start (date) |
| ODR_AS_T | Anesthesia Start (time) |
| ODR_AE_D | Anesthesia End(date) |
| ODR_AE_T | Anesthesia End(time) |
| ODR_IN_D | Enter OR room (date) |
| ODR_IN_T | Enter OR room (time) |
| ODR_OS_D | Operation Start (date) |
| ODR_OS_T | Operation Start (time) |
| ODR_OE_D | Operation End (date) |
| ODR_OE_T | Operation End (time) |
| ODR_OT_D | Exit OR room (date) |
| ODR_OT_T | Exit OR room (time) |
| ODR_OP_1 ∼ODR_OP_4 | Operating procedure type’s IDs |
| ODR_KF_2 ∼ODR_KF_4 | N/A |
| ODR_SK_2 ∼ODR_SK_4 | N/A |
| ODR_M_DR | Main Doctor |
| ODR_DN_1 | scrub nurse 1 |
| ODR_DN_2 | scrub nurse 2 |
| ODR_WN_1 | circulation nurse 1 |
| ODR_WN_2 | circulation nurse 2 |
| ODR_AD_1 ∼ODR_AD_4 | N/A |
| ODR_PAYK | Payment category (01- Self-Pay, 30-Health insurance) |
| ODR_OPID | Operation ID |
| ODR_ANAM | Anesthesia methods |
| ODR_AN_D | Anesthesiologist (Doctor) |
| ODR_INDR | Anesthesia assessment Doctor |
| ODR_ASA | Anesthesia risk1∼5 (low∼high) |
| ODR_IRFG | N/A |
| ODR_IDFC | N/A |
| ODR_OPAG | N/A |
| ODR_FAID | N/A |
| ODR_DEAD | N/A |
| ODR_SAT1 ∼ODR_SAT5 | N/A |
| ODR_ANS1 ∼ODR_ANS5 | N/A |
| ODR_M_D2 | Assistant Doctors 2 ∼4 |
| ODR_PKN1 ∼ODR_PKN5 | N/A |
| ODR_TIM1 ∼ODR_TIM5 | N/A |
| ODR_CHRF | N/A |
| ODR_SPKD | N/A |
| ODR_ORMT | N/A |
| ODR_ANMT | N/A |
| ODR_ANT1 ∼ODR_ANT3 | Anesthesia method’s notes |
| ODR_WOUD | Wound cleanness: 1: clean 2: cleaned contaminated 3: contaminated 4: dirty |
| ODR_ITE1 ∼ODR_ITE4 | N/A |
| ODR_NPRO | N/A |
| ODR_PC01 ∼ODR_PC20 | N/A |
| ODR_PRDG | Operating procedure name |
| ODR_FIND | Finding |
| ODR_OPF | Finding during procedure |
| ODR_OPP | Operating procedure |
| ODR_PODG | Post-operation diagnosis |