LearningFromDeaths - QASpecific
- Assure Administrator
This report uses the same method as the Learning From Deaths report but enables users to focus on (include) a particular dataset rather than exclude them.
User will allocate a relevant scoring question to determine if that question subject was avoidable. They can then opt to excluding selected questions and answers from the dataset as well as allocate a scoring question and answer combination to show good and poor care.
PLEASE NOTE:
- This report is best used with review forms including more than one scoring question.
- The report is only available to be ran at a Trust Level (not site level).
- Works for any review form where there are Select Lists and Form Scores.
Report Criteria Options (Coloured cells show the grouped/related questions) | |
|---|---|
| Select Organisation | Select the relevant Trust code |
| Select Review Form | Select the relevant review form for your report data |
| Report From | Select the starting batch month you wish to report on |
| Standard or Fiscal Year | Select the time period you wish to run your report on. Standard = January to December Fiscal = April to March (Based on your selected report from date will also group the data in to standard or fiscal quarters) |
| Select Inclusion Questions | This will show the list of all single select list questions (where you can only select one answer from a list of options). Select the question(s) which represents the dataset you wish to focus the report on. If you do not wish to exclude any questions select "Select All" Please note that if your field was a single selection type and then changes to a multi-selection type, your options for this field will still refer to your single select version and will return data from your single select version. For example if Q1 has a single selectable answer of A, B or C and is changed to have multiple selectable answers of A and/or B and/or C, the report will only show the single selectable version. |
| Select Inclusion Answer Options | This is linked to your selection in the "Select Inclusion Questions" field It will show all of the answer options for the selected inclusion questions. Select all the answers which best suits your inclusion requirements If you do not wish to exclude any questions select "Select All" |
| Select Question Relating To Avoidable/Non Avoidable Death | This will show the list of all scoring questions within the review form(s) selected. Select which scoring question you wish to allocate as concluding whether a subject area was avoidable or not avoidable |
| Select Answers Categorised as Avoidable | This is linked to your selection in the "Select Question Relating To Avoidable/Non Avoidable Death" field It will show all of the answer options for the selected exclusion question. Select all the answers which you want to deem as avoidable |
| Select Answers Categorised as Not Avoidable | This is linked to your selections in "Select Answers Categorised as Avoidable" field. It will show the remaining list of answers which were not selected in the "Select Answers Categorised as Avoidable" and will be automatically selected for you. |
| Select Question Relating to Grade of Care Provided | This will show the list of all scoring questions within the review form(s) selected. Select which scoring question you wish to allocate as indicated whether care given was good or poor |
| Select Answers Relating To Good Care | This is linked to your selection in the"Select Question Relating to Grade of Care Provided" Select which scoring question you wish to allocate as concluding good care was given |
| Select Answers Relating To Less Than Good Care | This is linked to your selections in "Select Answers Relating To Good Care" field. It will show the remaining list of answers which were not selected in the "Select Answers Categorised as Avoidable" and will be automatically selected for you. |
Report Data Explanations All the figures as based on the month in which the death occurred for the review form selected and meeting inclusion question / answer selections | ||||||||
|---|---|---|---|---|---|---|---|---|
Month of Death | Total Number of Reviews | Number of Priority Reviews | Number of Priority Reviews Completed | Total Number of Completed Reviews | Where Death Judged To Be Avoidable | Where Death Judged To be Not Avoidable | Reviews Where Quality of Care Was Graded As Good | Reviews Where Quality of Care Was Graded As Poor |
| After applying the Inclusion criteria....... | ||||||||
The month in which the death occurred (e.g. 2017-06-01 = June 2017) | How many of the selected review forms have been assigned | How many of the Total number of reviews have a priority flag | How many of the reviews with a priority flag have a status of "Complete/Closed" Also expressed as what percentage this is of the total reviews | How many of the Total Number of Reviews have a status of "Complete/Closed" Also expressed as what percentage this is of the total reviews | How many reviews have a status of of "Complete/Closed" and have the answers selected in the "Select Answers Categorised as Avoidable" Also expressed as what percentage this is of total completed reviews | How many reviews have a status of of "Complete/Closed" and have the answers selected in "Select Answers Categorised as Not Avoidable" Also expressed as what percentage this is of total completed reviews | How many reviews have a status of of "Complete/Closed" and have the answers selected in "Select Answers Relating To Good Care" Also expressed as what percentage this is of total completed reviews | How many reviews have a status of of "Complete/Closed" and have the answers selected in the "Select Answers Relating To Less Than Good Care" Also expressed as what percentage this is of total completed reviews |
Example
(Using the same example as that in the original Learning from Deaths report so you can see the difference)
Scenario: I work for Trust 1 and want to run a report to see what level of care all cases with a definite or suspected learning disability received. I want to see the care given for a calendar year basis from month X with a Y review assigned, where the death was avoidable.
My Case Records have the following
| Month of Death | Review Form | Priority Type | Review Status | Did the patient have a learning disability? | Scoring Question - AVOIDABLE DEATH? In your judgement, is there some evidence that the patient's death was avoidable if the problem/s in healthcare had not occurred? | Scoring Question- GOOD CARE? How would you rate the OVERALL quality of healthcare received from this trust? |
|---|---|---|---|---|---|---|
| month X | Y review | Standard | Complete | No learning disability | 6-Definitely preventable | 1-Excellent |
| month X | Y review | Standard | In Progress | No learning disability | 1-Definitely not preventable | 6-Very poor |
| month X | Y review | Priority | Complete | Clear indication of learning disabilities | 4-Probably preventable greater than 50-50 | 2 - Good |
| month X | Y review | Priority | In Progress | No learning disability | 1-Definitely not preventable | 6-Very poor |
To see this I would enter the report criteria as follows:-
| Report Field | Criteria Selected |
|---|---|
| Select Organisation | Trust 1 |
| Select Review Form | Y review |
| Report From | month X |
| Standard or Fiscal Year | Standard |
| Select Inclusion Questions | Did the patient have a learning disability? |
| Select Inclusion Answer Options | Clear indication of learning disabilities Some indication of learning disabilities |
| Select Question Relating To Avoidable/Non Avoidable Death | In your judgement, is there some evidence that the patient's death was avoidable if the problem/s in healthcare had not occurred? |
| Select Answers Categorised as Avoidable | 4-Probably preventable greater than 50-50 5-Strong evidence for preventability 6-Definitely preventable |
| Select Answers Categorised as Not Avoidable | 1-Definitely not preventable 2-Slight evidence for preventability 3-Possibly preventable less than 50-50 |
| Select Question Relating to Grade of Care Provided | How would you rate the OVERALL quality of healthcare received from this trust? |
| Select Answers Relating To Good Care | 1-Excellent 2-Very good 3-Good |
| Select Answers Relating To Less Than Good Care | 4-Adequate 5-Poor 6-Very poor |
This means that the figures in my report will disregard the cases where there was no identified learning difficulties before producing any figures.
My report data would looks as follows (Grey cells are to remind you what the figures are for)
| After applying inclusion criteria | ||||||||
| The month in which the death occurred | How many of the selected review forms have been assigned | How many of the Total number of reviews have a priority flag | How many of the reviews with a priority flag have a status of "Complete/Closed" | How many of the Total Number of Reviews have a status of "Complete/Closed" | How many reviews have a status of of "Complete/Closed" and have the answers selected in the "Select Answers Categorised as Avoidable" | How many reviews have a status of of "Complete/Closed" and have the answers selected in "Select Answers Categorised as Not Avoidable" | How many reviews have a status of of "Complete/Closed" and have the answers selected in "Select Answers Relating To Good Care" | How many reviews have a status of of "Complete/Closed" and have the answers selected in the "Select Answers Relating To Less Than Good Care" |
Month of Death | Total Number of Reviews | Number of Priority Reviews | Number of Priority Reviews Completed | Total Number of Completed Reviews | Where Death Judged To Be Avoidable | Where Death Judged To be Not Avoidable | Reviews Where Quality of Care Was Graded As Good | Reviews Where Quality of Care Was Graded As Poor |
| month X | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 |