TPP Extract FHIR Mapping: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 6: | Line 6: | ||
== SRAppointment == | == SRAppointment == | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:70%;" | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:70%;" | ||
! style="color:#90A4AE" |'''Publisher''' | ! style="color:#90A4AE" |'''Publisher''' | ||
| Line 116: | Line 57: | ||
|date_time_left | |date_time_left | ||
appointment_status_concept_id | 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 == | |||
Revision as of 12:41, 29 August 2023
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 | - | - | - |