Barts Health CDS FHIR Mapping

From Discovery Data Service
Jump to navigation Jump to search

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.

CDS Encounter Structure

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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_event
One to many.png
observation
clinical_effective_date


Emergency Care Arrival

Time

HH:MM:SS Encounter (Emergency)

Period.start

Encounter (Emergency Arrival)

Period.start

Condition (complaint)

Onset Date

encounter
One to many.png
encounter_event
One to many.png
observation
clinical_effective_date


Emergency Care Initial

Assessment Date

CCYY-MM-DD Encounter (Emergency)

|

Encounter (Emergency Arrival)

Period.end

Encounter (Emergency Assessment)

Period.start

encounter
One to many.png
encounter_event

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
One to many.png
encounter_event

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
One to many.png
encounter_event

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
One to many.png
encounter_event

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
One to many.png
encounter_additional
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
One to many.png
encounter_event
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
One to many.png
encounter_additional
property_id, value_id
Emergency Care

Attendance Conclusion

Date

CCYY-MM-DD Encounter (Emergency)

Period.end

Encounter (Emergency Conclusion)

Period.start

encounter
One to many.png
encounter_event
end_date

clinical_effective_date

Emergency Care

Attendance Conclusion

Time

HH:MM:SS Encounter (Emergency)

Period.end

Encounter (Emergency Conclusion)

Period.start

encounter
One to many.png
encounter_event
end_date

clinical_effective_date

Emergency Care

Departure Date

CCYY-MM-DD Encounter (Emergency)

Period.end

Encounter (Emergency Conclusion)

Period.end

encounter
One to many.png
encounter_event
clinical_effective_date

end_date

Emergency Care

Departure Time

HH:MM:SS Encounter (Emergency)

Period.end

Encounter (Emergency Conclusion)

Period.end

encounter
One to many.png
encounter_event
clinical_effective_date

end_date

Decided to Admit Date CCYY-MM-DD Encounter (Emergency)

status = INPROGRESS

encounter
One to many.png
encounter_event
Becomes (Inpatient)

*Updated via Inpatient record*

Decided to Admit Time HH:MM:SS Encounter (Emergency)

status = INPROGRESS

encounter
One to many.png
encounter_event
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
property_id, value_id
Start Date (Hospital

Provider Spell)

CCYY-MM-DD Encounter (Inpatient)

Period.start

Encounter (Inpatient Admission)

Period.start

encounter
One to many.png
encounter_event
clinical_effective_date


Start Time (Hospital

Provider Spell)

HH:MM:SS Encounter (Inpatient)

Period.start

Encounter (Inpatient Admission)

Period.start

encounter
One to many.png
encounter_event
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
One to many.png
encounter_event
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
One to many.png
encounter_event
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
One to many.png
encounter_event
end_date


clinical_effective_date

end_date

Discharge Time

(Hospital Provider Spell)

HH:MM:SS Encounter (Inpatient)

Period.end

Encounter (Inpatient Discharge)

Period.start

Period.end

encounter
One to many.png
encounter_event
end_date


clinical_effective_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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_event
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
One to many.png
encounter_additional
property_id, value_id
Delivery date CCYY-MM-DD Encounter (Inpatient Episode)

Contained Parameters [

IM.maternity_birth.property,

JSON_delivery_date

]

encounter_event
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
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
One to many.png
encounter_additional
property_id, json_value