Barts Health CDS FHIR Mapping: Difference between revisions
(Created page with "to complete") |
No edit summary |
||
(27 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
to | 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. | |||
[[File:CDS_Encounter_Structure.png|alt=|frame|'''CDS Encounter Structure'''|none]] | |||
== Emergency Care CDS == | |||
=== Emergency Care Attendance 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 | |||
|- | |||
|Emergency Care Chief | |||
Complaint | |||
|SNOMED CT | |||
|<u>Condition (complaint)</u> | |||
CodeableConcept.coding.code | |||
|<u>observation</u> | |||
|core_concept_id, | |||
is_problem = true | |||
|- | |||
|Emergency Care | |||
Attendance Category | |||
|NHS Data Dictionary | |||
|<u>Encounter (Emergency Arrival)</u> | |||
Contained Parameters [ | |||
IM.attendance_category.property, | |||
IM.attendance_category.value | |||
] | |||
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | |||
|property_id, value_id | |||
|- | |||
|Emergency Care | |||
Attendance Identifier | |||
|Unique Identifier | |||
|<u>Encounter (Emergency Arrival)</u> | |||
id + ":01:EM" | |||
<u>Encounter (Emergency Assessment)</u> | |||
id + ":02:EM" | |||
<u>Encounter (Emergency Treatment)</u> | |||
id + ":03:EM" | |||
<u>Encounter (Emergency Conclusion)</u> | |||
id + ":04:EM" | |||
|<u>encounter_event</u> | |||
|id | |||
|- | |||
|Emergency Care | |||
Attendance Source | |||
|SNOMED CT | |||
|<u>Encounter (Emergency Arrival)</u> | |||
Contained Parameters [ | |||
IM.attendance_source.property, | |||
IM.attendance_source.value | |||
] | |||
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | |||
|property_id, value_id | |||
|- | |||
|Emergency Care Arrival | |||
Mode | |||
|SNOMED CT | |||
|<u>Encounter (Emergency Arrival)</u> | |||
Contained Parameters [ | |||
IM.arrival_mode.property, | |||
IM.arrival_mode.value | |||
] | |||
|<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | |||
|property_id, value_id | |||
|- | |||
|Emergency Care Arrival | |||
Date | |||
|CCYY-MM-DD | |||
|<u>Encounter (Emergency)</u> | |||
Period.start | |||
<u>Encounter (Emergency Arrival)</u> | |||
Period.start | |||
<u>Condition (complaint)</u> | |||
Onset Date | |||
|<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> | |||
|clinical_effective_date | |||
<br /> | |||
|- | |||
|Emergency Care Arrival | |||
Time | |||
|HH:MM:SS | |||
|<u>Encounter (Emergency)</u> | |||
Period.start | |||
<u>Encounter (Emergency Arrival)</u> | |||
Period.start | |||
<u>Condition (complaint)</u> | |||
Onset Date | |||
|<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> | |||
|clinical_effective_date | |||
<br /> | |||
|- | |||
|Emergency Care Initial | |||
Assessment Date | |||
|CCYY-MM-DD | |||
|<u>Encounter (Emergency)</u> | |||
<nowiki>|</nowiki> | |||
<u>Encounter (Emergency Arrival)</u> | |||
Period.end | |||
<u>Encounter (Emergency Assessment)</u> | |||
Period.start | |||
|<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 Initial | |||
Assessment Time | |||
|HH:MM:SS | |||
|<u>Encounter (Emergency)</u> | |||
<nowiki>|</nowiki> | |||
<u>Encounter (Emergency Arrival)</u> | |||
Period.end | |||
<u>Encounter (Emergency Assessment)</u> | |||
Period.start | |||
|<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 Date | |||
Seen for Treatment | |||
|CCYY-MM-DD | |||
|<u>Encounter (Emergency)</u> | |||
<nowiki>|</nowiki> | |||
<u>Encounter (Assessment)</u> | |||
Period.end | |||
<u>Encounter (Emergency Treatment)</u> | |||
Period.start | |||
|<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 Time | |||
Seen for Treatment | |||
|HH:MM:SS | |||
|<u>Encounter (Emergency)</u> | |||
<nowiki>|</nowiki> | |||
<u>Encounter (Assessment)</u> | |||
Period.end | |||
<u>Encounter (Emergency Treatment)</u> | |||
Period.start | |||
|<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 | |||
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.
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_eventencounter_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_eventencounter_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_eventencounter_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 |
encounterencounter_eventobservation | clinical_effective_date
|
Emergency Care Arrival
Time |
HH:MM:SS | Encounter (Emergency)
Period.start Encounter (Emergency Arrival) Period.start Condition (complaint) Onset Date |
encounterencounter_eventobservation | clinical_effective_date
|
Emergency Care Initial
Assessment Date |
CCYY-MM-DD | Encounter (Emergency)
| Encounter (Emergency Arrival) Period.end Encounter (Emergency Assessment) Period.start |
encounterencounter_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 |
encounterencounter_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 |
encounterencounter_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 |
encounterencounter_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_eventencounter_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 |
encounterencounter_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_eventencounter_additional | property_id, value_id |
Emergency Care
Attendance Conclusion Date |
CCYY-MM-DD | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.start |
encounterencounter_event | end_date
clinical_effective_date |
Emergency Care
Attendance Conclusion Time |
HH:MM:SS | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.start |
encounterencounter_event | end_date
clinical_effective_date |
Emergency Care
Departure Date |
CCYY-MM-DD | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.end |
encounterencounter_event | clinical_effective_date
end_date |
Emergency Care
Departure Time |
HH:MM:SS | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.end |
encounterencounter_event | clinical_effective_date
end_date |
Decided to Admit Date | CCYY-MM-DD | Encounter (Emergency)
status = INPROGRESS |
encounterencounter_event | Becomes (Inpatient)
*Updated via Inpatient record* |
Decided to Admit Time | HH:MM:SS | Encounter (Emergency)
status = INPROGRESS |
encounterencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_additional | property_id, value_id |
Start Date (Hospital
Provider Spell) |
CCYY-MM-DD | Encounter (Inpatient)
Period.start Encounter (Inpatient Admission) Period.start |
encounterencounter_event | clinical_effective_date
|
Start Time (Hospital
Provider Spell) |
HH:MM:SS | Encounter (Inpatient)
Period.start Encounter (Inpatient Admission) Period.start |
encounterencounter_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 |
encounterencounter_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 |
encounterencounter_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 |
encounterencounter_event | end_date
end_date |
Discharge Time
(Hospital Provider Spell) |
HH:MM:SS | Encounter (Inpatient)
Period.end Encounter (Inpatient Discharge) Period.start Period.end |
encounterencounter_event | end_date
end_date |
Discharge Destination
Code (Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.discharge_destination_code.property, IM.discharge_destination_code.value ] |
encounter_eventencounter_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_eventencounter_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_eventencounter_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 |
encounterencounter_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_eventencounter_additional | property_id, value_id |
Delivery date | CCYY-MM-DD | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_birth.property, JSON_delivery_date ] |
encounter_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_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_eventencounter_additional | property_id, json_value |