Barts Health CDS FHIR Mapping: Difference between revisions
More actions
No edit summary |
|||
| Line 82: | Line 82: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 102: | Line 98: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 124: | Line 116: | ||
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> | ||
<u>encounter_event</u> | |||
<u>observation</u> | |||
|clinical_effective_date | |clinical_effective_date | ||
<br /> | <br /> | ||
| Line 151: | Line 135: | ||
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> | ||
<u>encounter_event</u> | |||
<u>observation</u> | |||
|clinical_effective_date | |clinical_effective_date | ||
<br /> | <br /> | ||
| Line 178: | Line 154: | ||
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> | |||
<u>encounter_event</u> | <u>encounter_event</u> | ||
| Line 204: | Line 176: | ||
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> | |||
<u>encounter_event</u> | <u>encounter_event</u> | ||
| Line 230: | Line 198: | ||
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> | |||
<u>encounter_event</u> | <u>encounter_event</u> | ||
| Line 256: | Line 220: | ||
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> | |||
<u>encounter_event</u> | <u>encounter_event</u> | ||
| Line 290: | Line 250: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 320: | Line 276: | ||
serviceProvider | serviceProvider | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|organization_id | |organization_id | ||
<br /> | <br /> | ||
| Line 391: | Line 343: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 411: | Line 359: | ||
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 | |end_date | ||
| Line 433: | Line 377: | ||
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 | |end_date | ||
| Line 453: | Line 393: | ||
Period.end | Period.end | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|clinical_effective_date | |clinical_effective_date | ||
| Line 473: | Line 409: | ||
Period.end | Period.end | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|clinical_effective_date | |clinical_effective_date | ||
| Line 487: | Line 419: | ||
status = INPROGRESS | status = INPROGRESS | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|Becomes (Inpatient) | |Becomes (Inpatient) | ||
| Line 501: | Line 429: | ||
status = INPROGRESS | status = INPROGRESS | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|Becomes (Inpatient) | |Becomes (Inpatient) | ||
| Line 523: | Line 447: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 543: | Line 463: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 563: | Line 479: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|} | |} | ||
| Line 701: | Line 613: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 721: | Line 629: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 743: | Line 647: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 763: | Line 663: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 781: | Line 677: | ||
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> | |||
|clinical_effective_date | |clinical_effective_date | ||
<br /> | <br /> | ||
| Line 800: | Line 692: | ||
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> | |||
|clinical_effective_date | |clinical_effective_date | ||
<br /> | <br /> | ||
| Line 835: | Line 723: | ||
serviceProvider | serviceProvider | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|organization_id | |organization_id | ||
<br /> | <br /> | ||
| Line 870: | Line 754: | ||
serviceProvider | serviceProvider | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|organization_id | |organization_id | ||
<br /> | <br /> | ||
| Line 901: | Line 781: | ||
Period.end | Period.end | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|end_date | |end_date | ||
| Line 926: | Line 802: | ||
Period.end | Period.end | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|end_date | |end_date | ||
| Line 953: | Line 825: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 973: | Line 841: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|} | |} | ||
| Line 1,003: | Line 867: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 1,027: | Line 887: | ||
participant | participant | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
|practitioner_id | |practitioner_id | ||
<br /> | <br /> | ||
| Line 1,194: | Line 1,050: | ||
NOTE: also part of overall maternity_birth JSON | NOTE: also part of overall maternity_birth JSON | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 1,212: | Line 1,064: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|- | |- | ||
| Line 1,230: | Line 1,078: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|- | |- | ||
| Line 1,250: | Line 1,094: | ||
NOTE: also part of overall maternity_birth JSON | NOTE: also part of overall maternity_birth JSON | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 1,270: | Line 1,110: | ||
NOTE: also part of overall maternity_birth JSON | NOTE: also part of overall maternity_birth JSON | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
| Line 1,288: | Line 1,124: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|} | |} | ||
| Line 1,316: | Line 1,148: | ||
] | ] | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|- | |- | ||
| Line 1,336: | Line 1,164: | ||
JSON_birth_date | JSON_birth_date | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|- | |- | ||
| Line 1,356: | Line 1,180: | ||
JSON_birth_weight | JSON_birth_weight | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|- | |- | ||
| Line 1,376: | Line 1,196: | ||
JSON_live_or_still_birth_indicator | JSON_live_or_still_birth_indicator | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|- | |- | ||
| Line 1,396: | Line 1,212: | ||
JSON_gender_code | JSON_gender_code | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|- | |- | ||
| Line 1,416: | Line 1,228: | ||
JSON_baby_nhs_number | JSON_baby_nhs_number | ||
|<u>encounter_event</u> | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
<u>encounter_additional</u> | |||
|property_id, json_value | |property_id, json_value | ||
|} | |} | ||
Revision as of 15:36, 8 April 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.
Emergency Care CDS
Emergency Care Attendance Activity Characteristics
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Emergency Care Chief
Complaint |
SNOMED CT | Condition (complaint)
CodeableConcept.coding.code |
observation | core_concept_id,
is_problem = true |
| Emergency Care
Attendance Category |
NHS Data Dictionary | Encounter (Emergency Arrival)
Contained Parameters [ IM.attendance_category.property, IM.attendance_category.value ] |
encounter_event |
property_id, value_id |
| Emergency Care
Attendance Identifier |
Unique Identifier | Encounter (Emergency Arrival)
id + ":01:EM" Encounter (Emergency Assessment) id + ":02:EM" Encounter (Emergency Treatment) id + ":03:EM" Encounter (Emergency Conclusion) id + ":04:EM" |
encounter_event | id |
| Emergency Care
Attendance Source |
SNOMED CT | Encounter (Emergency Arrival)
Contained Parameters [ IM.attendance_source.property, IM.attendance_source.value ] |
encounter_event |
property_id, value_id |
| Emergency Care Arrival
Mode |
SNOMED CT | Encounter (Emergency Arrival)
Contained Parameters [ IM.arrival_mode.property, IM.arrival_mode.value ] |
encounter_event |
property_id, value_id |
| Emergency Care Arrival
Date |
CCYY-MM-DD | Encounter (Emergency)
Period.start Encounter (Emergency Arrival) Period.start Condition (complaint) Onset Date |
encounter |
clinical_effective_date
|
| Emergency Care Arrival
Time |
HH:MM:SS | Encounter (Emergency)
Period.start Encounter (Emergency Arrival) Period.start Condition (complaint) Onset Date |
encounter |
clinical_effective_date
|
| Emergency Care Initial
Assessment Date |
CCYY-MM-DD | Encounter (Emergency)
| Encounter (Emergency Arrival) Period.end Encounter (Emergency Assessment) Period.start |
encounter encounter_event |
end_date
clinical_effective_date |
| Emergency Care Initial
Assessment Time |
HH:MM:SS | Encounter (Emergency)
| Encounter (Emergency Arrival) Period.end Encounter (Emergency Assessment) Period.start |
encounter encounter_event |
end_date
clinical_effective_date |
| Emergency Care Date
Seen for Treatment |
CCYY-MM-DD | Encounter (Emergency)
| Encounter (Assessment) Period.end Encounter (Emergency Treatment) Period.start |
encounter encounter_event |
end_date
clinical_effective_date |
| Emergency Care Time
Seen for Treatment |
HH:MM:SS | Encounter (Emergency)
| Encounter (Assessment) Period.end Encounter (Emergency Treatment) Period.start |
encounter encounter_event |
end_date
clinical_effective_date |
Emergency Care Attendance Location
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Emergency Care
Department Type |
NHS Data Dictionary | Encounter (Emergency Arrival)
Contained Parameters [ IM.department_type.property, IM.department_type.value ] |
encounter_event |
property_id, value_id |
| Organisation Site
Identifier (of Treatment) |
ODS | Encounter (Emergency)
serviceProvider Encounter (Emergency Arrival) serviceProvider Encounter (Emergency Assessment) serviceProvider Encounter (Emergency Treatment) serviceProvider Encounter (Emergency Conclusion) serviceProvider |
encounter |
organization_id
|
Emergency Care Diagnoses
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Emergency Care
Diagnosis (multi) |
SNOMED CT | Condition (diagnosis)
CodeableConcept.coding.code |
observation | core_concept_id,
is_problem = false |
| Emergency Care
Diagnosis Qualifier |
SNOMED CT | only populate where = 410605003 (confirmed present) |
Discharge from Emergency Care
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Safeguarding Concern (multi) | SNOMED CT | Observation
CodeableConcept.coding.code |
observation | core_concept_id |
| Activity Treatment
Function Code (Decision to Admit) |
NHS Data Dictionary | Encounter (Emergency Conclusion)
Contained Parameters [ IM.treatment_function_code.property, IM.treatment_function_code.value ] |
encounter_event |
property_id, value_id |
| Emergency Care
Attendance Conclusion Date |
CCYY-MM-DD | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.start |
encounter |
end_date
clinical_effective_date |
| Emergency Care
Attendance Conclusion Time |
HH:MM:SS | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.start |
encounter |
end_date
clinical_effective_date |
| Emergency Care
Departure Date |
CCYY-MM-DD | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.end |
encounter |
clinical_effective_date
end_date |
| Emergency Care
Departure Time |
HH:MM:SS | Encounter (Emergency)
Period.end Encounter (Emergency Conclusion) Period.end |
encounter |
clinical_effective_date
end_date |
| Decided to Admit Date | CCYY-MM-DD | Encounter (Emergency)
status = INPROGRESS |
encounter |
Becomes (Inpatient)
*Updated via Inpatient record* |
| Decided to Admit Time | HH:MM:SS | Encounter (Emergency)
status = INPROGRESS |
encounter |
Becomes (Inpatient)
*Updated via Inpatient record* |
| Emergency Care
Discharge Status |
SNOMED CT | Encounter (Emergency Conclusion)
Contained Parameters [ IM.discharge_status.property, IM.discharge_status.value ] |
encounter_event |
property_id, value_id |
| Emergency Care
Discharge Destination |
SNOMED CT | Encounter (Emergency Conclusion)
Contained Parameters [ IM.discharge_destination.property, IM.discharge_destination.value ] |
encounter_event |
property_id, value_id |
| Emergency Care
Discharge Follow-up |
SNOMED CT | Encounter (Emergency Conclusion)
Contained Parameters [ IM.discharge_follow_up.property, IM.discharge_follow_up.value ] |
encounter_event |
property_id, value_id |
Emergency Care Investigations
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Emergency Care Clinical
Investigation (multi) |
SNOMED CT | Observation
CodeableConcept.coding.code |
observation | core_concept_id |
| Procedure Date
(Emergency Care Clinical Investigation) |
CCYY-MM-DD | Observation
effective |
observation | clinical_effective_date |
| Procedure Time
(Emergency Care Clinical Investigation) |
HH:MM:SS | Observation
effective |
observation | clinical_effective_date |
Emergency Care Treatments
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Emergency Care
Procedure (multi) |
SNOMED CT | Observation
CodeableConcept.coding.code |
observation | core_concept_id |
| Procedure Date
(Emergency Care Procedure) |
CCYY-MM-DD | Observation
effective |
observation | clinical_effective_date |
| Procedure Time
(Emergency Care Procedure) |
HH:MM:SS | Observation
effective |
observation | clinical_effective_date |
Inpatient
Hospital Provider Spell - Admission Characteristics
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Hospital Provider Spell
Number |
Unique number | Encounter (Inpatient Admission)
id + ":01:IP:Admission" Encounter (Inpatient Episode) id + episode_number + ":IP:Episode" Encounter (Inpatient Discharge) id + ":01:IP:Discharge" |
encounter_event | id |
| Administrative Category
Code (On Admission) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.administrative_category_code.property, IM.administrative_category_code.value ] |
encounter_event |
property_id, value_id |
| Admission Method Code
(Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.admission_method_code.property, IM.admission_method_code.value ] |
encounter_event |
property_id, value_id |
| Source of Admission
Code (Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.admission_source_code.property, IM.admission_source_code.value ] |
encounter_event |
property_id, value_id |
| Patient Classification
Code |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.patient_classification.property, IM.patient_classification.value ] |
encounter_event |
property_id, value_id |
| Start Date (Hospital
Provider Spell) |
CCYY-MM-DD | Encounter (Inpatient)
Period.start Encounter (Inpatient Admission) Period.start |
encounter |
clinical_effective_date
|
| Start Time (Hospital
Provider Spell) |
HH:MM:SS | Encounter (Inpatient)
Period.start Encounter (Inpatient Admission) Period.start |
encounter |
clinical_effective_date
|
Location Group (At Start of Episode)
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Site Code (of Treatment) | ODS | Encounter (Inpatient)
serviceProvider Encounter (Inpatient Admission) serviceProvider Encounter (Inpatient Episode) serviceProvider Encounter (Inpatient Discharge) serviceProvider |
encounter |
organization_id
|
Location Group (At End of Episode)
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Site Code (of Treatment) | ODS | Encounter (Inpatient)
serviceProvider Encounter (Inpatient Admission) serviceProvider Encounter (Inpatient Episode) serviceProvider Encounter (Inpatient Discharge) serviceProvider |
encounter |
organization_id
|
Hospital Provider Spell - Discharge Characteristics
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Discharge Date (Hospital
Provider Spell) |
CCYY-MM-DD | Encounter (Inpatient)
Period.end Encounter (Inpatient Discharge) Period.start Period.end |
encounter |
end_date
end_date |
| Discharge Time
(Hospital Provider Spell) |
HH:MM:SS | Encounter (Inpatient)
Period.end Encounter (Inpatient Discharge) Period.start Period.end |
encounter |
end_date
end_date |
| Discharge Destination
Code (Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.discharge_destination_code.property, IM.discharge_destination_code.value ] |
encounter_event |
property_id, value_id |
| Discharge Method Code
(Hospital Provider Spell) |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.discharge_method.property, IM.discharge_method.value ] |
encounter_event |
property_id, value_id |
Consultant Episode - Person Group (Consultant)
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Activity Treatment
Function Code |
NHS Data Dictionary | Encounter (Inpatient Admission)
Contained Parameters [ IM.treatment_function_code.property, IM.treatment_function_code.value ] |
encounter_event |
property_id, value_id |
| Consultant Code | NHS national code | Encounter (Inpatient)
participant Encounter (Inpatient Admission) participant Encounter (Inpatient Episode) participant Encounter (Inpatient Discharge) participant |
encounter |
practitioner_id
|
Consultant Episode - Clinical Diagnosis Group
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Primary Diagnosis | ICD-10 | Condition (diagnosis)
CodeableConcept.coding.code is_primary |
observation | core_concept_id,
is_problem = false, is_primary = true |
| Secondary Diagnosis | ICD-10 | Condition (diagnosis)
CodeableConcept.coding.code |
observation | core_concept_id,
is_problem = false, is_primary = false |
Consultant Episode - Clinical Activity Group
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Primary Procedure | OPCS4 | Procedure
CodeableConcept.coding.code is_primary |
observation | core_concept_id,
is_primary = true |
| Primary Procedure Date | CCYY-MM-DD | Procedure
startDate |
observation | clinical_effective_date |
| Secondary Procedure | OPCS4 | Procedure
CodeableConcept.coding.code |
observation | core_concept_id,
is_primary = false |
| Secondary Procedure Date | CCYY-MM-DD | Procedure
startDate |
observation | clinical_effective_date |
Consultant Episode – Activity Characteristics
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Episode Number | Sequential 2-digit
number (01 – 89) |
Encounter (Inpatient Episode)
id + episode_number + ":IP:Episode" |
encounter_event | id |
| Start Date (Episode) | CCYY-MM-DD | Encounter (Inpatient Episode)
Period.start |
encounter_event | clinical_effective_date |
| Start Time (Episode) | HH:MM:SS | Encounter (Inpatient Episode)
Period.start |
encounter_event | clinical_effective_date |
| End Date (Episode) | CCYY-MM-DD | Encounter (Inpatient Episode)
Period.end |
encounter_event | end_date |
| End Time (Episode) | HH:MM:SS | Encounter (Inpatient Episode)
Period.end |
encounter_event | end_date |
Birth Occurrence - Patient Characteristics
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Delivery Method Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.delivery_method.property, IM.delivery_method.value ] NOTE: also part of overall maternity_birth JSON |
encounter_event |
property_id, value_id |
| Delivery date | CCYY-MM-DD | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_birth.property, JSON_delivery_date ] |
encounter_event |
property_id, json_value |
| Birth weight | Weight in grams. 9999 = Not Known | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_birth.property, JSON_birth_weight ] |
encounter_event |
property_id, json_value |
| Live or Still Birth Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.live_or_still_birth_indicator.property, IM.live_or_still_birth_indicator.value ] NOTE: also part of overall maternity_birth JSON |
encounter_event |
property_id, value_id |
| Gender Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.gender.property, IM.gender.value ] NOTE: also part of overall maternity_birth JSON |
encounter_event |
property_id, value_id |
| Mother NHS number | NHS number (Mothers) | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_birth.property, JSON_mother_nhs_number ] |
encounter_event |
property_id, json_value |
Delivery Occurrence - for Each Baby in the Delivery (1-9)
| Field Name | Data/Coding Type | FHIR | Table | Field |
|---|---|---|---|---|
| Delivery Method Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] |
encounter_event |
property_id, json_value |
| Birth date | CCYY-MM-DD | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_birth_date |
encounter_event |
property_id, json_value |
| Birth weight | Weight in grams. 9999 = Not Known | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_birth_weight |
encounter_event |
property_id, json_value |
| Live or Still Birth Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_live_or_still_birth_indicator |
encounter_event |
property_id, json_value |
| Gender Code | NHS Data Dictionary | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_gender_code |
encounter_event |
property_id, json_value |
| Baby NHS number | NHS number (Babies) | Encounter (Inpatient Episode)
Contained Parameters [ IM.maternity_delivery.property, JSON_delivery_method ] JSON_baby_nhs_number |
encounter_event |
property_id, json_value |