PV XML to UKRDC RDA XML Mapping

This document shows how the fileds currently in a PV XML file should be mapped in the UKRDC format to allow the sending of the PV data. Besides the changes of structure the coding of tests should be changed to use the AUdit file coding if the test is part of the dataset. If it isn't then the PV test code should still be used.

Below are shown the PV fields not currently in the data set and a list of Audit data set results.

PV Field	RDA Object	RDA XPath	Notes
sequence			Not included in XML, however continue to include in filename.
dateofreport		SendingFacility/@time
flag			Not used. Accounts need to be managed via the PV Website.
centredetails/centrecode	PatientRecord	SendingFacility	Other centredetails fields are not required.
gpdetails/gpname	FamilyDoctor	Patient/FamilyDoctor/GPName	We would prefer just the GPId / GPPracticeId be used if possible.
gpdetails/gpaddress1		Patient/FamilyDoctor/Address/Street
gpdetails/gpaddress2		N/A
gpdetails/gpaddress3		N/A
gpdetails/gppostcode		Patient/FamilyDoctor/Address/Postcode
gpdetails/gptelephone		Patient/FamilyDoctor/ContactDetails/ContactDetail/Value = Value Patient/FamilyDoctor/ContactDetails/ContactDetail/@use = 'WPN'
gpdetails/gpemail		Patient/FamilyDoctor/ContactDetails/ContactDetail/Value = Value Patient/FamilyDoctor/ContactDetails/ContactDetail/@use = 'NET'
personaldetails/surname	Name	Patient/Names/Name/Family
/personaldetails/forename	Name	Patient/Names/Name/Given
/personaldetails/dateofbirth	Patient	Patient/BirthTime
/personaldetails/sex	Patient	Patient/Gender	This field may need converting from M/F to 1/2 etc.
/personaldetails/nhsno		Patient/PatientNumbers/Number/ = Value Patient/PatientNumbers/Organization = NHS/CHI/H&SC Patient/PatientNumbers/NumberType/ = 'NI'	The Organization field will need to be calculated based on the number range.
/personaldetails/ethnicorigin or /personaldetails/ethnicorig		Patient/EthnicGroup
/personaldetails/hospitalnumber		Patient/PatientNumbers/Number/ = Value Patient/PatientNumbers/Organization/ = centrecode Patient/PatientNumbers/NumberType/ = "MRN"	If no Local Hospital Number exists you should submit the NHS Number as the MRN with the Organization as NI/CHI/H&SC.
/personaldetails/address1		Patient/Addresses/Address/Street
/personaldetails/address2		N/A
/personaldetails/address3		N/A
/personaldetails/address4		N/A
/personaldetails/postcode		Patient/Addresses/Address/PostCode
/personaldetails/telephone1		Patient/ContactDetails/ContactDetail/Value = Value
/personaldetails/telephone2		Patient/ContactDetails/ContactDetail/Value = Value
/personaldetails/mobile		Patient/ContactDetails/ContactDetail/Value = Value Patient/ContactDetails/ContactDetail/@user = 'PRS'
/clinicaldetails/rrtstatus		PVData/rrtstatus
/clinicaldetails/tpstatus		PVData/tpstatus
/clinicaldetails/diagnosisedta		Diagnoses/RenalDiagnosis/Code = Value
/clinicaldetails/diagnosis		Diagnoses/Diagnosis/Code = Value	There can be multiple diagnosis records.
/testdetails/test/testname		LabOrders/LabOrder/ResultItems/ResultItem/ServiceId/Description
/testdetails/test/testcode		LabOrders/LabOrder/ResultItems/ResultItem/ServiceId/Code
/testdetails/test/units		LabOrders/LabOrder/ResultItems/ResultItem/ResultValueUnits
/testdetails/test/daterange		LabOrders/@start LabOrders/@stop
/testdetails/test/result/datestamp		LabOrders/LabOrder/ResultItems/ResultItem/ObservationTime	There can be multiple result records
/testdetails/test/result/prepost		LabOrders/LabOrder/ResultItems/ResultItem/PrePost
/testdetails/test/result/value		LabOrders/LabOrder/ResultItems/ResultItem/ResultValue
/drugdetails/drug/drugstartdate		Medications/Medication/FromTime	There can be multiple drug records
/drugdetails/drug/drugname		Medications/Medication/DrugProduct/LabelName
/drugdetails/drug/drugdose		Medications/Medication/DoseQuantity
/letterdetails/letter/letterdate		Documents/Document/DocumentTime	There can be multiple letter records
/letterdetails/letter/lettertype		Documents/Document/DocumentName
/letterdetails/letter/lettercontent		Documents/Document/NoteText

