PKB Indicator Report
- George Swinnerton
- Gleb Rysev
- Andre Ortega Alban
With PV there was a measure for how many people at each unit on RRT were enrolled, and of those how many had used it in the last three months. We needed to replicate that process in PKB.
The report is run at the end of each quarter (31st March, 30th June, 31st September, 31st December) and the report from PKB used needs to be the one which was run as close as possible to that date.
Getting the Reports
There should be an automated process for this but for now ask Michael to download from the SFTP server the latest lot of files to Q:\PKB\Indicator\Input. The SFTP server is sftp.ukrdc.org and the files are in /data/filetransfers/PKB/incoming/
There will be a lot of daily zip files. Find the one you want and unzip it - you will be prompted for a password which is found in KeyPass under the pkb section in Indicator Report Zip Files.
Setting up the Report Environment
The report script is found in the scripts folder under pkb_services.
[I suspect the same environment used for pkbdump would work here but more details would be nice.]
Configuring the Report Script
Amend the lines:
INPUT_FILE = "Q:/PKB/Indicator/Input/fd127355.csv"
OUTPUT_FILE = "C:/Temp/PKB_Report_Q2.csv"
BHLY_OUTPUT_FILE = "C:/Temp/BHLY_PKB_Report_Q2.csv"
BRISTOL_OUTPUT_FILE = "C:/Temp/BRISTOL_PKB_Report_Q2.csv"to point at the new input CSV file and adjust the quarter number in the output filenames.
Running the Report and Output
The script doesn’t take any parameters so just run it.
It will establish a connection to the UKRDC database to obtain information about which units the patients belong to (based on which unit(s) we have recieved files for them from) and their modality. This will be combined with the information from the input CSV file.
The main report file should be put in a folder under Q:\PKB\Indicator\Output by Year then Quarter. Tell Retha where it is.
The BHLY report should be e-mailed securely to leedsth-tr.renalreportingresearch@nhs.net (shared email for daniele.trinca@nhs.net and elizabeth.lindley@nhs.net).
The Bristol report can be ignored.