PV FieldMappingRDA ObjectRDA XPathNotesPV DB TablePV 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
PatientRecordSendingFacilityOther centredetails fields are not required.

gpdetails/gpname
FamilyDoctorPatient/FamilyDoctor/GPNameWe 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
NamePatient/Names/Name/Family
patient((((patient.content -> 'name'::text) -> 0) -> 'family'::text) ->> 0)
/personaldetails/forename
NamePatient/Names/Name/Given
patient((((patient.content -> 'name'::text) -> 0) -> 'given'::text) ->> 0)
/personaldetails/dateofbirth
PatientPatient/BirthTime
patient(patient.content ->> 'birthDate'::text)
/personaldetails/sex
PatientPatient/GenderThis 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 = 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