TPP Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
 
(59 intermediate revisions by 2 users not shown)
Line 1: Line 1:
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]].
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]].
== SRAppointment ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Appointment::Id
|appointment
|id
|+
|-
|DateStart
|Appointment::Start 
Slot::Start
|appointment
|start_date
|-
|DateEnd
|Appointment::end
Slot::end
| -
| -
|-
|AppointmentStatus
|Appointment::Status (=Value)
|appointment
|appointment_status_concept_id
|-
|DateAppointmentBooked
|Appointment::appointment-booking-date-extension::DateValue*
| -
| -
|-
|DatePatientArrival
|Appointment::primarycare-appointment-sent-in-extension::DateTimeValue
Appointment::Status (=Arrived)
|appointment
|date_time_sent_in
appointment_status_concept_id
|-
|DatePatientSeen
|Appointment::primarycare-appointment-left-extension::DateTimeValue
Appointment::Status (=Fulfilled)
|appointment
|date_time_left
appointment_status_concept_id
|-
|TelephoneAppointment
|Appointment::Type::Value
|appointment_additional
|property_id  (type), text
|-
|IDProfileClinician
|Schedule::primarycare-recorded-by-extension::ReferenceValue*
| -
| -
|-
|DateAppointmentCancelled
|Appointment::appointment-cancellation-date-extension::DateValue*
| -
| -
|-
|IDRota
|Slot::Schedule::Reference *
|appointment
|schedule_id
|-
|IDPatient
|Appointment::Participant::Reference  *
|appointment
|patient_id
|-
|RemovedData
| -
| -
| -
|}
== SRCCG ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Organization::Id*
|organization
|id
|+
|Name
|Organization::Name
|organization
|name
|-
|OdsCode
|Organization::Identifier::Value  (use=official, system=ods-organization-code)
|organization
|ods_code
|-
|HouseName
|Organization::Address::Line
| -
| -
|-
|HouseNumber
|Organization::Address::Line
| -
| -
|-
|NameOfRoad
|Organization::Address::Line
| -
| -
|-
|NameOfLocality
|Organization::Address::Line
| -
| -
|-
|NameOfTown
|Organization::Address::City
| -
| -
|-
|NameOfCounty
|Organization::Address::District
| -
| -
|-
|FullPostCode
|Organization::Address::PostalCode
|organization
|postcode
|-
|Telephone
|Organization::Telecom  (use=work, system=phone)
| -
| -
|-
|SecondaryTelephone
|Organization::Telecom  (use=work, system=phone)
| -
| -
|-
|Fax
|Organization::Telecom  (use=work, system=fax)
| -
| -
|-
|RemovedData
| -
| -
| -
|}
== SRCode ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|AllergyIntolerance::id 
Procedure::id
Condition::id
 Observation::id
 FamilyMemberHistory::id
|Allergy_Intolerance
 Procedure_Request
 Observation
|id
|+
|DateEventRecorded
|AllergyIntolerance::recordedDate
 Procedure::recordedDate
Condition::recordedDate
 Observation::recordedDate
 FamilyMemberHistory::recordedDate
|Allergy_Intolerance 
Procedure_Request
Observation
|date_recorded
|-
|DateEvent
|AllergyIntolerance::onset
 Procedure::onset
Condition::onset
Observation::onset
FamilyMemberHistory::onset
|Allergy_Intolerance 
Procedure_Request
Observation
|clinical_effective_date
|-
|IDProfileEnteredBy
|AllergyIntolerance::extension::primarycare-recorded-by-extension  Condition::extension::primarycare-recorded-by-extension  Procedure::extension::primarycare-recorded-by-extension  Observation::extension::primarycare-recorded-by-extension FamilyMemberHistory::extension::primarycare-recorded-by-extension
| -
| -
|-
|IDDoneBy
|AllergyIntolerance::recorder
Procedure::recorder
Condition::asserter
Observation::performer
FamilyMemberHistory::primarycare-family-member-history-reporter-extension
|Allergy_Intolerance 
Procedure_Request 
Observation
|practitioner_id
|-
|CTV3Code
|AllergyIntolerance::substance::coding::readv2::code  FamilyMemberHistory::category::coding::readv2::code  Observation::code::coding::readv2::code
Condition::category::coding::code
 Procedure::code::coding::code
| -
| -
|-
|CTV3Text
|AllergyIntolerance::substance::coding::readv2::display  FamilyMemberHistory::category::coding::readv2::display  Observation::code::coding::readv2::display  Condition::category::coding::readv2::display  Procedure::code::coding::readv2::display
| -
| -
|-
|SNOMEDCode
|AllergyIntolerance::substance::coding::sct::code  FamilyMemberHistory::category::coding::sct::code  Observation::code::coding::sct::code
 Condition::category::coding::sct::code
 Procedure::code::coding::sct::code
| -
| -
|-
|SNOMEDText
|AllergyIntolerance::substance::coding::sct::display  FamilyMemberHistory::category::coding::sct::display  Observation::code::coding::sct::display
 Condition::category::coding::sct::display 
Procedure::code::coding::sct::display
| -
| -
|-
|NumericComparator
|Observation::valueNumberComparator
| -
| -
|-
|NumericValue
|Observation::valueNumber
|Observation
|result_value
|-
|NumericUnit
|Observation::valueUnits
|Observation
|result_value_units
|-
|EpisodeType
|Condition::extension::primarycare-problem-episodicity
|Observation
|episodicity_concept_id
|-
|IDEvent
|Condition::encounter
 Observation::encounter
 AllergyIntolerance::encounter
 Procedure::encounter
 FamilyMemberHistory::encounter
|AllergyIntolerance 
Procedure
Condition
Observation
FamilyMemberHistory
|encounter_id
|-
|IDPatient
|Condition::patient
 Procedure::patient
 AllergyIntolerance::patient
 Observation::patient
 FamilyMemberHistory::patient
|AllergyIntolerance
 Procedure
 Condition
 Observation
 FamilyMemberHistory
