Adastra Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
Line 93: Line 93:
|CaseRef
|CaseRef
|identifier also used to derive the linked Encounter reference from a pre- transform
|identifier also used to derive the linked Encounter reference from a pre- transform
|QuestionnaireRespone::subject.patient.reference
| -
| -
|-
|-
|QuestionSetName
|QuestionSetName
|group.title
|group.title
|QuestionnaireRespone::group.title
| -
| -
|-
|-
|Question
|Question
|group.question.text
|group.question.text
|QuestionnaireRespone::group.question.text
| -
| -
|-
|-
|Answer
|Answer
|group.question.answer.value
|group.question.answer.value
|QuestionnaireRespone::group.question.answer.value
| -
| -
|-
|
|
|status = QuestionnaireResponseStatus.Completed
| -
| -
|}
|}


Line 122: Line 140:
|CaseRef
|CaseRef
|id
|id
|EpisodeOfCare::id
| -
| -
|-
|-
|OutcomeName
|OutcomeName
|outcome  extension
|outcome  extension
|EpisodeOfCare::outcome.extension
| -
| -
|}
|}


Line 145: Line 169:
|CaseRef
|CaseRef
|id  together with patientId and ReviewDateTime
|id  together with patientId and ReviewDateTime
|Flag::id:patientId:ReviewDateTime
|flag
|id
|-
|-
|PatientRef
|PatientRef
|subject  patient reference
|subject  patient reference
|Flag::Subject::ReferenceValue
|flag
|patient_id
|-
|-
|ReviewDateTime
|ReviewDateTime
|period.start
|period.start
|Flag::Period::Start::DateValue
|flag
|effective_date
|-
|-
|NoteText
|NoteText
|code  as text only
|code  as text only
|Flag::CodeableConcept::Text
|flag
|flag_text
|-
|-
|Obsolete
|Obsolete
|n/a -  ignored where equals true
|n/a -  ignored where equals true
| -
| -
| -
|-
|-
|Active
|Active
|status
|status
|Flag::Status::Value
|flag
|flag_text
|-
|-
|UserRef
|UserRef
|author  reference
|author  reference
|Flag::Author::ReferenceValue
| -
| -
|}
|}


Line 182: Line 227:
|-
|-
|PatientRef
|PatientRef
|id
|Patient::Id
|patient
|id
|id
|-
|-
|Forename
|Forename
|givenName
|givenName
|Patient::Name::Given
|patient
|first_names
|-
|-
|Surname
|Surname
|familyName
|familyName
|Patient::Name::Family
|patient
|last_name
|-
|-
|DOB
|DOB
|birthDate
|birthDate
|Patient::BirthDate
|patient
|date_of_birth
|-
|-
|NHSNumber
|NHSNumber
|identifier
|identifier
|Patient::Identifier::Value (use=official, system=nhs-number)
|patient
|nhs_number
|-
|-
|NHSNoTraceStatus
|NHSNoTraceStatus
|identifier
|identifier
|Patient::primarycare-nhs-number-verification-status-extension::Value (NHS Verification Status)
| -
| -
|-
|-
|Language
|Language
|communicationComponent.language CodableConcept
|communicationComponent.language CodableConcept
speaks English extension if language = English
speaks English extension if language = English
|Patient:CodableConcept:Patientlanguage
| -
| -
|-
|-
|Ethnicity
|Ethnicity
|enthnicity extension (only attempt match if field 27 blank)
|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
|gender
|gender
|Patient::Gender
|patient
|gender_concept_id
|-
|-
|RegistrationType
|RegistrationType
|episode of care registration type extension
|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
|HomeAddressBuilding
|address.line, use = HOME
|address.line, use = HOME
|Patient::Address::Line
|patient_address
|address_line_1
|-
|-
|HomeAddressStreet
|HomeAddressStreet
|address.line, use = HOME
|address.line, use = HOME
|Patient::Address::Line
|patient_address
|address_line_2
|-
|-
|HomeAddressTown
|HomeAddressTown
|address.town, use = HOME
|address.town, use = HOME
|Patient::Address::City
|patient_address
|city
|-
|-
|HomeAddressLocality
|HomeAddressLocality
|address.line, use = HOME
|address.line, use = HOME
|Patient::Address::District
|patient_address
|address_line_4
|-
|-
|HomeAddressPostcode
|HomeAddressPostcode
|address.postcode, use = HOME
|address.postcode, use = HOME
|Patient::Address::PostalCode
|patient_address
|postcode
|-
|-
|MobilePhone
|MobilePhone
|contactPoint, use = MOBILE
|contactPoint, use = MOBILE
|Patient::contactPoint::phone (use=mobile, system=phone)
|patient_contact
|type_concept_id - value
|-
|-
|HomePhone
|HomePhone
|contactPoint, use = HOME
|contactPoint, use = HOME
|Patient::contactPoint::phone (use=home, system=phone)
|patient_contact
|type_concept_id - value
|-
|-
|EthnicCode
|EthnicCode
|enthnicity extension
|enthnicity extension
|Patient:enthnicity.extension
|patient
|ethnic_code_concept_id
|}
|}


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


