Barts Health CDS FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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.
[[File:CDS_Encounter_Structure.png|alt=|frame|'''CDS Encounter Structure'''|none]]
== Emergency Care CDS ==
== Emergency Care CDS ==


=== Emergency Care Attendance Activity Characteristics ===
=== Emergency Care Attendance Activity Characteristics ===
{| border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |CDS Notation
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="15%" |Data/Coding Type
Line 11: Line 21:
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
| rowspan="11" |Emergency Care
Attendance Activity
Characteristics
|Emergency Care Chief
|Emergency Care Chief


Line 41: Line 46:


]
]
|encounter_event
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
 
<nowiki>|</nowiki>
 
encounter_additional
|property_id, value_id
|property_id, value_id
|-
|-
Line 83: Line 84:


]
]
|<u>encounter_event</u>
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
 
<nowiki>|</nowiki>
 
<u>encounter_additional</u>
|property_id, value_id
|property_id, value_id
|-
|-
Line 103: Line 100:


]
]
|<u>encounter_event</u>
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
 
<nowiki>|</nowiki>
 
<u>encounter_additional</u>
|property_id, value_id
|property_id, value_id
|-
|-
Line 125: Line 118:


Onset Date
Onset Date
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>observation</u>
 
<nowiki>|</nowiki>
 
<u>encounter_event</u>
 
<u>|</u>
 
<u>observation</u>
|clinical_effective_date
|clinical_effective_date
<br />
<br />
Line 152: Line 137:


Onset Date
Onset Date
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>observation</u>
 
<nowiki>|</nowiki>
 
<u>encounter_event</u>
 
<nowiki>|</nowiki>
 
<u>observation</u>
|clinical_effective_date
|clinical_effective_date
<br />
<br />
Line 179: Line 156:


Period.start
Period.start
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
 
<nowiki>|</nowiki>
 
<u>encounter_event</u>


<u>encounter_event</u>
<u>encounter_event</u>
Line 205: Line 178:


Period.start
Period.start
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
 
<nowiki>|</nowiki>
 
<u>encounter_event</u>


<u>encounter_event</u>
<u>encounter_event</u>
Line 231: Line 200:


Period.start
Period.start
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
 
<nowiki>|</nowiki>
 
<u>encounter_event</u>


<u>encounter_event</u>
<u>encounter_event</u>
Line 257: Line 222:


Period.start
Period.start
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
 
<u>encounter_event</u>
|end_date
 
clinical_effective_date
|}
 
=== Emergency Care Attendance Location ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Emergency Care
 
Department Type
|NHS Data Dictionary
|<u>Encounter (Emergency Arrival)</u>
 
Contained Parameters [
 
IM.department_type.property,
 
IM.department_type.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Organisation Site
 
Identifier (of Treatment)
|ODS
|<u>Encounter (Emergency)</u>
 
serviceProvider
 
<u>Encounter (Emergency Arrival)</u>
 
serviceProvider
 
<u>Encounter (Emergency Assessment)</u>
 
serviceProvider
 
<u>Encounter (Emergency Treatment)</u>
 
serviceProvider
 
<u>Encounter (Emergency Conclusion)</u>
 
serviceProvider
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|organization_id
<br />
|}
 
=== Emergency Care Diagnoses ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Emergency Care
 
Diagnosis (multi)
|SNOMED CT
|<u>Condition (diagnosis)</u>
 
CodeableConcept.coding.code
|<u>observation</u>
|core_concept_id,
 
is_problem = false
|-
|Emergency Care
 
Diagnosis Qualifier
|SNOMED CT
|only populate where = 410605003 (confirmed present)
|
|
|}
 
=== Discharge from Emergency Care ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Safeguarding Concern (multi)
|SNOMED CT
|<u>Observation</u>
 
CodeableConcept.coding.code
|<u>observation</u>
|core_concept_id
|-
|Activity Treatment
 
Function Code (Decision
 
to Admit)
|NHS Data Dictionary
|<u>Encounter (Emergency Conclusion)</u>
 