|patient_id
|-
|RemovedData
| -
| -
| -
|}
== SRDrugSensitivity ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|AllergyIntolerance::id
|allergy_intolerance
|id
|+
|DateEventRecorded
|AllergyIntolerance::recordedDate
|allergy_intolerance
|date_recorded
|-
|IDProfileEnteredBy
|AllergyIntolerance::extension::primarycare-recorded-by-extension
| -
| -
|-
|IDDoneBy
|AllergyIntolerance::recorder
|allergy_intolerance
|practitioner_id
|-
|DateStarted
|AllergyIntolerance::onset
|allergy_intolerance
|clinical_effective_date
|-
|DateEnded
|AllergyIntolerance::lastOccurance
| -
| -
|-
|IDDrugCode
|AllergyIntolerance::allergy_intolerance_main_code::coding::code
|allergy_intolerance
|non_core_concept_id
|-
|IDMultiLexAction
|AllergyIntolerance::code_system_tpp_drug_action_group::coding::display
|allergy_intolerance
|core_concept_id
|-
|IDEvent
|AllergyIntolerance::encounter
|allergy_intolerance
|encounter_id
|-
|IDPatient
|AllergyIntolerance::patient
|allergy_intolerance
|patient_id
|-
|NameOfMedication
|AllergyIntolerance::code_system_tpp_drug_action_group::text
| -
| -
|-
|RemovedData
| -
| -
| -
|}
== SREvent ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Encounter::id
|Encounter
|id
|+
|DateEventRecorded
|Encounter::extension::primarycare-recorded-date-extension
|Encounter
|date_recorded
|-
|DateEvent
|Encounter::period::start
|Encounter
|clinical_effective_date
|-
|IDProfileEnteredBy
|Encounter::extension::primarycare-recorded-by-extension
| -
| -
|-
|IDDoneBy
|Encounter::participant::individual
|Encounter
|practitioner_id
|-
|IDOrganisationDoneAt
|Encounter::serviceProvider
|Encounter
|service_provider_organisation_id
|-
|ContactEventLocation
|Encounter::extension::encounter-location-type-extension::valueCodeableConcept::text
|Encounter
|core_concept_id
|-
|ContactMethod
|Encounter::extension::primarycare-encounter-source::valueCodeableConcept::text
| -
| -
|-
|EventIncomplete
|Encounter::extension::primarycare-encounter-incomplete::value
| -
| -
|-
|ClinicalEvent
|Encounter::extension::primarycare-encounter-source::valueCodeableConcept::text
| -
| -
|-
|IDPatient
|Encounter::patient
|Encounter
|patient_id
|-
|IDOrganisation
|Encounter::location::location
|Encounter
|organization_id
|-
|IDBranch
|Encounter::location::location
| -
| -
|-
|RemovedData
| -
| -
| -
|}
== SRImmunisation ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Immunization::id
|Observation
|id
|+
|DateEventRecorded
|Immunization::extension::primarycare-recorded-date-extension
|Observation
|date_recorded
|-
|DateEvent
|Immunization::date
|Observation
|clinical_effective_date
|-
|IDProfileEnteredBy
|Immunization::primarycare-recorded-by-extension::valueReference
| -
| -
|-
|IDDoneBy
|Immunization::performer::reference
|Observation
|practitoner_id
|-
|IDImmunisationContent
|Immunization::vaccinationProtocol::series
| -
| -
|-
|Dose
|Immunization::doseQuantity
| -
| -
|-
|Location
|Immunization::immunizationSite::text
| -
| -
|-
|Method
|Immunization::immunizationRoute::text
| -
| -
|-
|DateExpiry
|Immunization::expirationDate
| -
| -
|-
|ImmsReadCode
|Immunization::vaccineCode::coding::readv2::code
|Observation
|core_concept_id
non_core_concept_id
|-
|ImmsSNOMEDCode
|Immunization::vaccineCode::coding::snomed::code
|Observation
|core_concept_id
non_core_concept_id
|-
|VaccPart
|Immunization::vaccinationProtocol::doseSequence
Immunization::vaccinationProtocol::description
| -
| -
|-
|VaccBatchNumber
|Immunization::lotNumber
| -
| -
|-
|IDEvent
|Immunization::encounter::reference
|Observation
|encounter_id
|-
|IDPatient
|Immunization::patient::reference
|Observation
|patient_id
|-
|RemovedData
| -
| -
| -
|}
== SROrganisation ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Organization::Id*
|organization
|id
|+
|-
|Name
|Organization::name
|organization
|Name
|-
|ID
|Organization::Identifier::Value  (use=official, system=ods-organization-code)
|organization
|ods_code
|-
|HouseName
|Organization::Address::Line
| -
| -
|-
|HouseNumber
|Organization::Address::Line
| -
| -
|-
|NameOfRoad
|Organization::Address::Line
| -
| -
|-
|NameOfLocality
|Organization::Address::Line
| -
| -
|-
|NameOfTown
|Organization::Address::City
| -
| -
|-
|NameOfCounty
|Organization::Address::District
| -
| -
|-
|FullPostCode
|Organization::Address::PostalCode
|organization
|postcode
|-
|Telephone
|Organization::Telecom  (use=work, system=phone)
| -
| -
|-
|SecondaryTelephone
|Organization::Telecom  (use=work, system=phone)
| -
| -
|-
|Fax
|Organization::Telecom  (use=work, system=fax)
| -
| -
|-
|IDTrust
|Organization::PartOf::Reference  *
|organization
|parent_organization_id
|-
|IDCcg
|Organization::PartOf::Reference  *
|organization
|parent_organization_id
|-
|RemovedData
| -
| -
| -
|}
== SROrganisationBranch ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
Line 10: Line 663:
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|RowIdentifier
|location::id
|location
|id
|+
|BranchName
|location::name
|location
|name
|-
|HouseName
|location::address::line
|location
|
|
|-
|HouseNumber
|location::address::line
|location
|
|
|-
|RoadName
|location::address::line
|location
|
|
|-
|Locality
|location::address::line
|location
|
|
|+
|-
|-
|Town
|location::address::city
|location
|
|
|-
|County
|location::address::district
|location
|
|
|-
|PostCode
|location::address::postalcode
|location
|postcode
|-
|BranchObsolete
|location::status
|location
|
|
|-
|IDOrganisation
|location::managingOrganization.reference
|location
|managing_organization
|}
== SRPatient ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Patient::Id*
|patient
|id
|+
|Title
|Patient::Name::Prefix  (use=official)
|patient
|title
|-
|FirstName
|Patient::Name::Given
|patient
|first_names
|-
|MiddleNames
|Patient::Name::Given
|patient
|first_names
|-
|Surname
|Patient::Name::Family
|patient
|last_name
|-
|NHSNumber
|Patient::Identifier::Value  (use=official, system=nhs-number)
|patient
|nhs_number
|-
|DateBirth
|Patient::BirthDate
|patient
|date_of_birth
|-
|DateDeath
|Patient::Deceased
|patient
|date_of_death
|-
|Gender
|Patient::Gender
|patient
|gender_concept_id
|-
|SpeaksEnglish
|Patient::patient-speaks-english-extension::ValueBoolean  (extension is only created if value is true)
| -
| -
|-
|EmailAddress
|Patient::contactPoint::email  (use=home, system=email)
|patient_contact
|type_concept_id -  value
|-
|TestPatient
|Patient::patient-is-test-patient-extension::ValueBoolean  (extension is only created if value is true)
| -
| -
|-
|SpineMatched
|Patient::extension::primarycare-nhs-number-verification-status-extension
| -
| -
|-
|RemovedData
| -
| -
| -
|}
== SRPatientAddressHistory ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|+
|-
|IDOrganisationVisibleTo
|Patient::managingOrganisation
|patient
|registered_practice_organization_id
|-
|DateEvent
|Patient::Address::Period.start
|patient_address
|start_date
|-
|NameOfBuilding
|Patient::Address::Line
|patient_address
|address_line_1
|-
|NumberOfBuilding
|Patient::Address::Line
|patient_address
|address_line_1
|-
|NameOfRoad
|Patient::Address::Line
|patient_address
|address_line_2
|-
|NameOfLocality
|Patient::Address::Line
|patient_address
|address_line_3
|-
|NameOfTown
|Patient::Address::City
|patient_address
|city
|-
|NameOfCounty
|Patient::Address::District
|patient_address
|address_line_4
|-
|FullPostCode
|Patient::Address::PostalCode
|patient_address
|postcode
|-
|DateTo
|Patient::Address::Period.end
|patient_address
|end_date
|-
|AddressType
|Patient::Address::Use  (temp, home,old)
|patient_address
|use_concept_id
|}
== SRPatientContactDetails ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Patient::id
|Patient
|id
|+
|DateEvent
|Patient::contact:period.startDate
|patient_contact
|start_date
|-
|ContactType
|Patient::contact::telecom
|patient_contact
|
|-
|ContactNumber
|Patient::contact::telecom.value
|patient_contact
|value
|-
|IDPatient
|Patient::id
|Patient
|id
|}
== SRPatientRegistration ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|EpisodeOfCare::id
|episode_of_care
|id
|+
|-
|IDOrganisationVisibleTo
|EpisodeOfCare::managingOrganization.reference
|episode_of_care
|organisation_id
|-
|DateRegistration
|EpisodeOfCare::period.start
|episode_of_care
|date_registered
|-
|DateDeRegistration
|EpisodeOfCare::period.end
|episode_of_care
|date_registered_end
|-
|RegistrationStatus
|EpisodeOfCare::extension
|episode_of_care
|registration_status_concept_id
|-
|IDPatient
|EpisodeOfCare::patient.reference
|episode_of_care
|patient_id
|-
|IDOrganisation
| -
| -
| -
|-
|RemovedData
| -
| -
| -
|}
== SRPatientRelationship ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Patient::contact::id
|n/a
|n/a
|+
|DateEvent
|Patient::contact::period.start
|n/a
|n/a
|-
|DateEnded
|Patient::contact::period.end
|n/a
|n/a
|-
|RelationshipType
|Patient::contact::relationship
|n/a
|n/a
|-
|NextOfKin
|Patient::contact::extension::patient-contact-is-next-of-kin
|n/a
|n/a
|-
|CaresForPatient
|Patient::contact::extension::patient-contact-is-carer
|n/a
|n/a
|-
|PrincipalCarerForPatient
|Patient::contact::extension::patient-contact-is-carer
|n/a
|n/a
|-
|RelationshipWithName
|Patient::contact::name
|n/a
|n/a
|-
|RelationshipWithHouseName
|Patient::contact::address.line
|n/a
|n/a
|-
|RelationshipWithHouseNumber
|Patient::contact::address.line
|n/a
|n/a
|-
|RelationshipWithRoad
|Patient::contact::address.line
|n/a
|n/a
|-
|RelationshipWithLocality
|Patient::contact::address.line
|n/a
|n/a
|-
|RelationshipWithPostTown
|Patient::contact::address.city
|n/a
|n/a
|-
|RelationshipWithCounty
|Patient::contact::address.district
|n/a
|n/a
|-
|RelationshipWithPostCode
|Patient::contact::address.postalcode
|n/a
|n/a
|-
|RelationshipWithTelephone
|Patient::contact::telecom
|n/a
|n/a
|-
|RelationshipWithWorkTelephone
|Patient::contact::telecom
|n/a
|n/a
|-
|RelationshipWithMobileTelephone
|Patient::contact::telecom
|n/a
|n/a
|-
|RelationshipWithFax
|Patient::contact::telecom
|n/a
|n/a
|-
|RelationshipWithEmailAddress
|Patient::contact::telecom
|n/a
|n/a
|-
|IDPatient
|Patient::id
|n/a
|n/a
|-
|RemovedData
|
|
|n/a
|n/a
|}
== SRPersonAtRisk ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Flag::id
|Flag
|id
|+
|DateAdded
|Flag::extension::primarycare-recorded-date-time-extension::valueDateTime
|Flag
|effective_date
|-
|IDProfileEnteredBy
|Flag::author::reference
| -
| -
|-
|ProtectionPlan
|Flag::status
|Flag
|is_active
|-
|DateRemoved
|Flag::period::end
| -
| -
|-
|IDPatient
|Flag::patient::reference
|Flag
|patient_id
|-
|ReasonForPlan
|Flag::code::text
|Flag
|flag_text
|-
|RemovedData
| -
| -
| -
|}
|}


