BHRUT Medway Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
m (JoshuA moved page BHRUT Extract FHIR Mapping to BHRUT Medway Extract FHIR Mapping without leaving a redirect)
No edit summary
Line 4: Line 4:


=== PMI ===
=== PMI ===
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
 
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! scope="col" width="30%" |FieldName
! style="color:#90A4AE" |'''Publisher'''
! scope="col" width="70%" |FHIR Mapping
! style="color:#90A4AE" |DDS Core
! 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
|-
|-
|PAS_ID
|Patient.id
Patient.identifier
|patient
|id
|+
|+
'''FHIR Resource: Patient'''
|-
|PAS_ID
|patient.id
patient.identifier
|-
|-
|FORENAME
|FORENAME
|patient.givenName
|Patient::Name::Given
|patient
|first_names
|-
|-
|SURNAME
|SURNAME
|patient.familyName
|Patient::Name::Family
|patient
|last_name
|-
|-
|NHS_NUMBER
|NHS_NUMBER
|patient.identifier
|Patient::Identifier::Value (use=official, system=nhs-number)
|patient  
|nhs_number
|-
|-
|GENDER_CODE
|GENDER_CODE
|patient.gender
|Patient::Gender
|patient
|gender_concept_id
|-
|-
|BIRTH_DTTM
|BIRTH_DTTM
|patient.birthDate
|Patient::BirthDate
|patient
|date_of_birth
|-
|-
|DEATH_DTTM
|DEATH_DTTM
|patient.deceasedDateTime
|Patient::Deceased
|patient
|date_of_death
|-
|-
|CAUSEOFDEATH
| CAUSEOFDEATH
|patient.containedParameters => IM.CAUSEOFDEATH
|Patient.containedParameters => IM.CAUSEOFDEATH
|patient_additional
|property_id
value_id
|-
|-
|CAUSEOFDEATH_1B
|CAUSEOFDEATH_1B  
|patient.containedParameters => IM.CAUSEOFDEATH_1B
|Patient.containedParameters => IM.CAUSEOFDEATH_1B
|patient_additional
|property_id
value_id
|-
|-
|CAUSEOFDEATH_1C
| CAUSEOFDEATH_1C  
|patient.containedParameters => IM.CAUSEOFDEATH_1C
|Patient.containedParameters => IM.CAUSEOFDEATH_1C
| patient_additional
|property_id
value_id
|-
|-
|CAUSEOFDEATH_2
|CAUSEOFDEATH_2  
|patient.containedParameters => IM.CAUSEOFDEATH_2
|Patient.containedParameters => IM.CAUSEOFDEATH_2
|patient_additional
|property_id
value_id
|-
|-
|INFECTION_STATUS
|INFECTION_STATUS
|patient.containedParameters => IM.INFECTION_STATUS
|Patient.containedParameters => IM.INFECTION_STATUS
|patient_additional
|property_id
value_id
|-
|-
|ADDRESS1
|ADDRESS1
|patient.address.line,  use = HOME
|Patient::Address::Line
|patient_address
|address_line_1
|-
|-
|ADDRESS2
|ADDRESS2
|patient.address.line,  use = HOME
|Patient::Address::Line
|patient_address
|address_line_2
|-
|-
|ADDRESS3
|ADDRESS3
|patient.address.town,  use = HOME
|Patient::Address::Line
|patient_address
|address_line_3
|-
|-
|ADDRESS4
|ADDRESS4
|patient.address.line,  use = HOME
|Patient::Address::City
|patient_address
|city
|-
|-
|ADDRESS5
|ADDRESS5
|patient.address.line,  use = HOME
|Patient::Address::District
|patient_address
|address_line_4
|-
|-
|POSTCODE
|POSTCODE
|patient.address.postcode,  use = HOME
|Patient::Address::PostalCode
|patient_address
|postcode
|-
|-
|SENSITIVE_PDS_FLAG
|SENSITIVE_PDS_FLAG
|patient spine  sensitive extension (true/false)
|Patient:spinesensitiveextension
| -
| -
|-
|-
|HPHONE_NUMBER
|HPHONE_NUMBER
|patient.contact.telecom, use = HOME
|Patient::contactPoint::phone (use=home, system=phone)
|patient_contact
|type_concept_id - value
|-
|-
|MPHONE_NUMBER
|MPHONE_NUMBER
|patient.contact.telecom, use = MOBILE
|Patient::contactPoint::phone (use=mobile, system=phone)
|patient_contact
|type_concept_id - value
|-
|-
|ETHNICITY_CODE
|ETHNICITY_CODE
|patient  enthnicity extension
|Patient::enthnicity.extension
|patient
|ethnic_code_concept_id
|-
|-
|REGISTERED_GP_PRACTICE
|REGISTERED_GP_PRACTICE
|patient.serviceProvider  (reference -> Organization (GP) resource)
|Patient::ServiceProvider
|patient
|registered_practice_organization_id
|}
|}


