BHRUT Medway Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
Line 359: Line 359:
|}
|}


=== Spells===
=== Spells ===
 
=== Episodes ===
 
=== Outpatients===


{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
Line 371: Line 375:
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|
| rowspan="6" |EXTERNAL_ID
|
|Encounter (Outpatient).id
|
|encounter
|
|id
|+
|-
|-
|
|EpisodeOfCare.id
|
|episode_of_care
|
|id
|
|}
 
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|-
|+'''FHIR Resource: Encounter'''
|Appointment.id:Appointment
|appointment
|id
|-
|-
| EXTERNAL_ID
|Condition.Encounter (reference -> Encounter(Outpatient) resource)
|encounter (Inpatient).id
|observation
|encounter_id
|-
|-
|PAS_ID
|Procedure.Encounter (reference -> Encounter(Outpatient) resource)
|encounter (Inpatient).patient (reference -> Patient resource)
|observation
 
|encounter_id
encounter (Inpatient Admission).patient (reference -> Patient resource)
 
encounter (Inpatient Discharge).patient (reference -> Patient resource)
|-
|-
|ADMISSION_DTTM
|Encounter (Outpatient).setAppointment (reference -> appointment resource)
|encounter (Inpatient).period.start, status = INPROGRESS
|encounter
 
|appointment_id
encounter (Inpatient Admission).period.start, status = INPROGRESS
|+
|-
|-
|ADMISSION_CONSULTANT_CODE
| rowspan="5" |PAS_ID
|encounter (Inpatient).participant (reference -> Practitioner resource)
|Encounter.patient (reference -> Patient resource)
 
|encounter
encounter (Inpatient Admission).participant (reference -> Practitioner resource)
| rowspan="5" |patient_id
|-
|-
|ADMISSION_HOSPITAL_CODE
|EpisodeOfCare.patient (reference -> Patient resource)
|encounter (Inpatient).serviceProvider (reference -> Organization resource)
|episode_of_care
 
encounter (Inpatient Admission).serviceProvider (reference -> Organization resource)
 
encounter (Inpatient Discharge).serviceProvider (reference -> Organization resource)
|-
|-
| ADMISSION_METHOD_CODE
|Condition.patient (reference -> Patient resource)
|encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_METHOD_CODE
|observation
|-
|-
|ADMISSION_SOURCE_CODE
|Procedure.patient (reference -> Patient resource)
|encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_SOURCE_CODE
|observation
|-
|-
|ADMISSION_WARD_CODE
|Appointment.participant (reference -> Patient resource)
|encounter (Inpatient  Admission).containedParameters => JSON_ADMISSION_WARD_CODE
|appointment
|-
|-
|PATIENT_CLASS_CODE
|ADMIN_CATEGORY_CODE
|encounter (Inpatient  Admission).containedParameters => IM.PATIENT_CLASS
|Encounter (Outpatient).containedParameters => IM.ADMIN_CATEGORY_CODE
|encounter_additional
|property_id
value_id
|-
|-
|DISCHARGE_DTTM
|APPOINTMENT_PRIORITY
|encounter (Inpatient).period.end, status = FINISHED
|EpisodeOfCare.priority extension
 
