Inpatient and Outpatient Related Hospital Activity Data

$447.50 / 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-11-30

Version

2018-11-30

Update Frequency

Quarterly

Temporal Coverage

2017-2018

Spatial Coverage

England

Source

John Snow Labs; NHS England;

Source License URL

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

NameDescriptionTypeConstraints
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
2018April to JuneCommissioner BasedEngland157835814481473427923418135461462285409499683446516910530172968900
2018April to JuneCommissioner BasedXDHNHS ENGLANDX24NHS ENGLAND65525920411584678416457411698939843826729116602655864
2018April to JuneCommissioner BasedY54NORTH OF ENGLAND COMMISSIONING REGION00CNHS DARLINGTON CCG230120922326862466987141831216228582409
2018April to JuneCommissioner BasedY54NORTH OF ENGLAND COMMISSIONING REGION00DNHS DURHAM DALES, EASINGTON AND SEDGEFIELD CCG71506483828841769013677276982391495095305
2018April to JuneCommissioner BasedY54NORTH OF ENGLAND COMMISSIONING REGION00JNHS NORTH DURHAM CCG5672525696743143079416221491720405493868
2018April to JuneCommissioner BasedY54NORTH OF ENGLAND COMMISSIONING REGION00KNHS HARTLEPOOL AND STOCKTON-ON-TEES CCG6831668259706159069189180341732300633601
2018April to JuneCommissioner BasedY54NORTH OF ENGLAND COMMISSIONING REGION00LNHS NORTHUMBERLAND CCG9924945015410111823012278270052029639635568
2018April to JuneCommissioner BasedY54NORTH OF ENGLAND COMMISSIONING REGION00MNHS SOUTH TEES CCG60475474946731504011703191272192373264265
2018April to JuneCommissioner BasedY54NORTH OF ENGLAND COMMISSIONING REGION00NNHS SOUTH TYNESIDE CCG59065240178681103098039156881598335093477
2018April to JuneCommissioner BasedY54NORTH OF ENGLAND COMMISSIONING REGION00PNHS SUNDERLAND CCG893780092489492126614100347382745539025633