Difference between revisions of "Final Progress"

From Analytics Practicum
Jump to navigation Jump to search
Line 83: Line 83:
 
According to our project sponsor, Hospital X experiences high no-show appointments rate of about 21% for first visits and 19% for review visits. Our project sponsor is keen on improving the access to care as missed appointments lead to longer appointment lead times, idle time and an overall reduced quality of care.
 
According to our project sponsor, Hospital X experiences high no-show appointments rate of about 21% for first visits and 19% for review visits. Our project sponsor is keen on improving the access to care as missed appointments lead to longer appointment lead times, idle time and an overall reduced quality of care.
 
This paper seeks to explore the no-show patterns of the patients’ appointments in Hospital X from 2015 to 2016.
 
This paper seeks to explore the no-show patterns of the patients’ appointments in Hospital X from 2015 to 2016.
 +
<br/>
 +
<div align="left">
 +
<div style="background: #F5FFFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #2E8B57 solid 32px;"><font color="##4682B4">Literature Review</font></div>
 +
<br/>
 +
Ma, Seemanta, Wu and Ng (2014)  developed logistic regression and recursive partitioning models, using SAP records to predict patients’ no-show probabilities for each of the three clinics. The study included external information such as financial debt and reminder responses as predictor variables for no-show probability of patients. The results showed that there were some variations in the main predictor variables for no-show appointments among the three clinics.
 +
Allaeddini, Yang, Reddy, Yu (2011) developed a hybrid probabilistic model that combines logistic regression as a population-based approach along with Bayesian inference as an individual-based approach for the no-show prediction model. The model included the effect of appointment characteristics such as number of previous appointments, appointment types and lead times in the next scheduled appointment. The study also highlighted that there are other types of disruption such as cancellation of appointments and patient lateness that may have an impact on the performance of the scheduling system.
 +
Huang and Hanauer (2014) developed an evidence-based predictive model for no-show appointments and to improve overbooking approaches in outpatient settings to reduce the negative impact of no-shows. Factors like distance to the clinic, appointment characteristics, general demographic information and insurance information have been considered. One unique variable that this study has taken into account is the number of people in the household of the patient.
 +
William, M.S.W and BCD (2001) provided explanations to deepen practitioners’ understanding and management of no-show appointments. The study showed that no-show behaviour is positively correlated with lower income, lower socioeconomic status and lower age. Patients with more serious psychological difficulties are particularly taxed by long waiting times.
 +
Michael et al. (2016) described patterns of no-show variation by patient age, gender, appointment age, and type of appointment request, using eight years’ worth of individual-level records. A multifactor analysis of variance (ANOVA) was performed characterize no-show and attendance rates and the impact of certain patient factors. One of the findings showed that the longer a patient has to wait for an appointment to be scheduled, the less likely is the patient to keep the first appointment.
 +
<br/>
 +
A key distinction between our project and the literature review is that our project’s appointments can be further broken down into consultation with a doctor or an allied health professional. The reference [Ma, Seemanta, Wu and Ng, 2014] is especially relevant and similar to this project as the study was also conducted on outpatient clinics for a public hospital in Singapore.
 +
While most references shared the general consensus that no-show patient appointments are defined as patients who neither kept nor cancelled scheduled appointments, Huang and Hanauer (2014) brought up an interesting point that a cancelled appointment should be considered as no-show if it was cancelled with minimal lead time that the appointment slot cannot be filled. These findings are useful as a starting base to give us an idea of what is essential for the analysis as well as adding on to what other research studies had done. For example, the given dataset was lacking of some variables such as appointment age as seen in some of the secondary data. We can explore the data to determine if we could derive it instead. At the same time, only Huang and Hanauer (2014) accounted for the distance between the outpatient clinics and the patients’ residence as being a potential factor for no-show appointment. We can compute this variable and include it for our own analysis.
 
<br/>
 
<br/>

Revision as of 13:05, 15 April 2017


HOME

 

PROJECT OVERVIEW

 

PROJECT FINDINGS

 

PROJECT MANAGEMENT

 

DOCUMENTATION

 

ABOUT US

 


Mid-Term Progress


Final Progressnew!



NoDocument
01 Final Conference Paper
02 Final Presentation Slides
03 Final Poster


An excerpt from the Final Conference Paper is shown below. For more information on the analysis, please download the paper or contact the team.



Abstract


The healthcare industry has always been concerned with gathering insights on patients and their no-show appointments. The number of no-show appointments has an impact on the cost and clinic utilization. It creates an opportunity cost for another patient who is unable to make use of the no-show appointment slot to get a consultation from a doctor or an allied health professional. In this study, we aim to identify significant variables that affect no-show appointments in Hospital X. The data used for this model building process is provided to us by our sponsor, a medical consultant at Hospital X. Taking references from past literature review, we will select and derive relevant variables to be used for modelling. We will develop logistic regression and decision tree models to predict the probability of no-shows for Hospital X using both patient information and individual clinical appointment attendance records. We will then compare the different models and assess the results. Based on our findings, we will end the report with set of implications and results for Hospital X.