| -
NOTE: encounter (Inpatient Admission).period.end, status = FINISHED when linked Inpatient Episode encounter starts (See EPISODES)
| -
|-
|-
|DISCHARGE_METHOD_CODE
|APPT_TYPE
| encounter (Inpatient  Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE
|Appointment.type.text
|appointment_additional
|property_id
text_value
|-
|-
|DISCHARGE_DESTINATION_CODE
|APPOINTMENT_OUTCOME
|encounter  (Inpatient Discharge).containedParameters => IM.DISCHARGE_DEST_CODE
|Appointment.comments
| -
| -
|-
|-
|DISCHARGE_CONSULTANT_CODE
|APPOINTMENT_STATUS_CODE
|encounter  (Inpatient Discharge).participant (reference -> Practitioner resource)
|Encounter (Outpatient).containedParameters => IM.APPOINTMENT_STATUS_CODE
|encounter_additional
appointment
|property_id
value_id
appointment_status_concept_id
|-
|-
|DISCHARGE_WARD_CODE
| rowspan="4" |APPOINTMENT_DTTM
|encounter (Inpatient  Discharge).containedParameters => JSON_DISCHARGE_WARD_CODE
|Appointment.start
|}<br />
|appointment
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|start_date
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|-
|+'''FHIR Resource: EpisodeOfCare'''
|Encounter (Outpatient).period.start (if APPT_SEEN_DTM blank)
|encounter
|clinical_effective_date
|-
|-
|EXTERNAL_ID
|Appointment.minutesDuration
|episodeofcare.id
| -
| -
|-
|-
|PAS_ID
|EpisodeOfCare.period.start (if APPT_SEEN_DTM blank)
|episodeofcare.patient (reference -> Patient resource)
|episode_of_care
|date_registered
|-
|-
|ADMISSION_DTTM
|APPT_ARRIVAL_DTTM
|episodeofcare.period.start, status = ACTIVE
|Appointment.extension.APPOINTMENT_PATIENT_WAIT
|appointment
|patient_wait
|-
|-
|ADMISSION_CONSULTANT_CODE
|APPT_CALL_DTTM
|episodeofcare.caremanager (reference -> Practitioner resource)
|Appointment.minutesDuration
| -
| -
|-
|-
|ADMISSION_HOSPITAL_CODE
| rowspan="3" |APPT_SEEN_DTTM
|episodeofcare.managingOrganization (reference -> Organization resource)
|Encounter (Outpatient).period.start
|appointment
|clinical_effective_date
|-
|-
|DISCHARGE_DTTM
|Appointment.extension.APPOINTMENT_PATIENT_DELAY
| episodeofcare.period.start, status = FINISHED
|encounter
|}<br />
|date_time_sent_in
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|-
|+'''FHIR Resource: Condition'''
|EpisodeOfCare.period.start
|episode_of_care
|date_registered
|-
|-
|EXTERNAL_ID
|APPT_DEPARTURE_DTTM
|condition.encounter (reference -> encounter(Inpatient) resource)
|Appointment.end
|appointment
|date_time_left
|-
|-
|PAS_ID
|
|condition.patient (reference -> Patient resource)
|Encounter (Outpatient).period.end
|encounter
|end_date
|-
|-
|ADMISSION_DTTM
|
|condition.onset
|EpisodeOfCare.period.end
|episode_of_care
|date_registered_end
|-
|-
|ADMISSION_CONSULTANT_CODE
|BOOKED_DTTM
|condition.clinician (reference -> Practitioner resource)
|Appointment.bookingdateextension
| -
| -
|-
|-
| PRIMARY_DIAGNOSIS
|CANCEL_DTTM
|condition.codeableConcept.code.text
|Appointment.cancellationdateextension
|-
|appointment
|PRIMARY_DIAGNOSIS_CODE
|cancelled_date
|condition.codeableConcept.code,  condition.codeableConcept.code.display (via lookup)
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|-
|+'''FHIR Resource: Procedure'''
| rowspan="2" |HOSPITAL_CODE
|Encounter (Outpatient).serviceProvider (reference -> Organization resource)
|encounter
|service_provider_organization_id
|-
|-
|EXTERNAL_ID
|EpisodeOfCare.managingOrganization (reference -> Organization resource)
|procedure.encounter (reference -> encounter(Inpatient) resource)
| -
| -
|-
|-
|PAS_ID
| rowspan="3" |CONSULTANT_CODE
|procedure.patient (reference -> Patient resource)
|Encounter (Outpatient).participant (reference -> Practitioner resource)
|encounter
|practitioner_id
|-
|-
|ADMISSION_DTTM
|EpisodeOfCare.careManager (reference -> Practitioner resource)
|procedure.performed
|episode_of_care
|usual_gp_practitioner_id
|-
|-
|ADMISSION_CONSULTANT_CODE
|Appointment.participant (reference -> Practitioner resource)
|procedure.performer (reference -> Practitioner resource)
|appointment
|practitioner_id
|-
|-
|PRIMARY_PROCEDURE
|SPECIALTY_CODE
|procedure.codeableConcept.code.text
|Encounter (Outpatient).containedParameters => IM.OUTPATIENT_SPECIALTY_CODE
|encounter_additional
appointment_additional
|property_id
value_id
|-
|-
|PRIMARY_PROCEDURE_CODE
|PRIMARY_PROCEDURE_CODE
|procedure.codeableConcept.code, procedure.codeableConcept.code.display (via lookup)  
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
|}
Procedure.isprimary = true
 
