Adastra Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]]
== Case ==
== Case ==
=== EpisodeOfCare ===
This file contains details of patient out of hours case data.<br />
This file contains details of patient out of hours case data.<br />
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
Line 17: Line 16:
|-
|-
|PatientRef
|PatientRef
|Patient  reference
|EpisodeOfCare::Patient.reference
|EpisodeOfCare::Patient.reference
|episode_of_care
|episode_of_care
Line 23: Line 21:
|-
|-
|PriorityName
|PriorityName
|priority  extension
|EpisodeOfCare::priority.extension
|EpisodeOfCare::priority.extension
| -
| -
Line 29: Line 26:
|-
|-
|CaseRef
|CaseRef
|id
|EpisodeOfCare::id
|EpisodeOfCare::id
|episode_of_care
|episode_of_care
Line 35: Line 31:
|-
|-
|CaseNo
|CaseNo
|identifier
|EpisodeOfCare::identifier
|EpisodeOfCare::identifier
| -
| -
Line 41: Line 36:
|-
|-
|StartDateTime
|StartDateTime
|period.start
|EpisodeOfCare:period.start
|EpisodeOfCare:period.start
|episode_of_care
|episode_of_care
Line 47: Line 41:
|-
|-
|EndDateTime
|EndDateTime
|period.end
|EpisodeOfCare:period.end
|EpisodeOfCare:period.end
|episode_of_care
|episode_of_care
Line 53: Line 46:
|-
|-
|CaseTagName
|CaseTagName
|identifier
|EpisodeOfCare::identifier
|EpisodeOfCare::identifier
| -
| -
Line 59: Line 51:
|-
|-
|ArrivedPCC
|ArrivedPCC
|arrival  extension
|EpisodeOfCare::arrival.extension
|EpisodeOfCare::arrival.extension
| -
| -
Line 65: Line 56:
|-
|-
|UserRef
|UserRef
|practitioner  reference
|EpisodeOfCare::practitioner.reference
|EpisodeOfCare::practitioner.reference
|episode_of_care
|episode_of_care
Line 71: Line 61:
|-
|-
|ODSCode
|ODSCode
|organisation  reference
|EpisodeOfCare::organisation.reference
|EpisodeOfCare::organisation.reference
| -
| -
Line 78: Line 67:


== Case Questions ==
== Case Questions ==
This file contains defined questions and answers linked to a case.  It is treated like a questionnaire associated with a case encounter.<br />
This file contains defined questions and answers linked to a case.  It is treated like a questionnaire associated with a case encounter.
 
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: QuestionnaireResponse'''
|+
|-
|-
|CaseRef
|CaseRef
|identifier also used to derive the linked Encounter reference from a pre- transform
|QuestionnaireRespone::subject.patient.reference
| -
| -
|-
|-
|QuestionSetName
|QuestionSetName
|group.title
|QuestionnaireRespone::group.title
| -
| -
|-
|-
|Question
|Question
|group.question.text
|QuestionnaireRespone::group.question.text
| -
| -
|-
|-
|Answer
|Answer
|group.question.answer.value
|QuestionnaireRespone::group.question.answer.value
| -
| -
|-
|
|status = QuestionnaireResponseStatus.Completed
| -
| -
|}
|}


== Outcomes ==
== Outcomes ==
This files list the outcomes(s) of the case.<br />
This files list the outcomes(s) of the case.
 
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: EpisodeOfCare'''
|+
|-
|-
|CaseRef
|CaseRef
|id
|EpisodeOfCare::id
| -
| -
|-
|-
|OutcomeName
|OutcomeName
|outcome extension
|EpisodeOfCare::outcome.extension
| -
| -
|}
|}


