NHS Digital Data Release Register

NHS Digital Data Release Register - reformatted

University Hospitals Coventry and Warwickshire NHS Trust

Opt outs honoured: N

Basis: Health and Social Care Act 2012

Format: Anonymised - ICO code compliant Non Sensitive

How often: Ongoing

When: unknown — 11/2016

HSCIC Id: DARS-NIC-388494-W3L6K-v0.0

Data: Hospital Episode Statistics Accident and Emergency

Data: Hospital Episode Statistics Admitted Patient Care

Data: Hospital Episode Statistics Outpatients

Project info

Output: Overarching principle to be applied

All outputs will only contain aggregated level data with small numbers suppressed in line with the HES analysis guide.

Output to be created to satisfy all objectives

Microsoft Excel based reports will be sent to the following teams within UHCW, at the end of each financial quarter:
• UHCW Commercial Finance Managers (x4)
• UHCW Head of Clinical Coding (x1)
The excel based reports will include the following data items:
• *Inpatient: data items: Provider code – Commissioner code – SUS generated HRG – Method of admission - Treatment specialty – date of discharge – duration of spell.
• *Outpatient data items: Provider code – Commissioner code – SUS generated HRG – Treatment specialty – attendance date – attended or did not attend
• *A&E data items: Provider code – Commissioner code – SUS generated HRG – date of attendance

Specifically For objective 2, the additional data items which will be included in the report includes; Inpatients: All diagnosis codes -- All operative procedure codes. Outpatients: All operation codes. A&E: A&E investigation – A&E diagnosis.
All reports will be presented in the form of a pivot table, enabling the recipient to modify as necessary.

All persons who will be processing the data and/or receiving reports arising from analysis of the data will be UHCW employees.

Activities: Please see data flow diagram i.e. “SD1 – Data Flow Diagram”. The data processing activities apply to all three objectives.
Step One
Receive data from HSCIC in psuedonymised/non-sensitive format
Step 2
UHCW commercial analytics team upload data into SQL server, stored as a table formatting
Step 3
UHCW commercial analytics team run data queries which will result in output tables (in aggregated format with small numbers suppressed)
Step 4
UHCW commercial analytics team export data into Microsoft Excel (in aggregated format with small numbers suppressed)
Step 5
UHCW commercial analytics team produce reports using Microsoft Excel and distribute to internal UHCW colleagues i.e. Commercial Finance Managers and Head of Clinical Coding. The reports will be presented in the form of a pivot table, enabling the recipient to modify as necessary.
All persons who will be processing the data and/or receiving reports arising from analysis of the data will be UHCW employees. The Trust will not be using the HES data extracts to develop any commercial products. Any reference to the UHCW “commercial analytics teams” or “commercial finance manager” relates to the fact that there is a consistency in team name and structure within the Trust’s Finance Department.

Objective: 1. To provide University Hospitals Coventry & Warwickshire NHS Trust (UHCW) with the means to undertake clinical benchmarking against their peers for the following themes:

a. Length of stay at a HRG sub-chapter level across elective and non-elective activity
b. Emergency admission rates at a HRG sub-chapter level
c. The proportion of outpatient new attenders who are followed up (first to follow-up ratio) for every clinical specialty.
d. Elective care activity volumes at a specialty and HRG-sub-chapter level.
e. A&E activity volumes at a HRG level.
with the overall aim of helping UHCW to identify variations in practice and efficiency opportunities.

2. To provide UHCW with the means to undertake clinical coding benchmarking analysis which specifically focuses on reviewing casemix differences from the perspective of ICD and OPCS coding.

3. To provide UHCW with the means to undertake market share analysis, with a specific focus on: comparing elective care, non-elective care and outpatient care activity volumes for the Trust compared to peers. UHCW Trust falls within the Midlands and East Commissioning Area, this is the area that will be used in regards to market share analysis to understand how activity across the region has changed and what effect this will have on UHCW’s operation.
The Trust will be undertaking benchmarking analysis against Trusts within the Association of University Hospitals (AUKUH) group. These trusts are similar sized to UHCW, all teaching hospitals like UHCW and offer similar services.

Benefits: Objective One – Undertaking benchmarking against peers – to be achieved within 3 months of the report being made available to the users, i.e. UHCW internal colleagues.

• By comparing Length of stay at a HRG sub-chapter level across elective and non-elective activity, this will enable UHCW to quantify the opportunities available for reducing hospital length of stay at UHCW.
• By comparing Emergency admission rates at a HRG sub-chapter level, this will enable UHCW to quantify the opportunities available for reducing short stay admissions at UHCW.
• By comparing the proportion of outpatient new attenders who are followed up this will enable UHCW to quantify the opportunities available for reducing unnecessary follow-up outpatient activity at UHCW.
• By comparing Elective care activity volumes at a specialty and HRG-sub-chapter level this will enable UHCW to quantify the opportunities available for increasing the proportion of elective work undertaken as a daycase at UHCW.
• By comparing A&E activity volumes at a HRG level this will enable UHCW to quantify the opportunities available for reducing A&E attendances at UHCW.

Objective Two – Undertaking clinical coding benchmarking analysis which specifically focuses on reviewing casemix differences from the perspective of ICD and OPCS coding benchmarking against peers – to be achieved within 3 months of the report being made available to the users, i.e. UHCW internal colleagues.

• By comparing against peers, UHCW will improve the accuracy and depth of clinical information by investigating how other Trusts code. Using the data to investigate differences in coding will mean that the UHCW can understand where improvements to clinical reports e.g. clinical notes, discharge summaries, may have to be improved.
• The overarching benefit to Heath and Social Care would mean that commissioners and regulators would be provided with a more accurate description clinical pathway complexity being operated by UHCW

Objective Three – Undertaking market share analysis by comparing elective care, non-elective care and outpatient care activity volumes for the Trust compared to peers - to be achieved within 3 months of the report being made available to the users, i.e. UHCW internal colleagues.

• Using the data to understand the relative volume of different activity types across the health economies, where UHCW has a presence, will inform UHCW’s development of service redesign offering to commissioners.
• The overarching benefit to Health and Social Care would be a service redesign offering which focuses on reducing variation in secondary care provision and overall cost.

Source: NHS Digital.