Archived PEDW Data Online
The annual PEDW data tables are now available for download for 2014/15 to 2020/21. They consist of headline figures relating to hospital admissions (inpatient, day case and maternity admissions) in Portable Document Format (PDF); and Microsoft Excel tables containing separate analyses by diagnosis, operation, specialty, Healthcare Resource Group (HRG), Local Health Board (LHB) of patient’s usual residence and regular attendance information.
From 1st April 2019 health service provision for residents of Bridgend local authority moved from Abertawe Bro Morgannwg to Cwm Taf. The health board names have changed with Cwm Taf University Health Board becoming Cwm Taf Morgannwg University Health Board and Abertawe Bro Morgannwg University Health Board becoming Swansea Bay University Health Board. For more information see the Joint statement from Cwm Taf and Abertawe Bro Morgannwg University Health Boards. Therefore, data for Cwm Taf Morgannwg University Health Board and Swansea Bay University Health Board are only available for 2019/20 and are not comparable with previous years’ data.
For data prior to 2014/15 or where your request cannot be satisfied through the available data, specific requests for data can be obtained through the Digital Health and Care Wales bespoke analysis service. This service is provided to the Welsh Government, NHS Wales and others. For information other than that already available via this website, please contact the Analysis Team at DHCW.Info@wales.nhs.uk and detail your requirements as fully as possible.
What is PEDW?
The Patient Episode Database for Wales (PEDW) was implemented in April 1991. The database contains all inpatient and day case activity undertaken in NHS Wales plus data on Welsh residents treated in English Trusts. In 1997 the mandated inpatient and day case dataset changed to Admitted Patient Care (APC). The decision to adopt APC was to align the Welsh inpatient and day case dataset with England to allow benchmarking. Some data items previously submitted on PEDW were dropped and new date items added to the APC format. APC contains demographic, clinical and administrative detail, such as age and sex of patient; diagnostic and operative procedures (ICD10 and OPCS -4).
The Data Acquisition Team are responsible for the collection, processing and monitoring of the monthly Admitted Patient Care extracts received from Welsh NHS sites that provide inpatient and day case care and English sites that treat Welsh residents. These extracts are used to update the Patient Episode Database for Wales (PEDW), from which the Business Intelligence Team provide an analysis service and extract data which are used for Welsh Government Publications.
APC extracts are received on a monthly basis directly from Welsh NHS sites and a download from the NHS Digital Secondary Uses Service (SUS) for Welsh residents treated in English hospitals. The submission date is the 17th day of each month. A report is produced each month, which monitors the timeliness of data submissions.
Data Summary
Individual records are submitted to PEDW on the basis of a patient's consultant episode; that is the time an admitted patient spends in the continuous care of one consultant within one NHS provider. If the patient is transferred to the care of another consultant, either in the same or another specialty or they are transferred to another NHS provider for continuing in-patient care, another consultant episode will start and result in another PEDW record.
Patients captured by the PEDW database are classified as follows:
- In-Patients - Patients that are admitted to hospital staying at least one night.
- Day Cases - Patients who are admitted electively for treatment or care that does not require an overnight stay in hospital.
- Maternity Patients - The admission of a pregnant or recently pregnant woman to a maternity ward (including delivery facilities).
- Regular Attenders - Patient admitted electively as part of a planned series of regular admissions for an on-going regime of broadly similar treatment (e.g. for chemotherapy/radiotherapy sessions).
Diagnosis and Procedural Information
Information about the diagnosis for which a patient is admitted, or any operative procedures undertaken during an episode of care, is coded by clinical coders to standard classifications. Diagnosis information is coded as using the International Statistical Classification of Diseases and Related Health Problems (Version 10) known as ICD10, and operative procedures are coded using the the Office of Population Censuses and Surveys Classification of Surgical Operations and Procedures (Version 4) known as OPCS4.