=== Alerts ===
 
===Alerts===
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
Line 96: Line 152:
|-
|-
|PAS_ID
|PAS_ID
|flag.patient  (reference -> Patient resource)
| flag.patient  (reference -> Patient resource)
|-
|-
|ALERT_TYPE_DESCRIPTION
|ALERT_TYPE_DESCRIPTION  
|flag.category
|flag.category
|-
|-
Line 107: Line 163:
|flag.period.start,  status = ACTIVE
|flag.period.start,  status = ACTIVE
|-
|-
|ALERT_DESCRIPTION  
|ALERT_DESCRIPTION
|flag.code.text
|flag.code.text
|-
|-
Line 117: Line 173:
|}
|}


== Activity ==
==Activity==


=== A&E Attendances ===
===A&E Attendances===
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
Line 131: Line 187:
|episodeofcare.id
|episodeofcare.id
|-
|-
|PAS_ID
| PAS_ID
|episodeofcare.patient (reference -> Patient resource)
|episodeofcare.patient (reference -> Patient resource)
|-
|-
Line 138: Line 194:
|-
|-
|DISCHARGED_DTTM
|DISCHARGED_DTTM
|episodeofcare.period.end,.status = FINISHED
|episodeofcare.period.end,.status = FINISHED  
|}<br />
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
Line 209: Line 265:
|}
|}


=== Spells ===
=== Spells===
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
Line 217: Line 273:
|+'''FHIR Resource: Encounter'''
|+'''FHIR Resource: Encounter'''
|-
|-
|EXTERNAL_ID
| EXTERNAL_ID
|encounter (Inpatient).id
|encounter (Inpatient).id
|-
|-
Line 225: Line 281:
encounter (Inpatient Admission).patient (reference -> Patient resource)
encounter (Inpatient Admission).patient (reference -> Patient resource)


encounter (Inpatient Discharge).patient (reference -> Patient resource)
encounter (Inpatient Discharge).patient (reference -> Patient resource)  
|-
|-
|ADMISSION_DTTM
|ADMISSION_DTTM
Line 244: Line 300:
encounter (Inpatient Discharge).serviceProvider (reference -> Organization resource)
encounter (Inpatient Discharge).serviceProvider (reference -> Organization resource)
|-
|-
|ADMISSION_METHOD_CODE
| ADMISSION_METHOD_CODE
|encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_METHOD_CODE
|encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_METHOD_CODE
|-
|-
Line 262: Line 318:
|-
|-
|DISCHARGE_METHOD_CODE
|DISCHARGE_METHOD_CODE
|encounter (Inpatient  Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE
| encounter (Inpatient  Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE
|-
|-
|DISCHARGE_DESTINATION_CODE
|DISCHARGE_DESTINATION_CODE
Line 289: Line 345:
|episodeofcare.period.start, status = ACTIVE
|episodeofcare.period.start, status = ACTIVE
|-
|-
|ADMISSION_CONSULTANT_CODE
|ADMISSION_CONSULTANT_CODE  
|episodeofcare.caremanager (reference -> Practitioner resource)
|episodeofcare.caremanager (reference -> Practitioner resource)
|-
|-
|ADMISSION_HOSPITAL_CODE
|ADMISSION_HOSPITAL_CODE  
|episodeofcare.managingOrganization (reference -> Organization resource)
|episodeofcare.managingOrganization (reference -> Organization resource)
|-
|-
|DISCHARGE_DTTM
|DISCHARGE_DTTM  
|episodeofcare.period.start, status = FINISHED
| episodeofcare.period.start, status = FINISHED
|}<br />
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
Line 309: Line 365:
|-
|-
|PAS_ID
|PAS_ID
|condition.patient (reference -> Patient resource)  
|condition.patient (reference -> Patient resource)
|-
|-
|ADMISSION_DTTM
|ADMISSION_DTTM  
|condition.onset
|condition.onset
|-
|-
Line 317: Line 373:
|condition.clinician (reference -> Practitioner resource)
|condition.clinician (reference -> Practitioner resource)
|-
|-
|PRIMARY_DIAGNOSIS
| PRIMARY_DIAGNOSIS
|condition.codeableConcept.code.text
|condition.codeableConcept.code.text
|-
|-
Line 334: Line 390:
|-
|-
|PAS_ID
|PAS_ID
|procedure.patient (reference -> Patient resource)  
|procedure.patient (reference -> Patient resource)
|-
|-
|ADMISSION_DTTM
|ADMISSION_DTTM
Line 346: Line 402:
|-
|-
|PRIMARY_PROCEDURE_CODE
|PRIMARY_PROCEDURE_CODE
|procedure.codeableConcept.code,  procedure.codeableConcept.code.display (via lookup)
|procedure.codeableConcept.code,  procedure.codeableConcept.code.display (via lookup)  
|}
|}


