Vision GP Extract FHIR Mapping

From Discovery Data Service
Jump to navigation Jump to search

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’