Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


PV Field
FIeld Size
MappingRDA ObjectRDA XPath
Field Size
NotesPV 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
PatientRecord
/PatientRecord/
SendingFacility
/
Other centredetails fields are not required.

gpdetails/gpname
FamilyDoctor
/PatientRecord/
Patient/FamilyDoctor/GPNameWe would prefer just the GPId / GPPracticeId be used if possible.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
???


N/A
practitioner(((practitioner.content -> 'address'::text) -> 'city'::text) ->> 0)
/
gpdetails/gpaddress3
???/


N/A


gpdetails/gppostcode
/PatientRecord/


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
/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/GenderThis 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/ContactDetails/ContactDetail/@user = 'PRS'


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 = 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
/PatientRecord/


Medications/Medication/FromTimeThere 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/DocumentTimeThere can be multiple letter records

/letterdetails/letter/lettertype
/PatientRecord/


Documents/Document/DocumentName


/letterdetails/letter/lettercontent
/PatientRecord/


Documents/Document/NoteText