Contained Parameters [
 
IM.treatment_function_code.property,
 
IM.treatment_function_code.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Emergency Care
 
Attendance Conclusion
 
Date
|CCYY-MM-DD
|<u>Encounter (Emergency)</u>
 
Period.end
 
<u>Encounter (Emergency Conclusion)</u>
 
Period.start
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|end_date
 
clinical_effective_date
|-
|Emergency Care
 
Attendance Conclusion
 
Time
|HH:MM:SS
|<u>Encounter (Emergency)</u>
 
Period.end
 
<u>Encounter (Emergency Conclusion)</u>
 
Period.start
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|end_date
 
clinical_effective_date
|-
|Emergency Care
 
Departure Date
|CCYY-MM-DD
|<u>Encounter (Emergency)</u>
 
Period.end
 
<u>Encounter (Emergency Conclusion)</u>
 
Period.end
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|clinical_effective_date
 
end_date
|-
|Emergency Care
 
Departure Time
|HH:MM:SS
|<u>Encounter (Emergency)</u>
 
Period.end
 
<u>Encounter (Emergency Conclusion)</u>
 
Period.end
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|clinical_effective_date
 
end_date
|-
|Decided to Admit Date
|CCYY-MM-DD
|<u>Encounter (Emergency)</u>
 
status = INPROGRESS
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|Becomes (Inpatient)
 
<nowiki>*</nowiki>Updated via Inpatient record*
|-
|Decided to Admit Time
|HH:MM:SS
|<u>Encounter (Emergency)</u>
 
status = INPROGRESS
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|Becomes (Inpatient)
 
<nowiki>*</nowiki>Updated via Inpatient record*
|-
|Emergency Care
 
Discharge Status
|SNOMED CT
|<u>Encounter (Emergency Conclusion)</u>
 
Contained Parameters [
 
IM.discharge_status.property,
 
IM.discharge_status.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Emergency Care
 
Discharge Destination
|SNOMED CT
|<u>Encounter (Emergency Conclusion)</u>
 
Contained Parameters [
 
IM.discharge_destination.property,
 
IM.discharge_destination.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Emergency Care
 
Discharge Follow-up
|SNOMED CT
|<u>Encounter (Emergency Conclusion)</u>
 
Contained Parameters [
 
IM.discharge_follow_up.property,
 
IM.discharge_follow_up.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|}
 
=== Emergency Care Investigations ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Emergency Care Clinical
 
Investigation (multi)
|SNOMED CT
|<u>Observation</u>
 
CodeableConcept.coding.code
|<u>observation</u>
|core_concept_id
|-
|Procedure Date
 
(Emergency Care
 
Clinical Investigation)
|CCYY-MM-DD
|<u>Observation</u>
 
effective
|<u>observation</u>
|clinical_effective_date
|-
|Procedure Time
 
(Emergency Care
 
Clinical Investigation)
|HH:MM:SS
|<u>Observation</u>
 
effective
|<u>observation</u>
|clinical_effective_date
|}
 
=== Emergency Care Treatments ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Emergency Care
 
Procedure (multi)
|SNOMED CT
|<u>Observation</u>
 
CodeableConcept.coding.code
|<u>observation</u>
|core_concept_id
|-
|Procedure Date
 
(Emergency Care
 
Procedure)
|CCYY-MM-DD
|<u>Observation</u>
 
effective
|<u>observation</u>
|clinical_effective_date
|-
|Procedure Time
 
(Emergency Care
 
Procedure)
|HH:MM:SS
|<u>Observation</u>
 
effective
|<u>observation</u>
|clinical_effective_date
|}
 
== Inpatient ==
 
=== Hospital Provider Spell - Admission Characteristics ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Hospital Provider Spell


<nowiki>|</nowiki>
Number
|Unique number
|<u>Encounter (Inpatient Admission)</u>
 
id + ":01:IP:Admission"
 
<u>Encounter (Inpatient Episode)</u>
 
id + episode_number + ":IP:Episode"
 
<u>Encounter (Inpatient Discharge)</u>
 
id + ":01:IP:Discharge"
|<u>encounter_event</u>
|id
|-
|Administrative Category
 
Code (On Admission)
|NHS Data Dictionary
|<u>Encounter (Inpatient Admission)</u>
 
Contained Parameters [
 
IM.administrative_category_code.property,
 
IM.administrative_category_code.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Admission Method Code
 
(Hospital Provider Spell)
|NHS Data Dictionary
|<u>Encounter (Inpatient Admission)</u>
 
Contained Parameters [
 
IM.admission_method_code.property,
 
IM.admission_method_code.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Source of Admission
 
Code (Hospital Provider
 
Spell)
|NHS Data Dictionary
|<u>Encounter (Inpatient Admission)</u>
 
Contained Parameters [
 
IM.admission_source_code.property,
 
IM.admission_source_code.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Patient Classification
 
Code
|NHS Data Dictionary
|<u>Encounter (Inpatient Admission)</u>
 
Contained Parameters [
 
IM.patient_classification.property,
 
IM.patient_classification.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Start Date (Hospital
 
Provider Spell)
|CCYY-MM-DD
|<u>Encounter (Inpatient)</u>
 
Period.start
 
<u>Encounter (Inpatient Admission)</u>
 
Period.start
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|clinical_effective_date
<br />
|-
|Start Time (Hospital
 
Provider Spell)
|HH:MM:SS
|<u>Encounter (Inpatient)</u>
 
Period.start
 
<u>Encounter (Inpatient Admission)</u>
 
Period.start
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|clinical_effective_date
<br />
|}
 
=== Location Group (At Start of Episode) ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Site Code (of Treatment)
|ODS
|<u>Encounter (Inpatient)</u>
 
serviceProvider
 
<u>Encounter (Inpatient Admission)</u>
 
serviceProvider
 
<u>Encounter (Inpatient Episode)</u>
 
serviceProvider
 
<u>Encounter (Inpatient Discharge)</u>
 
serviceProvider
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|organization_id
<br />
|}
 
=== Location Group (At End of Episode) ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Site Code (of Treatment)
|ODS
|<u>Encounter (Inpatient)</u>
 
serviceProvider
 
<u>Encounter (Inpatient Admission)</u>
 
serviceProvider
 
<u>Encounter (Inpatient Episode)</u>
 
serviceProvider
 
<u>Encounter (Inpatient Discharge)</u>
 
serviceProvider
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|organization_id
<br />
|}
 
=== Hospital Provider Spell - Discharge Characteristics ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Discharge Date (Hospital
 
Provider Spell)
|CCYY-MM-DD
|<u>Encounter (Inpatient)</u>
 
Period.end
 
<u>Encounter (Inpatient Discharge)</u>
 
Period.start
 
Period.end
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|end_date
 
 
clinical_effective_date
 
end_date
|-
|Discharge Time
 
(Hospital Provider Spell)
|HH:MM:SS
|<u>Encounter (Inpatient)</u>
 
Period.end
 
<u>Encounter (Inpatient Discharge)</u>


<u>encounter_event</u>
Period.start


<u>encounter_event</u>
Period.end
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|end_date
|end_date


clinical_effective_date
clinical_effective_date
end_date
|-
|Discharge Destination
Code (Hospital Provider
Spell)
|NHS Data Dictionary
|<u>Encounter (Inpatient Admission)</u>
Contained Parameters [
IM.discharge_destination_code.property,
IM.discharge_destination_code.value
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Discharge Method Code
(Hospital Provider Spell)
|NHS Data Dictionary
|<u>Encounter (Inpatient Admission)</u>
Contained Parameters [
IM.discharge_method.property,
IM.discharge_method.value
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|}
|}


=== Emergency Care Attendance Location ===
=== Consultant Episode - Person Group (Consultant) ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Activity Treatment
 
Function Code
|NHS Data Dictionary
|<u>Encounter (Inpatient Admission)</u>
 
Contained Parameters [
 
IM.treatment_function_code.property,
 
IM.treatment_function_code.value
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Consultant Code
|NHS national code
|<u>Encounter (Inpatient)</u>
 
participant
 
<u>Encounter (Inpatient Admission)</u>
 
participant
 
<u>Encounter (Inpatient Episode)</u>
 
participant
 
<u>Encounter (Inpatient Discharge)</u>
 
participant
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
|practitioner_id
<br />
|}
 
=== Consultant Episode - Clinical Diagnosis Group ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Primary Diagnosis
|ICD-10
|<u>Condition (diagnosis)</u>
 
CodeableConcept.coding.code
 
is_primary
|<u>observation</u>
|core_concept_id,
 
is_problem = false,
 
is_primary = true
|-
|Secondary Diagnosis
|ICD-10
|<u>Condition (diagnosis)</u>
 
CodeableConcept.coding.code
|<u>observation</u>
|core_concept_id,
 
is_problem = false,
 
is_primary = false
|}
 
=== Consultant Episode - Clinical Activity Group ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Primary Procedure
|OPCS4
|<u>Procedure</u>
 
CodeableConcept.coding.code
 
is_primary
|<u>observation</u>
|core_concept_id,
 
is_primary = true
|-
|Primary Procedure Date
|CCYY-MM-DD
|<u>Procedure</u>
 
startDate
|<u>observation</u>
|clinical_effective_date
|-
|Secondary Procedure
|OPCS4
|<u>Procedure</u>
 
CodeableConcept.coding.code
|<u>observation</u>
|core_concept_id,
 
is_primary = false
|-
|Secondary Procedure Date
|CCYY-MM-DD
|<u>Procedure</u>
 
startDate
|<u>observation</u>
|clinical_effective_date
|}
 
