Compass Database Mappings: Difference between revisions
Jump to navigation
Jump to search
Line 282: | Line 282: | ||
!column | !column | ||
!foreign key | !foreign key | ||
|- | |-style='background-color: #ddd;' | ||
|category | |category | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|substance.coding.code | |substance.coding.code | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|substance.coding.display | |substance.coding.display | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|substance.coding.system | |substance.coding.system | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|reaction[].severity.code | |reaction[].severity.code | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|reaction[].manifestation.coding.code | |reaction[].manifestation.coding.code | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|reaction[].manifestation.coding.display | |reaction[].manifestation.coding.display | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|reaction[].manifestation.coding.system | |reaction[].manifestation.coding.system | ||
| | | |
Revision as of 11:25, 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 |
---|---|---|---|
identifier.value | practitioner | gmc_code | |
identifier.system | practitioner | ||
name.family | practitioner | name | |
name.given | practitioner | name | |
name.prefix | practitioner |
EpisodeOfCare
property | table | column | foreign key |
---|---|---|---|
startDt | episode_of_care | date_registered | |
endDt | episode_of_care | date_registered_end |
Encounter
property | table | column | foreign key |
---|---|---|---|
class | encounter | admission_method | |
contained.Parameters.parameter.name | |||
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 |
Organization
property | table | column | foreign key |
---|---|---|---|
identifier.name | organization | name | |
identifier.value | organization | ods_code | |
identifier.system | |||
identifier.type | |||
type.system | |||
type.code | organization | type_code | |
type.display | organization | type_desc |
Location
property | table | column | foreign key |
---|---|---|---|
identifier | |||
status | |||
name | location | type_desc | |
description | location | name |
AllergyIntolerance
property | table | column | foreign key |
---|---|---|---|
category | |||
substance.coding.code | |||
substance.coding.display | |||
substance.coding.system | |||
reaction[].severity.code | |||
reaction[].manifestation.coding.code | |||
reaction[].manifestation.coding.display | |||
reaction[].manifestation.coding.system | |||
reaction[].onset | allergy_intolerance | date_recorded |
Condition
property | table | column | foreign key |
---|---|---|---|
code.coding.code | observation | core_concept_id | |
code.coding.display | |||
code.coding.system | |||
code.text | |||
onsetDateTime | observation | clinical_effective_date | |
asserter | |||
identifier.value | |||
identifier.system | |||
name.family | |||
name.given | |||
name.given | |||
name.prefix |
Procedure
property | table | column | foreign key |
---|---|---|---|
code.coding.code | observation | core_concept_id | |
code.coding.display | |||
code.coding.system | |||
code.text | |||
performedDateTime | observation | clinical_effective_date | |
category |