ADR Metadata Catalogue

ADR  > Outpatient Database for Wales (OPDW) @ 346

https://saildatabank.com/about-us/, https://docs.hiru.swan.ac.uk/display/SATP/OPDW+-+Outpatient+Database+for+Wales, https://www.datadictionary.wales.nhs.uk/#!WordDocuments/outpatientdatasetopds2.htm

Attendance information for all NHS Wales hospital outpatient appointments.

The data are collected and coded at each hospital. Administrative information is collected from the central PAS (Patient Administrative System), such as specialty of care, appointment date and attendance status.

This dataset contains all scheduled outpatient appointments, including those where the patient failed to attend.

SAIL Databank (Wales)

DHCW

Encypted case record number. A unique identifier for a patient within a hospital or health care provider.

case_rec_num_e

Operation data related to the Out Patient Dataset Wales.

Note, outpatient tables have to be joined based on att_id_e,case_rec_num_e,atten_dt, and prov_unit_cd

outpatients_oper

The 4th digit of the Procedure code available (OPCS4)

oper_cd_4

This is the date of an attendance or appointment to attend.

attend_dt

Date when the data made available i.e. date of loading

avail_from_dt

Encrypted Attendance Identifier. A sequential number or time of day used to enable an attendance or appointment to be uniquely identified.

att_id_e

A number used to identify the position of procedure assigned to a patient. Value 1 relates to the primary OPCS4 procedure Code. Values &amp;gt; 1 relate to secondary OPCS4 procedure codes.

oper_num

Provider Unit Code (3 character code). This is the organisation code of the health care provider. The provider code identifies the health care provider who is responsible for managing the treatment of the patient.

prov_unit_cd

The first 3 digits of the Procedure code available (OPCS4)

oper_cd_123

First Attendance Code. The first attendance is the start of the Outpatient episode and is the first attendance in a series with the same Consultant or Independent Nurse following a referral.

first_attend_cd

Data related to the Out Patient Dataset Wales. 

Note, outpatient tables have to be joined based on att_id_e,case_rec_num_e,atten_dt, and prov_unit_cd

outpatients

Operation status should be used once for each record to record states of knowledge regarding the operative procedure.

oper_sts_flg

Code indicating the outcome of the Outpatient Attendance.

outcome_cd

Match percentage assigned when deriving the Encrypted Anonymised Linking Field.

alf_mtch_pct

Last DNA or Patient Cancelled Date: This derived item should only be recorded for the first attendance for outpatient treatment

last_dna_cancel_dt

A unique code identifying each Main Specialty designated by Royal Colleges. Specialties are divisions of clinical work which may be defined by body systems (dermatology), age (paediatrics), clinical technology (nuclear medicine), clinical function (rheumatology), group of diseases (oncology) or combinations of these factors.Only Specialty titles recognised by the Royal Colleges and Faculties should be used. This list is maintained by the General and Specialist Medical Practice (Education, Training and Qualifications) Order 2003 and European Primary and Specialist Dental Qualifications Regulations 1998.

con_spec_main_cd

The Clinical Referral Date (CRD) is the clinically significant date marking the start of a period of waiting either for an initial outpatient consultation or for an episode of treatment such as elective surgery. The CRD is used to order pick lists used for booking patients, and it does not change under any circumstances. It is not used to calculate performance waiting times statistics.

clinical_ref_dt

Code identifying the source of referral of each Outpatient Episode or Outpatient Referral.

source_of_ref_cd

Encrypted GMC Consultant Code. Nationally agreed form for consultant code or Independent Nurse. It is the General Medical Council (GMC) code for the Consultant or the GP acting as a Consultant or locum Consultant, which is the unique identifier. The nurses Registration Number will be used to identify the Independent Nurse.

gmc_con_cd_e

Code indicating the type of medical staff seeing the patient during an Outpatient attendance.

med_staff_type_cd

