Community data FHIR mapping

From Discovery Data Service
Jump to navigation Jump to search

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)

Registration

User

Appointments

Care Record

Coding

Prescribing