== SRPrimaryCareMedication ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |'''Publisher'''
Line 32: Line 1,144:
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|RowIdentifier
|MedicationOrder::id
MedicationStatement::id
|medication_order
medication_statement
|id
|+
|DateEventRecorded
|MedicationOrder::extension::primarycare-recorded-date-extension::valueReference  MedicationStatement::extension::primarycare-recorded-date-extension::valueReference
| -
| -
|-
|IDProfileEnteredBy
|MedicationOrder::extension::primarycare-recorded-by-extension::valueReference  MedicationStatement::extension::primarycare-recorded-by-extension::valueReference
| -
| -
|-
|IDDoneBy
|MedicationOrder::prescriber::reference
MedicationStatement::informationSource::reference
|medication_order
medication_statement
|practitoner_id
|-
|IDMultiLexDMD
|MedicationStatement::medicationCodeableConcept::coding::code  MedicationOrder::medicationCodeableConcept::coding:code
| -
| -
|-
|NameOfMedication
|MedicationStatement::medicationCodeableConcept::coding::display  MedicationOrder::medicationCodeableConcept::coding:display
|medication_order
medication_statement
|core_concept_id
|-
|DateMedicationStart
|MedicationStatement::dateAsserted
MedicationStatement::dateWritten
|medication_order
medication_statement
|clinical_effective_date
|-
|DateMedicationEnd
|MedicationStatement::extension::primarycare-medication-authorisation-cancellation-extension::valueReference
|medication_statement
|cancellation_date
|-
|MedicationDosage
|MedicationStatement::dosage::text
MedicationOrder::dosageInstruction::text
|medication_order
medication_statement
|dose
|-
|MedicationQuantity
|MedicationStatement::extension::primarycare-medication-authorisation-quantity-extension::valueQuantity
MedicationOrder::dispenseRequest::quantity
|medication_order
medication_statement
|quantity_value
|-
|IsRepeatMedication
|MedicationStatement::primarycare-medication-autorisation-type-extension::valueCoding::display
| -
| -
|-
|IDEvent
|MedicationStatement::encounter::reference
MedicationOrder::encounter::reference
|medication_order
medication_statement
|encounter_id
|-
|IDPatient
|MedicationStatement::patient::reference
MedicationOrder::patient::reference
|medication_order
medication_statement
|patient_id
|-
|RemovedData
| -
| -
| -
|}
== SRProblem ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|DateEnd
|Condition::abatementDate
|Observation
|problem_end_date
|+
|-
|Severity
|Condition::extension::primarycare-problem-significance-extension::value
| -
| -
|}
== SRRecall ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|ProcedureRequest::id
|procedure_request
|id
|+
|DateEventRecorded
|ProcedureRequest::orderedOn
|procedure_request
|clinical_effective_date
|-
|IDProfileEnteredBy
|ProcedureRequest::orderer::reference
| -
| -
|-
|IDDoneBy
|ProcedureRequest::performer::reference
|procedure_request
|practitioner_id
|-
|DateRecall
|ProcedureRequest::scheduledDateTime
| -
| -
|-
|RecallType
|ProcedureRequest::notes::text
| -
| -
|-
|RecallStatus
|ProcedureRequest::status
|procedure_request
|status_concept_id
|-
|RecallStatusDate
|ProcedureRequest::code::coding::text
|procedure_request
|core_concept_id
|-
|IDEvent
|ProcedureRequest::encounter
|procedure_request
|encounter_id
|-
|IDPatient
|ProcedureRequest::subject::reference
|procedure_request
|patient_id
|}
== SRReferralOut ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|ReferralRequest::id
|referral_request
|id
|+
|DateEventRecorded
|ReferralRequest::extension::valuedatetime
|referral_request
|date_recorded
|-
|DateEvent
|ReferralRequest::date
|referral_request
|clinical_effective_date
|-
|IDProfileEnteredBy
|ReferralRequest::extension::valuereference::reference
|referral_request
|practitioner_id
|-
|IDDoneBy
|ReferralRequest::requester.reference
|referral_request
|
|-
|IDOrganisationDoneAt
|ReferralRequest::requester.reference
|referral_request
|requester_organization_id
|-
|TypeOfReferral
|ReferralRequest::extension::<nowiki>http://endeavourhealth.org/fhir/StructureDefinition/referral-request-recipient-service-type-extension</nowiki>
|referral_request
|
|-
|Reason
|ReferralRequest::type.text
|referral_request
|referral_request_type_concept_id
|-
|IDProfileReferrer
|ReferralRequest::requester.reference
|
|
|-
|ServiceOffered
|ReferralRequest::extension::<nowiki>http://endeavourhealth.org/fhir/StructureDefinition/referral-request-recipient-service-type-extension</nowiki>
|
|
|-
|Urgency
|ReferralRequest::CodeableConcept::(Referral_Request_Priority)
|referral_request
|referral_request_type_concept_id
|-
|PrimaryDiagnosis
|ReferralRequest::CodeableConcept::(Referral_Request_Service)
|
|
|
|
|-
|SNOMEDPrimaryDiagnosis
|ReferralRequest::CodeableConcept::(Referral_Request_Service)
|
|
|
|
|+
|-
|-
|RecipientID
|ReferralRequest::extension::url::<nowiki>http://endeavourhealth.org/fhir/StructureDefinition/referral-request-recipient-free-text-extension</nowiki>
|
|
|
|
|-
|RecipientIDType
|ReferralRequest::extension::url::<nowiki>http://endeavourhealth.org/fhir/StructureDefinition/referral-request-recipient-free-text-extension</nowiki>
|
|
|
|
|-
|IDEvent
|ReferralRequest::encounter.reference
|referral_request
|encounter_id
|-
|IDPatient
|ReferralRequest::patient
|referral_request
|patient_id
|}
== SRRepeatTemplate ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|MedicationStatement::id
|medication_statement
|id
|+
|DateEventRecorded
|MedicationStatement::extension::primarycare-recorded-date-extension::valueDate
| -
| -
|-
|DateEvent
|MedicationStatement::dateAsserted
|medication_statement
|clinical_effective_date
|-
|IDProfileEnteredBy
|MedicationStatement::extension::primarycare-recorded-by-extension::valueReference
| -
| -
|-
|IDDoneBy
|MedicationStatement::informationSource::reference
|medication_statement
|practitoner_id
|-
|IDMultiLexDMD
|MedicationStatement::medicationCodeableConcept::coding::code
| -
| -
|-
|NameOfMedication
|MedicationStatement::medicationCodeableConcept::coding::display
|medication_statement
|core_concept_id
|-
|DateMedicationTemplateEnd
|MedicationStatement::extension::primarycare-medication-authorisation-cancellation-extension::valueDate
|medication_statement
|cancellation_date
|-
|MedicationDosage
|MedicationStatement::dosage::text
|medication_statement
|dose
|-
|MedicationQuantity
|MedicationStatement::extension::primarycare-medication-authorisation-quantity-extension
|medication_statement
|quantity_value
quantity_unit
|-
|MaxIssues
|MedicationStatement::extension::primarycare-medication-authorisation-numberofrepeatsallowed-extension
| -
| -
|-
|IDEvent
|MedicationStatement::encounter::reference
|medication_statement
|encounter_id
|-
|IDPatient
|MedicationStatement::patient::reference
|medication_statement
|patient_id
|-
|RemovedData
| -
| -
| -
|}
== SRRota ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Schedule::id
|Schedule
|id
|+
|DateCreation
|Schedule::extension::primarycare-recorded-date-extension
| -
| -
|-
|IDProfileCreatedBy
|Schedule::extension::primarycare-recorded-by-extension
|Schedule
|practitioner_id
|-
|Name
|Schedule::extension::primarycare-schedule-name-extension
|Schedule
|name
|-
|RotaType
|Schedule::type::text
|Schedule
|type
|-
|Location
|Schedule::extension::primarycare-location-type-extension
|Schedule
Schedule_additional*
Schedule_additional*
|location
id*
property_id*
|-
|DateStart
|Schedule::planningHorizon::start
|Schedule
|start_date
|-
|IDBranch
|Schedule::extension::primarycare-location-extension
|Schedule
|location
|-
|RemovedData
| -
| -
| -
|}
<nowiki>*</nowiki>Note: Only populated when both Location and IDBranch present in the data.
== SRSpecialNotes ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Flag::id
|Flag
|id
|+
|IDProfileEnteredBy
|Flag::author::reference
| -
| -
|-
|DateStart
|Flag::period::start
|Flag
|effective_date
|-
|Type
|Flag::category::text
| -
| -
|-
|Note
|Flag::code:text
|Flag
|flag_text
|-
|DateExpired
|Flag::period::end
| -
| -
|-
|IDPatient
|Flag::subject::reference
|Flag
|patient_id
|}
== SRStaffMember ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Practitioner::Id*
|practitioner
|id
|+
|-
|StaffName
|Practitioner::Name::Given
Practitioner::Name::Family
|practitioner
|name
|-
|StaffUserName
| -
| -
| -
|-
|NationalIdType
|Practitioner::Identifier::Value (system=gmc-number)
| -
| -
|-
|IDNational
|Practitioner::Identifier::Value (system=gmc-number)
|practitioner
|gmc_code
|-
|IDSmartCard
|Practitioner::Identifier::Value  (system=<nowiki>http://tpp-uk.com/identifier/staff-smartcard-id</nowiki>)
| -
| -
|-
|Obsolete
| -
| -
| -
|-
|RemovedData
| -
| -
| -
|}
== SRTrust ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIdentifier
|Organization::Id*
|organization
|id
|+
|Name
|Organization::Name
|organization
|name
|-
|OdsCode
|Organization::Identifier::Value  (use=official, system=ods-organization-code)
|organization
|ods_code
|-
|HouseName
|Organization::Address::Line
| -
| -
|-
|HouseNumber
|Organization::Address::Line
| -
| -
|-
|NameOfRoad
|Organization::Address::Line
| -
| -
|-
|NameOfLocality
|Organization::Address::Line
| -
| -
|-
|NameOfTown
|Organization::Address::City
| -
| -
|-
|NameOfCounty
|Organization::Address::District
| -
| -
|-
|FullPostCode
|Organization::Address::PostalCode
|organization
|postcode
|-
|Telephone
|Organization::Telecom  (use=work, system=phone)
| -
| -
|-
|SecondaryTelephone
|Organization::Telecom  (use=work, system=phone)
| -
| -
|-
|Fax
|Organization::Telecom  (use=work, system=fax)
| -
| -
|-
|RemovedData
| -
| -
| -
|}
== SRVisit ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; 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
|-
|RowIden
|Appointment::id
Slot::id
Schedule::id
|Appointment
Schedule
|id
|+
|IDProfileEnteredBy
|Appointment::extension::primarycare-recorded-by-extension::valueReference
Schedule::extension::primarycare-recorded-by-extension::valueReference
| -
| -
|-
|DateBooked
|Appointment::extension::appointment-booking-date-extension::valueDate
Schedule::extension::primarycare-recorded-date-extension::valueDate
| -
| -
|-
|DateRequested
|Appointment::start
Schedule::planningHorizon::start
Slot::start
|Appointment
Schedule
|start_date
|-
|CurrentStatus
|Appointment::status
|Appointment
|appointment_status_id_concept
|-
|FollowUpDetails
|Appointment::comment
| -
| -
|-
|IDPatient
|Appointment::participant::actor::reference
|Appointment
|patient_id
|-
|Duration
|Schedule::planningHorizon::end
Appointment::end
Slot::end
|Appointment
|planned_duration
|}
|}

