[WWW - 2021.12.16]
  • MS

  • MS detail

Breadcrumb_DS

Elective Surgery Data Collection (ESDC)
Identifying and Definitional Attributes
Identifier
QH 020110
Version
3
Metadata Item Type
Information Asset
Metadata Set Type
Data Collection
Approval Status
Draft
01-Jul-2021 
Approval Type
Standard
Approving Authority
Information Management Strategic Governance Committee (IMSGC), Queensland Health
Effective From
01-Jul-2021
Effective To
-
Description 
The Elective Surgery Data Collection (ESDC) is a monthly collection of patients who have been removed from, or are still waiting on the elective surgery waiting list in one of 53 reporting public hospitals. The ESDC collects demographic, waiting list and service information to meet State and national reporting requirements.
Short Name
ESDC
Strategic Alignment Attributes
Actual or potential statewide coverage
Yes
All Elective Surgery reporting public hospitals are represented in the collection.
Absence would cause significant impact on QH business
No
Supports enterprise-wide decision making
Yes
Used for performance measurement and public reporting.
Supports enterprise-wide reporting requirements
Yes
Used for performance measurement, Service Level, and public reporting.
Supports the strategic directions of QH
Yes
Used for performance measurement, Service Level, and public reporting.
Strategic Asset Indicator
Yes
Collection and Usage Attributes
Guide for Use 
-
Purpose 
To collect elective surgery waiting list data to allow reporting to support service improvement, performance management and surgical planning.

The collection contains information on patients who have been registered on an elective surgery waiting list, permitting the reporting of patients waiting at a census date, and patients removed from the waiting list.
Scope 
Queensland Elective Surgery Reporting Hospitals.
Coverage
QLD
Content
Included are all patients placed on a waiting list for elective surgery, as identified by a treating clinician, who are given an urgency of 1, 2 or 3 and are registered on the Hospital Based Corporate Information System (HBCIS) Elective Admissions Management (EAM) module at any of the Queensland Elective Surgery Reporting Hospitals.
Sites Implemented 
Atherton Hospital
Ayr Hospital
Beaudesert Hospital
Biloela Hospital
Bundaberg Hospital
Caboolture Hospital
Cairns Hospital
Caloundra Hospital
Charleville Hospital
Chinchilla Hospital
Cooktown Hospital
Dalby Hospital
Emerald Hospital
Gladstone Hospital
Gold Coast University Hospital
Goondiwindi Hospital
Gympie Hospital
Hervey Bay Hospital
Innisfail Hospital
Ipswich Hospital
Kingaroy Hospital
Logan Hospital
Longreach Hospital
Mackay Base Hospital
Mareeba Hospital
Maryborough Hospital
Mater Hospital Brisbane Public
Mater Mothers' Hospital Public
Mount Isa Base Hospital
Nambour Hospital
Noosa Hospital
Princess Alexandra Hospital
Proserpine Hospital
Queen Elizabeth II Jubilee Hospital
Queensland Children's Hospital
Redcliffe Hospital
Redland Hospital
Robina Hospital
Rockhampton Hospital
Roma Hospital
Royal Brisbane & Women's Hospital
St George Hospital
Stanthorpe Hospital
Sunshine Coast University Hospital
Surgical, Treatment and Rehabilitation Service
The Prince Charles Hospital
Thursday Island Hospital
Toowoomba Hospital
Townsville University Hospital
Warwick Hospital
Weipa Hospital
Published Outputs 
Elective surgery data is published regularly through the Queensland Health Hospital Performance website and through national publications and websites.
Frequency of Updates
Data collected nightly.
Information Security Classification
SENSITIVE
Accessibility 
Elective surgery data is accessed through the Queensland Health Enterprise Reporting Service (QHERS) and through the Decision Support System (DSS). Data published online are in the public domain.
Access Constraints
Access to the data can be requested through the Hospital Access Analysis Team in the Healthcare Improvement Unit (HIU) by emailing HAAT@health.qld.gov.au.
Use Constraints
N/A.
Methodology 
Data is entered into the HBCIS EAM module at each reporting hospital. Each night, information is extracted from EAM and electronically transferred to SATR, a Department of Health central data repository.
Statistical Unit
-
Reporting Requirements
Hospital and Health Services use the data in the collection to manage elective surgery waiting lists and monitor activity and performance. The Department of Health uses the data in the collection to monitor elective surgery activity and performance, and to conduct analysis to support service improvement, planning and purchasing strategies. Commonwealth reporting requirements for elective surgery National Minimum Data Sets are identified by the Australian Institute of Health and Welfare. The data from the collection is reported on the Queensland Health Hospital Performance website to provide transparency of activity and performance to the public.
Frequency of Reporting Requirements
Data reported routinely on a monthly basis.
Comments 
-
Relational Attributes
Related Metadata References
Supersedes Elective Surgery Data Collection (ESDC) QH 020110 Version 2
Implementation in
- 
Included Data Elements and Performance Indicators

