Compass Database Mappings

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
.value

Condition

property	table	column	foreign key
.value

Procedure

property	table	column	foreign key
.value