Introduction


With regards to the state of mental health disorders in children, there has been an increase of cases from 533 in 1980 to 3051 in 2010. A medical study (Woo, et al, 2007) has shown that one in eight children in Singapore has emotional disorders, and one in 20 has behavioural disorders, only 10% ever see a psychiatrist. Thus, it places an emphasis in understanding no- show appointments. Appointments are made for a reason. When patients default on their appointments, they miss the opportunity for a medical consultation and thus, place their health status at risk. No-show appointment is defined as when a patient does not attend for a scheduled clinic appointment or cancels with such minimal lead time that the slot cannot be filled (Huang & Hanauer, 2014). The impact of no-show appointments includes disruption of efficient operations of the clinics, provider productivity, decreased access to care and depriving other patients of the opportunity to see a medical professional during no-show appointments.

Project Background


Hospital X is a pioneer tertiary hospital that provides a comprehensive range of medical and rehabilitative services for children, adolescents, adults and the elderly. Patients are usually referred to Hospital X by other medical institutions or they booked an appointment directly. Patients can be categorised according to their appointments with a doctor, an allied health professional or even both.

AY2017 ZAN Figure 1.png
Figure 1: Flow Chart of Different Visit Types


A patient’s first appointment begins with a diagnosis by a doctor and subsequent appointments are made according to the patient’s mental health status. If a patient does not have any appointment for a year, any subsequent appointment will have to be diagnosed by a doctor again (FV). Our project sponsor is a medical consultant working for Hospital X. He specialises in tending to younger patients from the age of 18 years old and below. He hopes to tap into the under-utilised administrative data that is collected by the hospital daily. According to our project sponsor, Hospital X experiences high no-show appointments rate of about 21% for first visits and 19% for review visits. Our project sponsor is keen on improving the access to care as missed appointments lead to longer appointment lead times, idle time and an overall reduced quality of care. This paper seeks to explore the no-show patterns of the patients’ appointments in Hospital X from 2015 to 2016.

Literature Review


Ma, Seemanta, Wu and Ng (2014) developed logistic regression and recursive partitioning models, using SAP records to predict patients’ no-show probabilities for each of the three clinics. The study included external information such as financial debt and reminder responses as predictor variables for no-show probability of patients. The results showed that there were some variations in the main predictor variables for no-show appointments among the three clinics. Allaeddini, Yang, Reddy, Yu (2011) developed a hybrid probabilistic model that combines logistic regression as a population-based approach along with Bayesian inference as an individual-based approach for the no-show prediction model. The model included the effect of appointment characteristics such as number of previous appointments, appointment types and lead times in the next scheduled appointment. The study also highlighted that there are other types of disruption such as cancellation of appointments and patient lateness that may have an impact on the performance of the scheduling system. Huang and Hanauer (2014) developed an evidence-based predictive model for no-show appointments and to improve overbooking approaches in outpatient settings to reduce the negative impact of no-shows. Factors like distance to the clinic, appointment characteristics, general demographic information and insurance information have been considered. One unique variable that this study has taken into account is the number of people in the household of the patient. William, M.S.W and BCD (2001) provided explanations to deepen practitioners’ understanding and management of no-show appointments. The study showed that no-show behaviour is positively correlated with lower income, lower socioeconomic status and lower age. Patients with more serious psychological difficulties are particularly taxed by long waiting times. Michael et al. (2016) described patterns of no-show variation by patient age, gender, appointment age, and type of appointment request, using eight years’ worth of individual-level records. A multifactor analysis of variance (ANOVA) was performed characterize no-show and attendance rates and the impact of certain patient factors. One of the findings showed that the longer a patient has to wait for an appointment to be scheduled, the less likely is the patient to keep the first appointment.
A key distinction between our project and the literature review is that our project’s appointments can be further broken down into consultation with a doctor or an allied health professional. The reference [Ma, Seemanta, Wu and Ng, 2014] is especially relevant and similar to this project as the study was also conducted on outpatient clinics for a public hospital in Singapore. While most references shared the general consensus that no-show patient appointments are defined as patients who neither kept nor cancelled scheduled appointments, Huang and Hanauer (2014) brought up an interesting point that a cancelled appointment should be considered as no-show if it was cancelled with minimal lead time that the appointment slot cannot be filled. These findings are useful as a starting base to give us an idea of what is essential for the analysis as well as adding on to what other research studies had done. For example, the given dataset was lacking of some variables such as appointment age as seen in some of the secondary data. We can explore the data to determine if we could derive it instead. At the same time, only Huang and Hanauer (2014) accounted for the distance between the outpatient clinics and the patients’ residence as being a potential factor for no-show appointment. We can compute this variable and include it for our own analysis.