Latest revision as of 10:22, 12 October 2023

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

SRAppointment

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Appointment::Id appointment id
DateStart Appointment::Start

Slot::Start

appointment start_date
DateEnd Appointment::end

Slot::end

- -
AppointmentStatus Appointment::Status (=Value) appointment appointment_status_concept_id
DateAppointmentBooked Appointment::appointment-booking-date-extension::DateValue* - -
DatePatientArrival Appointment::primarycare-appointment-sent-in-extension::DateTimeValue

Appointment::Status (=Arrived)

appointment date_time_sent_in

appointment_status_concept_id

DatePatientSeen Appointment::primarycare-appointment-left-extension::DateTimeValue

Appointment::Status (=Fulfilled)

appointment date_time_left

appointment_status_concept_id

TelephoneAppointment Appointment::Type::Value appointment_additional property_id (type), text
IDProfileClinician Schedule::primarycare-recorded-by-extension::ReferenceValue* - -
DateAppointmentCancelled Appointment::appointment-cancellation-date-extension::DateValue* - -
IDRota Slot::Schedule::Reference * appointment schedule_id
IDPatient Appointment::Participant::Reference * appointment patient_id
RemovedData - - -

SRCCG

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Organization::Id* organization id
Name Organization::Name organization name
OdsCode Organization::Identifier::Value (use=official, system=ods-organization-code) organization ods_code
HouseName Organization::Address::Line - -
HouseNumber Organization::Address::Line - -
NameOfRoad Organization::Address::Line - -
NameOfLocality Organization::Address::Line - -
NameOfTown Organization::Address::City - -
NameOfCounty Organization::Address::District - -
FullPostCode Organization::Address::PostalCode organization postcode
Telephone Organization::Telecom (use=work, system=phone) - -
SecondaryTelephone Organization::Telecom (use=work, system=phone) - -
Fax Organization::Telecom (use=work, system=fax) - -
RemovedData - - -

