[WWW - 2023.07.31]

Information Asset Detail

Elective Surgery Data Collection (ESDC)
Identifying and Definitional Attributes
QH 020110 v2
Information Asset
Data Collection
Draft
04-Jun-2019		Current
21-Sep-2021
Standard
Information Management Strategic Governance Committee (IMSGC), Queensland Health
01-Jul-2019
30-Jun-2021
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 52 reporting public hospitals. The ESDC collects demographic, waiting list and service information to meet State and national reporting requirements.
ESDC
Strategic Alignment Attributes
Yes
All Elective Surgery reporting public hospitals are represented in the collection.
No
Yes
Used for performance measurement and public reporting.
Yes
Used for performance measurement, Service Level, and public reporting.
Yes
Used for performance measurement, Service Level, and public reporting.
Yes
Collection and Usage Attributes
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.
Queensland Elective Surgery Reporting Hospitals.
Queensland
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.
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
The Prince Charles Hospital
Thursday Island Hospital
Toowoomba Hospital
Townsville University Hospital
Warwick Hospital
Weipa Hospital
Elective surgery data is published regularly through the Queensland Health Hospital Performance website and through national publications and websites.
Data collected nightly.
SENSITIVE
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 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.
N/A.
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.
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.
Data reported routinely on a monthly basis.
Relational Attributes
Related Metadata References

Related Metadata References_IR

  • 1 - 6
ViewRelationshipMetadata Item TypeMetadata Item SubtypeNameIdentifier & VersionApproval Status
SupersedesInformation AssetData CollectionElective Surgery Data Collection (ESDC)QH 020110 Version 1Superseded
Has been superseded byInformation AssetData CollectionElective Surgery Data Collection (ESDC)QH 020110 Version 3Draft
Relates toData Supply RequirementHHS Service AgreementElective Surgery Waiting List Census Data Supply Requirement (DSR) 2019-2020QH 020568 Version 1Superseded
Relates toData Supply RequirementHHS Service AgreementElective Surgery Waiting List Census Data Supply Requirement (DSR) 2020-2021QH 020682 Version 1Current
Relates toData Supply RequirementHHS Service AgreementElective Surgery Waiting List Removals Data Supply Requirement (DSR) 2019-2020QH 020567 Version 1Superseded
Relates toData Supply RequirementHHS Service AgreementElective Surgery Waiting List Removals Data Supply Requirement (DSR) 2020-2021QH 020683 Version 1Current
Implementation in Metadata Sets

Implemented

No Metadata Items
Included Data Elements and Performance Indicators

Included DE

  • 1 - 36
ViewMetadata Item TypeMetadata Item SubtypeNameIdentifer & VersionObligationApproval StatusEffective FromEffective To
Data ElementData ElementData collection-data extract period beginningQH 042065 Version 1MandatoryDraft01-Jul-201930-Jun-2021
Data ElementData ElementData collection-data extract period endingQH 042066 Version 1MandatoryDraft01-Jul-201930-Jun-2021
Data ElementData ElementData collection-number of data extract recordsQH 042068 Version 1MandatoryDraft01-Jul-201930-Jun-2021
Data ElementData ElementElective procedure waiting list episode-clinical urgency assessment category reassignment dateQH 041720 Version 2ConditionalCurrent01-Jul-201930-Jun-2021
Data ElementData Element ConceptElective surgery waiting list episodeQH 041716 Version 1Current01-Jul-201930-Jun-2021
Data ElementData ElementElective surgery waiting list episode-clinical urgency assessment categoryQH 040087 Version 4MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementElective surgery waiting list episode-date placed on waiting listQH 042273 Version 1MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementElective surgery waiting list episode-not ready for surgery end dateQH 042287 Version 1ConditionalCurrent01-Jul-201930-Jun-2021
Data ElementData ElementElective surgery waiting list episode-not ready for surgery start dateQH 042271 Version 1ConditionalCurrent01-Jul-201930-Jun-2021
Data ElementDerived Data ElementElective surgery waiting list episode-number of days not ready for surgeryQH 042318 Version 1MandatoryDraft01-Jul-201930-Jun-2021
Data ElementData ElementElective surgery waiting list episode-patient listing status, readiness for surgeryQH 041721 Version 2MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementElective surgery waiting list episode-planned procedure dateQH 040597 Version 1ConditionalCurrent01-Jul-201930-Jun-2021
Data ElementData ElementElective surgery waiting list episode-reason for removal from a waiting listQH 042321 Version 1ConditionalDraft01-Jul-201930-Jun-2021
Data ElementDerived Data ElementElective surgery waiting list episode-surgical specialty (of unit of admission) (ESDC)QH 042322 Version 1MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementElective surgery waiting list episode-waiting list removal dateQH 040983 Version 2ConditionalCurrent01-Jul-201930-Jun-2021
Data ElementDerived Data ElementElective surgery waiting list episode-waiting time at a census date, total daysQH 040962 Version 3ConditionalCurrent01-Jul-201930-Jun-2021
Data ElementDerived Data ElementElective surgery waiting list episode-waiting time at removal, total daysQH 040963 Version 3MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementFacility-facility codeQH 040006 Version 2MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementFacility-hospital managing waiting listQH 041726 Version 1Current01-Jul-201930-Jun-2021
Data ElementData ElementHealthcare Improvement Unit (HIU) data collection-data extract file nameQH 042785 Version 1MandatoryDraft01-Jul-201930-Jun-2021
Data ElementData ElementHealthcare Improvement Unit (HIU) data collection-data source systemQH 042067 Version 1MandatoryDraft01-Jul-201930-Jun-2021
Data ElementData Element ConceptHospital waiting listQH 040964 Version 1Current01-Jul-201930-Jun-2021
Data ElementData ElementHospital waiting list-census dateQH 040352 Version 3Current01-Jul-201930-Jun-2021
Data ElementData ElementPerson (identifier)-identifier designationQH 040014 Version 4MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementPerson (name)-family nameQH 040002 Version 5MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementPerson (name)-first given name (HIU)QH 042069 Version 2ConditionalDraft01-Jul-201930-Jun-2021
Data ElementData ElementPerson (name)-second given name (HIU)QH 042070 Version 2ConditionalDraft01-Jul-201930-Jun-2021
Data ElementData ElementPerson-Indigenous statusQH 040290 Version 6MandatoryCurrent01-Jan-202130-Jun-2021
Data ElementData ElementPerson-country of birth (SACC 2016, v2.2.1)QH 040161 Version 10MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementPerson-date of birthQH 040163 Version 4MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementPerson-indigenous statusQH 040290 Version 5MandatorySuperseded01-Jul-201931-Dec-2020
Data ElementData ElementPerson-sex (code)QH 040000 Version 5MandatorySuperseded28-Jan-202130-Jun-2021
Data ElementData ElementPerson-sex (code)QH 040000 Version 4MandatorySuperseded01-Jul-201927-Jan-2021
Data ElementData ElementPlanned accommodation statusQH 040385 Version 1MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementService request-planned primary procedure code (ACHI 11th edn)QH 041982 Version 3MandatoryCurrent01-Jul-201930-Jun-2021
Data ElementData ElementService request-waiting list statusQH 041978 Version 1MandatoryCurrent01-Jul-201930-Jun-2021
Source and Reference Attributes
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)
INTERNAL QH LINK NOT AVAILABLE (Elective Surgey Data Collection)
Admission; Elective surgery;