PV Codes

These are tests which are supported by PatientView or RaDaR but do not form part of the UKRR Dataset.

Units are as stated on the PV website.

PV Description	PV Units	Coding Standard	Code	UKRDC Element
Glucose Random	mmol/l	PV	glucose	Result
International Normalised Ratio (Blood Clotting)	ratio	PV	inr	Result
Bilirubin (Liver Test)	umol/l	PV	bili	Result
AST (Liver Test)	U/l	PV	ast	Result
GGT (Liver Test)	U/l	PV	ggt	Result
Iron Saturation	%	PV	ironsat	Result
Iron	mmol/l	PV	iron	Result
Body Mass Index		PV	bmi	Observation
Faecal Calprotectin		PV	FaecalCalprotectin	Result
Magnesim	mmol/l	PV	magnesium	Result
LDL:HDL Ratio	ratio	PV	lhratio	Result
Matrix MetalloProteinase		PV	mmp	Result
Pulse	bpm	PV	pulse	Observation
Total Thyroxine	ng/l	PV	t4	Result
TGN		PV	tgn	Result
TPMT	mU/l	PV	tpmt	Result
Phenylalanine (for PKU)	mg/dl	PV	phepku	Result
Reticulocyte Haemoglobin	pg	PV	ret-he	Result
Albumin in Urine	mg/l	PV	ualbumin	Result
Creatinine in Urine	mmol/l	PV	ucreatinine	Result
Protein in Urine	mmol/l	PV	uprotein	Result
Amylase (serum)	U/l	PV	amy	Result
Prostate Specific Antigen	ng/ml	PV	psa	Result
Troponin-T	ng/ml	PV	trop	Result
Covid 19 PCR		PV	covid19pcr	Result
Covid 19 Antibody		PV	covid19antibody	Result
Covid 19 Lateral Flow		PV	covid19lflow	Result

Common Dataset Entries

Most common Data Items required for the UKRDC data Feed. This is not a definitive list. For a In the UKRDC feed any PV test below should be sent using the Code shown.