The Waiting List Date is set initially as the same date as the Clinical Referral Date. It is used to calculate waiting times for the purpose of measuring Local Health Board/Trust performance against Welsh Assembly Government performance targets. It is not used to order outpatient waiting lists for partial booking or to order inpatient or daycase lists for selection of patients surgery. There are a number of situations where the WLD may be changed. These include rescheduling an appointment at the patients request, reinstatement to a waiting list following removal, or where a patient has chosen to remain with a consultant when offered an earlier appointment with a different consultant.

waiting_list_dt

Code indicating the priority of a request for services and is to be recorded for new attendances only, that is, where Attendance Category = 1. In the case of services to be provided by a Consultant, it is as assessed by or on behalf of the Consultant.For a Follow Up Attendance or a Pre-Operative Assessment Attendance, Priority Type must be blank.

priority_type_cd

Code indicating the classification of location type.

loc_type_cd

The age of the individual at the time of the appointment.

age_at_appt

Code indicating the sex (gender) of person, employee or patient.

gndr_cd

Code to indicate whether a person or patient attended for an appointment. If the patient did not attend, it also indicates whether or not advanced warning was given.

attend_cd

Status code assigned when deriving the Encrypted Anonymised Linking Field.

alf_sts_cd

Code to indicate the specialty under which the patient will be or is treated. This may either be the same as the specialty function recorded as the consultants main specialty or a different specialty function which will be the consultants interest specialty function. Note that both the main specialty function and the interest specialty function should be based on one of the Royal College specialties.

con_spec_cd_of_treat

The encrypted unique GP Practice code to which the patient is registered.

reg_prac_cd_e

Code indicating the locally or nationally defined division of clinical work which may cross specialty boundaries.

local_spec_cd

Encrypted Referral Code. This is the nationally recognized code of the person making the referral.This may be a General Medical Practitioner (GMP), General Dental Practitioner (GDP), Consultant or Independent Nurse.  If the referral is not from a GMP, GDP, Consultant or Independent Nurse one of the default codes used.

ref_cd_e

Lower Layer Super Output Area (LSOA) code in which the patient is resident, for a previous version of LSOA codes (2001)

lsoa2001_cd

Provider Site Code (5 character code). This is the organisation code of the health care provider. The provider code identifies the health care provider who is responsible for managing the treatment of the patient.

prov_site_cd

This is the date on which the patient was told about the referral. The starting point should be the date of referral given on the referral notification (not the date the letter was received in hospital). In cases where the referrer fails to specify a date of referral, the date the referral notification was received should be used.

ref_dt

Site Code of Treatment (5 character code). The organisation code for the site where the patient will be or is treated.

site_cd_of_treat

The Anonymised Linking Field, which has been Encrypted for its use within the database, is derived from the persons NHS number by double encryption (first encryption occurs in NWIS and the second in SAIL). If the NHS number is not supplied in the data extract then matching methods are applied.

alf_e

Code to indicate the function of an outpatient clinic e.g. psychogeriatric, obstetric. No national classification of functions for outpatient clinics has been developed, so function titles must be decided locally.Certain specialty sub-divisions must be shown, such as: a. Obstetric antenatal,  b. Obstetric postnatal,  c. Gynaecology.

clinic_purpose_cd

Administrative Category Code. Code to indicate whether the patient is treated as an NHS, private or amenity patient etc.

admin_cat_cd

Diagnostic data related to the Out Patient Dataset Wales.

Note, outpatient tables have to be joined based on att_id_e,case_rec_num_e,atten_dt, and prov_unit_cd

outpatients_diag

The first 3 digits of the Diagnostic code available (ICD 10)

diag_cd_123

The 5th and 6th digit of the Diagnostic code available (ICD 10)

diag_cd_56

The 4th digit of the Diagnostic code available (ICD 10)

diag_cd_4

A number used to identify the position of diagnosis assigned to a patient. Value 1 relates to the primary ICD Diagnostic Code. Values &amp;gt; 1 relate to secondary ICD diagnositic codes.

diag_num

Attendance information for all hospital outpatient appointments.

Outpatient Database for Wales (OPDW)

Summary

Documentation

Coverage

Spatial

Temporal

Provenance

Access and Governance

Usage

Access

Format and Standards

Observations

Origin