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>

CCG (TPP separate this out from the main organisation table)

Field Name	Data/Coding Type	FHIR	Table	Field
IDCcg	The unique identifier for the CCG the organisation is under	Id*
Name	The name of the CCG	Name
OdsCode	The unique identifier for the CCG	Identifier::Value (use=official, system=ods-organization-code)
HouseName	The house name of the address of the CCG	Address::Line
HouseNumber	The house number of the address of the CCG	Address::Line
NameOfRoad	The road name of the address of the CCG	Address::Line
NameOfLocality	The locality name of the address of the CCG	Address::Line
NameOfTown	The town name of the address of the CCG	Address::City
NameOfCounty	The county name of the address of the CCG	Address::District
FullPostCode	The Post code of the address of the CCG	Address::PostalCode
Telephone	The main telephone number of the CCG	Telecom (use=work, system=phone)
SecondaryTelephone	The secondary telephone number of the CCG	Telecom (use=work, system=phone)
Fax	The fax number of the CCG	Telecom (use=work, system=fax)

Trust (TPP separate this out from the main organisation table)

Field Name	Data/Coding Type	FHIR	Table	Field
IDTrust	The unique identifier for the trust the organisation is under	Id*
Name	The name of the trust	Name
OdsCode	National identifier for the trust	Identifier::Value (use=official, system=ods-organization-code)
HouseName	The house name	Address::Line
HouseNumber	The number of the house	Address::Line
NameOfRoad	The name of the road	Address::Line
NameOfLocality	The name of the locality	Address::Line
NameOfTown	The name of the town	Address::City
NameOfCounty	The name of the county	Address::District
FullPostCode	The Post code for the street	Address::PostalCode
Telephone	The main telephone number	Telecom (use=work, system=phone)
SecondaryTelephone	The secondary telephone number	Telecom (use=work, system=phone)
Fax	The fax number	Telecom (use=work, system=fax)

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)