UKRR Description	UKRR Units	Coding Standard	Code	UKRDC Element
Patient Blood Group ABO		N/A	N/A	Patient/BloodGroup
Patient Blood Group Rhesus		N/A	N/A	Patient/BloodRhesus
Serum Creatinine	micro mol/L	UKRR	QBLA1	Result
Serum Urea	mmol/L	UKRR	QBLA3	Result
Serum Bicarbonate	mmol/L	UKRR	QBLA4	Result
Serum Sodium	mmol/L	UKRR	QBLA6	Result
Serum Potassium	mmol/L	UKRR	QBLA9	Result
Lab Calculated eGFR	ml/min/1.73m2	UKRR	QBLAB	Result
Serum Uric Acid (Urate)	mmol/L	UKRR	QBLAC	Result
Unit Calculated eGFR	ml/min/1.73m2	UKRR	QBLAL	Result
Serum Phosphate	mmol/L	UKRR	QBLB1	Result
Serum Calcium	mmol/L	UKRR	QBLB3	Result
Corrected Serum Calcium	mmol/L	UKRR	QBLB4	Result
Serum Alkaline Phosphatase	IU/L	UKRR	QBLB5	Result
Serum Albumin	g/L	UKRR	QBLB7	Result
Serum Parathyroid Hormone (PTH)	pmol/L	UKRR	QBLB9	Result
Urine Protein:Creatinine Ratio		UKRR	QBLC1	Result
Urine Albumin:Creatinine Ratio		UKRR	QBLC3	Result
Total Serium Cholesterol	mmol/L	UKRR	QBLD1	Result
Serum HDL Cholesterol	mmol/L	UKRR	QBLD3	Result
Serum LDL Cholesterol	mmol/L	UKRR	QBLD4	Result
Serum Triglycerides	mmol/L	UKRR	QBLD5	Result
CRP	mg/L	UKRR	QBLD6	Result
Hba1c %	%	UKRR	QBLD8	Result
Hba1c	mmol/mol	UKRR	QBLDA	Result
Haemoglobin	g/dL	UKRR	QBLE1	Result
Haemoglobin	g/L	UKRR	QBLEB	Result
MCH	g/dL	UKRR	QBLE3	Result
Platelets	x 10^9/L	UKRR	QBLE4	Result
WBC (from full blood count)	x 10^9/L	UKRR	QBLE5	Result
Serum Ferritin	micro g/L = ng/ml	UKRR	QBLF1	Result
Transferrin Saturation	%	UKRR	QBLF3	Result
Percentage of Hypochromic Cells	%	UKRR	QBLF5	Result
Serum B12	ng/L	UKRR	QBLF7	Result
Serum Folate	micro g/L	UKRR	QBLF9	Result
Red Cell Folate	micro g/L	UKRR	QBLFB	Result
Serum Aluminium	micro mol/L	UKRR	QBLFD	Result
Tacrolimus Blood Concentration Level	ng/mL	UKRR	QBLFF	Result
Sirolimus Blood Concentration Level	ng/mL	UKRR	QBLFH	Result
Ciclosporin Blood Concentration Level	ng/mL	UKRR	QBLFK	Result
Mycophenolate Blood Concentration Level	ng/mL	UKRR	QBLFM	Result
Weight	kg	UKRR	QBLG1	Observation
Systolic BP	mmHg	UKRR	QBLG3	Observation
Diastolic BP	mmHg	UKRR	QBLG4	Observation
Urea Reduction Ratio	%	UKRR	QBLG9	Result
Kt/V		UKRR	QBLGG	Result
Height	cm	UKRR	QBLGB	Observation
HBV Antibody Status	NEG/POS/UNK	UKRR	QBLHA	Result/InterpretationCode
HBV Surface Antigen Status	NEG/POS/UNK	UKRR	QBLHC	Result/InterpretatonCode
HCV Antibody Status	NEG/POS/UNK	UKRR	QBLHE	Result/InterpretationCode
CMV Antibody Status	NEG/POS/UNK	UKRR	QBLHG	Result/InterpretationCode
CMV PCR Copies/ML		UKRR	QBLHK	Result
HIV Antigen Status	NEG/POS/UNK	UKRR	QBLHM	Result/InterpretationCode
Varicella	NEG/POS/UNK	UKRR	QBLHN	Result/InterpretationCode
EBV Status	NEG/POS/UNK	UKRR	QBLHR	Result/InterpretationCode
EBV Log Count		UKRR	QBLHS	Result
Urine Volume in 24 Hours	ml	UKRR	QBLHV	Observation
Urinary Creatinine Excreation	mmol/L	UKRR	QBLHX	Result
PTH ULN	pmol/L	UKRR	QBLPA	Result
PTH / PTHH ULN Ratio		UKRR	QBLPB	Result
ALT (Alanine aminotransferase)	IU/L	UKRR	QBLPC	Result
ANC (Absolute Neutrophil count)	x 10^9/L	UKRR	QBLPD	Result
ALC (Lymphocytes)	x 10^9/L	UKRR	QBLPE	Result