Adastra Extract FHIR Mapping: Difference between revisions
More actions
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
== Case == | == Case == | ||
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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 69: | Line 69: | ||
This file contains defined questions and answers linked to a case. It is 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. | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 110: | Line 110: | ||
This files list the outcomes(s) of the case. | 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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 136: | Line 136: | ||
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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 187: | Line 187: | ||
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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 298: | Line 298: | ||
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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 396: | Line 396: | ||
{{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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 453: | Line 453: | ||
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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 494: | Line 494: | ||
== Provider == | == Provider == | ||
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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
| Line 525: | Line 525: | ||
== 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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
! style="color:# | ! style="color:#04466b" |'''Publisher''' | ||
! style="color:# | ! style="color:#04466b" |DDS Core | ||
! colspan="2" style="color:# | ! colspan="2" style="color:#04466b" |Compass V2 | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="25%" |FHIR | ! scope="col" width="25%" |FHIR | ||
Latest revision as of 11:46, 14 November 2024
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 |
| 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 |
- | - |