Inpatient and Outpatient Related Hospital Activity Data

$199 / year

This dataset contains quarterly hospital activity data relating to inpatients (elective) and outpatients. All data items relate to all specialties. Figures are submitted quarterly on the Quarterly Activity Return (QAR) by National Health Service (NHS) Trusts and Independent sector providers treating NHS patients.

Complexity

The Quarterly Activity Return (QAR) is a Provider Commissioner collection with providers submitting their data broken down by commissioner. Commissioners extract the data from Extraction Viewer before validating and signing off their data. Commissioners do not need to upload a QAR return unless they need to add anything, for example, data for a non-English provider or Independent Sector provider.

Private patients should be recorded as Non-English Commissioner, code NONC. Commissioner returns should cover all activity for which the Clinical Commissioning Group (CCG) is financially responsible, regardless of whom it is commissioned from. They should include all NHS activity as well as non-NHS activity figures related to the volumes of total activity commissioned from non-NHS organizations e.g. voluntary, private and non-NHS statutory bodies.

From April 2013 nationally NHS England commissions specialized services, primary care, offender healthcare and some services for members of the armed forces. The Quarterly Activity Return is based on consultant specialties. From Q3 2007/08 only the ‘All specialties’ (specialty code: C_999) total has been required on the return, we no longer need the specialty breakdown.

Outpatient data include:
– The number of GP and other referrals for first consultant outpatient appointments
– The total number of attendances at consultant outpatient clinics including patients seen for their first appointments as well as those attending for subsequent or follow up appointments
– The number of patients who did not attend their outpatient appointment (first or subsequent) and gave no advance warning, or arrived too late to be seen.

Elective admission events are:
– Decisions to admit
– Patients admitted
– Patients failed to attend
– Removals other than admission

Date Created

2017-08-25

Last Modified

2018-08-31

Version

2018-08-31

Update Frequency

Quarterly

Temporal Coverage

2017-2018

Spatial Coverage

England

Source

John Snow Labs => NHS England

Source License URL

John Snow Labs Standard License

Source License Requirements

N/A

Source Citation

N/A

Keywords

Clinical Commissioning Group Data, Hospital Data, The Quarterly Activity Return, Provider Commissioner, Inpatient Data, Outpatient Data, Quarterly Activity Return Hospital Data

Other Titles

Hospital Activity Data, Quarterly Hospital Activity Data

Name Description Type Constraints
YearData collection Yeardaterequired : 1
QuarterPeriod of the year in which the data was collected.stringrequired : 1
Data_TypeType of data, either commissioner based or provider basedstringrequired : 1
Region_CodeRegion code of the NHS organizations.string-
Region_NameRegion name of the NHS organizations.string-
Organization_CodeNHS Organization unique codestring-
Organization_NameName of the NHS organizations.stringrequired : 1
Decisions_to_AdmitNumber of decisions to admit made in the given period. This count refers to patients for whom a clinical decision to admit to a hospital bed has been made during the quarter. It excludes Decisions to Admit for planned admissions.integerlevel : Ratio
Number_of_AdmissionsNumber of patients admitted electively. It includes the count of those patients who are subsequently sent home without treatment. It excludes Patients Admitted for planned admissions.integerlevel : Ratio
Patients_Failed_to_AttendNumber of patients for whom admission was arranged but who Failed to Attend and did not tell the hospital in advance that they would not be coming. It excludes Patients who Failed to Attend for planned admissions.integerlevel : Ratio
Removals_Other_Than_AdmissionsNumber of patients removed from the elective admission list for reasons other than admission. It excludes Removals for planned admissions. It does not include suspended patients as they have not been removed from the elective admission list.integerlevel : Ratio
GP_Referrals_MadeNumber of written referrals from General Practitioners (GP), whether doctors or dentists, for first consultant outpatient appointment. All written GP referral requests to a Consultant whether directed to a specific consultant or not, should be recorded, regardless of whether they result in an outpatient attendance.integerlevel : Ratio
Other_Referrals_MadeThe total number of other Referral Requests (written or verbal) for a first Consultant Out-Patient Episode in the period. All referral requests to a Consultant whether directed to a specific consultant or not, should be recorded, regardless of whether they result in an outpatient attendance.integerlevel : Ratio
First_Attendances_SeenNumber of first attendance appointments in all specialties, where the Out-Patient Attendance Consultant took place within the reporting period. These should be consultant outpatient appointments, whether taking place within a Consultant clinic session or outside a session. The only proviso is that the patient must have seen a Consultant (or a doctor acting for the Consultant) for examination or treatment.integerlevel : Ratio
First_Attendances_DNAThe total number of accepted appointments which should have resulted in a first Out-Patient Attendance Consultant within the quarter which did not take place due to the patient not attending the appointment.integerlevel : Ratio
Subsequent_Attendances_SeenThe total number of follow-up attendance appointments, where the Out-Patient Attendance Consultant took place within the quarter. This includes subsequent outpatient attendance for all consultant outpatient episodes for all sources of referral.integerlevel : Ratio
Subsequent_Attendances_DNAThe total number of accepted appointments which should have resulted in a follow-up Out-Patient Attendance Consultant within the quarter which did not take place due to the patient not attending the appointment.integerlevel : Ratio
YearQuarterData_TypeRegion_CodeRegion_NameOrganization_CodeOrganization_NameDecisions_to_AdmitNumber_of_AdmissionsPatients_Failed_to_AttendRemovals_Other_Than_AdmissionsGP_Referrals_MadeOther_Referrals_MadeFirst_Attendances_SeenFirst_Attendances_DNASubsequent_Attendances_SeenSubsequent_Attendances_DNA
2017April to JuneProvider BasedY54NORTH OF ENGLAND COMMISSIONING REGIONNQLNAVIGO
2017July to SeptemberProvider BasedY54NORTH OF ENGLAND COMMISSIONING REGIONNQLNAVIGO
2017April to JuneProvider BasedY56LONDON COMMISSIONING REGIONNLGCOMMUNITAS CLINICS349240221266
2017April to JuneProvider BasedY55MIDLANDS AND EAST OF ENGLAND COMMISSIONING REGIONNQAPROVIDE43
2018January to MarchProvider Based Y56 LONDON COMMISSIONING REGION NT314 SPIRE RODING HOSPITAL
2017July to SeptemberProvider BasedY56LONDON COMMISSIONING REGIONNLGCOMMUNITAS CLINICS325310111348
2017April to JuneProvider BasedEngland157368014509473277023923734934592188661486550746557110282508
2017July to SeptemberProvider BasedY55MIDLANDS AND EAST OF ENGLAND COMMISSIONING REGIONNQAPROVIDE31
2017April to JuneProvider BasedY56LONDON COMMISSIONING REGIONNDAVIRGIN CARE SERVICES LTD20199851004
2018April to JuneProvider BasedEngland15945271434253313019378276057733837203881528287411001588968900