PV XML to RDA XML Mapping

PV Field	RDA Object	RDA XPath	Notes	PV DB Table	PV DB "Field"
/centredetails/centrecode	PatientRecord	/PatientRecord/SendingFacility
/gpdetails/gpname	FamilyDoctor	/PatientRecord/Patient/FamilyDoctor/GPName		practitioner	(((practitioner.content -> 'name'::text) -> 'family'::text) ->> 0)
/gpdetails/gpaddress1		/PatientRecord/Patient/FamilyDoctor/Address/Street		practitioner	(((practitioner.content -> 'address'::text) -> 'line'::text) ->> 0)
/gpdetails/gpaddress2		???		practitioner	(((practitioner.content -> 'address'::text) -> 'city'::text) ->> 0)
/gpdetails/gpaddress3		???
/gpdetails/gppostcode		/PatientRecord/Patient/FamilyDoctor/Address/Postcode		practitioner	(((practitioner.content -> 'address'::text) -> 'zip'::text) ->> 0)
/gpdetails/gptelephone		???		practitioner	(practitioner.content -> 'telecom'::text) This is a list.
/gpdetails/gpemail		???		practitioner	(practitioner.content -> 'telecom'::text) This is a list
/personaldetails/surname	Name	/PatientRecord/Patient/Names/Name/Family		patient	((((patient.content -> 'name'::text) -> 0) -> 'family'::text) ->> 0)
/personaldetails/forename	Name	/PatientRecord/Patient/Names/Name/Given		patient	((((patient.content -> 'name'::text) -> 0) -> 'given'::text) ->> 0)
/personaldetails/dateofbirth	Patient	/PatientRecord/Patient/BirthTime		patient	(patient.content ->> 'birthDate'::text)
/personaldetails/sex	Patient	/PatientRecord/Patient/Gender	This field may need converting from M/F to 1/2 etc.	patient	(((patient.content -> 'gender'::text) ->> 'text'::text))
/personaldetails/nhsno		/PatientRecord/Patient/PatientNumbers/Number/ = Value /PatientRecord/Patient/PatientNumbers/Organization = NHS/CHI/H&SC /PatientRecord/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		/PatientRecord/Patient/EthnicGroup		???	???
/personaldetails/hospitalnumber		/PatientRecord/Patient/PatientNumbers/Number/ = Value /PatientRecord/Patient/PatientNumbers/Organization/ = centrecode /PatientRecord/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		/PatientRecord/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		/PatientRecord/Patient/Addresses/Address/PostCode		patient	((((patient.content -> 'address'::text) -> 0) -> 'zip'::text) ->> 0)
/personaldetails/telephone1		/PatientRecord/Patient/ContactDetails/ContactDetail/Value = Value		patient	(((patient.content -> 'contact'::text) -> 0) -> 'telecom'::text) This is a list.
/personaldetails/telephone2		/PatientRecord/Patient/ContactDetails/ContactDetail/Value = Value		patient	(((patient.content -> 'contact'::text) -> 0) -> 'telecom'::text) This is a list.
/personaldetails/mobile		/PatientRecord/Patient/ContactDetails/ContactDetail/Value = Value		patient	(((patient.content -> 'contact'::text) -> 0) -> 'telecom'::text) This is a list.
/clinicaldetails/rrtstatus		/PatientRecord/PVData/rrtstatus
/clinicaldetails/tpstatus		/PatientRecord/PVData/tpstatus
/clinicaldetails/diagnosisedta		/PatientRecord/Diagnoses/RenalDiagnosis/Code = Value
/clinicaldetails/diagnosis		/PatientRecord/Diagnoses/Diagnosis/Code = Value	There can be multiple diagnosis records.
/testdetails/test/testname		???
/testdetails/test/testcode		???
/testdetails/test/units		???
/testdetails/test/daterange		???
/testdetails/test/result/datestamp		???	There can be multiple result records
/testdetails/test/result/prepost		???
/testdetails/test/result/value		???
/drugdetails/drug/drugstartdate		/PatientRecord/Medications/Medication/FromTime	There can be multiple drug records
/drugdetails/drug/drugname		/PatientRecord/Medications/Medication/DrugProduct/LabelName
/drugdetails/drug/drugdose		/PatientRecord/Medications/Medication/DoseQuantity
/letterdetails/letter/letterdate		/PatientRecord/Documents/Document/DocumentTime	There can be multiple letter records
/letterdetails/letter/lettertype		/PatientRecord/Documents/Document/DocumentName
/letterdetails/letter/lettercontent		/PatientRecord/Documents/Document/NoteText

Page tree

PV XML to RDA XML Mapping