=== Episodes ===
===Episodes===
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
Line 361: Line 417:
|-
|-
|IP_SPELL_EXTERNAL_ID
|IP_SPELL_EXTERNAL_ID
|encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource)
| encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource)


encounter (Inpatient Episode).episodeOfCare (reference -> EpisodOfCare resource)
encounter (Inpatient Episode).episodeOfCare (reference -> EpisodOfCare resource)
|-
|-
|PAS_ID
|PAS_ID
|encounter (Inpatient Episode).patient (reference -> Patient resource)  
|encounter (Inpatient Episode).patient (reference -> Patient resource)
|-
|-
|EPI_NUM
|EPI_NUM
Line 380: Line 436:
|encounter  (Inpatient Episode).containedParameters => JSON_EPISODE_END_WARD_CODE
|encounter  (Inpatient Episode).containedParameters => JSON_EPISODE_END_WARD_CODE
|-
|-
|EPISODE_START_DTTM
| EPISODE_START_DTTM
|encounter  (Inpatient Admission).period.end    (created during SPELLS)
|encounter  (Inpatient Admission).period.end    (created during SPELLS)
encounter (Inpatient Episode).period.start
encounter (Inpatient Episode).period.start
Line 391: Line 447:
|-
|-
|ADMISSION_METHOD_CODE
|ADMISSION_METHOD_CODE
|encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_METHOD_CODE
| encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_METHOD_CODE
|-
|-
|ADMISSION_SOURCE_CODE
|ADMISSION_SOURCE_CODE
Line 406: Line 462:
|-
|-
|ADMISSION_HOSPITAL_CODE
|ADMISSION_HOSPITAL_CODE
|encounter  (Inpatient Episode).serviceProvider (reference -> Organization resource)
|encounter  (Inpatient Episode).serviceProvider (reference -> Organization resource)  
|}<br />
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
Line 413: Line 469:
! scope="col" width="70%" |FHIR Mapping
! scope="col" width="70%" |FHIR Mapping
|-
|-
|+'''FHIR Resource: Condition'''
|+ '''FHIR Resource: Condition'''
|-
|-
|EXTERNAL_ID
|EXTERNAL_ID
Line 419: Line 475:
|-
|-
|PAS_ID
|PAS_ID
|condition.patient (reference -> Patient resource)  
|condition.patient (reference -> Patient resource)
|-
|-
|EPISODE_CONSULTANT_CODE
|EPISODE_CONSULTANT_CODE
|condition.clinician (reference -> Practitioner resource)
|condition.clinician (reference -> Practitioner 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
Line 435: Line 491:
condition.isprimary = false
condition.isprimary = false
|-
|-
|DIAG1_DTTM - DIAG12_DTTM  
|DIAG1_DTTM - DIAG12_DTTM
|condition.onset
|condition.onset
|}<br />
|}<br />
Line 443: Line 499:
! scope="col" width="70%" |FHIR Mapping
! scope="col" width="70%" |FHIR Mapping
|-
|-
|+'''FHIR Resource: Procedure'''
|+ '''FHIR Resource: Procedure'''
|-
|-
|EXTERNAL_ID
|EXTERNAL_ID
|procedure.encounter (reference -> encounter(Inpatient Episode) resource)
|procedure.encounter (reference -> encounter(Inpatient Episode) resource)  
|-
|-
|PAS_ID
|PAS_ID
|procedure.patient (reference -> Patient resource)  
|procedure.patient (reference -> Patient resource)
|-
|-
|EPISODE_CONSULTANT_CODE
|EPISODE_CONSULTANT_CODE
Line 464: Line 520:
|procedure.codeableConcept.code.text
|procedure.codeableConcept.code.text
|-
|-
|PROC_01 - PROC_12
|PROC_01 - PROC_12  
|procedure.codeableConcept.code,procedure.codeableConcept.code.display  (via lookup)
|procedure.codeableConcept.code,procedure.codeableConcept.code.display  (via lookup)
procedure.isprimary = false
procedure.isprimary = false
Line 472: Line 528:
|}
|}


