Adastra Extract FHIR Mapping

From Discovery Data Service
Revision as of 14:54, 27 July 2023 by JoC (talk | contribs)
Jump to navigation Jump to search

Case

This file contains details of patient out of hours case data.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
PatientRef Patient reference EpisodeOfCare::Patient.reference episode_of_care patient_id
PriorityName priority extension EpisodeOfCare::priority.extension - -
CaseRef id EpisodeOfCare::id episode_of_care id
CaseNo identifier EpisodeOfCare::identifier - -
StartDateTime period.start EpisodeOfCare:period.start episode_of_care date_registered
EndDateTime period.end EpisodeOfCare:period.end episode_of_care date_registered_end
CaseTagName identifier EpisodeOfCare::identifier - -
ArrivedPCC arrival extension EpisodeOfCare::arrival.extension - -
UserRef practitioner reference EpisodeOfCare::practitioner.reference episode_of_care usual_gp_practitioner_id
ODSCode organisation reference EpisodeOfCare::organisation.reference - -

Case Questions

This file contains defined questions and answers linked to a case.  It is treated like a questionnaire associated with a case encounter.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
CaseRef identifier also used to derive the linked Encounter reference from a pre- transform QuestionnaireRespone::subject.patient.reference - -
QuestionSetName group.title QuestionnaireRespone::group.title - -
Question group.question.text QuestionnaireRespone::group.question.text - -
Answer group.question.answer.value QuestionnaireRespone::group.question.answer.value - -
status = QuestionnaireResponseStatus.Completed - -

Outcomes

This files list the outcomes(s) of the case.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
CaseRef id EpisodeOfCare::id - -
OutcomeName outcome extension EpisodeOfCare::outcome.extension - -

Notes

This file lists all patient notes linked to a case.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
CaseRef id together with patientId and ReviewDateTime Flag::id:patientId:ReviewDateTime flag id
PatientRef subject patient reference Flag::Subject::ReferenceValue flag patient_id
ReviewDateTime period.start Flag::Period::Start::DateValue flag effective_date
NoteText code  as text only Flag::CodeableConcept::Text flag flag_text
Obsolete n/a - ignored where equals true - - -
Active status Flag::Status::Value flag flag_text
UserRef author reference Flag::Author::ReferenceValue - -

Patient

Details all the patients seen as part of the OOH service linked to a case.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
PatientRef id Patient::Id patient id
Forename givenName Patient::Name::Given patient first_names
Surname familyName Patient::Name::Family patient last_name
DOB birthDate Patient::BirthDate patient date_of_birth
NHSNumber identifier Patient::Identifier::Value (use=official, system=nhs-number) patient nhs_number
NHSNoTraceStatus identifier Patient::primarycare-nhs-number-verification-status-extension::Value (NHS Verification Status) - -
Language communicationComponent.language CodableConcept

speaks English extension if language = English

Patient:CodableConcept:Patientlanguage - -
Ethnicity enthnicity extension (only attempt match if field 27 blank) Patient:enthnicity.extension (only attempt match if fieldIndex 27 blank) patient ethnic_code_concept_id
Gender gender Patient::Gender patient gender_concept_id
RegistrationType episode of care registration type extension EpisodeOfCare:: primarycare-patient-registration-type-extension::ValueCodeableConcept*** episode_of_care registration_type_concept_id
HomeAddressType address.line, use = HOME Patient::Address::Use (temp, home,old) patient_address use_concept_id
HomeAddressBuilding address.line, use = HOME Patient::Address::Line patient_address address_line_1
HomeAddressStreet address.line, use = HOME Patient::Address::Line patient_address address_line_2
HomeAddressTown address.town, use = HOME Patient::Address::City patient_address city
HomeAddressLocality address.line, use = HOME Patient::Address::District patient_address address_line_4
HomeAddressPostcode address.postcode, use = HOME Patient::Address::PostalCode patient_address postcode
MobilePhone contactPoint, use = MOBILE Patient::contactPoint::phone (use=mobile, system=phone) patient_contact type_concept_id - value
HomePhone contactPoint, use = HOME Patient::contactPoint::phone (use=home, system=phone) patient_contact type_concept_id - value
EthnicCode enthnicity extension Patient:enthnicity.extension patient ethnic_code_concept_id

