This report is designed to enable users to produce a report using the scoring questions.
...
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 are 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 |
| After applying Exclusion 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 |
...
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
...
(Grey cells are to remind you what the figures are for)
| After applying the 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 | 3 (because we have excluded the learning disability case) | 1 | 0 | 1 | 1 | 0 | 1 | 0 |
...