Page tree

UKRDC Dataset

Skip to end of metadata
Go to start of metadata


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


  • No labels