Compass Database Mappings: Difference between revisions
From Voror_Wiki
More actions
No edit summary |
|||
| Line 107: | Line 107: | ||
=== Practitioner === | === Practitioner === | ||
{| class="wikitable" | |||
!property | |||
!table | |||
!column | |||
!foreign key | |||
|- | |||
|.value | |||
| | |||
| | |||
| | |||
|} | |||
=== EpisodeOfCare === | === EpisodeOfCare === | ||
{| class="wikitable" | |||
!property | |||
!table | |||
!column | |||
!foreign key | |||
|- | |||
|.value | |||
| | |||
| | |||
| | |||
|} | |||
=== Encounter === | === Encounter === | ||
{| class="wikitable" | |||
!property | |||
!table | |||
!column | |||
!foreign key | |||
|- | |||
|.value | |||
| | |||
| | |||
| | |||
|} | |||
=== Organization === | === Organization === | ||
{| class="wikitable" | |||
!property | |||
!table | |||
!column | |||
!foreign key | |||
|- | |||
|.value | |||
| | |||
| | |||
| | |||
|} | |||
=== Location === | === Location === | ||
{| class="wikitable" | |||
!property | |||
!table | |||
!column | |||
!foreign key | |||
|- | |||
|.value | |||
| | |||
| | |||
| | |||
|} | |||
=== AllergyIntolerance === | === AllergyIntolerance === | ||
{| class="wikitable" | |||
!property | |||
!table | |||
!column | |||
!foreign key | |||
|- | |||
|.value | |||
| | |||
| | |||
| | |||
|} | |||
=== Condition === | === Condition === | ||
{| class="wikitable" | |||
!property | |||
!table | |||
!column | |||
!foreign key | |||
|- | |||
|.value | |||
| | |||
| | |||
| | |||
|} | |||
=== Procedure === | === Procedure === | ||
{| class="wikitable" | |||
!property | |||
!table | |||
!column | |||
!foreign key | |||
|- | |||
|.value | |||
| | |||
| | |||
| | |||
|} | |||
Revision as of 10:24, 5 July 2021
Introduction
FHIR Mappings
Patient
| 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 | |
| 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 | |
| communication.language | |||
| communication.preferred |
Practitioner
| property | table | column | foreign key |
|---|---|---|---|
| .value |
EpisodeOfCare
| property | table | column | foreign key |
|---|---|---|---|
| .value |
Encounter
| property | table | column | foreign key |
|---|---|---|---|
| .value |
Organization
| property | table | column | foreign key |
|---|---|---|---|
| .value |
Location
| property | table | column | foreign key |
|---|---|---|---|
| .value |
AllergyIntolerance
| property | table | column | foreign key |
|---|---|---|---|
| .value |
Condition
| property | table | column | foreign key |
|---|---|---|---|
| .value |
Procedure
| property | table | column | foreign key |
|---|---|---|---|
| .value |