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 |