| PV Field |
|---|
| Mapping | RDA Object | RDA XPath |
|---|
| Notes | PV DB Table | PV DB "Field" | ||||
|---|---|---|---|---|---|---|
| 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. | practitioner | (((practitioner.content -> 'name'::text) -> 'family'::text) ->> 0) |
| gpdetails/gpaddress1 |
| Patient/FamilyDoctor/Address/Street | practitioner | (((practitioner.content -> 'address'::text) -> 'line'::text) ->> 0) |
| gpdetails/gpaddress2 |
| N/A | practitioner | (((practitioner.content -> 'address'::text) -> 'city'::text) ->> 0) |
| gpdetails/gpaddress3 |
| N/A | |||||
| gpdetails/gppostcode |
| Patient/FamilyDoctor/Address/Postcode | practitioner | (((practitioner.content -> 'address'::text) -> 'zip'::text) ->> 0) |
| gpdetails/gptelephone |
Patient/FamilyDoctor/ContactDetails/ContactDetail/Value = Value Patient/FamilyDoctor/ContactDetails/ContactDetail/@use = 'WPN' | practitioner | (practitioner.content -> 'telecom'::text) This is a list. |
| gpdetails/gpemail |
Patient/FamilyDoctor/ContactDetails/ContactDetail/Value = Value Patient/FamilyDoctor/ContactDetails/ContactDetail/@use = 'NET' | practitioner | (practitioner.content -> 'telecom'::text) This is a list |
| personaldetails/surname | Name |
| Patient/Names/Name/Family | patient | ((((patient.content -> 'name'::text) -> 0) -> 'family'::text) ->> 0) | |
| /personaldetails/forename | Name |
| Patient/Names/Name/Given | patient | ((((patient.content -> 'name'::text) -> 0) -> 'given'::text) ->> 0) | |
| /personaldetails/dateofbirth | Patient |
| Patient/BirthTime | patient | (patient.content ->> 'birthDate'::text) | |
| /personaldetails/sex | Patient |
| Patient/Gender | This field may need converting from M/F to 1/2 etc. | patient | (((patient.content -> 'gender'::text) ->> 'text'::text)) |
| /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. | patient | (patient.content -> 'identifier'::text) This is a list. |
/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. | patient | (patient.content -> 'identifier'::text) This is a list. |
| /personaldetails/address1 |
| Patient/Addresses/Address/Street | patient | ((((patient.content -> 'address'::text) -> 0) -> 'line'::text) ->> 0) | ||||
/personaldetails/address2 | N/A | patient | ((((patient.content -> 'address'::text) -> 0) -> 'city'::text) ->> 0) | |||
| /personaldetails/address3 | N/A | |||||
| /personaldetails/address4 | N/A | |||||
| /personaldetails/postcode |
| Patient/Addresses/Address/PostCode | patient | ((((patient.content -> 'address'::text) -> 0) -> 'zip'::text) ->> 0) | |||
| /personaldetails/telephone1 |
| Patient/ContactDetails/ContactDetail/Value = Value | patient | (((patient.content -> 'contact'::text) -> 0) -> 'telecom'::text) This is a list. | |||
| /personaldetails/telephone2 |
| Patient/ContactDetails/ContactDetail/Value = Value | patient | (((patient.content -> 'contact'::text) -> 0) -> 'telecom'::text) This is a list. | |||
| /personaldetails/mobile |
Patient/ContactDetails/ContactDetail/Value = Value Patient/ContactDetails/ContactDetail/@user = 'PRS' | patient | (((patient.content -> 'contact'::text) -> 0) -> 'telecom'::text) This is a list. | |||
| /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 |