Line 315: Line 477:
|id = CaseRef + ConsulationRef + PatientId
|id = CaseRef + ConsulationRef + PatientId
Used to  derive Patient reference
Used to  derive Patient reference
|MedicationStatement::Patient::Reference *
|medication_statement
|patient_id
|-
|-
|ConsultationRef
|ConsultationRef
Line 320: Line 485:
Consultation UserRef
Consultation UserRef
Encounter reference
Encounter reference
|MedicationStatement::DateAsserted
|medication_statement
|clinical_effective_date
|-
|-
|DrugName
|DrugName
|CodableConcept.code.text
|CodableConcept.code.text
|MedicationStatement::CodeableConcept::Coding::Text
|medication_statement
|core_concept_id
|-
|-
|Preparation
|Preparation
|units extension
|units extension
|MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Unit
|medication_statement
|quantity_unit
|-
|-
|Dosage
|Dosage
|dosage
|dosage
|MedicationStatement::Dosage::Text
|medication_statement
|dose
|-
|-
|Quantity
|Quantity
|quanity extension
|quanity extension
|MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Value
|medication_statement
|quantity_value
|-
|-
|DMDCode
|DMDCode
|CodableConcept.code
|CodableConcept.code
|MedicationStatement::CodeableConcept::Coding
|medication_statement
|core_concept_id
|-
|-
|Issue
|Issue
|if (not N) then creates linked MedicationOrder resource
|if (not N) then creates linked MedicationOrder resource
|Y or N
| -
| -
|}
|}
<br />
<br />
Line 356: Line 542:
|-
|-
|+
|+
|-
|
|
|Obsrvation::id
|observation
|id
|-
|-
|CaseRef
|CaseRef
|id = CaseRef + ConsulationRef + ClinicalCode
|id = CaseRef + ConsulationRef + ClinicalCode
Used to  derive Patient reference
Used to  derive Patient reference
|Observation::Subject.reference
|observation
|patient_id
|-
|-
|ConsultationRef
|ConsultationRef
|Used to derive effectiveDate, i.e. same as consultation date and  the UserRef of the consultation for the Observation clinician
|Used to derive effectiveDate, i.e. same as consultation date and  the UserRef of the consultation for the Observation clinician
Encounter reference
Encounter reference
|Observation::Encounter.reference
|observation
|encounter_id
|-
|-
|ClinicalCode
|ClinicalCode
|CodableConcept.code  as Read2.  Also mapped to Snomed.
|CodableConcept.code  as Read2.  Also mapped to Snomed.
|Observation::codableConcept.code
|observation
|non_core_concept_id
core_concept_id
|-
|-
|Term
|Term
|CodableConcept.code.text  as Read2.  Also mapped to Snomed.
|CodableConcept.code.text  as Read2.  Also mapped to Snomed.
|Observation:CodableConcept.code.text
| -
| -
|}
|}


Line 390: Line 595:
|GPPracticeNatCode
|GPPracticeNatCode
|Organization.identifier.value
|Organization.identifier.value
|Organization::Identifier::Value (use=official, system=ods-organization-code)
|organization
|ods_code
|-
|-
|GPPracitceName
|GPPracitceName
|Organization.name
|Organization.name
|Organization::name
|organization
|Name
|-
|-
|GPPracticePostcode
|GPPracticePostcode
|Organization.address.postcode
|Organization.address.postcode
|Organization:address:postcode
|organization
|Postcode
|}
|}


Line 414: Line 628:
|-
|-
|UserRef
|UserRef
|id
|Practitioner::Id*
|practitioner
|id
|id
|-
|-
|Forename
|Forename
|HumanName.given
|HumanName.given
|Practitioner::Name::Given
|practitioner
|name
|-
|-
|Surname
|Surname
|HumanName.family
|HumanName.family
|Practitioner::Name::Family
|practitioner
|name
|-
|-
|FullName
|FullName
|HumanName.text
|HumanName.text
|Practitioner::Name::Given
Practitioner::Name::Family
|practitioner
|name
|-
|-
|ProviderGMC
|ProviderGMC
|if a  GP, create an <nowiki>http://endeavourhealth.org/fhir/Identifier/gmc-number</nowiki>  identifier
|if a  GP, create an <nowiki>http://endeavourhealth.org/fhir/Identifier/gmc-number</nowiki>  identifier
|Practitioner::Identifier::Value (system=gmc-number)
if a GP, create an <nowiki>http://endeavourhealth.org/fhir/Identifier/gmc-number</nowiki> identifier
|practitioner
|gmc_code
|-
|-
|ProviderNMC
|ProviderNMC
|if a  Nurse, create an <nowiki>http://endeavourhealth.org/fhir/Identifier/nmc-number</nowiki>  identifier
|if a  Nurse, create an <nowiki>http://endeavourhealth.org/fhir/Identifier/nmc-number</nowiki>  identifier
|Practitioner::Identifier::Value (system=nmc-number)
if a Nurse, create an <nowiki>http://endeavourhealth.org/fhir/Identifier/nmc-number</nowiki> identifier
| -
| -
|}
|}

Revision as of 14:54, 27 July 2023

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

- -
Retrieved from ‘https://wiki.discoverydataservice.org/index.php?title=Adastra_Extract_FHIR_Mapping&oldid=6496’