...
Data
...
Exchange
This will
...
be
...
Clinical Data
...
returned in RDA format one file per patient, integrating data from a number of sources as described below. A sample file was sent to the SIMPLIFIED project a couple of months ago and confirmed suitable but it should be noted that the schema may have changed slightly since then and any code already written reviewed. The schema can be found at https://github.com/renalreg/ukrdc .
...
Data
...
Info |
---|
This data is only available after it has been processed by the UKRR Data Managers which happens approximately 12-18 months after the activity has happened. |
...
Set
...
Requested Data | Source Item | Description | RDA |
---|
Item | Source | |||
---|---|---|---|---|
Identifiers – NHS number or equivalent | NHS Number | PatientNumber | SIMPLIFIED / PDS | |
Surname | Family | SIMPLIFIED | ||
Forename | Given | |||
DOB | BirthTime | |||
Sex | Gender | |||
RRT Modality (full history) | TXT00 | Date Treatment Started | FromTime | UKRR |
TXT01 | Date Treatment Ended | ToTime | ||
TXT02 | Treatment Modality (Code) | AdmitReason (what treatment they will receive) or DischargeReason (why they ceased treatment) | ||
TXT04 | Reason for Treatment Change | DischargeReason |
TXTZ0 | Hospital Center | SendingFacility |
TXT20 | Treatment |
Centre | HealthCareFacility |
TXT40 | Where they were previously | AdmissionSource |
TXT41 | Transfer |
NHS Blood & Transplant Data
Out To | DischargeLocation | |||
Transplant List Status | ||||
| REGISTRATION_ID | EncounterNumber | NHS B&T | |
REGISTRATION_DATE | FromTime | |||
REGISTRATION_END_DATE | ToTime | |||
TRANSPLANT_CONSIDERATION | Kidney / Kidney + Pancreas etc | AdmitReason | ||
REGISTRATION_END_STATUS | DischargeReason | |||
| 70536003 (SNOMED Code) | Renal Transplantation | ProcedureType | |
TRANSPLANT_DATE | ProcedureTime | |||
UKT_FAIL_DATE | Attributes/TRA64 | |||
Medications Vitamin D preparations
Phosphate binders Statins Ezetimibe ACE inhibitors Angiotensin Receptor Antagonists Mineralocorticoid Receptor Blocker Beta Blocker | drugstartdate | FromTIme | PV XML | |
drugname | DrugProduct/Generic | |||
drugdose | Comment | |||
Results / Observations | datestamp | ObservationTime | PV XML | |
prepost | PrePost | |||
value | ResultValue or ObservationValue | |||
testcode | ServiceId or ObservationCode | |||
PV Code | Description | RDA Type | ||
pth | Parathyroid Hormone | Result | ||
adjustedcalcium | Corrected Calcium | Result | ||
phosphate | Phosphate | Result | ||
potassium | Potassium | Result | ||
urr | Urea Reduction Ratio | Result | ||
ktv | Kt/V | Result | ||
hb | Haemoglobin | Result | ||
albumin | Albumin | Result | ||
sodium | Sodium | Result | ||
alp | Alkaline Phosphatase | Result | ||
vitd | 25-Hydroxyvitamin D | Result | ||
bpsys | Systolic Blood Pressure | Observation | ||
bpdia | Diastolic Blood Pressure | Observation |
Data Source Notes
Data Source | Data Type | Notes |
---|---|---|
UKRR | This data is only available after it has been processed by the UKRR Data Managers which happens approximately 12-18 months after the activity has happened. | |
NHS B&T | This data is received by the UKRR approximatley 6 months after the activity in the extract happened. Periods of Wait Listing / Transplantation will be recorded as Transplant Listing Elements. The actual Transplants will be recorded as Transplant Procedure Elements. Note that REGISTRATION_END_DATE doesn't seem to be well populated. There may be something we can do where we use the TRANSPLANT_DATE instead. |
Transplant Listing
...
Transplant Procedure
...
70536003 (SNOMED Code)
...
PatientView Feed Data
...
PV XML | PatientView data is received daily by the UKRDC for Patients who have been enrolled in PatientView. This must have happened for the SIMPLIFIED patients in order for their data to be available. | |
Medications |
...
There are a number of caveats around the Medication Data -
|
...
...
Vitamin D preparations:
- Alfacalcidol
- Paricalcitol
- Ergocalciferol
Phosphate binders
Statins
Ezetimibe
ACE inhibitors
Angiotensin Receptor Antagonists
Mineralocorticoid Receptor Blocker
Beta Blocker
Results/Observations |
...
There are some caveats around PV Results/Observations
|
...
SIMPLIFIED Requested Result/Observation | PV Code |
---|---|
Parathyroid Hormone | pth |
Corrected Calcium | adjustedcalcium |
Phosphate | phosphate |
Potassium | potassium |
Urea Reduction Ratio | urr |
Kt/V | ktv |
Haemoglobin | hb |
Albumin | albumin |
Sodium | sodium |
Alkaline Phosphatase | alp |
25-Hydroxyvitamin D | vitd |
Systolic Blood Pressure | bpsys |
Diastolic Blood Pressure | bpdia