Adastra Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]]
== Case ==
== Case ==
This file contains details of patient out of hours case data.
This file contains details of patient out of hours case data.<br />
<br />
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="wikitable"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|+
|+
!FieldName
!FHIR Mapping
|-
|-
|PatientRef
|PatientRef
|Patient reference
|EpisodeOfCare::Patient.reference
|episode_of_care
|patient_id
|-
|-
|PriorityName
|PriorityName
|priority extension
|EpisodeOfCare::priority.extension
| -
| -
|-
|-
|CaseRef
|CaseRef
|EpisodeOfCare::id
|episode_of_care
|id
|id
|-
|-
|CaseNo
|CaseNo
|identifier
|EpisodeOfCare::identifier
| -
| -
|-
|-
|StartDateTime
|StartDateTime
|period.start
|EpisodeOfCare:period.start
|episode_of_care
|date_registered
|-
|-
|EndDateTime
|EndDateTime
|period.end
|EpisodeOfCare:period.end
|-
|episode_of_care
|LocationName
|date_registered_end
|n/a
|-
|-
|CaseTagName
|CaseTagName
|identifier
|EpisodeOfCare::identifier
| -
| -
|-
|-
|ArrivedPCC
|ArrivedPCC
|arrival extension
|EpisodeOfCare::arrival.extension
| -
| -
|-
|-
|UserRef
|UserRef
|practitioner reference
|EpisodeOfCare::practitioner.reference
|episode_of_care
|usual_gp_practitioner_id
|-
|-
|ODSCode
|ODSCode
|organisation reference
|EpisodeOfCare::organisation.reference
| -
| -
|}
|}


== Case Questions ==
== Case Questions ==
This file contains defined questions and answers linked to a case.  Treated like a questionnaire associated with a case encounter.
This file contains defined questions and answers linked to a case.  It is treated like a questionnaire associated with a case encounter.
<br />
 
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |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 ==
== Outcomes ==
This files list the outcomes(s) of the case.
This files list the outcomes(s) of the case.
<br />
 
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|+
|-
|CaseRef
|EpisodeOfCare::id
| -
| -
|-
|OutcomeName
|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.
<br />
 
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |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 ==
== 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.
<br />
 
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |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 ==
== 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%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |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 ==
== Prescriptions ==
Details the drug items given during the Consultation which links back to a case.   
Details the drug items given during the Consultation which links back to a case.   


{{Note|These will be Snomed DM&D coded as part of phase 2.}}<br />
{{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%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |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
| -
| -
|}
<br />


== Clinical codes ==
== Clinical codes ==
Details all the clinical codes added during a Consultation which links back to a case.
Details all the clinical codes added during a Consultation which links back to a case.<br />
<br />
 
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |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 ==
== Provider ==
Details the patient GP practice and locations
Details the patient GP practice and locations.
<br />
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |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 ==
== Users ==
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%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |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 <nowiki>http://endeavourhealth.org/fhir/Identifier/gmc-number</nowiki> identifier
|practitioner
|gmc_code
|-
|ProviderNMC
|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’