|observation
===Episodes===
|non_core_concept_id
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
is_primary
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|-
|+'''FHIR Resource: Encounter'''
|SECONDARY_PROCEDURE_CODE_1
|-
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
|EXTERNAL_ID
Procedure.isprimary = false
|encounter (Inpatient Episode).id:epi_num:IP:Episode
|observation
|non_core_concept_id
is_primary
|-
|-
|IP_SPELL_EXTERNAL_ID
|SECONDARY_PROCEDURE_CODE_2
| encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
 
Procedure.isprimary = false
encounter (Inpatient Episode).episodeOfCare (reference -> EpisodOfCare resource)
|observation
|non_core_concept_id
is_primary
|-
|-
|PAS_ID
|SECONDARY_PROCEDURE_CODE_3
|encounter (Inpatient Episode).patient (reference -> Patient resource)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|EPI_NUM
|SECONDARY_PROCEDURE_CODE_4
|encounter (Inpatient Episode).id:epi_num:IP:Episode
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|EPISODE_CONSULTANT_CODE
|SECONDARY_PROCEDURE_CODE_5
|encounter (Inpatient Episode).participant (reference -> Practitioner resource)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|EPISODE_START_WARD_CODE
|SECONDARY_PROCEDURE_CODE_6
|encounter  (Inpatient Episode).containedParameters => JSON_EPISODE_START_WARD_CODE
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|EPISODE_END_WARD_CODE
|SECONDARY_PROCEDURE_CODE_7
|encounter  (Inpatient Episode).containedParameters => JSON_EPISODE_END_WARD_CODE
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
| EPISODE_START_DTTM
|SECONDARY_PROCEDURE_CODE_8
|encounter  (Inpatient Admission).period.end    (created during SPELLS)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
encounter (Inpatient Episode).period.start
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|EPISODE_END_DTTM
|SECONDARY_PROCEDURE_CODE_9
|encounter  (Inpatient Episode).period.end
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|ADMINISTRATIVE_CATEGORY_CODE
|SECONDARY_PROCEDURE_CODE_10
|encounter  (Inpatient Admission).containedParameters =>  IM.ADMINISTRATIVE_CATEGORY_CODE
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|ADMISSION_METHOD_CODE
|SECONDARY_PROCEDURE_CODE_11
| encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_METHOD_CODE
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
|-
Procedure.isprimary = false
|ADMISSION_SOURCE_CODE
|observation
|encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_SOURCE_CODE
|non_core_concept_id
|-
is_primary
|PATIENT_CLASS_CODE
|encounter (Inpatient  Admission).containedParameters => IM.PATIENT_CLASS
|-
|DISCHARGE_METHOD_CODE
|encounter (Inpatient  Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE
|-
|DISCHARGE_DESTINATION_CODE
|encounter  (Inpatient Discharge).containedParameters => IM.DISCHARGE_DEST_CODE
|-
|ADMISSION_HOSPITAL_CODE
|encounter  (Inpatient Episode).serviceProvider (reference -> Organization resource)
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|+ '''FHIR Resource: Condition'''
|-
|EXTERNAL_ID
|condition.encounter (reference -> encounter(Inpatient Episode) resource)
|-
|PAS_ID
|condition.patient (reference -> Patient resource)
|-
|EPISODE_CONSULTANT_CODE
|condition.clinician (reference -> Practitioner resource)
|-
|PRIMARY_DIAGNOSIS_CODE
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)  
condition.isprimary = true
|-
|PRIMDIAG_DTTM
|condition.onset
|-
|DIAG_01 - DIAG_12
|condition.codeableConcept.code,  condition.codeableConcept.code.display (via lookup)
condition.isprimary = false
|-
|DIAG1_DTTM - DIAG12_DTTM
|condition.onset
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|+ '''FHIR Resource: Procedure'''
|-
|EXTERNAL_ID
|procedure.encounter (reference -> encounter(Inpatient Episode) resource)
|-
|PAS_ID
|procedure.patient (reference -> Patient resource)
|-
|EPISODE_CONSULTANT_CODE
|procedure.performer (reference -> Practitioner resource)
|-
|PRIMARY_PROCEDURE_CODE
|procedure.codeableConcept.code,procedure.codeableConcept.code.display  (via lookup)
procedure.isprimary = true
|-
|PRIMARY_PROCEDURE_DATE
|procedure.performed
|-
|PRIMARY_PROCEDURE
|procedure.codeableConcept.code.text
|-
|PROC_01 - PROC_12
|procedure.codeableConcept.code,procedure.codeableConcept.code.display  (via lookup)
procedure.isprimary = false
|-
|PROC_01_DESC - PROC_12_DESC
|procedure.codeableConcept.code.text
|}
 
