View source for Vision GP Extract FHIR Mapping

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

== Patients ==

{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; 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
|-
|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
|-
|EMAIL
|Patient::Telecom::Value (use=home, system=email)
|patient_contact
|type_concept_id - value
|-
|PRACT_NUMBER
|Patient::Identifier::Value (use=secondary, system=<nowiki>http://visionhealth.co.uk/identifier/patient-number</nowiki>)
| -
| -
|-
|SERVICE_ID
|EpisodeOfCare ::ManagingOrganization::Reference *
|patient
|organization_id
|}

== Encounters ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; 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
|-
|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 ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; 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
|-
|PID
|Observation::PatientID
|Observation
|patient_id
|+
|-
|ID
|Observation::Id
|Observation
|id
|-
| rowspan="10" |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
|-
| rowspan="10" |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
|-
| rowspan="10" |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
|-
| rowspan="10" |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
|-
| rowspan="10" |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
| -
| -
|-
| rowspan="11" |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
|-
| rowspan="2" |END_DATE
|Condition::Abaintment
|observation
|problem_end_date
|-
|MedicationStatement::MedicationAuthorizationCancellation
|medication_statement
|cancellation_date
|-
| rowspan="10" |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
| -
| -
|-
| rowspan="10" |LINKS
|DiagnosticReport::Id *
|
|
|-
|Observation::Id *
|
|
|-
|Procedure::Id *
|
|
|-
|Condition::Id *
|
|
|-
|AllergyIntolerance::Id *
|
|
|-
|FamilyMemberHistory::Id *
|
|
|-
|Immunization::Id *
|
|
|-
|Specimen::Id *
|
|
|-
|ReferralRequest::Id *
|
|
|-
|DiagnosticOrder::Id *
|
|
|-
| rowspan="2" |SUBSET
|MedicationStatement::AuthorizationTypeExtension
|medication_statement
|authorisation_type_concept_id
|-
|Used to determine FHIR resource
| -
| -
|-
| rowspan="10" |DOCUMENT_ID
|DiagnosticReport::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|Observation::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|Procedure::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|Condition::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|AllergyIntolerance::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|FamilyMemberHistory::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|Immunization::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|Specimen::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|ReferralRequest::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|-
|DiagnosticOrder::Identifier::Value (use=official, system=<nowiki>http://visionhealth.co.uk/identifier/document-guid</nowiki>)
| -
| -
|}

== Referrals ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; 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
|-
|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 ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; 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
|-
| rowspan="2" |ID
|Organization::Id*
|organization
| rowspan="2" |id
|-
|Location::Id*
|location
|+
|-
| rowspan="2" |NAME
|Organization::name
|organization
| rowspan="2" |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
| -
| -
|-
| rowspan="2" |POSTCODE
|Organization::Address::PostalCode
|organization
| rowspan="2" |Postcode
|-
|Location::Address::PostalCode
|location
|-
|PHONE
|Location::contactPoint::phone  (use=work, system=phone)
| -
| -
|-
|EMAIL
|Location::contactPoint::email (use=work, system=email)
| -
| -
|-
|FAX
|Location::contactPoint::fax (use=work, system=fax)
| -
| -
|}

== Staff ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; 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
|-
|HCP
|Practitioner::Id*
|practitioner
|id
|+
|-
| rowspan="2" |HCP_TYPE
|Practitioner::Role::Role::Code
| rowspan="2" |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
|}