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 FieldMappingRDA ObjectRDA XPathNotes
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
PatientRecordSendingFacilityOther centredetails fields are not required.
gpdetails/gpname
FamilyDoctorPatient/FamilyDoctor/GPNameWe 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
NamePatient/Names/Name/Family
/personaldetails/forename
NamePatient/Names/Name/Given
/personaldetails/dateofbirth
PatientPatient/BirthTime
/personaldetails/sex
PatientPatient/GenderThis 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 = ValueThere 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/ObservationTimeThere 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/FromTimeThere can be multiple drug records
/drugdetails/drug/drugname

Medications/Medication/DrugProduct/LabelName
/drugdetails/drug/drugdose

Medications/Medication/DoseQuantity
/letterdetails/letter/letterdate

Documents/Document/DocumentTimeThere 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 Randommmol/lPVglucoseResult
International Normalised Ratio (Blood Clotting)ratioPVinrResult

Bilirubin (Liver Test)

umol/lPVbiliResult
AST (Liver Test)U/lPVastResult
GGT (Liver Test)U/lPVggtResult
Iron Saturation%PVironsatResult
Ironmmol/lPVironResult

Body Mass Index


PVbmiObservation
Faecal Calprotectin
PVFaecalCalprotectinResult
Magnesimmmol/lPVmagnesiumResult
LDL:HDL RatioratioPVlhratioResult
Matrix MetalloProteinase
PVmmpResult

Pulse

bpmPVpulseObservation
Total Thyroxineng/lPVt4Result
TGN
PVtgnResult

TPMT

mU/lPVtpmtResult
Phenylalanine (for PKU)mg/dlPVphepkuResult
Reticulocyte HaemoglobinpgPVret-heResult
Albumin in Urinemg/lPVualbuminResult

Creatinine in Urine

mmol/lPVucreatinineResult
Protein in Urinemmol/lPVuproteinResult
Amylase (serum)U/lPVamyResult
Prostate Specific Antigen

ng/ml

PVpsaResult
Troponin-Tng/mlPVtropResult
Covid 19 PCR
PVcovid19pcrResult
Covid 19 Antibody
PVcovid19antibodyResult
Covid 19 Lateral Flow
PVcovid19lflowResult

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/AN/APatient/BloodGroup
Patient Blood Group Rhesus
N/AN/APatient/BloodRhesus
Serum Creatininemicro mol/LUKRRQBLA1Result
Serum Ureammol/LUKRRQBLA3Result
Serum Bicarbonatemmol/LUKRRQBLA4Result
Serum Sodiummmol/LUKRRQBLA6Result
Serum Potassiummmol/LUKRRQBLA9Result
Lab Calculated eGFRml/min/1.73m2UKRRQBLABResult
Serum Uric Acid (Urate)mmol/LUKRRQBLACResult
Unit Calculated eGFRml/min/1.73m2UKRRQBLALResult
Serum Phosphatemmol/LUKRRQBLB1Result
Serum Calciummmol/LUKRRQBLB3Result
Corrected Serum Calciummmol/LUKRRQBLB4Result
Serum Alkaline PhosphataseIU/LUKRRQBLB5Result
Serum Albuming/LUKRRQBLB7Result
Serum Parathyroid Hormone (PTH)pmol/LUKRRQBLB9Result
Urine Protein:Creatinine Ratio
UKRRQBLC1Result
Urine Albumin:Creatinine Ratio
UKRRQBLC3Result
Total Serium Cholesterolmmol/LUKRRQBLD1Result
Serum HDL Cholesterolmmol/LUKRRQBLD3Result
Serum LDL Cholesterolmmol/LUKRRQBLD4Result
Serum Triglyceridesmmol/LUKRRQBLD5Result
CRPmg/LUKRRQBLD6Result
Hba1c %%UKRRQBLD8Result
Hba1cmmol/molUKRRQBLDAResult
Haemoglobing/dLUKRRQBLE1Result
Haemoglobing/LUKRRQBLEBResult
MCHg/dLUKRRQBLE3

Result

Plateletsx 10^9/LUKRRQBLE4Result
WBC (from full blood count)x 10^9/LUKRRQBLE5Result
Serum Ferritinmicro g/L = ng/mlUKRRQBLF1Result
Transferrin Saturation%UKRRQBLF3Result
Percentage of Hypochromic Cells%UKRRQBLF5Result
Serum B12ng/LUKRRQBLF7

Result

Serum Folatemicro g/LUKRRQBLF9Result
Red Cell Folatemicro g/LUKRRQBLFBResult
Serum Aluminiummicro mol/LUKRRQBLFDResult
Tacrolimus Blood Concentration Levelng/mLUKRRQBLFFResult
Sirolimus Blood Concentration Levelng/mLUKRRQBLFHResult
Ciclosporin Blood Concentration Levelng/mLUKRRQBLFKResult
Mycophenolate Blood Concentration Levelng/mLUKRRQBLFMResult
WeightkgUKRRQBLG1Observation
Systolic BPmmHgUKRRQBLG3Observation
Diastolic BPmmHgUKRRQBLG4Observation
Urea Reduction Ratio%UKRRQBLG9Result
Kt/V
UKRRQBLGGResult
HeightcmUKRRQBLGBObservation
HBV Antibody StatusNEG/POS/UNKUKRRQBLHAResult/InterpretationCode
HBV Surface Antigen StatusNEG/POS/UNKUKRRQBLHCResult/InterpretatonCode
HCV Antibody StatusNEG/POS/UNKUKRRQBLHEResult/InterpretationCode
CMV Antibody StatusNEG/POS/UNKUKRRQBLHGResult/InterpretationCode
CMV PCR Copies/ML
UKRRQBLHKResult
HIV Antigen StatusNEG/POS/UNKUKRRQBLHMResult/InterpretationCode
VaricellaNEG/POS/UNKUKRRQBLHNResult/InterpretationCode
EBV StatusNEG/POS/UNKUKRRQBLHRResult/InterpretationCode
EBV Log Count
UKRRQBLHSResult
Urine Volume in 24 HoursmlUKRRQBLHVObservation
Urinary Creatinine Excreationmmol/LUKRRQBLHXResult
PTH ULNpmol/LUKRRQBLPAResult
PTH / PTHH ULN Ratio
UKRRQBLPBResult
ALT (Alanine aminotransferase)IU/LUKRRQBLPCResult
ANC (Absolute Neutrophil count)x 10^9/LUKRRQBLPDResult
ALC (Lymphocytes)x 10^9/LUKRRQBLPEResult