===Outpatients===
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|+'''FHIR Resource: Encounter'''
|-
|EXTERNAL_ID
| encounter (Outpatient).id
 
encounter (Outpatient).setAppointment (reference -> appointment resource)
|-
|PAS_ID
|encounter.patient (reference -> Patient resource)
|-
|ADMIN_CATEGORY_CODE
|encounter (Outpatient).containedParameters => IM.ADMIN_CATEGORY_CODE
|-
|APPOINTMENT_STATUS_CODE
|encounter (Outpatient).containedParameters => IM.APPOINTMENT_STATUS_CODE
|-
|APPOINTMENT_DTTM
|encounter (Outpatient).period.start (if APPT_SEEN_DTM blank)
|-
|APPT_SEEN_DTTM
|encounter (Outpatient).period.start
|-
|APPT_DEPARTURE_DTTM
|encounter (Outpatient).period.end
|-
|HOSPITAL_CODE
|encounter (Outpatient).serviceProvider (reference -> Organization resource)
|-
|CONSULTANT_CODE
| encounter (Outpatient).participant (reference -> Practitioner resource)
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|+'''FHIR Resource: EpisodeOfCare'''
|-
|EXTERNAL_ID
|episodeofcare.id
|-
|PAS_ID
|episodeofcare.patient (reference -> Patient resource)
|-
|APPOINTMENT_PRIORITY
|episodeofcare.priority  extension
|-
|APPOINTMENT_DTTM
|episodeofcare.period.start (if APPT_SEEN_DTM blank)
|-
|APPT_SEEN_DTTM
|episodeofcare.period.start
|-
|APPT_DEPARTURE_DTTM
| episodeofcare.period.end
|-
|HOSPITAL_CODE
|episodeofcare.managingOrganization (reference -> Organization resource)
|-
| CONSULTANT_CODE
|episodeofcare.careManager (reference -> Practitioner resource)
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|+'''FHIR Resource: Appointment'''
|-
|EXTERNAL_ID
|appointment.id:Appointment
|-
|PAS_ID
|appointment.participant (reference -> Patient resource)
|-
|APPT_TYPE
|appointment.type.text
|-
|APPOINTMENT_OUTCOME
|appointment.comments
|-
| APPOINTMENT_STATUS
|appointment.status
|-
|APPOINTMENT_DTTM
|appointment.start
|-
|APPT_ARRIVAL_DTTM
|appointment.minutesDuration
|-
|APPT_CALL_DTTM
|appointment.minutesDuration
|-
|APPT_SEEN_DTTM
|appointment.end
|-
|BOOKED_DTTM
|appointment  booking date extension
|-
|CANCEL_DTTM
|appointment cancellation date extension
|-
|CONSULTANT_CODE
|appointment.participant (reference -> Practitioner resource)
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|+'''FHIR Resource: Condition'''
|-
|EXTERNAL_ID
| condition.encounter (reference -> encounter(Outpatient) resource)
|-
|PAS_ID
|condition.patient (reference -> Patient resource)
|-
|-
|PRIMARY_DIAGNOSIS_CODE
|PRIMARY_DIAGNOSIS_CODE
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
condition.isprimary = true
Condition.isprimary = true
|observation
|non_core_concept_id
is_primary
|-
|-
|SECONDARY_DIAGNOSIS_CODE_1
|SECONDARY_DIAGNOSIS_CODE_1
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
condition.isprimary = false
Condition.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|SECONDARY_DIAGNOSIS_CODE_2  
|SECONDARY_DIAGNOSIS_CODE_2
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
condition.isprimary = false
Condition.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|SECONDARY_DIAGNOSIS_CODE_3
|SECONDARY_DIAGNOSIS_CODE_3
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
condition.isprimary = false
Condition.isprimary = false
|}<br />
|observation
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|non_core_concept_id
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
is_primary
! scope="col" width="30%" |FieldName
! scope="col" width="70%" |FHIR Mapping
|-
|+'''FHIR Resource: Procedure'''
|-
|EXTERNAL_ID
|procedure.encounter (reference -> encounter(Outpatient) resource)
|-
|PAS_ID
|procedure.patient (reference -> Patient resource)
|-
|PRIMARY_PROCEDURE_CODE
|procedure.codeableConcept.code,procedure.codeableConcept.code.display  (via lookup)
procedure.isprimary = true
|-
|SECONDARY_PROCEDURE_CODE_1
|procedure.codeableConcept.code,procedure.codeableConcept.code.display  (via lookup)
procedure.isprimary = false
|-
|SECONDARY_PROCEDURE_CODE_2 - 11
|procedure.codeableConcept.code,procedure.codeableConcept.code.display  (via lookup)
procedure.isprimary = false
|}
|}

