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
|
Linked to the Patient resource Care Provider
| 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
|
-
|
-
|