Barts Health CDS FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
 
(16 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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  
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  


Line 6: Line 8:


The child date records are processed into the DDS within the parent encounter, as shown below.
The child date records are processed into the DDS within the parent encounter, as shown below.
[[File:CDS Encounter Structure.png|thumb|310x310px|''CDS Encounter Structure''|alt=|none]]
 
'''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 ==


Line 43: Line 48:


]
]
|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 85: Line 86:


]
]
|<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 105: Line 102:


]
]
|<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 127: Line 120:


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 154: Line 139:


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 181: Line 158:


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 207: Line 180:


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 233: Line 202:


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 259: Line 224:


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 293: Line 254:


]
]
|<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 323: Line 280:


serviceProvider
serviceProvider
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
 
<nowiki>|</nowiki>
 
<u>encounter_event</u>
|organization_id
|organization_id
<br />
<br />
Line 394: Line 347:


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


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


Line 436: Line 381:


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


Line 456: Line 397:


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


Line 476: Line 413:


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


Line 490: Line 423:


status = INPROGRESS
status = INPROGRESS
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
 
<u>|</u>
 
<u>encounter_event</u>
|Becomes (Inpatient)
|Becomes (Inpatient)


Line 504: Line 433:


status = INPROGRESS
status = INPROGRESS
|<u>encounter</u>
|<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>
 
<u>|</u>
 
<u>encounter_event</u>
|Becomes (Inpatient)
|Becomes (Inpatient)


Line 526: Line 451:


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


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


]
]
|<u>encounter_event</u>
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u>
 
<u>|</u>
 
<u>encounter_additional</u>
|property_id, value_id
|property_id, value_id
|}
|}
Line 660: Line 573:
|<u>observation</u>
|<u>observation</u>
|clinical_effective_date
|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
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>
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 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
|}
=== 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
|}
|}

Latest revision as of 11:00, 3 August 2023

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.

CDS Encounter Structure

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
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 CollapseField
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 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
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 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
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 CollapseField
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 CollapseField
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 CollapseField
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 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
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 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
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 CollapseField
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
Retrieved from ‘https://wiki.discoverydataservice.org/index.php?title=Barts_Health_CDS_FHIR_Mapping&oldid=6554’