BHRUT Medway Extract FHIR Mapping: Difference between revisions

From Voror_Wiki
No edit summary
Line 162: Line 162:
|
|
|}
|}
{| 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: Flag'''
|-
|EXTERNAL_ID
|flag.id
|-
|PAS_ID
| flag.patient  (reference -> Patient resource)
|-
|ALERT_TYPE_DESCRIPTION
|flag.category
|-
|APPLIED_DTTM
|flag recorded  date extension
|-
|START_DTTM
|flag.period.start,  status = ACTIVE
|-
|ALERT_DESCRIPTION
|flag.code.text
|-
|ALERT_COMMENTS
|flag.code.text
|-
|CLOSED_DTTM
|flag.period.end,  status = INACTIVE
|}


==Activity==
==Activity==


===A&E Attendances===
===A&E Attendances===
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
! style="color:#90A4AE" |'''Publisher'''
! scope="col" width="30%" |FieldName
! style="color:#90A4AE" |DDS Core
! scope="col" width="70%" |FHIR Mapping
! colspan="2" style="color:#90A4AE" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|-
|
|
|
|
|+
|+
'''FHIR Resource: EpisodeOfCare'''
|-
|EXTERNAL_ID
|episodeofcare.id
|-
| PAS_ID
|episodeofcare.patient (reference -> Patient resource)
|-
|ARRIVAL_DTTM
|episodeofcare.period.start,.status = ACTIVE
|-
|DISCHARGED_DTTM
|episodeofcare.period.end,.status = FINISHED
|}<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: Encounter'''
|-
|EXTERNAL_ID
|encounter (Emergency).id
encounter (Emergency Arrival).id:01:EM
encounter (Emergency Assessment).id:02:EM
encounter (Emergency Treatment).id:03:EM
encounter (Emergency Conclusion).id:04:EM
|-
|PAS_ID
|encounter  (Emergency).patient (reference -> Patient resource)
encounter (Emergency Arrival).patient (reference -> Patient  resource)
encounter (Emergency Assessment).patient (reference -> Patient  resource)
encounter (Emergency Treatment).patient (reference -> Patient  resource)
encounter (Emergency Conclusion).patient (reference -> Patient  resource)
|-
|HOSPITAL_CODE
|encounter  (Emergency).serviceProvider (reference -> Organization resource)
encounter (Emergency Arrival).serviceProvider (reference -> Organization  resource)
encounter (Emergency Assessment).serviceProvider (reference ->  Organization resource)
encounter (Emergency Treatment).serviceProvider (reference ->  Organization resource)
encounter (Emergency Conclusion).serviceProvider (reference ->  Organization resource)
|-
|ATTENDANCE_TYPE
|encounter  (Emergency Arrival).containedParameters => IM.ATTENDANCE_TYPE
|-
|ARRIVAL_MODE
|encounter  (Emergency Arrival).containedParameters => IM.ARRIVAL_MODE
|-
|REFERRAL_SOURCE
|encounter  (Emergency Arrival).containedParameters => IM.REFERRAL_SOURCE
|-
|ARRIVAL_DTTM
|encounter  (Emergency).period.start, status = INPROGRESS
encounter (Emergency Arrival).period.start, status = INPROGRESS
|-
|TRIAGE_DTTM
|encounter  (Emergency Arrival).period.end, status = FINISHED
encounter (Emergency Assessment).period.start, status = INPROGRESS
|-
|SEEN_BY_AE_DOCTOR_DTTM
|encounter  (Emergency Assessment).period.end, status = FINISHED
encounter (Emergency Treatment).period.start, status = INPROGRESS
|-
|COMPLAINT
|encounter  (Emergency).codeableConcept.code.text
|-
|DISCHARGED_DTTM
|encounter  (Emergency).period.end, status = FINISHED
encounter (Emergency Treatment).period.end, status = FINISHED
encounter (Emergency Conclusion).period.start, status = INPROGRESS
episodeofcare.period.end,.status = FINISHED
|-
|LEFT_DEPARTMENT_DTTM
|encounter  (Emergency Conclusion).period.end, status = FINISHED
|-
|DISCHARGE_DESTINATION
|encounter  (Emergency Conclusion).containedParameters => IM.DISCHARGE_DESTINATION
|-
|-
|RECORDED_OUTCOME
|
|encounter  (Emergency).hospitalization.dischargeDisposition
|
encounter (Emergency Conclusion).containedParameters =>  IM.RECORDED_OUTCOME
|
|
|}
|}


Revision as of 13:16, 1 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


Activity

A&E Attendances

Publisher DDS Core Compass V2
Field Name FHIR Table Field

Spells

FieldName FHIR Mapping
FHIR Resource: Encounter
EXTERNAL_ID encounter (Inpatient).id
PAS_ID encounter (Inpatient).patient (reference -> Patient resource)

encounter (Inpatient Admission).patient (reference -> Patient resource)

encounter (Inpatient Discharge).patient (reference -> Patient resource)

ADMISSION_DTTM encounter (Inpatient).period.start, status = INPROGRESS

encounter (Inpatient Admission).period.start, status = INPROGRESS

ADMISSION_CONSULTANT_CODE encounter (Inpatient).participant (reference -> Practitioner resource)

encounter (Inpatient Admission).participant (reference -> Practitioner resource)