Consultation

This file details the patient consultations associated with a case.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
CaseRef EpisodeOfCare reference

Used to derive Patient reference

EpisodeOfCare:reference encounter patient_id
ConsultationRef id Encounter::Id encounter id
StartDateTime period.start Encounter::Period::Start encounter clinical_effective_date
EndDateTime period.end Encounter::Period::End encounter end_date
Location CodableConcept encounter_source - - -
CaseType Observation.comments linked to Encounter Encount:CodableConcept:encounter_source encounter non_core_concept_id
History Observation.comments linked to Encounter Observation:comments - -
Examination Observation.comments linked to Encounter Observation:comments - -
Diagnosis Observation.comments linked to Encounter Observation:comments - -
TreatmentPlan n/a - Patient reference used Observation:comments - -
PatientName n/a - Patient reference used n/a - Patient reference used - -
PatientForename n/a - Patient reference used n/a - Patient reference used - -
PatientSurname Participant Primary Performer reference n/a - Patient reference used - -
ProviderType - -
GMC - -
UserRef Encounter::Participant::ReferenceValue encounter practitioner_id

Prescriptions

Details the drug items given during the Consultation which links back to a case. 

These will be Snomed DM&D coded as part of phase 2.
Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
CaseRef id = CaseRef + ConsulationRef + PatientId

Used to derive Patient reference

MedicationStatement::Patient::Reference * medication_statement patient_id
ConsultationRef Used to derive effectiveDate, i.e. same as consultation date and practitioner from

Consultation UserRef Encounter reference

MedicationStatement::DateAsserted medication_statement clinical_effective_date
DrugName CodableConcept.code.text MedicationStatement::CodeableConcept::Coding::Text medication_statement core_concept_id
Preparation units extension MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Unit medication_statement quantity_unit
Dosage dosage MedicationStatement::Dosage::Text medication_statement dose
Quantity quanity extension MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Value medication_statement quantity_value
DMDCode CodableConcept.code MedicationStatement::CodeableConcept::Coding medication_statement core_concept_id
Issue if (not N) then creates linked MedicationOrder resource Y or N - -


Clinical codes

Details all the clinical codes added during a Consultation which links back to a case.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
Obsrvation::id observation id
CaseRef id = CaseRef + ConsulationRef + ClinicalCode

Used to derive Patient reference

Observation::Subject.reference observation patient_id
ConsultationRef Used to derive effectiveDate, i.e. same as consultation date and the UserRef of the consultation for the Observation clinician

Encounter reference

Observation::Encounter.reference observation encounter_id
ClinicalCode CodableConcept.code as Read2.  Also mapped to Snomed. Observation::codableConcept.code observation non_core_concept_id

core_concept_id

Term CodableConcept.code.text as Read2.  Also mapped to Snomed. Observation:CodableConcept.code.text - -

Provider

Details the patient GP practice and locations.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
Linked to the Patient resource Care Provider
GPPracticeNatCode Organization.identifier.value Organization::Identifier::Value (use=official, system=ods-organization-code) organization ods_code
GPPracitceName Organization.name Organization::name organization Name
GPPracticePostcode Organization.address.postcode Organization:address:postcode organization Postcode

Users

Details the clinical users/practitioners, linking into all UserRef references in other resources.

Publisher DDS Core Compass V2
Field Name Data/Coding Type FHIR Table Field
UserRef id Practitioner::Id* practitioner id
Forename HumanName.given Practitioner::Name::Given practitioner name
Surname HumanName.family Practitioner::Name::Family practitioner name
FullName HumanName.text Practitioner::Name::Given

Practitioner::Name::Family

practitioner name
ProviderGMC if a GP, create an http://endeavourhealth.org/fhir/Identifier/gmc-number identifier Practitioner::Identifier::Value (system=gmc-number)

if a GP, create an http://endeavourhealth.org/fhir/Identifier/gmc-number identifier

practitioner gmc_code
ProviderNMC if a Nurse, create an http://endeavourhealth.org/fhir/Identifier/nmc-number identifier Practitioner::Identifier::Value (system=nmc-number)

if a Nurse, create an http://endeavourhealth.org/fhir/Identifier/nmc-number identifier

- -