Otherrelational

  • 1 - 25
ViewMetadata Item TypeNameAscendingIdentifier & VersionObligationApproval StatusEffective fromEffective to
Data ElementElective procedure waiting list episode-clinical urgency assessment category reassignment dateQH 041720 Version 2ConditionalCurrent01-Jul-2021
Data Element ConceptElective surgery waiting list episodeQH 041716 Version 1Current01-Jul-2021
Data ElementElective surgery waiting list episode-clinical urgency assessment categoryQH 040087 Version 4MandatoryCurrent01-Jul-2021
Data ElementElective surgery waiting list episode-date placed on waiting listQH 042273 Version 1MandatoryCurrent01-Jul-2021
Data ElementElective surgery waiting list episode-not ready for surgery end dateQH 042287 Version 1ConditionalCurrent01-Jul-2021
Data ElementElective surgery waiting list episode-not ready for surgery start dateQH 042271 Version 1ConditionalCurrent01-Jul-2021
Derived Data ElementElective surgery waiting list episode-number of days not ready for surgeryQH 042318 Version 1MandatoryDraft01-Jul-2021
Data ElementElective surgery waiting list episode-patient listing status, readiness for surgeryQH 041721 Version 2MandatoryCurrent01-Jul-2021
Data ElementElective surgery waiting list episode-planned procedure dateQH 040597 Version 1ConditionalCurrent01-Jul-2021
Data ElementElective surgery waiting list episode-reason for removal from a waiting listQH 042321 Version 1ConditionalDraft01-Jul-2021
Derived Data ElementElective surgery waiting list episode-surgical specialty (of unit of admission) (ESDC)QH 042322 Version 1MandatoryCurrent01-Jul-2021
Data ElementElective surgery waiting list episode-waiting list removal dateQH 040983 Version 2ConditionalCurrent01-Jul-2021
Derived Data ElementElective surgery waiting list episode-waiting time at a census date, total daysQH 040962 Version 3ConditionalCurrent01-Jul-2021
Derived Data ElementElective surgery waiting list episode-waiting time at removal, total daysQH 040963 Version 3MandatoryCurrent01-Jul-2021
Data ElementFacility-facility codeQH 040006 Version 2MandatoryCurrent01-Jul-2021
Data ElementFacility-hospital managing waiting listQH 041726 Version 1Current01-Jul-2021
Data ElementHealthcare Improvement Unit (HIU) data collection-data extract file nameQH 042785 Version 1MandatoryDraft01-Jul-2021
Data ElementHealthcare Improvement Unit (HIU) data collection-data extract period beginningQH 042065 Version 1MandatoryDraft01-Jul-2021
Data ElementHealthcare Improvement Unit (HIU) data collection-data extract period endingQH 042066 Version 1MandatoryDraft01-Jul-2021
Data ElementHealthcare Improvement Unit (HIU) data collection-data source systemQH 042067 Version 1MandatoryDraft01-Jul-2021
Data ElementHealthcare Improvement Unit (HIU) data collection-number of data extract recordsQH 042068 Version 1MandatoryDraft01-Jul-2021
Data Element ConceptHospital waiting listQH 040964 Version 1Current01-Jul-2021
Data ElementHospital waiting list-census dateQH 040352 Version 3Current01-Jul-2021
Data ElementPerson (name)-first given name (HIU)QH 042069 Version 2ConditionalDraft01-Jul-2021
Data ElementPerson (name)-second given name (HIU)QH 042070 Version 2ConditionalDraft01-Jul-2021
Data Quality Declaration 
-
Source and Reference Attributes
Source Systems 
SATR Data Collection acts as an enterprise data warehouse for statewide elective surgery and specialist outpatient waitlists, as well as the core HIU data collections (SODC, ESDC, EDC, GIEDC, RTDC)

Data is extracted from the following hospital information systems into SATR nightly:
HBCIS-Elective Admissions Module (EAM)
HBCIS Appointment Scheduling System (APP)
HBCIS-ADT (patient demographic and doctor information for elective surgery patients and specialist outpatients)
ASIM (Logan Hospital specialist outpatient appointments)
Cerner-OSIM (Royal Brisbane and Women's Hospital and Princess Alexandra Hospital specialist outpatient appointments)
Source Organisation 
-
Source Document
<INTERNAL QH LINK NOT AVAILABLE> (Elective Surgey Data Collection)
Keywords

Admission; Elective surgery