Revision as of 12:36, 2 August 2023


Demographics

PMI

Publisher DDS Core Compass V2
Field Name FHIR Table Field
PAS_ID Patient.id

Patient.identifier

patient id
FORENAME Patient::Name::Given patient first_names
SURNAME Patient::Name::Family patient last_name
NHS_NUMBER Patient::Identifier::Value (use=official, system=nhs-number) patient nhs_number
GENDER_CODE Patient::Gender patient gender_concept_id
BIRTH_DTTM Patient::BirthDate patient date_of_birth
DEATH_DTTM Patient::Deceased patient date_of_death
CAUSEOFDEATH Patient.containedParameters => IM.CAUSEOFDEATH patient_additional property_id

value_id

CAUSEOFDEATH_1B Patient.containedParameters => IM.CAUSEOFDEATH_1B patient_additional property_id

value_id

CAUSEOFDEATH_1C Patient.containedParameters => IM.CAUSEOFDEATH_1C patient_additional property_id

value_id

CAUSEOFDEATH_2 Patient.containedParameters => IM.CAUSEOFDEATH_2 patient_additional property_id

value_id

INFECTION_STATUS Patient.containedParameters => IM.INFECTION_STATUS patient_additional property_id

value_id

ADDRESS1 Patient::Address::Line patient_address address_line_1
ADDRESS2 Patient::Address::Line patient_address address_line_2
ADDRESS3 Patient::Address::Line patient_address address_line_3
ADDRESS4 Patient::Address::City patient_address city
ADDRESS5 Patient::Address::District patient_address address_line_4
POSTCODE Patient::Address::PostalCode patient_address postcode
SENSITIVE_PDS_FLAG Patient:spinesensitiveextension - -
HPHONE_NUMBER Patient::contactPoint::phone (use=home, system=phone) patient_contact type_concept_id - value
MPHONE_NUMBER Patient::contactPoint::phone (use=mobile, system=phone) patient_contact type_concept_id - value
ETHNICITY_CODE Patient::enthnicity.extension patient ethnic_code_concept_id
REGISTERED_GP_PRACTICE Patient::ServiceProvider patient registered_practice_organization_id


Alerts