=== Consultant Episode – Activity Characteristics ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Episode Number
|Sequential 2-digit
 
number (01 – 89)
|<u>Encounter (Inpatient Episode)</u>
 
id + episode_number + ":IP:Episode"
|<u>encounter_event</u>
|id
|-
|Start Date (Episode)
|CCYY-MM-DD
|<u>Encounter (Inpatient Episode)</u>
 
Period.start
|<u>encounter_event</u>
|clinical_effective_date
|-
|Start Time (Episode)
|HH:MM:SS
|<u>Encounter (Inpatient Episode)</u>
 
Period.start
|<u>encounter_event</u>
|clinical_effective_date
|-
|End Date (Episode)
|CCYY-MM-DD
|<u>Encounter (Inpatient Episode)</u>
 
Period.end
|<u>encounter_event</u>
|end_date
|-
|End Time (Episode)
|HH:MM:SS
|<u>Encounter (Inpatient Episode)</u>
 
Period.end
|<u>encounter_event</u>
|end_date
|}
 
=== Birth Occurrence - Patient Characteristics ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Delivery Method Code
|NHS Data Dictionary
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.delivery_method.property,
 
IM.delivery_method.value
 
]
 
NOTE: also part of overall maternity_birth JSON
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Delivery date
|CCYY-MM-DD
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.maternity_birth.property,
 
