(→SRCcg) |
No edit summary Tag: Reverted |
||
| Line 1: | Line 1: | ||
{{TOC}} | |||
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]]. | To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]]. | ||
Revision as of 12:44, 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 | - | - | - |
SRCcg
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| RowIdentifier | Organization::Id* | organization | id |
| Name | Organization::Name | organization | name |
| OdsCode | Organization::Identifier::Value (use=official, system=ods-organization-code) | organization | ods_code |
| HouseName | Organization::Address::Line | - | - |
| HouseNumber | Organization::Address::Line | - | - |
| NameOfRoad | Organization::Address::Line | - | - |
| NameOfLocality | Organization::Address::Line | - | - |
| NameOfTown | Organization::Address::City | - | - |
| NameOfCounty | Organization::Address::District | - | - |
| FullPostCode | Organization::Address::PostalCode | organization | postcode |
| Telephone | Organization::Telecom (use=work, system=phone) | - | - |
| SecondaryTelephone | Organization::Telecom (use=work, system=phone) | - | - |
| Fax | Organization::Telecom (use=work, system=fax) | - | - |
| RemovedData | - | - | - |