Physio_MSK
2024-10-24
1 Introduction
1.1 Objectives
To review the data quality of MSK programme
For audit/ research: Patient catchment, presenting condition,
injection referral, medical history
For update: see data at any point in month rather than the end of month
For keeping track of Patient Status
1.2 Design
Retrospective, descriptive analysis
1.3 Setting
Musculoskeletal Physiotherapy
1.4 Sampling
- Targeted Population: MSK patients
- Sample size: MSK recipients (n=800), between March and August 2024.
- Sampling method: convenience sampling
2 Results
2.1 Variable definitions
## Rows: 800
## Columns: 20
## $ `Hospital Number` <chr> …
## $ `Scheduled Appointment Date` <dttm> …
## $ `Scheduled Month` <chr> …
## $ `Patient Type` <chr> …
## $ `Number Of Days Betweeen Referral And Appointment - (Auto-calc)` <dbl> …
## $ `Number Of Days Betweeen Referral And Rescheduled Appointment (Auto-calc)` <dbl> …
## $ `Patient Seen Within KPI Timeframe` <chr> …
## $ `Seen Within 3 Months` <chr> …
## $ Specialty <chr> …
## $ `Clinic Location` <chr> …
## $ `Appointment Type` <chr> …
## $ `Did The Patient Attend This Scheduled Apointment Date?` <chr> …
## $ `Reason Patient Did Not Attend The Appointment` <chr> …
## $ `Current Patient Status` <chr> …
## $ `Physiotherapy Location` <chr> …
## $ `Is The Patient In The Mater Catchment` <chr> …
## $ `If Not In Catchment Area, Please Specify Location` <chr> …
## $ `Date Of Attended Appointment?` <dttm> …
## $ `Attended Appt Month` <chr> …
## $ `Referred To Consultant Clinic` <chr> …2.2 KPI 1 - No. of New MSK Orthopaedic and Rheumatology attendances seen by MSK Physiotherapist at hospital-based/ community-based/ virtual clinics
- Filter:
Patient Type==“New” - Group by:
Appointment Type,Specialty,Clinic Location,Scheduled Appointment Date(Month Year)
|
2.3 KPI 2 - New : Return Attendance
- Filter:
Patient Type==“Return / Follow up” - Group by:
Appointment Type,Specialty,Clinic Location,Scheduled Appointment Date(Month Year)
## `summarise()` has grouped output by 'Appointment Type', 'Specialty', 'Clinic
## Location'. You can override using the `.groups` argument.
|
2.4 KPI 3 - Referrals triaged as appropriate for Patients shall be Seen by an MSK physiotherapist within 3 months
- Filter:
Seen Within 3 Months==“Yes” - Group by:
Patient Type,Appointment Type,Specialty,Clinic Location,Scheduled Appointment Date(Month Year)
## `summarise()` has grouped output by 'Patient Type', 'Appointment Type',
## 'Specialty', 'Clinic Location'. You can override using the `.groups` argument.
|
2.5 KPI 4 - Percent DNA rate for New patients across Orthopaedics and Rheumatology
Filter:
Reason Patient Did Not Attend The Appointment==“DNA” &Patient Type==“New”Group by:
Appointment Type,Specialty,Clinic Location,Scheduled Appointment Date(Month Year)Filter:
Reason Patient Did Not Attend The Appointment==“Patient Cancellation Within 48 Hours Notice” || “Patient Cancellation >48 Hours Notice”Group by:
Patient Type,Appointment Type,Specialty,Clinic Location,Scheduled Appointment Date(Month Year)
## `summarise()` has grouped output by 'Appointment Type', 'Specialty', 'Clinic
## Location'. You can override using the `.groups` argument.
|
## `summarise()` has grouped output by 'Patient Type', 'Appointment Type',
## 'Specialty', 'Clinic Location'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'Patient Type', 'Appointment Type',
## 'Specialty', 'Clinic Location'. You can override using the `.groups` argument.
|
|
2.6 Addition - New Patient Outcome
2.6.1 Total New Outpatient Attendances
- Filter:
Specialty==“Orthopaedic” or “Rheumatology” &Patient Type==“New” - Group by:
Appointment Type,Clinic Location,Scheduled Appointment Date(Month Year)
## `summarise()` has grouped output by 'Appointment Type', 'Clinic Location'. You
## can override using the `.groups` argument.
## `summarise()` has grouped output by 'Appointment Type', 'Clinic Location'. You
## can override using the `.groups` argument.
|
|
2.6.2 New Attendances who were discharged
- Filter:
Specialty==“Orthopaedics” | “Rheumatology” &Patient Type==“New” &Current Patient Status==“Discharged” - Group by:
Appointment Type,Clinic Location,Scheduled Appointment Date(Month Year)
## `summarise()` has grouped output by 'Appointment Type', 'Clinic Location'. You
## can override using the `.groups` argument.
## `summarise()` has grouped output by 'Appointment Type', 'Clinic Location'. You
## can override using the `.groups` argument.
|
|
2.6.3 New Attendances who were subsequently scheduled for F2F or Virtual review
Filter:
Specialty==“Orthopaedic” | “Rheumatology” &Patient Type==“New” & !Current Patient Status==“Discharged”Group by:
Current Patient Status,Appointment Type,Clinic Location,Scheduled Appointment Date(Month Year)Filter:
Patient Type==“New” &Current Patient Status==“F2F FU Triage” | “Tel FU Triage”Group by:
Appointment Type,Specialty,Clinic Location,Scheduled Appointment Date(Month Year)
## `summarise()` has grouped output by 'Current Patient Status', 'Appointment
## Type', 'Clinic Location'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'Current Patient Status', 'Appointment
## Type', 'Clinic Location'. You can override using the `.groups` argument.
|
|
## `summarise()` has grouped output by 'Appointment Type', 'Specialty', 'Clinic
## Location'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'Appointment Type', 'Specialty', 'Clinic
## Location'. You can override using the `.groups` argument.
|
|
2.6.4 New Attendances who were referred to an Orthopaedics or Rheumatology Consultant (as from Orthopaedics or Rheumatology)
- Filter:
Specialty==“Orthopaedic” | “Rheumatology” &Patient Type==“New” - Group by:
Referred To Consultant Clinic,Appointment Type,Clinic Location,Scheduled Appointment Date(Month Year)
## `summarise()` has grouped output by 'Referred To Consultant Clinic',
## 'Appointment Type', 'Clinic Location'. You can override using the `.groups`
## argument.
## `summarise()` has grouped output by 'Referred To Consultant Clinic',
## 'Appointment Type', 'Clinic Location'. You can override using the `.groups`
## argument.
|
|
2.6.5 New Attendances who were referred to Primary Care or MMUH Physio
- Filter:
Specialty==“Orthopaedic” | “Rheumatology” &Patient Type==“New” - Group by:
Physiotherapy Location,Appointment Type,Clinic Location,Scheduled Appointment Date(Month Year)
## `summarise()` has grouped output by 'Physiotherapy Location', 'Appointment
## Type', 'Clinic Location'. You can override using the `.groups` argument.
## `summarise()` has grouped output by 'Physiotherapy Location', 'Appointment
## Type', 'Clinic Location'. You can override using the `.groups` argument.
|
|
2.7 Patient characteristics
| Characteristic | N = 7601 |
|---|---|
| Patient Type | |
| New | 717 (95%) |
| Return / Follow up | 38 (5.0%) |
| Unknown | 5 |
| Patient Seen Within KPI Timeframe | |
| No | 545 (77%) |
| Patient Has Not Attended (DNA/UTA) | 28 (4.0%) |
| Yes | 135 (19%) |
| Unknown | 52 |
| Seen Within 3 Months | |
| No | 546 (77%) |
| Patient Has Not Attended (DNA/UTA) | 28 (4.0%) |
| Yes | 134 (19%) |
| Unknown | 52 |
| Appointment Type | |
| F2F | 737 (99%) |
| Virtual | 9 (1.2%) |
| Unknown | 14 |
| Did The Patient Attend This Scheduled Apointment Date? | 621 (82%) |
| Unknown | 1 |
| 1 n (%) | |
| Characteristic | N = 7601 |
|---|---|
| Specialty | |
| Orthopaedics | 696 (92%) |
| Rheumatology | 63 (8.3%) |
| Unknown | 1 |
| Clinic Location | |
| Primary Care | 222 (30%) |
| Secondary Care | 525 (70%) |
| Unknown | 13 |
| Physiotherapy Location | |
| MMUH | 104 (50%) |
| Other DATH | 23 (11%) |
| Primary Care | 81 (39%) |
| Unknown | 552 |
| catchment | |
| Beaumont | 36 (7.9%) |
| cappagh | 4 (0.9%) |
| Cappagh | 3 (0.7%) |
| Connolly | 38 (8.4%) |
| donegal | 2 (0.4%) |
| James's | 15 (3.3%) |
| Mater | 343 (75%) |
| Other DATH | 3 (0.7%) |
| St Vincents | 8 (1.8%) |
| Tallaght | 3 (0.7%) |
| Unknown | 305 |
| Referred To Consultant Clinic | |
| No | 513 (98%) |
| Orthopaedic | 8 (1.5%) |
| Rheumatology | 1 (0.2%) |
| Unknown | 238 |
| Current Patient Status | |
| Await Consultant Discussion | 45 (6.8%) |
| Await Investigations | 35 (5.3%) |
| Consultant Appointment Booked | 12 (1.8%) |
| Discharged | 479 (73%) |
| Discharged to Other Specialty | 5 (0.8%) |
| F2F FU Triage | 16 (2.4%) |
| Injection & Consultant FU | 1 (0.2%) |
| Injection & D/C | 55 (8.3%) |
| Injection & MSK FU | 6 (0.9%) |
| Listed for Surgery | 2 (0.3%) |
| Refer To Other Ortho Consultant | 1 (0.2%) |
| Tel FU Triage | 2 (0.3%) |
| Unknown | 101 |
| 1 n (%) | |
2.8 Number of Patients Based on Scheduled Appointment Date
2.9 Average Days Between Referral And Appointment (Auto-calc)