JSON_delivery_date
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|-
|Birth weight
|Weight in grams. 9999 = Not Known
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.maternity_birth.property,
 
JSON_birth_weight
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|-
|Live or Still Birth Code
|NHS Data Dictionary
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.live_or_still_birth_indicator.property,
 
IM.live_or_still_birth_indicator.value
 
]
 
NOTE: also part of overall maternity_birth JSON
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Gender Code
|NHS Data Dictionary
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.gender.property,
 
IM.gender.value
 
]
 
NOTE: also part of overall maternity_birth JSON
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, value_id
|-
|Mother NHS number
|NHS number (Mothers)
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.maternity_birth.property,
 
JSON_mother_nhs_number
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|}
 
=== Delivery Occurrence - for Each Baby in the Delivery (1-9) ===
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Data/Coding Type
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|Delivery Method Code
|NHS Data Dictionary
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.maternity_delivery.property,
 
JSON_delivery_method
 
]
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|-
|Birth date
|CCYY-MM-DD
|Encounter (Inpatient Episode)
 
Contained Parameters [
 
IM.maternity_delivery.property,
 
JSON_delivery_method
 
]
 
JSON_birth_date
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|-
|Birth weight
|Weight in grams. 9999 = Not Known
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.maternity_delivery.property,
 
JSON_delivery_method
 
]
 
JSON_birth_weight
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|-
|Live or Still Birth Code
|NHS Data Dictionary
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.maternity_delivery.property,
 
JSON_delivery_method
 
]
 
JSON_live_or_still_birth_indicator
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|-
|Gender Code
|NHS Data Dictionary
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.maternity_delivery.property,
 
JSON_delivery_method
 
]
 
JSON_gender_code
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|-
|Baby NHS number
|NHS number (Babies)
|<u>Encounter (Inpatient Episode)</u>
 
Contained Parameters [
 
IM.maternity_delivery.property,
 
JSON_delivery_method
 
]
 
JSON_baby_nhs_number
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
|property_id, json_value
|}

Revision as of 15:32, 28 September 2021

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