From Discovery Data Service
Jump to navigation
Jump to search
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
|
|
|
|