Contact

Doug Gould <Doug.Gould@icnarc.org>

Running

Install sql_runner -https://bitbucket.renalregistry.nhs.uk/projects/RR/repos/sql_runner/browse

Run:

Definition

All patients extracted are restricted to those who were successfully matched and held in inserted into the STUDY_PATIENTS table. The original cohort was "for all patients with ERF diagnosed at anytime up to 31 March 2017 and alive at 1 April 2009".

...

NB: There is a new field in the STUDY_PATIENTS for the match score that was returned by NHS Digital should it be required in futue.

"ESRF"

Fields:

• EDTA_DISEASE_CODE

• EDTA_NEW_DISEASE_CODE

• SECONDARY_DISEASE_CODE

• PRIMARY_DISEASE_TEXT

From ESRF block for all study patients. A patient may have multiple rows if they have attended multiple renal units.

"Haemodialysis Session"

Fields:

• HD_SESSION_DATE
• SESSION_TYPE

For all study patients. Note that we default the session type to "HD" if it is not submitted. This would include all records prior to 2015 where we weren't officially collecting Plasma Exchange sessions.

"Patient"

Fields:

• FIRST_SEEN_DATE
• FIRST_EVER_RRT_MODALITY
• FIRST_EVER_RRT_DATE
• DATE_DEATH
• COD_EDTA1
• COD_EDTA2
• COD_TEXT

The First Ever RRT fields are taken from the earliest Treatment (TXT) record where the modality was one we group as RRT. This should only include dialysis for the purposes of chronic care provided that the site is using the correct codes.

"Transplants"

Fields:

• TRANSPLANT_DATE
• TRANSPLANT_ID
• TRANSPLANT_TYPE

Where TRANSPLANT_DATE is not NULL (i.e. a transplant has happened and it's not just a waiting list entry). Because sites are not submitting the new TRA block this has had to be done from the NHSBT data to obtain the TRANSPLANT_ID. Were this not required it could also be done from the Treamtent (TXT) records albeit with less information about Transplant Type.