== Notes ==
== Notes ==
This file lists all patient notes linked to a case.
This file lists all patient notes linked to a case.
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: Flag'''
|+
|-
|-
|CaseRef
|CaseRef
|id together with patientId and ReviewDateTime
|Flag::id:patientId:ReviewDateTime
|flag
|id
|-
|-
|PatientRef
|PatientRef
|subject  patient reference
|Flag::Subject::ReferenceValue
|flag
|patient_id
|-
|-
|ReviewDateTime
|ReviewDateTime
|period.start
|Flag::Period::Start::DateValue
|flag
|effective_date
|-
|-
|NoteText
|NoteText
|code  as text only
|Flag::CodeableConcept::Text
|flag
|flag_text
|-
|-
|Obsolete
|Obsolete
|n/a - ignored where equals true
| -
| -
| -
|-
|-
|Active
|Active
|status
|Flag::Status::Value
|flag
|flag_text
|-
|-
|UserRef
|UserRef
|author  reference
|Flag::Author::ReferenceValue
| -
| -
|}
|}


== Patient ==
== Patient ==
Details all the patients seen as part of the OOH service linked to a case.
Details all the patients seen as part of the OOH service linked to a case.
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: Patient'''
|+
|-
|-
|PatientRef
|PatientRef
|Patient::Id
|patient
|id
|id
|-
|-
|Forename
|Forename
|givenName
|Patient::Name::Given
|patient
|first_names
|-
|-
|Surname
|Surname
|familyName
|Patient::Name::Family
|patient
|last_name
|-
|-
|DOB
|DOB
|birthDate
|Patient::BirthDate
|patient
|date_of_birth
|-
|-
|NHSNumber
|NHSNumber
|identifier
|Patient::Identifier::Value (use=official, system=nhs-number)
|patient
|nhs_number
|-
|-
|NHSNoTraceStatus
|NHSNoTraceStatus
|identifier
|Patient::primarycare-nhs-number-verification-status-extension::Value (NHS Verification Status)
| -
| -
|-
|-
|Language
|Language
|communicationComponent.language CodableConcept
|Patient:CodableConcept:Patientlanguage
speaks English extension if language = English
| -
| -
|-
|-
|Ethnicity
|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
|gender
|Patient::Gender
|patient
|gender_concept_id
|-
|-
|RegistrationType
|RegistrationType
|episode of care registration type extension
|EpisodeOfCare:: primarycare-patient-registration-type-extension::ValueCodeableConcept***
|episode_of_care
|registration_type_concept_id
|-
|HomeAddressType
|Patient::Address::Use (temp, home,old)
|patient_address
|use_concept_id
|-
|-
|HomeAddressBuilding
|HomeAddressBuilding
|address.line, use = HOME
|Patient::Address::Line
|patient_address
|address_line_1
|-
|-
|HomeAddressStreet
|HomeAddressStreet
|address.line, use = HOME
|Patient::Address::Line
|patient_address
|address_line_2
|-
|-
|HomeAddressTown
|HomeAddressTown
|address.town, use = HOME
|Patient::Address::City
|patient_address
|city
|-
|-
|HomeAddressLocality
|HomeAddressLocality
|address.line, use = HOME
|Patient::Address::District
|patient_address
|address_line_4
|-
|-
|HomeAddressPostcode
|HomeAddressPostcode
|address.postcode, use = HOME
|Patient::Address::PostalCode
|patient_address
|postcode
|-
|-
|MobilePhone
|MobilePhone
|contactPoint, use = MOBILE
|Patient::contactPoint::phone (use=mobile, system=phone)
|patient_contact
|type_concept_id - value
|-
|-
|HomePhone
|HomePhone
|contactPoint, use = HOME
|Patient::contactPoint::phone (use=home, system=phone)
|patient_contact
|type_concept_id - value
|-
|-
|EthnicCode
|EthnicCode
|enthnicity extension
|Patient:enthnicity.extension
|patient
|ethnic_code_concept_id
|}
|}


