No edit summary |
No edit summary |
||
(8 intermediate revisions by 2 users not shown) | |||
Line 6: | Line 6: | ||
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|alt=|frame|'''CDS Encounter Structure''']] | |||
'''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 44: | Line 46: | ||
] | ] | ||
|encounter_event | |<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_additional</u> | ||
< | |||
|property_id, value_id | |property_id, value_id | ||
|- | |- | ||
Line 86: | Line 84: | ||
] | ] | ||
|<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 106: | Line 100: | ||
] | ] | ||
|<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 128: | Line 118: | ||
Onset Date | Onset Date | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>observation</u> | ||
<u>encounter_event</u> | |||
<u>observation</u> | |||
|clinical_effective_date | |clinical_effective_date | ||
<br /> | <br /> | ||
Line 155: | Line 137: | ||
Onset Date | Onset Date | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u>[[File:One to many.png|center|frameless|43x43px]]<u>observation</u> | ||
<u>encounter_event</u> | |||
<u>observation</u> | |||
|clinical_effective_date | |clinical_effective_date | ||
<br /> | <br /> | ||
Line 182: | Line 156: | ||
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 208: | Line 178: | ||
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 234: | Line 200: | ||
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 260: | Line 222: | ||
Period.start | Period.start | ||
|<u>encounter</u> | |<u>encounter</u>[[File:One to many.png|center|frameless|43x43px]]<u>encounter_event</u> | ||
<u>encounter_event</u> | |||
<u>encounter_event</u> | <u>encounter_event</u> | ||
Line 294: | Line 252: | ||
] | ] | ||
|<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 324: | Line 278: | ||
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 395: | Line 345: | ||
] | ] | ||
|<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 415: | Line 361: | ||
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 437: | Line 379: | ||
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 457: | Line 395: | ||
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 477: | Line 411: | ||
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 491: | Line 421: | ||
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 505: | Line 431: | ||
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 527: | Line 449: | ||
] | ] | ||
|<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 547: | Line 465: | ||
] | ] | ||
|<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 567: | Line 481: | ||
] | ] | ||
|<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 705: | Line 615: | ||
] | ] | ||
|<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 725: | Line 631: | ||
] | ] | ||
|<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 747: | Line 649: | ||
] | ] | ||
|<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 767: | Line 665: | ||
] | ] | ||
|<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 785: | Line 679: | ||
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 804: | Line 694: | ||
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 839: | Line 725: | ||
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 874: | Line 756: | ||
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 905: | Line 783: | ||
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 930: | Line 804: | ||
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 957: | Line 827: | ||
] | ] | ||
|<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 977: | Line 843: | ||
] | ] | ||
|<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,007: | Line 869: | ||
] | ] | ||
|<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,031: | Line 889: | ||
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,198: | Line 1,052: | ||
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,216: | Line 1,066: | ||
] | ] | ||
|<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,234: | Line 1,080: | ||
] | ] | ||
|<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,254: | Line 1,096: | ||
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,274: | Line 1,112: | ||
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,292: | Line 1,126: | ||
] | ] | ||
|<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,320: | Line 1,150: | ||
] | ] | ||
|<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,340: | Line 1,166: | ||
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,360: | Line 1,182: | ||
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,380: | Line 1,198: | ||
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,400: | Line 1,214: | ||
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,420: | Line 1,230: | ||
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 | ||
|} | |} |
Latest revision as of 15:32, 28 September 2021
The DDS transforms the received CDS data using FHIR transforms written to the Indigo 4 Standard BT Translation Service v6-2 Specification and stores these as encounters in the DDS; an encounter is a record of the
services provided to a patient with a medical problem within a specific period of time across a continuum of care in an integrated health care system.
The CDS data is processed into three parent encounters with a number of child date records, that also contain data.
The child date records are processed into the DDS within the parent encounter, as shown below.
Note - This is an ongoing project and this data is not yet available in the DDS or the Compass database.
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_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 | Field |
---|---|---|---|---|
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 | 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_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 | 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_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 | Field |
---|---|---|---|---|
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 | Field |
---|---|---|---|---|
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 | Field |
---|---|---|---|---|
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 | Field |
---|---|---|---|---|
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 | 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_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 | Field |
---|---|---|---|---|
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 |