Service Agreement - Department of Health Tasmania: 2018, Elective Surgery - Number of Category 3 patients who are treated in turn, 2018

Identifying and definitional attributes

Metadata item type:

Indicator

Indicator type:

Indicator

Short name:

Treat in Turn Rates Cat 3

METeOR identifier:

698723

Registration status:

Tasmanian Health, Endorsed 28/03/2019

Description:

This KPI is expressed as a percentage.

Elective Surgery Treat In Turn rate using the Royal Australian College of Surgery (RACS) calculation method. Measures the percentage of patients treated in turn from the longest waiting through to those waiting the least amount of time. Nationally the target for this indicator is set at 60-80%.

Rationale:

A higher percentage indicates more of the longer waiting patients are being treated from the back of the list.

To ensure that patients are removed in order of the longest waiting back. Allowing for clinical discretion at a level of approximately 40% but requiring the remaining 60% of patients to be treated from the longest waiting section of the waiting list for each category.

Collection and usage attributes

Count the number of category 3 patients treated in the month where their TotalWaitDays is greater than the TotalWaitDays of the longest waiting patient at the end of the month.

Exclude any patients still waiting who have come back on the list from being suspended during the month so that a long waiting suspended patient doesn't hijack the list.

Increase the TotalWaitDays of each removed patient by the difference between the Removal Date and the Last Day of Month to standardise the removal dates and make a fair comparison against the longest waiting day still on the list at end of month.

Denominator:

Total count of category 3 patients treated and removed in the month.

Computation:

100 x (Numerator ÷ Denominator)

Numerator:

Count the number of category 3 patients treated in the month where their TotalWaitDays is greater than the TotalWaitDays of the longest waiting patient at the end of the month.

Exclude any patients still waiting who have come back on the list from being suspended during the month so that a long waiting suspended patient doesn't hijack the list.

Increase the TotalWaitDays of each removed patient by the difference between the Removal Date and the Last Day of Month to standardise the removal dates and make a fair comparison against the longest waiting day still on the list at end of month.

Select All records from DimTWLPCExtraDetail where this field contains a value of 0 – indicating the procedure is a surgical one and within reporting range. This table will need to link to WaitingListHistory.PPPCode via the DimCode table.

Select All records from WaitingListHistory where this field contains a value between the highest recommended time for the given priority and 1 day higher than the next highest priority. For example: We would include a Category 3 patient where the TotalWaitingDays was between 91 and 365 days.

Select All records from DimTWLPCExtraDetail where this field contains a value of 0 – indicating the procedure is a surgical one and within reporting range. This table will need to link to WaitingListHistory.PPPCode via the DimCode table.