Vision GP Extract FHIR Mapping: Difference between revisions
From Voror_Wiki
More actions
| Line 150: | Line 150: | ||
== Encounters == | == Encounters == | ||
{| 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 | ||
Revision as of 12:35, 14 November 2024
To see the latest Compass V2 schema, please see Discovery Remote Subscriber Database Familiarisation#Data_Mapping
Patients
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| PID | Patient::Id*
EpisodeOfCare::Id* |
patient | id |
| DATE_OF_BIRTH | Patient::BirthDate | patient | date_of_birth |
| SEX | Patient::Gender | patient | gender_concept_id |
| POSTCODE | Patient::Address::PostalCode | patient_address | postcode |
| MARITAL_STATUS | Patient::Marital_Status::ValueCodeableconcept | observation | core_concept_id
non_core_concept_id |
| GP_USUAL | EpisodeOfCare ::CareManager::Reference *
Patient::CareProvider::Reference * |
- | - |
| ACTIVE | EpsisodeOfCare:: primarycare-patient-registration-type-extension::ValueCodeableConcept*** | episode_of_care | registration_type_concept_id |
| REGISTERED_DATE | EpisodeOfCare ::Period::Start
Also used as part of the EpisodeOfCare Id |
episode_of_care
registration_status_history |
date_registered
start_date |
| REMOVED_DATE | EpisodeOfCare ::Period::End | episode_of_care
registration_status_history |
date_registered_end
end_date |
| DATE_OF_DEATH | Patient::Deceased | patient | date_of_death |
| SURNAME | Patient::Name::Family | patient | last_name |
| FORENAME | Patient::Name::Given | patient | first_names |
| TITLE | Patient::Name::Prefix (use=official) | patient | title |
| NHS_NUMBER | Patient::Identifier::Value (use=official, system=nhs-number) | patient | nhs_number |
| ADDRESS_1 | Patient::Address::Line | patient_address | address_line_1 |
| ADDRESS_2 | Patient::Address::Line | patient_address | address_line_2 |
| ADDRESS_3 | Patient::Address::Line | patient_address | address_line_3 |
| ADDRESS_4 | Patient::Address::District | patient_address | address_line_4 |
| ADDRESS_5 | Patient::Address::City | patient_address | city |
| PHONE_NUMBER | Patient::Telecom::Value (use=home, system=phone) | patient_contact | type_concept_id - value |
| MOBILE_NUMBER | Patient::Telecom::Value (use=mobile, system=phone) | patient_contact | type_concept_id - value |
| Patient::Telecom::Value (use=home, system=email) | patient_contact | type_concept_id - value | |
| PRACT_NUMBER | Patient::Identifier::Value (use=secondary, system=http://visionhealth.co.uk/identifier/patient-number) | - | - |
| SERVICE_ID | EpisodeOfCare ::ManagingOrganization::Reference * | patient | organization_id |
Encounters
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| PID | Encounter::Patient (referece -> Patient resource) | encounter | patient_id |
| ID | Encounter::Id | encounter | id |
| DATE | Encounter::Period::Start | encounter | clinical_effective_date |
| HCP | Encounter::Participant | encounter | practitioner_id |
| SESSION | Encounter::Type | encounter | core_concept_id
non_core_concept_id |
| LOCATION | Encounter::LocationType | - | - |
| TIME | Encounter::Period::Start | encounter | clinical_effective_date |
| SERVICE_ID | Encounter::ServiceProvider::OrganizationId | encounter | service_provider_organization_id |
Journals
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| PID | Observation::PatientID | Observation | patient_id |
| ID | Observation::Id | Observation | id |
| DATE | DiagnosticReport::EffectiveDateTime | observation | clinical_effective_date |
| Observation::EffectiveDateTime | observation | clinical_effective_date | |
| Procedure::PerformedPeriod::Start | observation | clinical_effective_date | |
| Condition::OnsetDateTime | observation | clinical_effective_date | |
| AllergyIntolerance::Onset | allergy_intolerance | clinical_effective_date | |
| FamilyMemberHistory::Date | observation | clinical_effective_date | |
| Immunization::Date | observation | clinical_effective_date | |
| Specimen::Collection::Collected::ValueDateTime | observation | clinical_effective_date | |
| ReferralRequest::Date | referral_request | clinical_effective_date | |
| DiagnosticOrder::Event::DateTime | diagnostic_order | clinical_effective_date | |
| RECORDED_DATE | DiagnosticReport::primarycare-recorded-date-extension::DateTimeValue or | observation | date_recorded |
| Observation::primarycare-recorded-date-extension::DateTimeValue | observation | date_recorded | |
| Procedure:: primarycare-recorded-date-extension::DateTimeValue | observation | date_recorded | |
| Condition::DateRecorded | observation | date_recorded | |
| AllergyIntolerance::RecordedDate | allergy_intolerance | date_recorded | |
| FamilyMemberHistory:: primarycare-recorded-date-extension::DateTimeValue | observation | date_recorded | |
| Immunization:: primarycare-recorded-date-extension::DateTimeValue | observation | date_recorded | |
| Specimen:: primarycare-recorded-date-extension::DateTimeValue | observation | date_recorded | |
| ReferralRequest::primarycare-recorded-date-extension::DateTimeValue | referral_request | date_recorded | |
| DiagnosticOrder::primarycare-recorded-date-extension::DateTimeValue | diagnostic_order | date_recorded | |
| CODE | DiagnosticReport::Code **** | observation | core_concept_id
non_core_concept_id |
| Observation::Code **** | observation | core_concept_id
non_core_concept_id | |
| Procedure::Code **** | observation | core_concept_id
non_core_concept_id | |
| Condition::Code **** | observation | core_concept_id
non_core_concept_id | |
| AllergyIntolerance::Substance **** | allergy_intolerance | core_concept_id
non_core_concept_id | |
| FamilyMemberHistory::Condition::Code **** | observation | core_concept_id
non_core_concept_id | |
| Immunization::VaccinationCode **** | observation | core_concept_id
non_core_concept_id | |
| Specimen::Type **** | observation | core_concept_id
non_core_concept_id | |
| ReferralRequest::ServiceRequested::CodeableConcept **** | referral_request | core_concept_id
non_core_concept_id | |
| DiagnosticOrder::Item::Code **** | diagnostic_order | core_concept_id
non_core_concept_id | |
| SNOMED_CODE | DiagnosticReport::Code **** | observation | core_concept_id
non_core_concept_id |
| Observation::Code **** | observation | core_concept_id
non_core_concept_id | |
| Procedure::Code **** | observation | core_concept_id
non_core_concept_id | |
| Condition::Code **** | observation | core_concept_id
non_core_concept_id | |
| AllergyIntolerance::Substance **** | allergy_intolerance | core_concept_id
non_core_concept_id | |
| FamilyMemberHistory::Condition::Code **** | observation | core_concept_id
non_core_concept_id | |
| Immunization::VaccinationCode **** | observation | core_concept_id
non_core_concept_id | |
| Specimen::Type **** | observation | core_concept_id
non_core_concept_id | |
| ReferralRequest::ServiceRequested::CodeableConcept **** | referral_request | core_concept_id
non_core_concept_id | |
| DiagnosticOrder::Item::Code **** | diagnostic_order | core_concept_id
non_core_concept_id | |
| HCP | DiagnosticReport::primarycare-diagnostic-report-filed-by-extension::ValueReference * | observation | practitioner_id |
| Observation::Performer::Reference * | observation | practitioner_id | |
| Procedure::Performer::Reference * | observation | practitioner_id | |
| Condition::Asserter::Reference * | observation | practitioner_id | |
| AllergyIntolerance::Recorder::Reference * (note, this FHIR field should not have been used for this source field, but it’s too late to change without converting DDS content) | allergy_intolerance | practitioner_id | |
| FamilyMemberHistory:: primarycare-family-member-history-reporter-extension::ValueReference * | observation | practitioner_id | |
| Immunization::Performer::Reference * | observation | practitioner_id | |
| Specimen::Collection::Collector::Reference * | observation | practitioner_id | |
| ReferralRequest::Requester or Recipient::Reference * | referral_request | practitioner_id | |
| DiagnosticOrder::Orderer::Reference * | diagnostic_order | practitioner_id | |
| EPISODE
(In a record with CODE for a diagnosis or problem) |
Condition::Episodicity | - | - |
| EPISODE
(In a record with CODE for prescribable item) |
See SUBSET | - | - |
| TEXT | DiagnosticReport::Conclusion | - | - |
| Observation::Comments | - | - | |
| Procedure::Notes | - | - | |
| Condition::Notes | - | - | |
| AllergyIntolerance::Note | - | - | |
| FamilyMemberHistory::Note | - | - | |
| Immunization::Note | - | - | |
| Specimen::Collection::Comment | - | - | |
| ReferralRequest::Description | - | - | |
| DiagnosticOrder::Note | - | - | |
| DosageInstruction::Text | medication_statement | dose | |
| DRUG_PACKSIZE | primarycare-medication-authorisation-quantity-extension::QuantityValue | medication_statement | quantity_value |
| DMD_CODE | Medication::DrugCode | medication_statement | core_concept_id |
| IMMS_COMPOUND | Immunization::Note | - | - |
| IMMS_SOURCE | Immunization::Note | - | - |
| IMMS_BATCH | Immunization::LotNumber | - | - |
| IMMS_REASON | Immunization::Reason | - | - |
| IMMS_METHOD | Immunization::Route | - | - |
| IMMS_SITE | Immunization::Site | - | - |
| ENTITY | Observation::ValueQuantity::Unit | observation | result_value_units |
| VALUE1 | Observation::ValueQuantity::Value | observation | result_value |
| VALUE1_UNITS | Observation::ValueQuantity::Unit | observation | result_value_units |
| VALUE2 | Observation::ValueQuantity::Value | observation | result_value |
| VALUE2_UNITS | Observation::ValueQuantity::Unit | observation | result_value_units |
| END_DATE | Condition::Abaintment | observation | problem_end_date |
| MedicationStatement::MedicationAuthorizationCancellation | medication_statement | cancellation_date | |
| TIME | DiagnosticReport::EffectiveDateTime | observation | clinical_effective_date |
| Observation::EffectiveDateTime | observation | clinical_effective_date | |
| Procedure::PerformedPeriod::Start | observation | clinical_effective_date | |
| Condition::OnsetDateTime | observation | clinical_effective_date | |
| AllergyIntolerance::Onset | allergy_intolerance | clinical_effective_date | |
| FamilyMemberHistory::Date | observation | clinical_effective_date | |
| Immunization::Date | observation | clinical_effective_date | |
| Specimen::Collection::Collected::ValueDateTime | observation | clinical_effective_date | |
| ReferralRequest::Date | referral_request | clinical_effective_date | |
| DiagnosticOrder::Event::DateTime | diagnostic_order | clinical_effective_date | |
| CERTAINTY | AllergyIntolerance::Reaction | - | - |
| SEVERITY | AllergyIntolerance::Reaction | - | - |
| LINKS | DiagnosticReport::Id * | ||
| Observation::Id * | |||
| Procedure::Id * | |||
| Condition::Id * | |||
| AllergyIntolerance::Id * | |||
| FamilyMemberHistory::Id * | |||
| Immunization::Id * | |||
| Specimen::Id * | |||
| ReferralRequest::Id * | |||
| DiagnosticOrder::Id * | |||
| SUBSET | MedicationStatement::AuthorizationTypeExtension | medication_statement | authorisation_type_concept_id |
| Used to determine FHIR resource | - | - | |
| DOCUMENT_ID | DiagnosticReport::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - |
| Observation::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
| Procedure::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
| Condition::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
| AllergyIntolerance::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
| FamilyMemberHistory::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
| Immunization::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
| Specimen::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
| ReferralRequest::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
| DiagnosticOrder::Identifier::Value (use=official, system=http://visionhealth.co.uk/identifier/document-guid) | - | - | |
Referrals
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| PID | ReferralRequest::patient_id | referral_request | patient_id |
| ID | ReferralRequest::id | referral_request | id |
| DATE | ReferralRequest::date | referral_request | clinical_effective_date |
| HCP | ReferralRequest::Requester | referral_request | practitioner_id |
| TO_HCP | ReferralRequest::Recipient | - | - |
| TYPE | ReferralRequest::Type::CodeableConcept | referral_request | referral_request_type_concept_id |
| LINKS | ReferralRequest:Encounter (reference -> Encounter resource) | referral_request | encounter_id |
Practice
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| ID | Organization::Id* | organization | id |
| Location::Id* | location | ||
| NAME | Organization::name | organization | Name |
| Location::Name | location | ||
| IDENTIFIER | Organization::Identifier::Value (use=official, system=ods-organization-code) | organization | ods_code |
| ADDRESS_1 | Organization::Address::Line
Location::Address::Line |
- | - |
| ADDRESS_2 | Organization::Address::Line
Location::Address::Line |
- | - |
| ADDRESS_3 | Organization::Address::Line
Location::Address::Line |
- | - |
| ADDRESS_4 | Organization::Address::City
Location::Address::City |
- | - |
| ADDRESS_5 | Organization::Address::District
Location::Address::District |
- | - |
| POSTCODE | Organization::Address::PostalCode | organization | Postcode |
| Location::Address::PostalCode | location | ||
| PHONE | Location::contactPoint::phone (use=work, system=phone) | - | - |
| Location::contactPoint::email (use=work, system=email) | - | - | |
| FAX | Location::contactPoint::fax (use=work, system=fax) | - | - |
Staff
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| HCP | Practitioner::Id* | practitioner | id |
| HCP_TYPE | Practitioner::Role::Role::Code | practitioner | role_code |
| Practitioner::Role::Role::Display | role_desc | ||
| GMP_CODE | Practitioner::Identifier::Value (system=gmp-ppd-code) | - | - |
| SURNAME | Practitioner::Name::Family | practitioner | name |
| FORENAME | Practitioner::Name::Given | practitioner | name |
| TITLE | Practitioner::Name::Prefix | practitioner | name |
| SERVICE_ID | Practitioner::Role::ManagingOrganisation::Reference * | practitioner | organization_id |