Jump to content
Toggle search
Toggle menu
  • 131 articles
  • 373 files
  • 34 users
  • 7K edits
Voror_Wiki
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

TPP Extract FHIR Mapping: Difference between revisions

From Voror_Wiki
More actions
← Older edit

AdminJo (talk | contribs)

5 user groups
415 edits
VisualWikitext
 
(58 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]].
The number of extract tables received differs wildly across each of the community organisations, from 20 up to 66 of the total possible SystmOne extract total of 194.
The existing TPP inbound transform processes 36 schema files. Two tables, SRRecall and SRRecordStatus are received and transformed for GP S1 systems, but not Community.


== SRAppointment ==
== SRAppointment ==
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 89: Line 85:
|}
|}


== SRCcg ==
== SRCCG ==
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 172: Line 168:


== SRCode ==
== SRCode ==
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 310: Line 306:


== SRDrugSensitivity ==
== SRDrugSensitivity ==
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 382: Line 378:


== SREvent ==
== SREvent ==
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 464: Line 460:


== SRImmunisation ==
== SRImmunisation ==
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 564: Line 560:


== SROrganisation ==
== SROrganisation ==
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 657: Line 653:


== SROrganisationBranch ==
== 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 667: 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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|+
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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
|location
|-
|DateStart
|Schedule::planningHorizon::start
|Schedule
|start_date
|-
|IDBranch
|Schedule::extension::primarycare-location-extension
|Schedule
|location
|-
|RemovedData
| -
| -
| -
|}
== SRSpecialNotes ==
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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:100%;"
! style="color:#04466b" |'''Publisher'''
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|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 12:33, 14 November 2024

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 location
DateStart Schedule::planningHorizon::start Schedule start_date
IDBranch Schedule::extension::primarycare-location-extension Schedule location
RemovedData - - -

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.voror.co.uk/index.php?title=TPP_Extract_FHIR_Mapping&oldid=6830"
Last modified
This page was last modified on 14 November 2024, at 12:33.