To see the latest Compass V2 schema, please see Discovery Remote Subscriber Database Familiarisation#Data_Mapping
Case
This file contains details of patient out of hours case data.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| PatientRef | EpisodeOfCare::Patient.reference | episode_of_care | patient_id |
| PriorityName | EpisodeOfCare::priority.extension | - | - |
| CaseRef | EpisodeOfCare::id | episode_of_care | id |
| CaseNo | EpisodeOfCare::identifier | - | - |
| StartDateTime | EpisodeOfCare:period.start | episode_of_care | date_registered |
| EndDateTime | EpisodeOfCare:period.end | episode_of_care | date_registered_end |
| CaseTagName | EpisodeOfCare::identifier | - | - |
| ArrivedPCC | EpisodeOfCare::arrival.extension | - | - |
| UserRef | EpisodeOfCare::practitioner.reference | episode_of_care | usual_gp_practitioner_id |
| ODSCode | EpisodeOfCare::organisation.reference | - | - |
Case Questions
This file contains defined questions and answers linked to a case. It is treated like a questionnaire associated with a case encounter.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| CaseRef | QuestionnaireRespone::subject.patient.reference | - | - |
| QuestionSetName | QuestionnaireRespone::group.title | - | - |
| Question | QuestionnaireRespone::group.question.text | - | - |
| Answer | QuestionnaireRespone::group.question.answer.value | - | - |
| status = QuestionnaireResponseStatus.Completed | - | - | |
Outcomes
This files list the outcomes(s) of the case.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| CaseRef | EpisodeOfCare::id | - | - |
| OutcomeName | EpisodeOfCare::outcome.extension | - | - |
Notes
This file lists all patient notes linked to a case.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| CaseRef | Flag::id:patientId:ReviewDateTime | flag | id |
| PatientRef | Flag::Subject::ReferenceValue | flag | patient_id |
| ReviewDateTime | Flag::Period::Start::DateValue | flag | effective_date |
| NoteText | Flag::CodeableConcept::Text | flag | flag_text |
| Obsolete | - | - | - |
| Active | Flag::Status::Value | flag | flag_text |
| UserRef | Flag::Author::ReferenceValue | - | - |
Patient
Details all the patients seen as part of the OOH service linked to a case.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| PatientRef | Patient::Id | patient | id |
| Forename | Patient::Name::Given | patient | first_names |
| Surname | Patient::Name::Family | patient | last_name |
| DOB | Patient::BirthDate | patient | date_of_birth |
| NHSNumber | Patient::Identifier::Value (use=official, system=nhs-number) | patient | nhs_number |
| NHSNoTraceStatus | Patient::primarycare-nhs-number-verification-status-extension::Value (NHS Verification Status) | - | - |
| Language | Patient:CodableConcept:Patientlanguage | - | - |
| Ethnicity | Patient:enthnicity.extension (only attempt match if fieldIndex 27 blank) | patient | ethnic_code_concept_id |
| Gender | Patient::Gender | patient | gender_concept_id |
| RegistrationType | EpisodeOfCare:: primarycare-patient-registration-type-extension::ValueCodeableConcept*** | episode_of_care | registration_type_concept_id |
| HomeAddressType | Patient::Address::Use (temp, home,old) | patient_address | use_concept_id |
| HomeAddressBuilding | Patient::Address::Line | patient_address | address_line_1 |
| HomeAddressStreet | Patient::Address::Line | patient_address | address_line_2 |
| HomeAddressTown | Patient::Address::City | patient_address | city |
| HomeAddressLocality | Patient::Address::District | patient_address | address_line_4 |
| HomeAddressPostcode | Patient::Address::PostalCode | patient_address | postcode |
| MobilePhone | Patient::contactPoint::phone (use=mobile, system=phone) | patient_contact | type_concept_id - value |
| HomePhone | Patient::contactPoint::phone (use=home, system=phone) | patient_contact | type_concept_id - value |
| EthnicCode | Patient:enthnicity.extension | patient | ethnic_code_concept_id |
Consultation
This file details the patient consultations associated with a case.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| CaseRef | EpisodeOfCare:reference | encounter | patient_id |
| ConsultationRef | Encounter::Id | encounter | id |
| StartDateTime | Encounter::Period::Start | encounter | clinical_effective_date |
| EndDateTime | Encounter::Period::End | encounter | end_date |
| Location | - | - | - |
| CaseType | Encount:CodableConcept:encounter_source | encounter | non_core_concept_id |
| History | Observation:comments | - | - |
| Examination | Observation:comments | - | - |
| Diagnosis | Observation:comments | - | - |
| TreatmentPlan | Observation:comments | - | - |
| PatientName | n/a - Patient reference used | - | - |
| PatientForename | n/a - Patient reference used | - | - |
| PatientSurname | n/a - Patient reference used | - | - |
| ProviderType | - | - | |
| GMC | - | - | |
| UserRef | Encounter::Participant::ReferenceValue | encounter | practitioner_id |
Prescriptions
Details the drug items given during the Consultation which links back to a case.
| These will be Snomed DM&D coded as part of phase 2. |
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| CaseRef | MedicationStatement::Patient::Reference * | medication_statement | patient_id |
| ConsultationRef | MedicationStatement::DateAsserted | medication_statement | clinical_effective_date |
| DrugName | MedicationStatement::CodeableConcept::Coding::Text | medication_statement | core_concept_id |
| Preparation | MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Unit | medication_statement | quantity_unit |
| Dosage | MedicationStatement::Dosage::Text | medication_statement | dose |
| Quantity | MedicationStatement::primarycare-medication-authorisation-quantity-extension::Quantity::Value | medication_statement | quantity_value |
| DMDCode | MedicationStatement::CodeableConcept::Coding | medication_statement | core_concept_id |
| Issue | Y or N | - | - |
Clinical codes
Details all the clinical codes added during a Consultation which links back to a case.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| Obsrvation::id | observation | id | |
| CaseRef | Observation::Subject.reference | observation | patient_id |
| ConsultationRef | Observation::Encounter.reference | observation | encounter_id |
| ClinicalCode | Observation::codableConcept.code | observation | non_core_concept_id
core_concept_id |
| Term | Observation:CodableConcept.code.text | - | - |
Provider
Details the patient GP practice and locations.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| GPPracticeNatCode | Organization::Identifier::Value (use=official, system=ods-organization-code) | organization | ods_code |
| GPPracitceName | Organization::name | organization | Name |
| GPPracticePostcode | Organization:address:postcode | organization | Postcode |
Users
Details the clinical users/practitioners, linking into all UserRef references in other resources.
| Publisher | DDS Core | Compass V2 | |
|---|---|---|---|
| Field Name | FHIR | Table | Field |
| UserRef | Practitioner::Id* | practitioner | id |
| Forename | Practitioner::Name::Given | practitioner | name |
| Surname | Practitioner::Name::Family | practitioner | name |
| FullName | Practitioner::Name::Given
Practitioner::Name::Family |
practitioner | name |
| ProviderGMC | Practitioner::Identifier::Value (system=gmc-number)
if a GP, create an http://endeavourhealth.org/fhir/Identifier/gmc-number identifier |
practitioner | gmc_code |
| ProviderNMC | Practitioner::Identifier::Value (system=nmc-number)
if a Nurse, create an http://endeavourhealth.org/fhir/Identifier/nmc-number identifier |
- | - |