SRCode

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier AllergyIntolerance::id

Procedure::id Condition::id  Observation::id  FamilyMemberHistory::id

Allergy_Intolerance

 Procedure_Request  Observation

id
DateEventRecorded AllergyIntolerance::recordedDate

 Procedure::recordedDate Condition::recordedDate  Observation::recordedDate  FamilyMemberHistory::recordedDate

Allergy_Intolerance

Procedure_Request Observation

date_recorded
DateEvent AllergyIntolerance::onset

 Procedure::onset Condition::onset Observation::onset FamilyMemberHistory::onset

Allergy_Intolerance

Procedure_Request Observation

clinical_effective_date
IDProfileEnteredBy AllergyIntolerance::extension::primarycare-recorded-by-extension Condition::extension::primarycare-recorded-by-extension Procedure::extension::primarycare-recorded-by-extension Observation::extension::primarycare-recorded-by-extension FamilyMemberHistory::extension::primarycare-recorded-by-extension - -
IDDoneBy AllergyIntolerance::recorder

Procedure::recorder Condition::asserter Observation::performer FamilyMemberHistory::primarycare-family-member-history-reporter-extension

Allergy_Intolerance

Procedure_Request  Observation

practitioner_id
CTV3Code AllergyIntolerance::substance::coding::readv2::code FamilyMemberHistory::category::coding::readv2::code Observation::code::coding::readv2::code