== Consultation ==
== Consultation ==
This file details the patient consultations associated with a case.
This file details the patient consultations associated with a case.
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: Encounter'''
|+  
|-
|-
|CaseRef
|CaseRef
|EpisodeOfCare reference
|EpisodeOfCare:reference
Used to derive Patient reference
|encounter
|patient_id
|-
|-
|ConsultationRef
|ConsultationRef
|Encounter::Id
|encounter
|id
|id
|-
|-
|StartDateTime
|StartDateTime
|period.start
|Encounter::Period::Start
|encounter
|clinical_effective_date
|-
|-
|EndDateTime
|EndDateTime
|period.end
|Encounter::Period::End
|encounter
|end_date
|-
|Location
| -
| -
| -
|-
|-
|CaseType
|CaseType
|CodableConcept encounter_source
|Encount:CodableConcept:encounter_source
|encounter
|non_core_concept_id
|-
|-
|History
|History
|Observation.comments linked to Encounter
|Observation:comments  
| -
| -
|-
|-
|Examination
|Examination
|Observation.comments linked to Encounter
|Observation:comments  
| -
| -
|-
|-
|Diagnosis
|Diagnosis
|Observation.comments linked to Encounter
|Observation:comments  
| -
| -
|-
|-
|TreatmentPlan
|TreatmentPlan
|Observation.comments linked to Encounter
|Observation:comments  
| -
| -
|-
|-
|PatientName
|PatientName
|n/a - Patient reference used
|n/a - Patient reference used
| -
| -
|-
|-
|PatientForename
|PatientForename
|n/a - Patient reference used
|n/a - Patient reference used
| -
| -
|-
|-
|PatientSurname
|PatientSurname
|n/a - Patient reference used
|n/a - Patient reference used
| -
| -
|-
|ProviderType
|
| -
| -
|-
|GMC
|
| -
| -
|-
|-
|UserRef
|UserRef
|Participant Primary Performer reference
|Encounter::Participant::ReferenceValue
|encounter
|practitioner_id
|}
|}


Line 295: Line 395:


{{Note|These will be Snomed DM&D coded as part of phase 2.}}
{{Note|These will be Snomed DM&D coded as part of phase 2.}}
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: MedicationStatement'''
|+
|-
|-
|CaseRef
|CaseRef
|id = CaseRef + ConsulationRef + PatientId
|MedicationStatement::Patient::Reference *
Used to  derive Patient reference
|medication_statement
|patient_id
|-
|-
|ConsultationRef
|ConsultationRef
|Used to derive effectiveDate, i.e. same as consultation date and  practitioner from
|MedicationStatement::DateAsserted
Consultation UserRef
|medication_statement
Encounter reference
|clinical_effective_date
|-
|-
|DrugName
|DrugName
|CodableConcept.code.text
|MedicationStatement::CodeableConcept::Coding::Text
|medication_statement
|core_concept_id
|-
|-
|Preparation
|Preparation
|units extension
|MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Unit
|medication_statement
|quantity_unit
|-
|-
|Dosage
|Dosage
|dosage
|MedicationStatement::Dosage::Text
|medication_statement
|dose
|-
|-
|Quantity
|Quantity
|quanity extension
|MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Value
|medication_statement
|quantity_value
|-
|-
|DMDCode
|DMDCode
|CodableConcept.code
|MedicationStatement::CodeableConcept::Coding
|medication_statement
|core_concept_id
|-
|-
|Issue
|Issue
|if (not N) then creates linked MedicationOrder resource
|Y or N
| -
| -
|}
|}
<br />
<br />
Line 339: Line 452:
== Clinical codes ==
== Clinical codes ==
Details all the clinical codes added during a Consultation which links back to a case.<br />
Details all the clinical codes added during a Consultation which links back to a case.<br />
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: Observation'''
|+
|-
|
|Obsrvation::id
|observation
|id
|-
|-
|CaseRef
|CaseRef
|id = CaseRef + ConsulationRef + ClinicalCode
|Observation::Subject.reference
Used to  derive Patient 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
|Observation::Encounter.reference
Encounter reference
|observation
|encounter_id
|-
|-
|ClinicalCode
|ClinicalCode
|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.
|Observation:CodableConcept.code.text  
| -
| -
|}
|}


Line 370: Line 495:
Details the patient GP practice and locations.
Details the patient GP practice and locations.
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: Organization.
|+  
Linked to the Patient resource Care Provider'''
Linked to the Patient resource Care Provider
|-
|-
|GPPracticeNatCode
|GPPracticeNatCode
|Organization.identifier.value
|Organization::Identifier::Value (use=official, system=ods-organization-code)
|organization
|ods_code
|-
|-
|GPPracitceName
|GPPracitceName
|Organization.name
|Organization::name
|organization
|Name
|-
|-
|GPPracticePostcode
|GPPracticePostcode
|Organization.address.postcode
|Organization:address:postcode
|organization
|Postcode
|}
|}


Line 396: Line 526:
Details the clinical users/practitioners, linking into all UserRef references in other resources.
Details the clinical users/practitioners, linking into all UserRef references in other resources.
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! colspan="2" style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|+'''FHIR Resource: Practitioner'''
|+
|-
|-
|UserRef
|UserRef
|Practitioner::Id*
|practitioner
|id
|id
|-
|-
|Forename
|Forename
|HumanName.given
|Practitioner::Name::Given
|practitioner
|name
|-
|-
|Surname
|Surname
|HumanName.family
|Practitioner::Name::Family
|practitioner
|name
|-
|-
|FullName
|FullName
|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
|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
|Practitioner::Identifier::Value (system=nmc-number)
if a Nurse, create an <nowiki>http://endeavourhealth.org/fhir/Identifier/nmc-number</nowiki> identifier
| -
| -
|}
|}

Latest revision as of 10:58, 3 August 2023

To see the latest Compass V2 schema, please see Discovery Remote Subscriber Database Familiarisation#Data_Mapping

Case

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

