CDS Data
More actions
To see the latest Compass V2 schema, please see Discovery Remote Subscriber Database Familiarisation#Data_Mapping
Using the Indigo 4 Standard BT Translation Service v6-2 CDS Specification, the following standardised DDS transforms into FHIR and the Compass V2 schema have been developed to store the data 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.
Although this is only a subset of the CDS data available, the following data items have been selected as these enrich the existing data in the DDS. Additional CDS data can be consumed by the DDS where there is a use case, or where this will further enhance the existing data.
Emergency Care CDS
Emergency Care Attendance Activity Characteristics
| Field Name* | Data/Coding Type* | FHIR | Table | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 | Field |
|---|---|---|---|---|
| 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 |
*Example organisation data files and field coding types only. File and field names can differ across different systems.