Vision GP Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
Tag: Manual revert
 
Line 12: Line 12:
! scope="col" width="15%" |Field
! 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
|}
|}


Line 35: Line 159:
! scope="col" width="15%" |Field
! 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
|}
|}


Line 58: Line 213:
! scope="col" width="15%" |Field
! 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>)
| -
| -
|}
|}


Line 81: Line 734:
! scope="col" width="15%" |Field
! 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 ==
== Practice ==
Line 103: Line 781:
! scope="col" width="15%" |Field
! 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)
| -
| -
|}
|}


Line 126: Line 868:
! scope="col" width="15%" |Field
! 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
|}
|}

Latest revision as of 12:28, 3 August 2023

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
EMAIL 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) - -
EMAIL 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
Retrieved from ‘https://wiki.discoverydataservice.org/index.php?title=Vision_GP_Extract_FHIR_Mapping&oldid=6566’