ADMISSION_HOSPITAL_CODE encounter (Inpatient).serviceProvider (reference -> Organization resource)

encounter (Inpatient Admission).serviceProvider (reference -> Organization resource)

encounter (Inpatient Discharge).serviceProvider (reference -> Organization resource)

ADMISSION_METHOD_CODE encounter (Inpatient Admission).containedParameters => IM.ADMISSION_METHOD_CODE
ADMISSION_SOURCE_CODE encounter (Inpatient Admission).containedParameters => IM.ADMISSION_SOURCE_CODE
ADMISSION_WARD_CODE encounter (Inpatient Admission).containedParameters => JSON_ADMISSION_WARD_CODE
PATIENT_CLASS_CODE encounter (Inpatient Admission).containedParameters => IM.PATIENT_CLASS
DISCHARGE_DTTM encounter (Inpatient).period.end, status = FINISHED

NOTE: encounter (Inpatient Admission).period.end, status = FINISHED when linked Inpatient Episode encounter starts (See EPISODES)

DISCHARGE_METHOD_CODE encounter (Inpatient Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE
DISCHARGE_DESTINATION_CODE encounter (Inpatient Discharge).containedParameters => IM.DISCHARGE_DEST_CODE
DISCHARGE_CONSULTANT_CODE encounter (Inpatient Discharge).participant (reference -> Practitioner resource)
DISCHARGE_WARD_CODE encounter (Inpatient Discharge).containedParameters => JSON_DISCHARGE_WARD_CODE


FieldName FHIR Mapping
FHIR Resource: EpisodeOfCare
EXTERNAL_ID episodeofcare.id
PAS_ID episodeofcare.patient (reference -> Patient resource)
ADMISSION_DTTM episodeofcare.period.start, status = ACTIVE
ADMISSION_CONSULTANT_CODE episodeofcare.caremanager (reference -> Practitioner resource)
ADMISSION_HOSPITAL_CODE episodeofcare.managingOrganization (reference -> Organization resource)
DISCHARGE_DTTM episodeofcare.period.start, status = FINISHED


FieldName FHIR Mapping
FHIR Resource: Condition
EXTERNAL_ID condition.encounter (reference -> encounter(Inpatient) resource)
PAS_ID condition.patient (reference -> Patient resource)
ADMISSION_DTTM condition.onset
ADMISSION_CONSULTANT_CODE condition.clinician (reference -> Practitioner resource)
PRIMARY_DIAGNOSIS condition.codeableConcept.code.text
PRIMARY_DIAGNOSIS_CODE condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)


FieldName FHIR Mapping
FHIR Resource: Procedure
EXTERNAL_ID procedure.encounter (reference -> encounter(Inpatient) resource)
PAS_ID procedure.patient (reference -> Patient resource)
ADMISSION_DTTM procedure.performed
ADMISSION_CONSULTANT_CODE procedure.performer (reference -> Practitioner resource)
PRIMARY_PROCEDURE procedure.codeableConcept.code.text
PRIMARY_PROCEDURE_CODE procedure.codeableConcept.code, procedure.codeableConcept.code.display (via lookup)

Episodes

FieldName FHIR Mapping
FHIR Resource: Encounter
EXTERNAL_ID encounter (Inpatient Episode).id:epi_num:IP:Episode
IP_SPELL_EXTERNAL_ID encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource)

encounter (Inpatient Episode).episodeOfCare (reference -> EpisodOfCare resource)

PAS_ID encounter (Inpatient Episode).patient (reference -> Patient resource)
EPI_NUM encounter (Inpatient Episode).id:epi_num:IP:Episode
EPISODE_CONSULTANT_CODE encounter (Inpatient Episode).participant (reference -> Practitioner resource)
EPISODE_START_WARD_CODE encounter (Inpatient Episode).containedParameters => JSON_EPISODE_START_WARD_CODE
EPISODE_END_WARD_CODE encounter (Inpatient Episode).containedParameters => JSON_EPISODE_END_WARD_CODE
EPISODE_START_DTTM encounter (Inpatient Admission).period.end   (created during SPELLS)

encounter (Inpatient Episode).period.start

EPISODE_END_DTTM encounter (Inpatient Episode).period.end
ADMINISTRATIVE_CATEGORY_CODE encounter (Inpatient Admission).containedParameters => IM.ADMINISTRATIVE_CATEGORY_CODE
ADMISSION_METHOD_CODE encounter (Inpatient Admission).containedParameters => IM.ADMISSION_METHOD_CODE
ADMISSION_SOURCE_CODE encounter (Inpatient Admission).containedParameters => IM.ADMISSION_SOURCE_CODE
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)


FieldName 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


FieldName 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

FieldName 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)


FieldName 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)


FieldName 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)


FieldName FHIR Mapping
FHIR Resource: Condition
EXTERNAL_ID condition.encounter (reference -> encounter(Outpatient) resource)
PAS_ID condition.patient (reference -> Patient resource)
PRIMARY_DIAGNOSIS_CODE condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)

condition.isprimary = true

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

condition.isprimary = false

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

condition.isprimary = false

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

condition.isprimary = false


FieldName 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

Retrieved from ‘https://wiki.voror.co.uk/index.php?title=BHRUT_Medway_Extract_FHIR_Mapping&oldid=6517’
Last modified
This page was last modified on 1 August 2023, at 13:16.