Barts Health CDS FHIR Mapping: Difference between revisions
More actions
No edit summary |
No edit summary |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]] | |||
The DDS transforms the received CDS data using FHIR transforms written to the Indigo 4 Standard BT Translation Service v6-2 Specification and stores these as encounters in the DDS; an encounter is a record of the | The DDS transforms the received CDS data using FHIR transforms written to the Indigo 4 Standard BT Translation Service v6-2 Specification and stores these as encounters in the DDS; an encounter is a record of the | ||
| Line 13: | Line 15: | ||
=== Emergency Care Attendance Activity Characteristics === | === Emergency Care Attendance Activity Characteristics === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 231: | Line 233: | ||
=== Emergency Care Attendance Location === | === Emergency Care Attendance Location === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 284: | Line 286: | ||
=== Emergency Care Diagnoses === | === Emergency Care Diagnoses === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 314: | Line 316: | ||
=== Discharge from Emergency Care === | === Discharge from Emergency Care === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 486: | Line 488: | ||
=== Emergency Care Investigations === | === Emergency Care Investigations === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 530: | Line 532: | ||
=== Emergency Care Treatments === | === Emergency Care Treatments === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 576: | Line 578: | ||
=== Hospital Provider Spell - Admission Characteristics === | === Hospital Provider Spell - Admission Characteristics === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 700: | Line 702: | ||
=== Location Group (At Start of Episode) === | === Location Group (At Start of Episode) === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 731: | Line 733: | ||
=== Location Group (At End of Episode) === | === Location Group (At End of Episode) === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 762: | Line 764: | ||
=== Hospital Provider Spell - Discharge Characteristics === | === Hospital Provider Spell - Discharge Characteristics === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 848: | Line 850: | ||
=== Consultant Episode - Person Group (Consultant) === | === Consultant Episode - Person Group (Consultant) === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 895: | Line 897: | ||
=== Consultant Episode - Clinical Diagnosis Group === | === Consultant Episode - Clinical Diagnosis Group === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 931: | Line 933: | ||
=== Consultant Episode - Clinical Activity Group === | === Consultant Episode - Clinical Activity Group === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 979: | Line 981: | ||
=== Consultant Episode – Activity Characteristics === | === Consultant Episode – Activity Characteristics === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 1,031: | Line 1,033: | ||
=== Birth Occurrence - Patient Characteristics === | === Birth Occurrence - Patient Characteristics === | ||
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
| Line 1,131: | Line 1,133: | ||
=== Delivery Occurrence - for Each Baby in the Delivery (1-9) === | === 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: | {| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center; vertical-align:top; width:100%;" | ||
|- style="background-color:# | |- style="background-color:#04466b; color: white; vertical-align: top;" | ||
! scope="col" width="15%" |Field Name | ! scope="col" width="15%" |Field Name | ||
! scope="col" width="15%" |Data/Coding Type | ! scope="col" width="15%" |Data/Coding Type | ||
Latest revision as of 12:52, 14 November 2024
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
Emergency Care Attendance Location
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
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
Location Group (At Start of Episode)
Location Group (At End of Episode)
Hospital Provider Spell - Discharge Characteristics
Consultant Episode - Person Group (Consultant)
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 |
