Community data FHIR mapping

Organisation

Organisation

Field Name	Data/Coding Type	FHIR	Table	Field
OrganisationGuid	Unique ID	Organization::Id*	organization	id
CDB (Local Identifier)	Customer number	Organization::Identifier::Value (use=secondary, system=cdb-number)
OrganisationName	Name of organisation	Organization::name	organization	Name
ODSCode	ODS code	Organization::Identifier::Value (use=official, system=ods-organization-code)	organization	ods_code
ParentOrganisationGuid	Links to Organisation - Organisation - OrganisationGuid	Organization::PartOf::Reference *	organization	parent_organization_id
CCGOrganisationGuid	Links to Organisation - Organisation - OrganisationGuid	Organization::PartOf::Reference *
OrganisationType	Type of organisation	Organization::Type***	organization	type_desc
OpenDate	Date organisation opened	Organization::primarycare-activeperiod-extension::ValuePeriod::Start
CloseDate	Date organisation closed	Organization::primarycare-activeperiod-extension::ValuePeriod::End
MainLocationGuid	Link to Organisation - Location - LocationGuid	Organization::primarycare-mainlocation-extension::ValueReference*

Location

Field Name	Data/Coding Type	FHIR	Table	Field
LocationGuid	Unique ID	Location::Id*	location	id
LocationName	Location name	Location::Name	location	name
LocationTypeDescription	Type of location	Location::Type::Text	location	type_desc
ParentLocationGuid	Parent location	Location::PartOf::Reference *	location	managing_organization_id
OpenDate	Open Date	Location::primarycare-activeperiod-extension::ValuePeriod::Start
CloseDate	Close Date	Location::primarycare-activeperiod-extension::ValuePeriod::End
MainContactName	Main contact name	Location::primarycare-location-main-contact-extension::String
FaxNumber	Fax number	Location::contactPoint::fax (use=work, system=fax)
EmailAddress	Email adress	Location::contactPoint::email (use=work, system=email)
PhoneNumber	Phone number	Location::contactPoint::phone  (use=work, system=phone)
HouseNameFlatNumber	Address name/flat number	Location::Address::Line
NumberAndStreet	Address street	Location::Address::Line
Village	Address village	Location::Address::Line
Town	Address town	Location::Address::City
County	Address county	Location::Address::District
Postcode	Postcode	Location::Address::PostalCode	location	Postcode

Organisation Location (used to associate a location with an organisation)

Field Name	Data/Coding Type	FHIR	Table	Field
OrganisationGuid	Unique ID	ManagingOrganization*
LocationGuid	Link to Organisation - Location -  LocationGuid	<used to match to the corresponding FHIR Location>
IsMainLocation	Flag to indicate if this is the main location	<used to order the ManagingOrganization references>

Patient Demographics