Publisher DDS Core Compass V2
Field Name FHIR Table Field
EXTERNAL_ID Flag.id flag id
PAS_ID Flag.patient (reference -> Patient resource) flag patient_id
ALERT_TYPE_DESCRIPTION Flag.category flag flag_text
APPLIED_DTTM Flag.recorded date extension - -
START_DTTM Flag.period.start, status = ACTIVE flag effective_date
ALERT_DESCRIPTION Flag.code.text flag flag_text
ALERT_COMMENTS Flag.code.text flag flag_text
CLOSED_DTTM Flag.period.end, status = INACTIVE flag is_active


Activity

A&E Attendances

Publisher DDS Core Compass V2
Field Name FHIR Table Field
EXTERNAL_ID Encounter (Emergency).id encounter id
Encounter (Emergency Arrival).id:01:EM encounter_event
Encounter (Emergency Assessment).id:02:EM encounter_event
Encounter (Emergency Treatment).id:03:EM encounter_event
Encounter (Emergency Conclusion).id:04:EM encounter_event
EpisodeOfCare.id episode_of_care
PAS_ID Encounter (Emergency).patient (reference -> Patient resource) encounter patient_id
Encounter (Emergency Arrival).patient (reference -> Patient resource) encounter_event
Encounter (Emergency Assessment).patient (reference -> Patient resource) encounter_event
Encounter (Emergency Treatment).patient (reference -> Patient resource) encounter_event
Encounter (Emergency Conclusion).patient (reference -> Patient resource) encounter_event
EpisodeOfCare.patient (reference -> Patient resource) episode_of_care
HOSPITAL_CODE Encounter (Emergency).serviceProvider (reference -> Organization resource) encounter service_provider_organization_id
Encounter (Emergency Arrival).serviceProvider (reference -> Organization resource) encounter_event
Encounter (Emergency Assessment).serviceProvider (reference -> Organization resource) encounter_event
Encounter (Emergency Treatment).serviceProvider (reference -> Organization resource) encounter_event
Encounter (Emergency Conclusion).serviceProvider (reference -> Organization resource) encounter_event
ATTENDANCE_TYPE Encounter (Emergency Arrival).containedParameters => IM.ATTENDANCE_TYPE encounter_additional property_id

value_id

ARRIVAL_MODE Encounter (Emergency Arrival).containedParameters => IM.ARRIVAL_MODE encounter_additional property_id

value_id

REFERRAL_SOURCE Encounter (Emergency Arrival).containedParameters => IM.REFERRAL_SOURCE encounter_additional property_id

value_id

ARRIVAL_DTTM Encounter (Emergency).period.start, status = INPROGRESS encounter clinical_effective_date
Encounter (Emergency Arrival).period.start, status = INPROGRESS encounter_event clinical_effective_date
EpisodeOfCare.period.start,.status = ACTIVE episode_of_care date_registered
TRIAGE_DTTM Encounter (Emergency Arrival).period.end, status = FINISHED encounter_event end_date
Encounter (Emergency Assessment).period.start, status = INPROGRESS encounter_event clinical_effective_date
SEEN_BY_AE_DOCTOR_DTTM Encounter (Emergency Assessment).period.end, status = FINISHED encounter_event end_date
Encounter (Emergency Treatment).period.start, status = INPROGRESS encounter_event clinical_effective_date
COMPLAINT Encounter (Emergency).codeableConcept.code.text - -
DISCHARGED_DTTM Encounter (Emergency).period.end, status = FINISHED encounter end_date
Encounter (Emergency Treatment).period.end, status = FINISHED encounter_event end_date
Encounter (Emergency Conclusion).period.start, status = INPROGRESS encounter_event clinical_effective_date
EpisodeOfCare.period.end,.status = FINISHED episode_of_care date_registered_end
LEFT_DEPARTMENT_DTTM Encounter (Emergency Conclusion).period.end, status = FINISHED encounter_event end_date
DISCHARGE_DESTINATION Encounter (Emergency Conclusion).containedParameters => IM.DISCHARGE_DESTINATION encounter_additional property_id

value_id

RECORDED_OUTCOME Encounter (Emergency).hospitalization.dischargeDisposition encounter_additional property_id
Encounter (Emergency Conclusion).containedParameters => IM.RECORDED_OUTCOME value_id