Condition::category::coding::code  Procedure::code::coding::code

- -
CTV3Text AllergyIntolerance::substance::coding::readv2::display FamilyMemberHistory::category::coding::readv2::display Observation::code::coding::readv2::display Condition::category::coding::readv2::display Procedure::code::coding::readv2::display - -
SNOMEDCode AllergyIntolerance::substance::coding::sct::code FamilyMemberHistory::category::coding::sct::code Observation::code::coding::sct::code

 Condition::category::coding::sct::code  Procedure::code::coding::sct::code

- -
SNOMEDText AllergyIntolerance::substance::coding::sct::display FamilyMemberHistory::category::coding::sct::display Observation::code::coding::sct::display

 Condition::category::coding::sct::display Procedure::code::coding::sct::display

- -
NumericComparator Observation::valueNumberComparator - -
NumericValue Observation::valueNumber Observation result_value
NumericUnit Observation::valueUnits Observation result_value_units
EpisodeType Condition::extension::primarycare-problem-episodicity Observation episodicity_concept_id
IDEvent Condition::encounter

 Observation::encounter  AllergyIntolerance::encounter  Procedure::encounter  FamilyMemberHistory::encounter

AllergyIntolerance

Procedure Condition Observation FamilyMemberHistory

encounter_id
IDPatient Condition::patient

 Procedure::patient  AllergyIntolerance::patient  Observation::patient  FamilyMemberHistory::patient

AllergyIntolerance

 Procedure  Condition  Observation  FamilyMemberHistory

patient_id
RemovedData - - -

SRDrugSensitivity

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier AllergyIntolerance::id allergy_intolerance id
DateEventRecorded AllergyIntolerance::recordedDate allergy_intolerance date_recorded
IDProfileEnteredBy AllergyIntolerance::extension::primarycare-recorded-by-extension - -
IDDoneBy AllergyIntolerance::recorder allergy_intolerance practitioner_id
DateStarted AllergyIntolerance::onset allergy_intolerance clinical_effective_date
DateEnded AllergyIntolerance::lastOccurance - -
IDDrugCode AllergyIntolerance::allergy_intolerance_main_code::coding::code allergy_intolerance non_core_concept_id
IDMultiLexAction AllergyIntolerance::code_system_tpp_drug_action_group::coding::display allergy_intolerance core_concept_id
IDEvent AllergyIntolerance::encounter allergy_intolerance encounter_id
IDPatient AllergyIntolerance::patient allergy_intolerance patient_id
NameOfMedication AllergyIntolerance::code_system_tpp_drug_action_group::text - -
RemovedData - - -

SREvent

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Encounter::id Encounter id
DateEventRecorded Encounter::extension::primarycare-recorded-date-extension Encounter date_recorded
DateEvent Encounter::period::start Encounter clinical_effective_date
IDProfileEnteredBy Encounter::extension::primarycare-recorded-by-extension - -
IDDoneBy Encounter::participant::individual Encounter practitioner_id
IDOrganisationDoneAt Encounter::serviceProvider Encounter service_provider_organisation_id
ContactEventLocation Encounter::extension::encounter-location-type-extension::valueCodeableConcept::text Encounter core_concept_id
ContactMethod Encounter::extension::primarycare-encounter-source::valueCodeableConcept::text - -
EventIncomplete Encounter::extension::primarycare-encounter-incomplete::value - -
ClinicalEvent Encounter::extension::primarycare-encounter-source::valueCodeableConcept::text - -
IDPatient Encounter::patient Encounter patient_id
IDOrganisation Encounter::location::location Encounter organization_id
IDBranch Encounter::location::location - -
RemovedData - - -

SRImmunisation

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Immunization::id Observation id
DateEventRecorded Immunization::extension::primarycare-recorded-date-extension Observation date_recorded
DateEvent Immunization::date Observation clinical_effective_date
IDProfileEnteredBy Immunization::primarycare-recorded-by-extension::valueReference - -
IDDoneBy Immunization::performer::reference Observation practitoner_id
IDImmunisationContent Immunization::vaccinationProtocol::series - -
Dose Immunization::doseQuantity - -
Location Immunization::immunizationSite::text - -
Method Immunization::immunizationRoute::text - -
DateExpiry Immunization::expirationDate - -
ImmsReadCode Immunization::vaccineCode::coding::readv2::code Observation core_concept_id

non_core_concept_id

ImmsSNOMEDCode Immunization::vaccineCode::coding::snomed::code Observation core_concept_id

non_core_concept_id

VaccPart Immunization::vaccinationProtocol::doseSequence

Immunization::vaccinationProtocol::description

- -
VaccBatchNumber Immunization::lotNumber - -
IDEvent Immunization::encounter::reference Observation encounter_id
IDPatient Immunization::patient::reference Observation patient_id
RemovedData - - -

SROrganisation

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Organization::Id* organization id
Name Organization::name organization Name
ID Organization::Identifier::Value (use=official, system=ods-organization-code) organization ods_code
HouseName Organization::Address::Line - -
HouseNumber Organization::Address::Line - -
NameOfRoad Organization::Address::Line - -
NameOfLocality Organization::Address::Line - -
NameOfTown Organization::Address::City - -
NameOfCounty Organization::Address::District - -
FullPostCode Organization::Address::PostalCode organization postcode
Telephone Organization::Telecom (use=work, system=phone) - -
SecondaryTelephone Organization::Telecom (use=work, system=phone) - -
Fax Organization::Telecom (use=work, system=fax) - -
IDTrust Organization::PartOf::Reference * organization parent_organization_id
IDCcg Organization::PartOf::Reference * organization parent_organization_id
RemovedData - - -

SROrganisationBranch

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier location::id location id
BranchName location::name location name
HouseName location::address::line location
HouseNumber location::address::line location
RoadName location::address::line location
Locality location::address::line location
Town location::address::city location
County location::address::district location
PostCode location::address::postalcode location postcode
BranchObsolete location::status location
IDOrganisation location::managingOrganization.reference location managing_organization