Publisher DDS Core Compass V2
Field Name FHIR Table Field
PatientRef EpisodeOfCare::Patient.reference episode_of_care patient_id
PriorityName EpisodeOfCare::priority.extension - -
CaseRef EpisodeOfCare::id episode_of_care id
CaseNo EpisodeOfCare::identifier - -
StartDateTime EpisodeOfCare:period.start episode_of_care date_registered
EndDateTime EpisodeOfCare:period.end episode_of_care date_registered_end
CaseTagName EpisodeOfCare::identifier - -
ArrivedPCC EpisodeOfCare::arrival.extension - -
UserRef EpisodeOfCare::practitioner.reference episode_of_care usual_gp_practitioner_id
ODSCode 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 FHIR Table Field
CaseRef QuestionnaireRespone::subject.patient.reference - -
QuestionSetName QuestionnaireRespone::group.title - -
Question QuestionnaireRespone::group.question.text - -
Answer 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 FHIR Table Field
CaseRef EpisodeOfCare::id - -
OutcomeName EpisodeOfCare::outcome.extension - -

Notes

This file lists all patient notes linked to a case.

Publisher DDS Core Compass V2
Field Name FHIR Table Field
CaseRef Flag::id:patientId:ReviewDateTime flag id
PatientRef Flag::Subject::ReferenceValue flag patient_id
ReviewDateTime Flag::Period::Start::DateValue flag effective_date
NoteText Flag::CodeableConcept::Text flag flag_text
Obsolete - - -
Active Flag::Status::Value flag flag_text
UserRef 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 FHIR Table Field
PatientRef Patient::Id patient id
Forename Patient::Name::Given patient first_names
Surname Patient::Name::Family patient last_name
DOB Patient::BirthDate patient date_of_birth
NHSNumber Patient::Identifier::Value (use=official, system=nhs-number) patient nhs_number
NHSNoTraceStatus Patient::primarycare-nhs-number-verification-status-extension::Value (NHS Verification Status) - -
Language Patient:CodableConcept:Patientlanguage - -
Ethnicity Patient:enthnicity.extension (only attempt match if fieldIndex 27 blank) patient ethnic_code_concept_id
Gender Patient::Gender patient gender_concept_id
RegistrationType EpisodeOfCare:: primarycare-patient-registration-type-extension::ValueCodeableConcept*** episode_of_care registration_type_concept_id
HomeAddressType Patient::Address::Use (temp, home,old) patient_address use_concept_id
HomeAddressBuilding Patient::Address::Line patient_address address_line_1
HomeAddressStreet Patient::Address::Line patient_address address_line_2
HomeAddressTown Patient::Address::City patient_address city
HomeAddressLocality Patient::Address::District patient_address address_line_4
HomeAddressPostcode Patient::Address::PostalCode patient_address postcode
MobilePhone Patient::contactPoint::phone (use=mobile, system=phone) patient_contact type_concept_id - value
HomePhone Patient::contactPoint::phone (use=home, system=phone) patient_contact type_concept_id - value
EthnicCode 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 FHIR Table Field
CaseRef EpisodeOfCare:reference encounter patient_id
ConsultationRef Encounter::Id encounter id
StartDateTime Encounter::Period::Start encounter clinical_effective_date
EndDateTime Encounter::Period::End encounter end_date
Location - - -
CaseType Encount:CodableConcept:encounter_source encounter non_core_concept_id
History Observation:comments - -
Examination Observation:comments - -
Diagnosis Observation:comments - -
TreatmentPlan Observation:comments - -
PatientName n/a - Patient reference used - -
PatientForename n/a - Patient reference used - -
PatientSurname 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 FHIR Table Field
CaseRef MedicationStatement::Patient::Reference * medication_statement patient_id
ConsultationRef MedicationStatement::DateAsserted medication_statement clinical_effective_date
DrugName MedicationStatement::CodeableConcept::Coding::Text medication_statement core_concept_id
Preparation MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Unit medication_statement quantity_unit
Dosage MedicationStatement::Dosage::Text medication_statement dose
Quantity MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Value medication_statement quantity_value
DMDCode MedicationStatement::CodeableConcept::Coding medication_statement core_concept_id
Issue 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 FHIR Table Field
Obsrvation::id observation id
CaseRef Observation::Subject.reference observation patient_id
ConsultationRef Observation::Encounter.reference observation encounter_id
ClinicalCode Observation::codableConcept.code observation non_core_concept_id

core_concept_id

Term Observation:CodableConcept.code.text - -

Provider

Details the patient GP practice and locations.

Publisher DDS Core Compass V2
Field Name FHIR Table Field
Linked to the Patient resource Care Provider
GPPracticeNatCode Organization::Identifier::Value (use=official, system=ods-organization-code) organization ods_code
GPPracitceName Organization::name organization Name
GPPracticePostcode 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 FHIR Table Field
UserRef Practitioner::Id* practitioner id
Forename Practitioner::Name::Given practitioner name
Surname Practitioner::Name::Family practitioner name
FullName Practitioner::Name::Given

Practitioner::Name::Family

practitioner name
ProviderGMC Practitioner::Identifier::Value (system=gmc-number)

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

practitioner gmc_code
ProviderNMC 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=6550’