Monthly AKI Lab RAG report

Owned by rapolas (Unlicensed)
Last updated: Apr 02, 2019 by George Swinnerton
2 min read

Description

Every month AKI Lab submission completion report is put online. RAG stands for Red/Amber/Green. This report looks at the lab submissions and reports back how much missing data they do not submit. Fields that are looked at are: NHS number, date of birth, aki warning test result, gender, and postcode.

  • Green is when mentioned fields are completely filled for the 90% of the rows for the given month.
  • Amber, is when mentioned fields are all filled between 50% and 90% of all the rows for the given month.
  • Red is when mentioned fields are all filled less than 50% of all the rows for the given month.

Report is triggered by email from one of the Data managers (atm mostly from NH/SE) asking to run the report and giving the path to locked AKI progress excel spreadsheet. Data managers should be able to make this report themselves.

Running

Run the usual AKI Validation Program ( R:\Registry_Utils\AKILoad ).

Click on the Menu Item "Generate RAG Report" under the "Utils" menu in the App.

That will produce the excel file which needs to be sent back to asking data manager. Normally, just put somewhere under Q:\AKI folder and send back a path to it.

Technical notes

In general, data managers could do this themselves, however the script is a bit fragile and it is not currently released. One assumption it does, that the report needs to be run for "current month - 2". Meaning, that if I run it, for example, on 2nd of May, it will make report for all months up to and including March. Given that I (RK) had no problems running it for more than half a year, it is probably safe to release and allow data managers to run it.

Updates

Sometimes data managers asks to modify/add/remove which lab is submitting for which data. There are two mappings at the top of aki/report.py script. Both need to be modified at the same time, SUBMITTED_BY defines "lab that is not submitting": "lab which is submitting for it", and ALSO_SUBMITS_FOR defines: "lab that is submitting for": [list of labs that the key part is submitting data for].