SRPatient

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Patient::Id* patient id
Title Patient::Name::Prefix (use=official) patient title
FirstName Patient::Name::Given patient first_names
MiddleNames Patient::Name::Given patient first_names
Surname Patient::Name::Family patient last_name
NHSNumber Patient::Identifier::Value (use=official, system=nhs-number) patient nhs_number
DateBirth Patient::BirthDate patient date_of_birth
DateDeath Patient::Deceased patient date_of_death
Gender Patient::Gender patient gender_concept_id
SpeaksEnglish Patient::patient-speaks-english-extension::ValueBoolean (extension is only created if value is true) - -
EmailAddress Patient::contactPoint::email (use=home, system=email) patient_contact type_concept_id - value
TestPatient Patient::patient-is-test-patient-extension::ValueBoolean (extension is only created if value is true) - -
SpineMatched Patient::extension::primarycare-nhs-number-verification-status-extension - -
RemovedData - - -

SRPatientAddressHistory

Publisher DDS Core Compass V2
Field Name FHIR Table Field
IDOrganisationVisibleTo Patient::managingOrganisation patient registered_practice_organization_id
DateEvent Patient::Address::Period.start patient_address start_date
NameOfBuilding Patient::Address::Line patient_address address_line_1
NumberOfBuilding Patient::Address::Line patient_address address_line_1
NameOfRoad Patient::Address::Line patient_address address_line_2
NameOfLocality Patient::Address::Line patient_address address_line_3
NameOfTown Patient::Address::City patient_address city
NameOfCounty Patient::Address::District patient_address address_line_4
FullPostCode Patient::Address::PostalCode patient_address postcode
DateTo Patient::Address::Period.end patient_address end_date
AddressType Patient::Address::Use (temp, home,old) patient_address use_concept_id

SRPatientContactDetails

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Patient::id Patient id
DateEvent Patient::contact:period.startDate patient_contact start_date
ContactType Patient::contact::telecom patient_contact
ContactNumber Patient::contact::telecom.value patient_contact value
IDPatient Patient::id Patient id

SRPatientRegistration

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier EpisodeOfCare::id episode_of_care id
IDOrganisationVisibleTo EpisodeOfCare::managingOrganization.reference episode_of_care organisation_id
DateRegistration EpisodeOfCare::period.start episode_of_care date_registered
DateDeRegistration EpisodeOfCare::period.end episode_of_care date_registered_end
RegistrationStatus EpisodeOfCare::extension episode_of_care registration_status_concept_id
IDPatient EpisodeOfCare::patient.reference episode_of_care patient_id
IDOrganisation - - -
RemovedData - - -

SRPatientRelationship

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Patient::contact::id n/a n/a
DateEvent Patient::contact::period.start n/a n/a
DateEnded Patient::contact::period.end n/a n/a
RelationshipType Patient::contact::relationship n/a n/a
NextOfKin Patient::contact::extension::patient-contact-is-next-of-kin n/a n/a
CaresForPatient Patient::contact::extension::patient-contact-is-carer n/a n/a
PrincipalCarerForPatient Patient::contact::extension::patient-contact-is-carer n/a n/a
RelationshipWithName Patient::contact::name n/a n/a
RelationshipWithHouseName Patient::contact::address.line n/a n/a
RelationshipWithHouseNumber Patient::contact::address.line n/a n/a
RelationshipWithRoad Patient::contact::address.line n/a n/a
RelationshipWithLocality Patient::contact::address.line n/a n/a
RelationshipWithPostTown Patient::contact::address.city n/a n/a
RelationshipWithCounty Patient::contact::address.district n/a n/a
RelationshipWithPostCode Patient::contact::address.postalcode n/a n/a
RelationshipWithTelephone Patient::contact::telecom n/a n/a
RelationshipWithWorkTelephone Patient::contact::telecom n/a n/a
RelationshipWithMobileTelephone Patient::contact::telecom n/a n/a
RelationshipWithFax Patient::contact::telecom n/a n/a
RelationshipWithEmailAddress Patient::contact::telecom n/a n/a
IDPatient Patient::id n/a n/a
RemovedData n/a n/a

SRPersonAtRisk

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Flag::id Flag id
DateAdded Flag::extension::primarycare-recorded-date-time-extension::valueDateTime Flag effective_date
IDProfileEnteredBy Flag::author::reference - -
ProtectionPlan Flag::status Flag is_active
DateRemoved Flag::period::end - -
IDPatient Flag::patient::reference Flag patient_id
ReasonForPlan Flag::code::text Flag flag_text
RemovedData - - -

SRPrimaryCareMedication

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier MedicationOrder::id

MedicationStatement::id

medication_order

medication_statement

id
DateEventRecorded MedicationOrder::extension::primarycare-recorded-date-extension::valueReference MedicationStatement::extension::primarycare-recorded-date-extension::valueReference - -
IDProfileEnteredBy MedicationOrder::extension::primarycare-recorded-by-extension::valueReference MedicationStatement::extension::primarycare-recorded-by-extension::valueReference - -
IDDoneBy MedicationOrder::prescriber::reference

MedicationStatement::informationSource::reference

medication_order

medication_statement

practitoner_id
IDMultiLexDMD MedicationStatement::medicationCodeableConcept::coding::code MedicationOrder::medicationCodeableConcept::coding:code - -
NameOfMedication MedicationStatement::medicationCodeableConcept::coding::display MedicationOrder::medicationCodeableConcept::coding:display medication_order

medication_statement

core_concept_id
DateMedicationStart MedicationStatement::dateAsserted

MedicationStatement::dateWritten

medication_order

medication_statement

clinical_effective_date
DateMedicationEnd MedicationStatement::extension::primarycare-medication-authorisation-cancellation-extension::valueReference medication_statement cancellation_date
MedicationDosage MedicationStatement::dosage::text

MedicationOrder::dosageInstruction::text

medication_order

medication_statement

dose
MedicationQuantity MedicationStatement::extension::primarycare-medication-authorisation-quantity-extension::valueQuantity

MedicationOrder::dispenseRequest::quantity

medication_order

medication_statement

quantity_value
IsRepeatMedication MedicationStatement::primarycare-medication-autorisation-type-extension::valueCoding::display - -
IDEvent MedicationStatement::encounter::reference

MedicationOrder::encounter::reference

medication_order

medication_statement

encounter_id
IDPatient MedicationStatement::patient::reference

MedicationOrder::patient::reference

medication_order

medication_statement

patient_id
RemovedData - - -

SRProblem

Publisher DDS Core Compass V2
Field Name FHIR Table Field
DateEnd Condition::abatementDate Observation problem_end_date
Severity Condition::extension::primarycare-problem-significance-extension::value - -

