Description
Transplant First is a project being run by KQUIP to collect information about whether a patient has been put on the transplant waiting list and if not the reasons why.
Data is currently being collected from a small number of units using Excel workbooks. While the data is patient level it is not patient identifiable.
The project wishes to rollout the collection to all English units. This will require a change in how the data is collected.
Further background and details https://www.thinkkidneys.nhs.uk/kquip/transplant-first/
Codebase
https://bitbucket.renalregistry.nhs.uk/projects/MISC/repos/transplantfirst.renalreg.org/browse
All the instructions how to start developing and deployment are there in the readme file.
Charts description
The site renders 2 types of charts (Dialysis Starter Charts and Transplant Listing Charts) based on the data extracted from the ER model illustrated here.
DIALYSIS STARTER CHARTS (view: edd-charts)
Dialysis starters data (Graph1)
Each percentage bar chart shows the percentage of items in dashboarddata by list_status (no_decision, working_up, active, unsuitable, suspended) at a quarter for the selected unit.
e.g. Preston at Q1 2018 proportion of list_status = "working_up"
select count(*) as count1 from txfirst_dashboarddata where unit_id = 4 and list_status = "working_up" and quarter_id=2 / select count(*) as count1 from txfirst_dashboarddata where unit_id = 4 and quarter_id=2 * 100 -> 7 / 26 * 100 = 26.92%
Patients who are still being “Working up or under discussion” (Graph2)
This graph presents a line graph per unit, where all units belong to the same region. It also includes a line graph for the region. Each point of a line graph represents the percentage of items in dashboarddata per unit, per quarter_id and list_status=”working_up'” over all dashboarddata items for all list_status and indicated unit, quarter_id (count of txfirst_dashboarddata records per list_status=” working_up”, unit and quarter_id / count of txfirst_dashboarddata records of all list_status per quarter_id and unit * 100)
Example for unit Preston at Q1 2018 proportion of list_status = "working_up"
select count(*) as count1 from txfirst_dashboarddata where unit_id = 4 and list_status = "working_up" and quarter_id = 2 / select count(*) as count1 from txfirst_dashboarddata where unit_id = 4 and quarter_id = 2 * 100 7 / 26 * 100 = 26.92%
Each point of the region line graph in the code is computed as region_count / region_total_count * 100, which is equivalent to the following query:
Example for region North West at Q1 2020 and list_status = “working_up”
select count(*) from txfirst_dashboarddata left join users_unit on unit_id = users_unit.id where region_id = 3 and list_status = "working_up" and quarter_id=17 / select count(*) from txfirst_dashboarddata left join users_unit on unit_id = users_unit.id where region_id = 3 and quarter_id=17 * 100 15 / 54 * 100 = 27.78%
Release
It is running on UKRR web server under txfirst account (together with magic project).
URL: https://transplantfirst.renalreg.org
Start Date
Length
Who
KQUIP