=== Outpatients ===
===Outpatients===
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
Line 480: Line 536:
|+'''FHIR Resource: Encounter'''
|+'''FHIR Resource: Encounter'''
|-
|-
|EXTERNAL_ID
|EXTERNAL_ID  
|encounter (Outpatient).id
| encounter (Outpatient).id


encounter (Outpatient).setAppointment (reference -> appointment resource)
encounter (Outpatient).setAppointment (reference -> appointment resource)
Line 507: Line 563:
|-
|-
|CONSULTANT_CODE
|CONSULTANT_CODE
|encounter (Outpatient).participant (reference -> Practitioner resource)
| encounter (Outpatient).participant (reference -> Practitioner resource)
|}<br />
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
Line 532: Line 588:
|-
|-
|APPT_DEPARTURE_DTTM
|APPT_DEPARTURE_DTTM
|episodeofcare.period.end
| episodeofcare.period.end
|-
|-
|HOSPITAL_CODE
|HOSPITAL_CODE
|episodeofcare.managingOrganization (reference -> Organization resource)
|episodeofcare.managingOrganization (reference -> Organization resource)
|-
|-
|CONSULTANT_CODE
| CONSULTANT_CODE  
|episodeofcare.careManager (reference -> Practitioner resource)
|episodeofcare.careManager (reference -> Practitioner resource)
|}<br />
|}<br />
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:60%;"
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
! scope="col" width="30%" |FieldName
! scope="col" width="30%" |FieldName  
! scope="col" width="70%" |FHIR Mapping
! scope="col" width="70%" |FHIR Mapping
|-
|-
Line 551: Line 607:
|-
|-
|PAS_ID
|PAS_ID
|appointment.participant (reference -> Patient resource)  
|appointment.participant (reference -> Patient resource)
|-
|-
|APPT_TYPE
|APPT_TYPE  
|appointment.type.text
|appointment.type.text
|-
|-
Line 559: Line 615:
|appointment.comments
|appointment.comments
|-
|-
|APPOINTMENT_STATUS
| APPOINTMENT_STATUS
|appointment.status
|appointment.status
|-
|-
Line 590: Line 646:
|+'''FHIR Resource: Condition'''
|+'''FHIR Resource: Condition'''
|-
|-
|EXTERNAL_ID
|EXTERNAL_ID  
|condition.encounter (reference -> encounter(Outpatient) resource)
| condition.encounter (reference -> encounter(Outpatient) resource)
|-
|-
|PAS_ID
|PAS_ID
|condition.patient (reference -> Patient resource)  
|condition.patient (reference -> Patient resource)
|-
|-
|PRIMARY_DIAGNOSIS_CODE
|PRIMARY_DIAGNOSIS_CODE
Line 604: Line 660:
condition.isprimary = false
condition.isprimary = false
|-
|-
|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
Line 623: Line 679:
|-
|-
|PAS_ID
|PAS_ID
|procedure.patient (reference -> Patient resource)  
|procedure.patient (reference -> Patient resource)
|-
|-
|PRIMARY_PROCEDURE_CODE
|PRIMARY_PROCEDURE_CODE

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

FieldName 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

A&E Attendances

FieldName FHIR Mapping
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


FieldName 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

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.discoverydataservice.org/index.php?title=BHRUT_Medway_Extract_FHIR_Mapping&oldid=6514’