BHRUT Medway Extract FHIR Mapping: Difference between revisions
More actions
No edit summary |
m JoshuA moved page BHRUT Extract FHIR Mapping to BHRUT Medway Extract FHIR Mapping without leaving a redirect |
(No difference)
| |
Revision as of 15:50, 22 March 2021
Demographics
PMI
| FieldName | FHIR Mapping |
|---|---|
| PAS_ID | patient.id
patient.identifier |
| FORENAME | patient.givenName |
| SURNAME | patient.familyName |
| NHS_NUMBER | patient.identifier |
| GENDER_CODE | patient.gender |
| BIRTH_DTTM | patient.birthDate |
| DEATH_DTTM | patient.deceasedDateTime |
| CAUSEOFDEATH | patient.containedParameters => IM.CAUSEOFDEATH |
| CAUSEOFDEATH_1B | patient.containedParameters => IM.CAUSEOFDEATH_1B |
| CAUSEOFDEATH_1C | patient.containedParameters => IM.CAUSEOFDEATH_1C |
| CAUSEOFDEATH_2 | patient.containedParameters => IM.CAUSEOFDEATH_2 |
| INFECTION_STATUS | patient.containedParameters => IM.INFECTION_STATUS |
| ADDRESS1 | patient.address.line, use = HOME |
| ADDRESS2 | patient.address.line, use = HOME |
| ADDRESS3 | patient.address.town, use = HOME |
| ADDRESS4 | patient.address.line, use = HOME |
| ADDRESS5 | patient.address.line, use = HOME |
| POSTCODE | patient.address.postcode, use = HOME |
| SENSITIVE_PDS_FLAG | patient spine sensitive extension (true/false) |
| HPHONE_NUMBER | patient.contact.telecom, use = HOME |
| MPHONE_NUMBER | patient.contact.telecom, use = MOBILE |
| ETHNICITY_CODE | patient enthnicity extension |
| REGISTERED_GP_PRACTICE | patient.serviceProvider (reference -> Organization (GP) resource) |
Alerts
| FieldName | FHIR Mapping |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |
|---|---|
| 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 |