Page Comparison

...

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.

• 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.
• Green is when all four fields are present on 95% or more of all entries for the 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 ).

Image Added

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.If any of the cells from column 13 onwards (the date ones) aren't actually blank but instead contain spaces the process will crash. There is a ticket

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 2^nd 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.

...