Service Agreement - Department of Health and Human Services Tasmania: 2016, ACC8 - Elective Surgery - Maximum waiting days for patients currently ready for care on the Elective Surgery Waiting List, 2016

Identifying and definitional attributes

Metadata item type:Indicator
Indicator type:Indicator
Short name:Maximum Wait Time
METeOR identifier:645326
Registration status:Tasmanian Health, Archived 28/03/2019
Description:

This KPI measures the waiting days of the single longest waiting patient on the Elective Surgery waiting list.

Rationale:

A decrease in the Maximum Wait Time indicates that longest waiting patients are being removed from the list.

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

Collection and usage attributes

Computation description:

Sort the list of Elective Surgery patients by the number of days they have been waiting and use the largest amount as the Maximum Wait Time.

Computation:

Numerator ÷ Denominator Calculated a result for each region. Sort the list of valid patients by Waiting Days from shortest to longest. Take the largest value as the Maximum Wait Time. MAX([TotalWaitingDays] )

Numerator:

Maximum Wait Time from the patient wait days on the Elective Surgery Waiting List

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 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 greater than the recommended number of days for the given priority.


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

Specified disaggregation: Hospital and region.

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:Percentage
Data type:Real
Unit of measure:Person
Format:

NN[N]

Accountability attributes

Reporting requirements:
  • 2016-17 Service Agreement

Relational attributes

Related metadata references:

Supersedes Service Agreement - Department of Health and Human Services Tasmania: 2015, AES3 - Elective Surgery - Maximum waiting days for patients currently ready for care on the Elective Surgery Waiting List, 2015 Tasmanian Health, Archived 09/12/2016