SRRecall

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier ProcedureRequest::id procedure_request id
DateEventRecorded ProcedureRequest::orderedOn procedure_request clinical_effective_date
IDProfileEnteredBy ProcedureRequest::orderer::reference - -
IDDoneBy ProcedureRequest::performer::reference procedure_request practitioner_id
DateRecall ProcedureRequest::scheduledDateTime - -
RecallType ProcedureRequest::notes::text - -
RecallStatus ProcedureRequest::status procedure_request status_concept_id
RecallStatusDate ProcedureRequest::code::coding::text procedure_request core_concept_id
IDEvent ProcedureRequest::encounter procedure_request encounter_id
IDPatient ProcedureRequest::subject::reference procedure_request patient_id

SRReferralOut

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier ReferralRequest::id referral_request id
DateEventRecorded ReferralRequest::extension::valuedatetime referral_request date_recorded
DateEvent ReferralRequest::date referral_request clinical_effective_date
IDProfileEnteredBy ReferralRequest::extension::valuereference::reference referral_request practitioner_id
IDDoneBy ReferralRequest::requester.reference referral_request
IDOrganisationDoneAt ReferralRequest::requester.reference referral_request requester_organization_id
TypeOfReferral ReferralRequest::extension::http://endeavourhealth.org/fhir/StructureDefinition/referral-request-recipient-service-type-extension referral_request
Reason ReferralRequest::type.text referral_request referral_request_type_concept_id
IDProfileReferrer ReferralRequest::requester.reference
ServiceOffered ReferralRequest::extension::http://endeavourhealth.org/fhir/StructureDefinition/referral-request-recipient-service-type-extension
Urgency ReferralRequest::CodeableConcept::(Referral_Request_Priority) referral_request referral_request_type_concept_id
PrimaryDiagnosis ReferralRequest::CodeableConcept::(Referral_Request_Service)
SNOMEDPrimaryDiagnosis ReferralRequest::CodeableConcept::(Referral_Request_Service)
RecipientID ReferralRequest::extension::url::http://endeavourhealth.org/fhir/StructureDefinition/referral-request-recipient-free-text-extension
RecipientIDType ReferralRequest::extension::url::http://endeavourhealth.org/fhir/StructureDefinition/referral-request-recipient-free-text-extension
IDEvent ReferralRequest::encounter.reference referral_request encounter_id
IDPatient ReferralRequest::patient referral_request patient_id

SRRepeatTemplate

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier MedicationStatement::id medication_statement id
DateEventRecorded MedicationStatement::extension::primarycare-recorded-date-extension::valueDate - -
DateEvent MedicationStatement::dateAsserted medication_statement clinical_effective_date
IDProfileEnteredBy MedicationStatement::extension::primarycare-recorded-by-extension::valueReference - -
IDDoneBy MedicationStatement::informationSource::reference medication_statement practitoner_id
IDMultiLexDMD MedicationStatement::medicationCodeableConcept::coding::code - -
NameOfMedication MedicationStatement::medicationCodeableConcept::coding::display medication_statement core_concept_id
DateMedicationTemplateEnd MedicationStatement::extension::primarycare-medication-authorisation-cancellation-extension::valueDate medication_statement cancellation_date
MedicationDosage MedicationStatement::dosage::text medication_statement dose
MedicationQuantity MedicationStatement::extension::primarycare-medication-authorisation-quantity-extension medication_statement quantity_value

quantity_unit

MaxIssues MedicationStatement::extension::primarycare-medication-authorisation-numberofrepeatsallowed-extension - -
IDEvent MedicationStatement::encounter::reference medication_statement encounter_id
IDPatient MedicationStatement::patient::reference medication_statement patient_id
RemovedData - - -

SRRota

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Schedule::id Schedule id
DateCreation Schedule::extension::primarycare-recorded-date-extension - -
IDProfileCreatedBy Schedule::extension::primarycare-recorded-by-extension Schedule practitioner_id
Name Schedule::extension::primarycare-schedule-name-extension Schedule name
RotaType Schedule::type::text Schedule type
Location Schedule::extension::primarycare-location-type-extension Schedule

Schedule_additional*

Schedule_additional*

location

id*

property_id*

DateStart Schedule::planningHorizon::start Schedule start_date
IDBranch Schedule::extension::primarycare-location-extension Schedule location
RemovedData - - -

*Note: Only populated when both Location and IDBranch present in the data.

SRSpecialNotes

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Flag::id Flag id
IDProfileEnteredBy Flag::author::reference - -
DateStart Flag::period::start Flag effective_date
Type Flag::category::text - -
Note Flag::code:text Flag flag_text
DateExpired Flag::period::end - -
IDPatient Flag::subject::reference Flag patient_id

SRStaffMember

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Practitioner::Id* practitioner id
StaffName Practitioner::Name::Given

Practitioner::Name::Family

practitioner name
StaffUserName - - -
NationalIdType Practitioner::Identifier::Value (system=gmc-number) - -
IDNational Practitioner::Identifier::Value (system=gmc-number) practitioner gmc_code
IDSmartCard Practitioner::Identifier::Value (system=http://tpp-uk.com/identifier/staff-smartcard-id) - -
Obsolete - - -
RemovedData - - -

SRTrust

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Organization::Id* organization id
Name Organization::Name organization name
OdsCode Organization::Identifier::Value (use=official, system=ods-organization-code) organization ods_code
HouseName Organization::Address::Line - -
HouseNumber Organization::Address::Line - -
NameOfRoad Organization::Address::Line - -
NameOfLocality Organization::Address::Line - -
NameOfTown Organization::Address::City - -
NameOfCounty Organization::Address::District - -
FullPostCode Organization::Address::PostalCode organization postcode
Telephone Organization::Telecom (use=work, system=phone) - -
SecondaryTelephone Organization::Telecom (use=work, system=phone) - -
Fax Organization::Telecom (use=work, system=fax) - -
RemovedData - - -

SRVisit

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIden Appointment::id

Slot::id Schedule::id

Appointment

Schedule

id
IDProfileEnteredBy Appointment::extension::primarycare-recorded-by-extension::valueReference

Schedule::extension::primarycare-recorded-by-extension::valueReference

- -
DateBooked Appointment::extension::appointment-booking-date-extension::valueDate

Schedule::extension::primarycare-recorded-date-extension::valueDate

- -
DateRequested Appointment::start

Schedule::planningHorizon::start Slot::start

Appointment

Schedule

start_date
CurrentStatus Appointment::status Appointment appointment_status_id_concept
FollowUpDetails Appointment::comment - -
IDPatient Appointment::participant::actor::reference Appointment patient_id
Duration Schedule::planningHorizon::end

Appointment::end Slot::end

Appointment planned_duration
Retrieved from ‘https://wiki.discoverydataservice.org/index.php?title=TPP_Extract_FHIR_Mapping&oldid=6653’