Spells

Episodes

Outpatients

Publisher DDS Core Compass V2
Field Name FHIR Table Field
EXTERNAL_ID Encounter (Outpatient).id encounter id
EpisodeOfCare.id episode_of_care id
Appointment.id:Appointment appointment id
Condition.Encounter (reference -> Encounter(Outpatient) resource) observation encounter_id
Procedure.Encounter (reference -> Encounter(Outpatient) resource) observation encounter_id
Encounter (Outpatient).setAppointment (reference -> appointment resource) encounter appointment_id
PAS_ID Encounter.patient (reference -> Patient resource) encounter patient_id
EpisodeOfCare.patient (reference -> Patient resource) episode_of_care
Condition.patient (reference -> Patient resource) observation
Procedure.patient (reference -> Patient resource) observation
Appointment.participant (reference -> Patient resource) appointment
ADMIN_CATEGORY_CODE Encounter (Outpatient).containedParameters => IM.ADMIN_CATEGORY_CODE encounter_additional property_id

value_id

APPOINTMENT_PRIORITY EpisodeOfCare.priority extension - -
APPT_TYPE Appointment.type.text appointment_additional property_id

text_value

APPOINTMENT_OUTCOME Appointment.comments - -
APPOINTMENT_STATUS_CODE Encounter (Outpatient).containedParameters => IM.APPOINTMENT_STATUS_CODE encounter_additional

appointment

property_id

value_id appointment_status_concept_id

APPOINTMENT_DTTM Appointment.start appointment start_date
Encounter (Outpatient).period.start (if APPT_SEEN_DTM blank) encounter clinical_effective_date
Appointment.minutesDuration - -
EpisodeOfCare.period.start (if APPT_SEEN_DTM blank) episode_of_care date_registered
APPT_ARRIVAL_DTTM Appointment.extension.APPOINTMENT_PATIENT_WAIT appointment patient_wait
APPT_CALL_DTTM Appointment.minutesDuration - -
APPT_SEEN_DTTM Encounter (Outpatient).period.start appointment clinical_effective_date
Appointment.extension.APPOINTMENT_PATIENT_DELAY encounter date_time_sent_in
EpisodeOfCare.period.start episode_of_care date_registered
APPT_DEPARTURE_DTTM Appointment.end appointment date_time_left
Encounter (Outpatient).period.end encounter end_date
EpisodeOfCare.period.end episode_of_care date_registered_end
BOOKED_DTTM Appointment.bookingdateextension - -
CANCEL_DTTM Appointment.cancellationdateextension appointment cancelled_date
HOSPITAL_CODE Encounter (Outpatient).serviceProvider (reference -> Organization resource) encounter service_provider_organization_id
EpisodeOfCare.managingOrganization (reference -> Organization resource) - -
CONSULTANT_CODE Encounter (Outpatient).participant (reference -> Practitioner resource) encounter practitioner_id
EpisodeOfCare.careManager (reference -> Practitioner resource) episode_of_care usual_gp_practitioner_id
Appointment.participant (reference -> Practitioner resource) appointment practitioner_id
SPECIALTY_CODE Encounter (Outpatient).containedParameters => IM.OUTPATIENT_SPECIALTY_CODE encounter_additional

appointment_additional

property_id

value_id

PRIMARY_PROCEDURE_CODE Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = true

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_1 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_2 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_3 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_4 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_5 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_6 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_7 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_8 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_9 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_10 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_PROCEDURE_CODE_11 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation non_core_concept_id

is_primary

PRIMARY_DIAGNOSIS_CODE Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = true

observation non_core_concept_id

is_primary

SECONDARY_DIAGNOSIS_CODE_1 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_DIAGNOSIS_CODE_2 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation non_core_concept_id

is_primary

SECONDARY_DIAGNOSIS_CODE_3 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation non_core_concept_id

is_primary

Retrieved from ‘https://wiki.discoverydataservice.org/index.php?title=BHRUT_Medway_Extract_FHIR_Mapping&oldid=6541’