Australian Government: Australian Institute of Health and Welfare METeOR Home Page

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:Help on this termIndicator
Indicator type:Help on this termIndicator
Short name:Help on this termTreat in Turn Rates Cat 3
METeOR identifier:Help on this term698723
Registration status:Help on this termTasmanian Health, Endorsed 28/03/2019
Description:Help on this term

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:Help on this term

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.

Indicator set:Help on this termService Plan - Department of Health Tasmania: 2018 Tasmanian Health, Endorsed 28/03/2019
Outcome area:Help on this termElective surgery access Tasmanian Health, Endorsed 07/12/2016

Collection and usage attributes

Computation description:Help on this term

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.

Denominator:

  • Total count of category 3 patients treated and removed in the month.
Computation:Help on this term

100 x (Numerator ÷ Denominator)

Numerator:Help on this term
  • 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.
Numerator data elements:Help on this term
Data Element / Data SetElective surgery waiting list episode—intended procedure, waiting list procedure (Tasmanian TWLPC) code NN[N]
Guide for use

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.


Data Element / Data SetPerson—person identifier, identifier (Tasmanian) N(9)
Data Element / Data SetEstablishment—organisation identifier, (Tasmanian) identifier NNNN
Data Element / Data SetHospital census (of elective surgery waitlist patients)—census date, DDMMYYYY
Guide for use

Select All records from FactWaitingList where this field contains a date value within the reporting range and where the [ArchiveFlag] is set to 0.


Data Element / Data SetElective care waiting list episode—clinical urgency, code X[AXAA]
Guide for use

Select All records from FactWaitingList where this field contains a value of 3 – indicating the patient is assigned a valid priority.


Data Element / Data SetElective surgery waiting list episode—waiting time (at a census date), total days N[NNN]
Guide for use

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.


Data Element / Data SetEstablishment—region identifier, code (Tasmanian) N
Denominator:Help on this term

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

Denominator data elements:Help on this term
Data Element / Data SetElective care waiting list episode—clinical urgency, code X[AXAA]
Guide for use

Select All records from FactWaitingList where this field contains a value of 3 – indicating the patient is assigned a valid priority.


Data Element / Data SetEstablishment—organisation identifier, (Tasmanian) identifier NNNN
Data Element / Data SetHospital census (of elective surgery waitlist patients)—census date, DDMMYYYY
Guide for use

Select All records from FactWaitingList where this field contains a date value within the reporting range and where the [ArchiveFlag] is set to 0.


Data Element / Data SetElective surgery waiting list episode—intended procedure, waiting list procedure (Tasmanian TWLPC) code NN[N]
Guide for use

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.


Data Element / Data SetEstablishment—region identifier, code (Tasmanian) N
Disaggregation:Help on this term

Specified disaggregation: Region and hospital.

Disaggregation data elements:Help on this term
Data Element / Data SetEstablishment—organisation identifier, (Tasmanian) identifier NNNN
Data Element / Data SetEstablishment—region identifier, code (Tasmanian) N

Representational attributes

Representation class:Help on this termPercentage
Data type:Help on this termReal
Unit of measure:Help on this termPerson
Format:Help on this term

NN[N]

Accountability attributes

Reporting requirements:Help on this term
  • 2017-18 Service Agreement

Relational attributes

Related metadata references:Help on this term

Supersedes Service Agreement - Department of Health and Human Services Tasmania: 2017, ACC7, 10, 13 - Elective Surgery - Number of elective surgery patients who are treated in turn by urgency category, 2017 Tasmanian Health, Archived 28/03/2019

My items Help on this term
Download Help on this term