Field Name	Data/Coding Type	FHIR	Table	Field
PatientGuid	Unique patient ID	Patient::Id* EpisodeOfCare::Id*	patient	id
OrganisationGuid	Links to Organisation - Organisation - OrganisationGuid	EpisodeOfCare::ManagingOrganization::Reference *	patient	organization_id
NhsNumber	NHS number	Patient::Identifier::Value (use=official, system=nhs-number)	patient	nhs_number
PatientNumber	Patient number	Patient::Identifier::Value (use=secondary, system=patient-number)	patient	person_id
PatientTypeDescription	Patient type	EpisodeOfCare:: primarycare-patient-registration-type-extension::ValueCodeableConcept***	episode_of_care	registration_type_concept_id
DummyType	Is a dummy patient	Patient::patient-is-test-patient-extension::ValueBoolean (extension is only created if value is true)
Title	Title	Patient::Name::Prefix (use=official)	patient	title
GivenName	Forename	Patient::Name::Given	patient	first_names
MiddleNames	Middle name	Patient::Name::Given	patient	first_names
Surname	Surname	Patient::Name::Family	patient	last_name
DateOfBirth	Date of birth	Patient::BirthDate	patient	date_of_birth
DateOfDeath	Date of death	Patient::Deceased	patient	date_of_death
Sex (Gender)	Sex of patient / Patients gender	Patient::Gender	patient	gender_concept_id
HouseNameFlatNumber	House name, flat no	Patient::Address::Line	patient_address	address_line_1
NumberAndStreet	Number and street	Patient::Address::Line	patient_address	address_line_2
Village	Village	Patient::Address::Line	patient_address	address_line_3
Town	Town	Patient::Address::City	patient_address	city
County	County	Patient::Address::District	patient_address	address_line_4
Postcode	Postcode	Patient::Address::PostalCode	patient_address	postcode
AddressType	Home, temporary, correspondence only, no fixed abode	Patient::Address::Use (temp, home,old)	patient_address	use_concept_id
DateEvent	The date the patient registered at the address	Patient::Address::Period.start	patient_address	Start_date
DateTo	The date the patient left the address	Patient::Address::Period.end	patient_address	end_date
EmailAddress	Email address	Patient::contactPoint::email (use=home, system=email)	patient_contact	type_concept_id - value
HomePhone	Home phone	Patient::contactPoint::phone (use=home, system=phone)	patient_contact	type_concept_id - value
MobilePhone	Mobile phone	Patient::contactPoint::phone (use=mobile, system=phone)	patient_contact	type_concept_id - value
ContactType	Home, Mobile, Work	Patient::Telecom::Value (use=home,mobile, system=phone,email)	patient_contact	type_concept_id
DateEvent	The date the patient registered the contact	Patient::Address::Period.start	patient_contact	Start_date
BirthPlace	The location where the patient was born	n/a
SpeaksEnglish	Defines if the patient speaks English	Patient::patient-speaks-english-extension::ValueBoolean (extension is only created if value is true)
Deleted	Indicates whether the record has been deleted (True/Fales , 0/1)

Patient Relationship

Field Name	Data/Coding Type	FHIR	Table	Field
RelationshipType	The relationship type (for example husband or key worker)	Patient::contact::codeableConcept::text
DateStarted	The date and time that the relationship started	Patient::contact::Period.start
DateEnded	The date and time that the relationship was ended	Patient::contact::Period.end
NextOfKin	Defines if this is a next of kin relationship	Patient::patient-contact-is-next-of-kin::ValueBoolean (extension is only created if value is true)
CaresForPatient	Defines whether the relation cares for the patient	Patient::patient-contact-is-carer::ValueBoolean (extension is only created if value is true)
PrincipalCarerForPatient	Defines whether the relation is the principal carer for the patient	Patient::patient-contact-is-carer::ValueBoolean (extension is only created if value is true)
RelationshipWithName	The name of the person the relationship is with	Patient::contact::name::text
RelationshipWithDateOfBirth	The date of birth of the person the relationship is with	n/a
RelationshipWithHouseName	The house name part of the address of the person the relationship is with	Patient::contact::Address::Line
RelationshipWithHouseNumber	The house number part of the address of the person the relationship is with	Patient::contact::Address::Line
RelationshipWithRoad	The road part of the address of the person the relationship is with	Patient::contact::Address::Line
RelationshipWithLocality	The locality part of the address of the person the relationship is with	Patient::contact::Address::Line
RelationshipWithPostTown	The post town part of the address of the person the relationship is with	Patient::contact::Address::City
RelationshipWithCounty	The county part of the address of the person the relationship is with	Patient::contact::Address::District
RelationshipWithPostCode	The post code of the person the relationship is with	Patient::contact::Address::PostalCode
RelationshipWithTelephone	The telephone number of the person the relationship is with	Patient::contact::contactPoint::phone (use=home, system=phone)
RelationshipWithWorkTelephone	The work telephone number of the person the relationship is with	Patient::contact::contactPoint::phone (use=work, system=phone)
RelationshipWithMobileTelephone	The mobile telephone number of the person the relationship is with	Patient::contact::contactPoint::phone (use=mobile, system=phone)
RelationshipWithFax	The fax number of the person the relationship is with	Patient::contact::contactPoint::fax (system=fax)
RelationshipWithEmailAddress	The email address of the person the relationship is with	Patient::contact::contactPoint::email (system=email)
IDPatient	Links to Patient_Demographics - PatientGuid	Patient::Id*
Deleted	Indicates whether the record has been deleted (True/Fales , 0/1)