Service Agreement - Department of Health and Human Services Tasmania: 2015, AES2 - Elective Surgery - Average overdue wait days for all patients currently ready for care on the Elective Surgery Waiting List, 2015

Identifying and definitional attributes

Metadata item type:Indicator
Indicator type:Indicator
Short name:Average overdue wait days
METeOR identifier:615442
Registration status:Tasmanian Health, Archived 09/12/2016
Description:

This KPI measures the average number of overdue days waiting of patients who have waited beyond the clinically recommended time.

Rationale:

A reduction in the Average Overdue Wait days indicates that longer waiting patients are being removed from the waiting list.

Indicator set:Service Agreement - Department of Health and Human Services Tasmania: 2015 Tasmanian Health, Archived 12/12/2016
Outcome area:Elective surgery access Tasmanian Health, Endorsed 07/12/2016

Collection and usage attributes

Computation description:

Determine the patients that are over boundary based on their category. Subtract the number of days they are over boundary from the recommended completion period (i.e.: a Category 1 patient who has been waiting 45 days will have 30 days removed from their total, leaving 15 days as the portion of their wait days overdue). Then sum all of these overdue amounts together to form a total of overdue days.

Divide the total sum of overdue (over boundary) days by the total count of overdue patients to determine the Average overdue days.

Computation:

Numerator ÷ Denominator

Calculated a result for each region.

Numerator:

Total sum of overdue portion of a patients wait days on the Elective Surgery Waiting List. Where a patient has waited longer than the recommended period of time for their Elective Surgery Urgency Category, subtract the recommended number of days from the total days waiting.

Numerator data elements:
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 WaitingListHistory where this field contains a date value within the reporting range and where the [ArcihveFlag] is set to 0.


Data Element / Data SetElective surgery waiting list episode—not ready for care, total days N[NNNN]
Guide for use

Select All records from WaitingListHistory where this field contains a value of 0 – indicating the patient is not suspended.


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

Select All records from WaitingListHistory where this field contains a value of 1, 2 or 3 – indicating the patient is assigned a valid priority.


Data Element / Data SetElective care 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 greater than the recommended number of days for the given priority.


Data Element / Data SetEstablishment—region identifier, code (Tasmanian) N
Denominator:

Total number of overdue patients

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

Select All records from WaitingListHistory where this field contains a value of 1, 2 or 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 WaitingListHistory 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—not ready for care, total days N[NNNN]
Guide for use

Select All records from WaitingListHistory where this field contains a value of 0 – indicating the patient is not suspended.


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

Select All records from WaitingListHistory where this field contains a value of 1, 2 or 3 – indicating the patient is assigned a valid priority.


Data Element / Data SetElective care 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 greater than the recommended number of days for the given priority.


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:

Specified disaggregation: Hospital and urgency category.

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

Representational attributes

Representation class:Mean (average)
Data type:Point in time
Unit of measure:Time (e.g. days, hours)
Format:

NNN.NN

Accountability attributes

Reporting requirements:
  • 2015-16 Service Agreement

Relational attributes

Related metadata references:

Has been superseded by Service Agreement - Department of Health and Human Services Tasmania: 2016, ACC7 - Elective Surgery - Average overdue wait days for all patients currently ready for care on the Elective Surgery Waiting List, 2016 Tasmanian Health, Archived 28/03/2019