Page tree

UKRDC Dataset

Skip to end of metadata
Go to start of metadata


PV FieldFIeld SizeMappingRDA ObjectRDA XPathField SizeNotesPV DB TablePV 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



  • No labels