This pro forma is designed to capture the length of time it has taken to undertake a Universal Mortality Review (UMR) following a death.
For each acute hospital within the Health Board/NHS Trust it asks for the total number of deaths which have occurred during a month and then how many UMRs were undertaken within categorised time periods from the date of death.
1) Indicator
This is pre populated in the pro forma with the acute hospitals for the respective Health Board/NHS Trust area and monthly rows for the data.
2) Total number of deaths which occurred during the month
This is a count of the number of deaths that occurred during the reporting period irrespective of when the UMR was undertaken.
3) Of the deaths which occurred during the month, how many UMRs for these deaths were undertaken
a. Up to and including 7 days from the date of death
b. 8 days and over and up to and including 28 days from the date of death
c. 29 days and over and up to and including 56 days from the date of death
d. 57 days and over and up to and including 84 days from the date of death
e. 85 days and over from the date of death
This is the count of UMRs undertaken during the reporting period split by the number of days from the date of death that the Review was undertaken.
Because a UMR for a death which occurred in one reporting month may not be undertaken until, for example, 2 months after the death then organisations will be required to back populate previous months’ data when submitting data for the current period (see working example below).
4) Total number of UMRs undertaken for the deaths that occurred during the month
This is auto calculated as a sum of the data entered for points 3a to 3e (see above) for the respective reporting period.
5) Percentage of UMRs undertaken within 28 days for deaths which occurred during the month
This percentage is auto calculated and is based on the sum of data in points 3a and 3b (see above) divided by the Total Number of Deaths which Occurred During the Month for the respective reporting period.
6) Percentage of UMRs undertaken for deaths which occurred during the month, irrespective of when the UMR was undertaken
This percentage is auto calculated and is based on a division of Total Number of UMRs Undertaken for the Deaths that Occurred During the Month by the Total Number of Deaths which Occurred During the Month for the respective reporting period.
Working example
Note that the screen shots below only display the relevant columns referenced in the working examples and do not represent all columns present in the pro forma.
3 deaths occurred in April 2017, therefore 3 would be entered for the relevant month under Total Number of Deaths which Occurred During the Month
Patient A died on 1st April 2017 – UMR completed on the 3rd April 2017
Patient B died on 2nd April 2017 – UMR completed on the 23rd April 2017
Patient C died on 30th April 2017 – UMR completed on the 1st June 2017
April data submission (due to be sent to WG by 31st May 2017)
June data submission (due to be sent to WG by 31st July 2017)
Note – the Total Number of UMRs Undertaken for the Deaths that Occurred During the Month cannot be more than the Total Number of Deaths which Occurred During the Month. If this occurs, the relevant cell in the Total Number of UMRs Undertaken for the Deaths that Occurred During the Month will be highlighted in red indicating that an error has occurred and therefore must be corrected before submission.