Compass Database Mappings: Difference between revisions
From Voror_Wiki
More actions
| Line 340: | Line 340: | ||
|core_concept_id | |core_concept_id | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|code.coding.display | |code.coding.display | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|code.coding.system | |code.coding.system | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|code.text | |code.text | ||
| | | | ||
| Line 360: | Line 360: | ||
|clinical_effective_date | |clinical_effective_date | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|asserter | |asserter | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|identifier.value | |identifier.value | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|identifier.system | |identifier.system | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|name.family | |name.family | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|name.given | |name.given | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|name.given | |name.given | ||
| | | | ||
| | | | ||
| | | | ||
|- | |-style='background-color: #ddd;' | ||
|name.prefix | |name.prefix | ||
| | | | ||
Revision as of 11:26, 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 |