To see the latest Compass V2 schema, please see Discovery Remote Subscriber Database Familiarisation#Data_Mapping
The DDS transforms the received CDS data using FHIR transforms written to the Indigo 4 Standard BT Translation Service v6-2 Specification and stores these as encounters in the DDS; an encounter is a record of the
services provided to a patient with a medical problem within a specific period of time across a continuum of care in an integrated health care system.
The CDS data is processed into three parent encounters with a number of child date records, that also contain data.
The child date records are processed into the DDS within the parent encounter, as shown below.
Note - This is an ongoing project and this data is not yet available in the DDS or the Compass database.
Emergency Care CDS
Emergency Care Attendance Activity Characteristics
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Emergency Care Chief
Complaint |
SNOMED CT | Condition (complaint)
CodeableConcept.coding.code |
observation | core_concept_id,
is_problem = true |
| Emergency Care
Attendance Category |
NHS Data Dictionary | Encounter (Emergency Arrival)
Contained Parameters [ IM.attendance_category.property, IM.attendance_category.value ] |
encounter_event |
property_id, value_id |
| Emergency Care
Attendance Identifier |
Unique Identifier | Encounter (Emergency Arrival)
id + ":01:EM" Encounter (Emergency Assessment) id + ":02:EM" Encounter (Emergency Treatment) id + ":03:EM" Encounter (Emergency Conclusion) id + ":04:EM" |
encounter_event | id |
| Emergency Care
Attendance Source |
SNOMED CT | Encounter (Emergency Arrival)
Contained Parameters [ IM.attendance_source.property, IM.attendance_source.value ] |
encounter_event |
property_id, value_id |
| Emergency Care Arrival
Mode |
SNOMED CT | Encounter (Emergency Arrival)
Contained Parameters [ IM.arrival_mode.property, IM.arrival_mode.value ] |
encounter_event |
property_id, value_id |
| Emergency Care Arrival
Date |
CCYY-MM-DD | Encounter (Emergency)
Period.start Encounter (Emergency Arrival) Period.start Condition (complaint) Onset Date |
encounter |
clinical_effective_date
|
| Emergency Care Arrival
Time |
HH:MM:SS | Encounter (Emergency)
Period.start Encounter (Emergency Arrival) Period.start Condition (complaint) Onset Date |
encounter |
clinical_effective_date
|
| Emergency Care Initial
Assessment Date |
CCYY-MM-DD | Encounter (Emergency)
| Encounter (Emergency Arrival) Period.end Encounter (Emergency Assessment) Period.start |
encounter encounter_event |
end_date
clinical_effective_date |
| Emergency Care Initial
Assessment Time |
HH:MM:SS | Encounter (Emergency)
| Encounter (Emergency Arrival) Period.end Encounter (Emergency Assessment) Period.start |
encounter encounter_event |
end_date
clinical_effective_date |
| Emergency Care Date
Seen for Treatment |
CCYY-MM-DD | Encounter (Emergency)
| Encounter (Assessment) Period.end Encounter (Emergency Treatment) Period.start |
encounter encounter_event |
end_date
clinical_effective_date |
| Emergency Care Time
Seen for Treatment |
HH:MM:SS | Encounter (Emergency)
| Encounter (Assessment) Period.end Encounter (Emergency Treatment) Period.start |
encounter encounter_event |
end_date
clinical_effective_date |
Emergency Care Attendance Location
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Emergency Care
Department Type |
NHS Data Dictionary | Encounter (Emergency Arrival)
Contained Parameters [ IM.department_type.property, IM.department_type.value ] |
encounter_event |
property_id, value_id |
| Organisation Site
Identifier (of Treatment) |
ODS | Encounter (Emergency)
serviceProvider Encounter (Emergency Arrival) serviceProvider Encounter (Emergency Assessment) serviceProvider Encounter (Emergency Treatment) serviceProvider Encounter (Emergency Conclusion) serviceProvider |
encounter |
organization_id
|
Emergency Care Diagnoses
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Emergency Care
Diagnosis (multi) |
SNOMED CT | Condition (diagnosis)
CodeableConcept.coding.code |
observation | core_concept_id,
is_problem = false |
| Emergency Care
Diagnosis Qualifier |
SNOMED CT | only populate where = 410605003 (confirmed present) |
Discharge from Emergency Care
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Safeguarding Concern (multi) | SNOMED CT | Observation
CodeableConcept.coding.code |
observation | core_concept_id |
| Activity Treatment
Function Code (Decision to Admit) |
NHS Data Dictionary | Encounter (Emergency Conclusion)
Contained Parameters [ IM.treatment_function_code.property, IM.treatment_function_code.value ] |
encounter_event |
property_id, value_id |
| Emergency Care
Attendance Conclusion Date |
CCYY-MM-DD | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.start |
encounter |
end_date
clinical_effective_date |
| Emergency Care
Attendance Conclusion Time |
HH:MM:SS | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.start |
encounter |
end_date
clinical_effective_date |
| Emergency Care
Departure Date |
CCYY-MM-DD | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.end |
encounter |
clinical_effective_date
end_date |
| Emergency Care
Departure Time |
HH:MM:SS | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.end |
encounter |
clinical_effective_date
end_date |
| Decided to Admit Date | CCYY-MM-DD | Encounter (Emergency)
status = INPROGRESS |
encounter |
Becomes (Inpatient)
*Updated via Inpatient record* |
| Decided to Admit Time | HH:MM:SS | Encounter (Emergency)
status = INPROGRESS |
encounter |
Becomes (Inpatient)
*Updated via Inpatient record* |
| Emergency Care
Discharge Status |
SNOMED CT | Encounter (Emergency Conclusion)
Contained Parameters [ IM.discharge_status.property, IM.discharge_status.value ] |
encounter_event |
property_id, value_id |
| Emergency Care
Discharge Destination |
SNOMED CT | Encounter (Emergency Conclusion)
Contained Parameters [ IM.discharge_destination.property, IM.discharge_destination.value ] |
encounter_event |
property_id, value_id |
| Emergency Care
Discharge Follow-up |
SNOMED CT | Encounter (Emergency Conclusion)
Contained Parameters [ IM.discharge_follow_up.property, IM.discharge_follow_up.value ] |
encounter_event |
property_id, value_id |
Emergency Care Investigations
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Emergency Care Clinical
Investigation (multi) |
SNOMED CT | Observation
CodeableConcept.coding.code |
observation | core_concept_id |
| Procedure Date
(Emergency Care Clinical Investigation) |
CCYY-MM-DD | Observation
effective |
observation | clinical_effective_date |
| Procedure Time
(Emergency Care Clinical Investigation) |
HH:MM:SS | Observation
effective |
observation | clinical_effective_date |
Emergency Care Treatments
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Emergency Care
Procedure (multi) |
SNOMED CT | Observation
CodeableConcept.coding.code |
observation | core_concept_id |
| Procedure Date
(Emergency Care Procedure) |
CCYY-MM-DD | Observation
effective |
observation | clinical_effective_date |
| Procedure Time
(Emergency Care Procedure) |
HH:MM:SS | Observation
effective |
observation | clinical_effective_date |
Inpatient
Hospital Provider Spell - Admission Characteristics
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Hospital Provider Spell
Number |
Unique number | Encounter (Inpatient Admission)
id + ":01:IP:Admission" Encounter (Inpatient Episode) id + episode_number + ":IP:Episode" Encounter (Inpatient Discharge) id + ":01:IP:Discharge" |
encounter_event | id |
| Administrative Category
Code (On Admission) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.administrative_category_code.property, IM.administrative_category_code.value ] |
encounter_event |
property_id, value_id |
| Admission Method Code
(Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.admission_method_code.property, IM.admission_method_code.value ] |
encounter_event |
property_id, value_id |
| Source of Admission
Code (Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.admission_source_code.property, IM.admission_source_code.value ] |
encounter_event |
property_id, value_id |
| Patient Classification
Code |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.patient_classification.property, IM.patient_classification.value ] |
encounter_event |
property_id, value_id |
| Start Date (Hospital
Provider Spell) |
CCYY-MM-DD | Encounter (Inpatient)
Period.start Encounter (Inpatient Admission) Period.start |
encounter |
clinical_effective_date
|
| Start Time (Hospital
Provider Spell) |
HH:MM:SS | Encounter (Inpatient)
Period.start Encounter (Inpatient Admission) Period.start |
encounter |
clinical_effective_date
|
Location Group (At Start of Episode)
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Site Code (of Treatment) | ODS | Encounter (Inpatient)
serviceProvider Encounter (Inpatient Admission) serviceProvider Encounter (Inpatient Episode) serviceProvider Encounter (Inpatient Discharge) serviceProvider |
encounter |
organization_id
|
Location Group (At End of Episode)
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Site Code (of Treatment) | ODS | Encounter (Inpatient)
serviceProvider Encounter (Inpatient Admission) serviceProvider Encounter (Inpatient Episode) serviceProvider Encounter (Inpatient Discharge) serviceProvider |
encounter |
organization_id
|
Hospital Provider Spell - Discharge Characteristics
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Discharge Date (Hospital
Provider Spell) |
CCYY-MM-DD | Encounter (Inpatient)
Period.end Encounter (Inpatient Discharge) Period.start Period.end |
encounter |
end_date
end_date |
| Discharge Time
(Hospital Provider Spell) |
HH:MM:SS | Encounter (Inpatient)
Period.end Encounter (Inpatient Discharge) Period.start Period.end |
encounter |
end_date
end_date |
| Discharge Destination
Code (Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.discharge_destination_code.property, IM.discharge_destination_code.value ] |
encounter_event |
property_id, value_id |
| Discharge Method Code
(Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.discharge_method.property, IM.discharge_method.value ] |
encounter_event |
property_id, value_id |
Consultant Episode - Person Group (Consultant)
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Activity Treatment
Function Code |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.treatment_function_code.property, IM.treatment_function_code.value ] |
encounter_event |
property_id, value_id |
| Consultant Code | NHS national code | Encounter (Inpatient)
participant Encounter (Inpatient Admission) participant Encounter (Inpatient Episode) participant Encounter (Inpatient Discharge) participant |
encounter |
practitioner_id
|
Consultant Episode - Clinical Diagnosis Group
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Primary Diagnosis | ICD-10 | Condition (diagnosis)
CodeableConcept.coding.code is_primary |
observation | core_concept_id,
is_problem = false, is_primary = true |
| Secondary Diagnosis | ICD-10 | Condition (diagnosis)
CodeableConcept.coding.code |
observation | core_concept_id,
is_problem = false, is_primary = false |
Consultant Episode - Clinical Activity Group
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Primary Procedure | OPCS4 | Procedure
CodeableConcept.coding.code is_primary |
observation | core_concept_id,
is_primary = true |
| Primary Procedure Date | CCYY-MM-DD | Procedure
startDate |
observation | clinical_effective_date |
| Secondary Procedure | OPCS4 | Procedure
CodeableConcept.coding.code |
observation | core_concept_id,
is_primary = false |
| Secondary Procedure Date | CCYY-MM-DD | Procedure
startDate |
observation | clinical_effective_date |
Consultant Episode – Activity Characteristics
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Episode Number | Sequential 2-digit
number (01 – 89) |
Encounter (Inpatient Episode)
id + episode_number + ":IP:Episode" |
encounter_event | id |
| Start Date (Episode) | CCYY-MM-DD | Encounter (Inpatient Episode)
Period.start |
encounter_event | clinical_effective_date |
| Start Time (Episode) | HH:MM:SS | Encounter (Inpatient Episode)
Period.start |
encounter_event | clinical_effective_date |
| End Date (Episode) | CCYY-MM-DD | Encounter (Inpatient Episode)
Period.end |
encounter_event | end_date |
| End Time (Episode) | HH:MM:SS | Encounter (Inpatient Episode)
Period.end |
encounter_event | end_date |
Birth Occurrence - Patient Characteristics
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Delivery Method Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.delivery_method.property, IM.delivery_method.value ] NOTE: also part of overall maternity_birth JSON |
encounter_event |
property_id, value_id |
| Delivery date | CCYY-MM-DD | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_birth.property, JSON_delivery_date ] |
encounter_event |
property_id, json_value |
| Birth weight | Weight in grams. 9999 = Not Known | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_birth.property, JSON_birth_weight ] |
encounter_event |
property_id, json_value |
| Live or Still Birth Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.live_or_still_birth_indicator.property, IM.live_or_still_birth_indicator.value ] NOTE: also part of overall maternity_birth JSON |
encounter_event |
property_id, value_id |
| Gender Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.gender.property, IM.gender.value ] NOTE: also part of overall maternity_birth JSON |
encounter_event |
property_id, value_id |
| Mother NHS number | NHS number (Mothers) | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_birth.property, JSON_mother_nhs_number ] |
encounter_event |
property_id, json_value |
Delivery Occurrence - for Each Baby in the Delivery (1-9)
| Field Name | Data/Coding Type | FHIR | Table | CollapseField |
|---|---|---|---|---|
| Delivery Method Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] |
encounter_event |
property_id, json_value |
| Birth date | CCYY-MM-DD | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_birth_date |
encounter_event |
property_id, json_value |
| Birth weight | Weight in grams. 9999 = Not Known | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_birth_weight |
encounter_event |
property_id, json_value |
| Live or Still Birth Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_live_or_still_birth_indicator |
encounter_event |
property_id, json_value |
| Gender Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_gender_code |
encounter_event |
property_id, json_value |
| Baby NHS number | NHS number (Babies) | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_baby_nhs_number |
encounter_event |
property_id, json_value |