This report is designed to enable users to produce a report using the scoring questions.
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 Exclusion Question | 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 you wish to exclude from the report data. If you do not wish to exclude any questions select "No Selection" |
| Select Exclusion Answer Options | This is linked to your selection in the "Select Exclusion Question" field It will show all of the answer options for the selected exclusion question. Select all the answers which confirms they met the exclusion. If you do not wish to exclude any questions select "No Selection" |
| 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 organisation selected minus any reviews meeting exclusion 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 |
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
Scenario: I work for Trust 1 and want to run a report to see what level of care my cases received for a calendar year from month X with a Y review assigned, where the death was avoidable. However, I do not wish to include any cases where there was a definite learning disability
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 Exclusion Question | Did the patient have a learning disability? |
| Select Exclusion Answer Options | Clear 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 case with the learning difficulties before producing any figures.
My report data would looks as follows
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 |
|---|---|---|---|---|---|---|---|---|
| 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 X | 3 (because we have excluded the learning disability case) | 1 | 0 | 1 | 1 | 0 | 1 | 0 |