UKRDC Dataset
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 | Mapping | 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 |
| SendingFacility | Other centredetails fields are not required. | |
gpdetails/gpname |
| 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 |
| Patient/Names/Name/Family |
| |
/personaldetails/forename |
| Patient/Names/Name/Given |
| |
/personaldetails/dateofbirth |
| Patient/BirthTime |
| |
/personaldetails/sex |
| 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 |