
B-1409/268-107) by the Institutional Review Board of the Seoul National University Bundang Hospital, which waived patients’ informed consent.

For accurate data analysis, the following data were excluded: data presumed to have been wrongly entered, such as transfer note dates recorded before the admission date or after the discharge date transfer completion dates recorded before the admission date and procedures performed beyond the extracted date. Finally, data from 45,546 subjects were analyzed. In a nutshell, out of a total of 53,965 subjects, 8,419 subjects were excluded due to repeat admission for unexpected events (122), lack of a discharge date (2), and day surgery (8,295). They were also removed from the set of target subjects being analyzed. Also, there was a lack of a discharge date for two subjects, and 8,295 patients were received the day surgery which does not have to be hospitalized.
#Statistical analysis in excel vs diagnostics full
The aim of this study was to determine a methodology that could be applied to help hospitals manage the duration of inpatient stay more efficiently.Ĭase ID: a unique ID for identification of inpatients.įor the full year of 2013, we have collected 53,965 subjects except for 745 and 1,029 subjects who were in hospital at the first and last day of the year, respectively. This allowed us to scrutinize issues regarding hospital processes that affect the actual LOS, as well as other related factors. In this study, electronic health records (EHR) data and process mining technology were used to analyze all event logs entered between admission and discharge of the patient. For these reason, in order to understand which factors are associated with LOS, all activities within the overall patient admission process flow should be analyzed from different perspectives. LOS among patients with the same disease or undergoing the same type of surgical intervention may vary owing to complex factors related to the individual or due to different process flows within different organizations or divergences in medical practice.

Majority of these involved subjects stratified by condition or admitting unit, for example, patients admitted to specialized departments, such as psychiatric wards or the intensive care unit (ICU) those with hip fractures or undergoing coronary artery surgery or, those admitted with a specific diagnosis, such as heart failure or pulmonary disease. Previous studies have examined effective management of LOS. Furthermore, shorter hospital stays reduce the burden of medical fees and increase the bed turnover rate, which in turn increases the profit margin of hospitals, while lowering the overall social costs. Decreased LOS has been associated with decreased risks of opportunistic infections and side effects of medication, and with improvements in treatment outcome and lower mortality rates. Length of hospital stay (LOS) is an important indicator of the use of medical services that is used to assess the efficiency of hospital management, patient quality of care, and functional evaluation.
