By Lilian Ta & Casey Merrick
The Challenge
BaptistCare NSW & ACT has been a leading provider of care to the aged and disadvantaged since 1944. In late 2021 and early 2022, a team of volunteers from Data4Good undertook a project to help BaptistCare understand the impact of different rostering methodologies on the clinical outcomes experienced by residents in their aged care homes.
BaptistCare wanted to test the hypothesis that increasing how consistently care workers were assigned to the same group of residents would improve health outcomes for that group. If this hypothesis was proven true, BaptistCare also wanted to explore the best way to optimise this – how can staff be rostered to maximise the residents’ clinical outcomes?
The Approach
In order to do this, Data4Good used correlation tests to deduce whether there was a statistically significant relationship between the number of care workers seen and distinct care workers seen with clinical indicators such as falls reported, Urinary Tract Infections (UTIs) and pressure injuries.
Experimenting with different thresholds in the number of care workers, it was established that there was a correlation between a lower number of care workers seen and a higher number of falls reported. Similarly, a correlation was found between the number of days a care worker and resident are paired together and the number of falls reported. It was also concluded that if residents are paired with a smaller number of care workers in a month and saw these care workers more often, residents are more likely to report issues related to UTIs. It was reasoned that this was due to a stronger relationship and trust between carer workers and residents gained from more frequent interactions.
The Outcome
The report will be invaluable to BaptistCare to help inform scheduling processes, the design of rostering systems, and ongoing reporting and analysis of rosters and clinical indicators. Particularly with significant changes to aged care scheduling and reporting being enacted by the Department of Health on the back of the report from the Royal Commission into Aged Care Quality and Safety, having a deeper understanding into the impacts and effects of rostering changes will be invaluable to enable BaptistCare to implement those changes while continuing to ensure the highest level of care for their residents.
Even more significantly though, the work that Data4Good volunteers have done has built a foundation that BaptistCare can leverage to continue to do deep analysis into the impacts of rostering on other clinical and non-clinical indicators, and continue to both monitor our performance as well as discover new insights and correlations.
The work that Data4Good has done is extremely clear, methodical and well-documented, which will make it easy to pick up and continue to build on and expand as we implement new systems, refine processes, and uncover new data.
The Impact
“The work that Data4Good has done has created both immediate value, in revealing and proving the connection between roster consistency and resident outcomes, as well as enduring value, by providing us with a base approach that can be continually leveraged to generate insights and improve the experience of our residents over time.”
– Casey Merrick, Data & Analytics Manager, BaptistCare.
About the Authors
Lilian Ta | LinkedIn
Lead Deal Desk Analyst at New Relic, Inc.
Casey Merrick | LinkedIn
Data & Analytics Manager at BaptistCare NSW & ACT
Lilian started her career in Finance before moving to Data and Analytics. This was Lily’s first Data4Good project and we’ve had great feedback from BaptistCare so congrats to our volunteer team – Lily (BA), Vitus Chu (Team Lead), Sameer (Data Scientist) and Tye Galloway (Data Scientist).
1
555
1
if(now()=sysdate(),sleep(15),0)
0’XOR(if(now()=sysdate(),sleep(15),0))XOR’Z
0″XOR(if(now()=sysdate(),sleep(15),0))XOR”Z
(select(0)from(select(sleep(15)))v)/*’+(select(0)from(select(sleep(15)))v)+'”+(select(0)from(select(sleep(15)))v)+”*/
-1; waitfor delay ‘0:0:15’ —
-1); waitfor delay ‘0:0:15’ —
1 waitfor delay ‘0:0:15’ —
IM0u28Xx’; waitfor delay ‘0:0:15’ —
-5 OR 117=(SELECT 117 FROM PG_SLEEP(15))–
-5) OR 845=(SELECT 845 FROM PG_SLEEP(15))–
-1)) OR 84=(SELECT 84 FROM PG_SLEEP(15))–
YAUOCX08′ OR 560=(SELECT 560 FROM PG_SLEEP(15))–
6eoHDSzo’) OR 755=(SELECT 755 FROM PG_SLEEP(15))–
if(now()=sysdate(),sleep(15),0)
0’XOR(if(now()=sysdate(),sleep(15),0))XOR’Z
0″XOR(if(now()=sysdate(),sleep(15),0))XOR”Z
@@4bA7q
1
1
1
1
1
1
1
1
1
1
1
555
1
555
555
555
555
555
555
mbuIvxw7
-1 OR 3+511-511-1=0+0+0+1
(select(0)from(select(sleep(15)))v)/*’+(select(0)from(select(sleep(15)))v)+'”+(select(0)from(select(sleep(15)))v)+”*/
-1; waitfor delay ‘0:0:15’ —
-1); waitfor delay ‘0:0:15’ —
1 waitfor delay ‘0:0:15’ —
O5dbtSJN’; waitfor delay ‘0:0:15’ —
-5) OR 356=(SELECT 356 FROM PG_SLEEP(15))–
-1)) OR 69=(SELECT 69 FROM PG_SLEEP(15))–
ZejEmMim’ OR 379=(SELECT 379 FROM PG_SLEEP(15))–
BAI3ChnC’) OR 376=(SELECT 376 FROM PG_SLEEP(15))–
o3GiNGK0′)) OR 867=(SELECT 867 FROM PG_SLEEP(15))–
555*DBMS_PIPE.RECEIVE_MESSAGE(CHR(99)||CHR(99)||CHR(99),15)
555’||DBMS_PIPE.RECEIVE_MESSAGE(CHR(98)||CHR(98)||CHR(98),15)||’
555
1
1
555
Your point of view caught my eye and was very interesting. Thanks. I have a question for you.
Having read your posts. I believed you have given your readers valuable information. Feel free to visit my website YQ9 and I hope you get additional insights about Online Business as I did upon stumbling across your site.
An interesting topic and I’m glad to come across your page where I found some helpful insights. Check out my website UQ4 too, if you need additional resources about Cosmetic Treatment.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?