View source for Compass Database Mappings

== Introduction ==

== FHIR Mappings ==

=== Patient ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-
|identifier.value
|patient
|nhs_number
|
|-
|name.family
|patient
|last_name
|
|-
|name.given
|patient
|first_names
|
|-
|name.middle
|patient
|first_names
|
|-
|name.prefix
|patient
|title
|
|-
|birthDate
|patient
|date_of_birth
|
|-
|gender
|patient
|gender_concept_id
|
|-
|deceasedDateTime
|patient
|date_of_death
|
|-
|address.line
|patient_address
|address_line_1
|
|-
|address.line
|patient_address
|address_line_2
|
|-
|address.city
|patient_address
|city
|
|-
|address.postalCode
|patient_address
|postcode
|
|-style='background-color: #ddd;'
|address.country
|
|
|
|-
|address.use
|patient_address
|use_concept_id
|
|-
|address.district
|patient_address
|address_line_3
|
|-
|telecom.value
|patient_contact
|value
|
|-
|telecom.use
|patient_contact
|use_concept_id
|
|-style='background-color: #ddd;'
|communication.language
|
|
|
|-style='background-color: #ddd;'
|communication.preferred
|
|
|
|-
|careProvider
|patient
|organization_id
|organization.id
|-style='background-color: #da614e;'
|careProvider - how are GP details populated?
|
|
|
|}

=== Practitioner ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-
|identifier.value
|practitioner
|gmc_code
|
|-style='background-color: #ddd;'
|identifier.system
|practitioner
|
|
|-
|name.family
|practitioner
|name
|
|-
|name.given
|practitioner
|name
|
|-style='background-color: #ddd;'
|name.prefix
|practitioner
|
|
|}

=== EpisodeOfCare ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-
|startDt
|episode_of_care
|date_registered
|
|-
|endDt
|episode_of_care
|date_registered_end
|
|-style='background-color: #ddd;'
|careManager
|
|
|
|-
|patient
|episode_of_care
|patient_id
|patient.id
|}

=== Encounter ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-
|class
|encounter
|admission_method
|
|-style='background-color: #ddd;'
|contained.Parameters.parameter.name
|
|
|
|-style='background-color: #ddd;'
|contained.Parameters.parameter.valueCodeableConcept.coding.code
|
|
|
|-
|contained.Parameters.parameter.valueCodeableConcept.coding.system
|encounter_additional_property
|property_id & value_id
|
|-
|type
|encounter
|admission_method
|
|-
|id
|encounter
|id
|
|-
|period.start
|encounter
|clinical_effective_date
|
|-
|period.end
|encounter
|end_date
|
|-style='background-color: #da614e;'
|location - how is the location table referenced?
|encounter
|institution_location_id
|
|-
|patient
|encounter
|patient_id
|patient.id
|-
|participant
|encounter
|practitioner_id
|practitioner.id
|-
|serviceProvider
|encounter
|service_provider_organization_id
|organization.id
|-
|episodeOfCare
|encounter
|episode_of_care_id
|episode_of_care.id
|}

=== Organization ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-
|identifier.name
|organization
|name
|
|-
|identifier.value
|organization
|ods_code
|
|-style='background-color: #ddd;'
|identifier.system
|
|
|
|-style='background-color: #ddd;'
|identifier.type
|
|
|
|-style='background-color: #ddd;'
|type.system
|
|
|
|-
|type.code
|organization
|type_code
|
|-
|type.display
|organization
|type_desc
|
|}

=== Location ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-style='background-color: #ddd;'
|identifier
|
|
|
|-style='background-color: #ddd;'
|status
|
|
|
|-
|name
|location
|type_desc
|
|-
|description
|location
|name
|
|}

=== AllergyIntolerance ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-style='background-color: #ddd;'
|category
|
|
|
|-style='background-color: #ddd;'
|substance.coding.code
|
|
|
|-style='background-color: #ddd;'
|substance.coding.display
|
|
|
|-style='background-color: #ddd;'
|substance.coding.system
|
|
|
|-style='background-color: #ddd;'
|reaction[].severity.code
|
|
|
|-style='background-color: #ddd;'
|reaction[].manifestation.coding.code
|
|
|
|-style='background-color: #ddd;'
|reaction[].manifestation.coding.display
|
|
|
|-style='background-color: #ddd;'
|reaction[].manifestation.coding.system
|
|
|
|-
|reaction[].onset
|allergy_intolerance
|date_recorded
|
|-
|patient
|allergy_intolerance
|patient_id
|patient.id
|-
|reporter
|allergy_intolerance
|practitioner_id
|practitioner.id
|}

=== Condition ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-
|code.coding.code
|observation
|core_concept_id
|
|-style='background-color: #ddd;'
|code.coding.display
|
|
|
|-style='background-color: #ddd;'
|code.coding.system
|
|
|
|-style='background-color: #ddd;'
|code.text
|
|
|
|-
|onsetDateTime
|observation
|clinical_effective_date
|
|-
|patient
|observation
|patient_id
|patient.id
|-
|asserter
|observation
|practitioner_id
|practitioner.id
|-
|encounter
|observation
|encounter_id
|encounter.id
|}

=== Procedure ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-
|code.coding.code
|observation
|core_concept_id
|
|-style='background-color: #ddd;'
|code.coding.display
|
|
|
|-style='background-color: #ddd;'
|code.coding.system
|
|
|
|-style='background-color: #ddd;'
|code.text
|
|
|
|-
|performedDateTime
|observation
|clinical_effective_date
|
|-style='background-color: #ddd;'
|category
|
|
|
|-
|patient
|observation
|patient_id
|patient.id
|-
|performer.actor
|observation
|practitioner_id
|practitioner.id
|-style='background-color: #da614e;'
|There is no Organization on DiagnosticReport. Potentially it could come through the Encounter relationship
|observation
|organization_id
|organization.id
|}

=== DiagnosticReport ===
{| class="wikitable"
!property
!table
!column
!foreign key
|-
|identifier.value
|observation
|id
|
|-
|code.coding.code
|observation
|core_concept_id
|
|-style='background-color: #ddd;'
|code.coding.display
|
|
|
|-style='background-color: #ddd;'
|code.coding.system
|
|
|
|-style='background-color: #ddd;'
|code.text
|
|
|
|-
|effectiveDateTime
|observation
|clinical_effective_date
|
|-style='background-color: #ddd;'
|category
|
|
|
|-
|patient
|observation
|patient_id
|patient.id
|-
|performer
|observation
|practitioner_id
|practitioner.id
|-style='background-color: #da614e;'
|There is no Organization on DiagnosticReport. Potentially it could come through the Encounter relationship
|observation
|organization_id
|organization.id
|}