TPP Extract FHIR Mapping

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 Slot::Start	appointment	start_date
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::Status (=Arrived)	appointment	date_time_sent_in appointment_status_concept_id
DatePatientSeen	Appointment::primarycare-appointment-left-extension::DateTimeValue Appointment::Status (=Fulfilled)	appointment	date_time_left appointment_status_concept_id
TelephoneAppointment	Appointment::Type::Value	appointment_additional	property_id (type), text
IDProfileClinician	Schedule::primarycare-recorded-by-extension::ReferenceValue*	-	-
DateAppointmentCancelled	Appointment::appointment-cancellation-date-extension::DateValue*	-	-
IDRota	Slot::Schedule::Reference *	appointment	schedule_id
IDPatient	Appointment::Participant::Reference *	appointment	patient_id
RemovedData	-	-	-

SRCcg

Publisher	DDS Core	Compass V2
Field Name	FHIR	Table	Field