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. Red - when more than 5% of all entries for the month are missing all of the following fields: nhs number, date of birth, gender and post code. Amber - when more than 5% of all entries for the month are missing one or more, but not all of those four fields mentioned with Red. And finally Green is when all four fields are present on 95% or more of all entries for the month.
Report is triggered by email from one of the Data managers (atm mostly from SE) asking to run the report and giving the path to locked AKI progress excel spreadsheet.
Details
To run the report, one needs to clone aki_validation repository, install all the requirements and run scripts/akiload.py script. There there is a menu under utils called generate RAG report. 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].