TPP Extract FHIR Mapping

From Discovery Data Service
Revision as of 10:54, 29 August 2023 by JoC (talk | contribs)
Jump to navigation Jump to search

To see the latest Compass V2 schema, please see Discovery Remote Subscriber Database Familiarisation#Data_Mapping.

The number of extract tables received differs wildly across each of the community organisations, from 20 up to 66 of the total possible SystmOne extract total of 194.

The existing TPP inbound transform processes 36 schema files. Two tables, SRRecall and SRRecordStatus are received and transformed for GP S1 systems, but not Community.

SRAppointment

Publisher DDS Core Compass V2
Field Name FHIR Table Field
RowIdentifier Appointment::Id appointment id
DateStart Appointment::Start appointment start_date
Slot::Start
DateEnd Appointment::end - -
Slot::end
AppointmentStatus Appointment::Status (=Value) appointment appointment_status_concept_id
DateAppointmentBooked Appointment::appointment-booking-date- - -
extension::DateValue*
DatePatientArrival Appointment::primarycare-appointment-sent-in-extension::DateTimeValue appointment date_time_sent_in
Appointment::Status (=Arrived) appointment_status_concept_id
DatePatientSeen Appointment::primarycare-appointment-left-extension::DateTimeValue appointment date_time_left
Appointment::Status (=Fulfilled) appointment_status_concept_id
Publisher DDS Core Compass V2
Field Name FHIR Table Field