Orthopedic and ophthalmology surgical service projection modelling in Manitoba: Research approach for a data linkage study

Background The healthcare system in Manitoba, Canada has faced long wait times for many surgical procedures and investigations, including orthopedic and ophthalmology surgeries. Wait times for surgical procedures is considered a significant barrier to accessing healthcare in Canada and can have neg...

Full description

Bibliographic Details
Main Authors: Alan Katz, Hannah Owczar, Carole Taylor, John-Micheal Bowes, Ruth-Ann Soodeen
Format: Article
Language:English
Published: Swansea University 2023-10-01
Series:International Journal of Population Data Science
Subjects:
Online Access:https://ijpds.org/article/view/2123
_version_ 1797411613998841856
author Alan Katz
Hannah Owczar
Carole Taylor
John-Micheal Bowes
Ruth-Ann Soodeen
author_facet Alan Katz
Hannah Owczar
Carole Taylor
John-Micheal Bowes
Ruth-Ann Soodeen
author_sort Alan Katz
collection DOAJ
description Background The healthcare system in Manitoba, Canada has faced long wait times for many surgical procedures and investigations, including orthopedic and ophthalmology surgeries. Wait times for surgical procedures is considered a significant barrier to accessing healthcare in Canada and can have negative health outcomes for patients. We developed models to forecast anticipated surgical procedure demands up to 2027. This paper explores the opportunities and challenges of using administrative data to describe forecasts of surgical service delivery. Methods This study used whole population linked administrative health data to predict future orthopedic and ophthalmology surgical procedure demands up to 2027. Procedure codes (CCI) from hospital discharge abstracts and medical claims data were used in the modelling. A Seasonal Autoregressive Integrated Moving Average model provided the best fit to the data from April 1, 2004 to March 31, 2020. Results Initial analyses of only hospital-based procedures excluded a significant portion of provider workload, namely those services provided in clinics. We identified 500,732 orthopedic procedures completed between April 1, 2004 and March 31, 2020 (349,171 procedures identified from hospital discharge abstracts and 151,561 procedures from medical claims). Procedure volumes for these services are expected to rise 17.7% from 2020 (36,542) to 2027 (43,011), including the forecasted 43.9% increase in clinic-based procedures. Of the 660,127 ophthalmology procedures completed between April 1, 2004 and March 31, 2020, 230,717 procedures were identified from hospital discharge abstracts and 429,410 from medical claims. Models forecasted a 27.7% increase from 2020 (69,598) to 2027 (88,893) with most procedures being performed in clinics. Conclusion Researchers should consider including multiple datasets to add information that may have been missing from the presumed data source in their research approach. Confirming the completeness of the data is critical in modelling accurate predictions. Forecast modelling techniques have evolved but still require validation.
first_indexed 2024-03-09T04:47:41Z
format Article
id doaj.art-3581a220d5c0465ebab9999bc5a90f1d
institution Directory Open Access Journal
issn 2399-4908
language English
last_indexed 2024-03-09T04:47:41Z
publishDate 2023-10-01
publisher Swansea University
record_format Article
series International Journal of Population Data Science
spelling doaj.art-3581a220d5c0465ebab9999bc5a90f1d2023-12-03T13:13:10ZengSwansea UniversityInternational Journal of Population Data Science2399-49082023-10-018110.23889/ijpds.v8i1.2123Orthopedic and ophthalmology surgical service projection modelling in Manitoba: Research approach for a data linkage studyAlan Katz0Hannah Owczar1Carole Taylor2John-Micheal Bowes3Ruth-Ann Soodeen4Manitoba Centre for Health Policy, Dept of Community Health Sciences, Rady Faculty of Health Sciences, University of Manitoba, Winnipeg, MB R3E 3P5 Canada; Department of Family Medicine, Rady Faculty of Health Sciences, University of Manitoba, Winnipeg, MB R33 0W2 CanadaDepartment of Family Medicine, Rady Faculty of Health Sciences, University of Manitoba, Winnipeg, MB R33 0W2 CanadaDepartment of Family Medicine, Rady Faculty of Health Sciences, University of Manitoba, Winnipeg, MB R33 0W2 CanadaDepartment of Family Medicine, Rady Faculty of Health Sciences, University of Manitoba, Winnipeg, MB R33 0W2 CanadaDepartment of Family Medicine, Rady Faculty of Health Sciences, University of Manitoba, Winnipeg, MB R33 0W2 Canada Background The healthcare system in Manitoba, Canada has faced long wait times for many surgical procedures and investigations, including orthopedic and ophthalmology surgeries. Wait times for surgical procedures is considered a significant barrier to accessing healthcare in Canada and can have negative health outcomes for patients. We developed models to forecast anticipated surgical procedure demands up to 2027. This paper explores the opportunities and challenges of using administrative data to describe forecasts of surgical service delivery. Methods This study used whole population linked administrative health data to predict future orthopedic and ophthalmology surgical procedure demands up to 2027. Procedure codes (CCI) from hospital discharge abstracts and medical claims data were used in the modelling. A Seasonal Autoregressive Integrated Moving Average model provided the best fit to the data from April 1, 2004 to March 31, 2020. Results Initial analyses of only hospital-based procedures excluded a significant portion of provider workload, namely those services provided in clinics. We identified 500,732 orthopedic procedures completed between April 1, 2004 and March 31, 2020 (349,171 procedures identified from hospital discharge abstracts and 151,561 procedures from medical claims). Procedure volumes for these services are expected to rise 17.7% from 2020 (36,542) to 2027 (43,011), including the forecasted 43.9% increase in clinic-based procedures. Of the 660,127 ophthalmology procedures completed between April 1, 2004 and March 31, 2020, 230,717 procedures were identified from hospital discharge abstracts and 429,410 from medical claims. Models forecasted a 27.7% increase from 2020 (69,598) to 2027 (88,893) with most procedures being performed in clinics. Conclusion Researchers should consider including multiple datasets to add information that may have been missing from the presumed data source in their research approach. Confirming the completeness of the data is critical in modelling accurate predictions. Forecast modelling techniques have evolved but still require validation. https://ijpds.org/article/view/2123orthopedicophthalmologysurgical service forecastsdata linkagehealth policy
spellingShingle Alan Katz
Hannah Owczar
Carole Taylor
John-Micheal Bowes
Ruth-Ann Soodeen
Orthopedic and ophthalmology surgical service projection modelling in Manitoba: Research approach for a data linkage study
International Journal of Population Data Science
orthopedic
ophthalmology
surgical service forecasts
data linkage
health policy
title Orthopedic and ophthalmology surgical service projection modelling in Manitoba: Research approach for a data linkage study
title_full Orthopedic and ophthalmology surgical service projection modelling in Manitoba: Research approach for a data linkage study
title_fullStr Orthopedic and ophthalmology surgical service projection modelling in Manitoba: Research approach for a data linkage study
title_full_unstemmed Orthopedic and ophthalmology surgical service projection modelling in Manitoba: Research approach for a data linkage study
title_short Orthopedic and ophthalmology surgical service projection modelling in Manitoba: Research approach for a data linkage study
title_sort orthopedic and ophthalmology surgical service projection modelling in manitoba research approach for a data linkage study
topic orthopedic
ophthalmology
surgical service forecasts
data linkage
health policy
url https://ijpds.org/article/view/2123
work_keys_str_mv AT alankatz orthopedicandophthalmologysurgicalserviceprojectionmodellinginmanitobaresearchapproachforadatalinkagestudy
AT hannahowczar orthopedicandophthalmologysurgicalserviceprojectionmodellinginmanitobaresearchapproachforadatalinkagestudy
AT caroletaylor orthopedicandophthalmologysurgicalserviceprojectionmodellinginmanitobaresearchapproachforadatalinkagestudy
AT johnmichealbowes orthopedicandophthalmologysurgicalserviceprojectionmodellinginmanitobaresearchapproachforadatalinkagestudy
AT ruthannsoodeen orthopedicandophthalmologysurgicalserviceprojectionmodellinginmanitobaresearchapproachforadatalinkagestudy