Jump to content
Toggle search
Toggle menu
  • 131 articles
  • 373 files
  • 34 users
  • 7K edits
Voror_Wiki
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

BHRUT Medway Extract FHIR Mapping: Difference between revisions

From Voror_Wiki
More actions
← Older edit

AdminJo (talk | contribs)

5 user groups
415 edits
VisualWikitext
No edit summary
Tag: Manual revert
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{DISPLAYTITLE:BHRUT Medway Extract FHIR Mapping}}
{{DISPLAYTITLE:BHRUT Medway Extract FHIR Mapping}}
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]]


== Demographics ==
== Demographics ==
Line 5: Line 7:
=== PMI ===
=== PMI ===


{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 137: Line 139:
|registered_practice_organization_id
|registered_practice_organization_id
|}
|}


===Alerts===
===Alerts===


{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 192: Line 193:
|is_active
|is_active
|}
|}


==Activity==
==Activity==


===A&E Attendances===
===A&E Attendances===
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 360: Line 360:


=== Spells ===
=== Spells ===
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 564: Line 564:


=== Episodes ===
=== Episodes ===
{| 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 991: Line 991:
=== Outpatients===
=== 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:100%;"
! style="color:#90A4AE" |'''Publisher'''
! style="color:#04466b" |'''Publisher'''
! style="color:#90A4AE" |DDS Core
! style="color:#04466b" |DDS Core
! colspan="2" style="color:#90A4AE" |Compass V2
! colspan="2" style="color:#04466b" |Compass V2
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|- style="background-color:#04466b; color: white; vertical-align: top;"
! scope="col" width="15%" |Field Name
! scope="col" width="15%" |Field Name
! scope="col" width="25%" |FHIR
! scope="col" width="25%" |FHIR
Line 1,278: Line 1,278:
is_primary
is_primary
|}
|}
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]]

Latest revision as of 11:56, 14 November 2024


To see the latest Compass V2 schema, please see Discovery Remote Subscriber Database Familiarisation#Data_Mapping

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

Publisher DDS Core Compass V2
Field Name FHIR Table Field
EXTERNAL_ID Encounter (Inpatient).id encounter id
Encounter (Inpatient Admission).id:01:IP:Admission encounter_event id
Encounter (Inpatient Admission).id:01:IP:Discharge encounter_event id
EpisodeOfCare.id episode_of_care id
Condition.Encounter (reference -> Encounter(Inpatient) resource) observation encounter_id
Procedure.Encounter (reference -> Encounter(Inpatient) resource) observation encounter_id
PAS_ID Encounter (Inpatient).patient (reference -> Patient resource) encounter patient_id
Encounter (Inpatient Admission).patient (reference -> Patient resource) encounter_event
Encounter (Inpatient Discharge).patient (reference -> Patient resource) encounter_event
EpisodeOfCare.patient (reference -> Patient resource) episode_of_care
Condition.patient (reference -> Patient resource) observation
Procedure.patient (reference -> Patient resource) observation
ADMISSION_DTTM Encounter (Inpatient).period.start, status = INPROGRESS encounter clinical_effective_date
Encounter (Inpatient Admission).period.start, status = INPROGRESS encounter_event clinical_effective_date
EpisodeOfCare.period.start, status = ACTIVE episode_of_care date_registered
Condition.onset observation clinical_effective_date
Procedure.performed observation clinical_effective_date
ADMISSION_CONSULTANT_CODE Encounter (Inpatient).participant (reference -> Practitioner resource) encounter practitioner_id
Encounter (Inpatient Admission).participant (reference -> Practitioner resource) encounter_event practitioner_id
EpisodeOfCare.caremanager (reference -> Practitioner resource) episode_of_care usual_gp_practitioner_id
Condition.clinician (reference -> Practitioner resource) observation practitioner_id
Procedure.performer (reference -> Practitioner resource) observation practitioner_id
ADMISSION_HOSPITAL_CODE Encounter (Inpatient).serviceProvider (reference -> Organization resource) encounter service_provider_organization_id
Encounter (Inpatient Admission).serviceProvider (reference -> Organization resource) encounter_event
Encounter (Inpatient Discharge).serviceProvider (reference -> Organization resource) encounter_event
EpisodeOfCare.managingOrganization (reference -> Organization resource) -
ADMISSION_METHOD_CODE Encounter (Inpatient Admission).containedParameters => IM.ADMISSION_METHOD_CODE encounter_additional property_id

value_id

ADMISSION_SOURCE_CODE Encounter (Inpatient Admission).containedParameters => IM.ADMISSION_SOURCE_CODE encounter_additional property_id

value_id

ADMISSION_SPECIALTY_CODE Encounter (Inpatient Admission).containedParameters => IM.ADMISSION_SPECIALITY_CODE encounter_additional property_id

value_id

ADMISSION_WARD_CODE Encounter (Inpatient Admission).containedParameters => JSON_ADMISSION_WARD_CODE encounter_additional json_value
PATIENT_CLASS_CODE Encounter (Inpatient Admission).containedParameters => IM.PATIENT_CLASS encounter_additional property_id

value_id

DISCHARGE_DTTM Encounter (Inpatient).period.end, status = FINISHED encounter end_date
EpisodeOfCare.period.start, status = FINISHED episode_of_care date_registered_end
DISCHARGE_METHOD_CODE Encounter (Inpatient Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE encounter_additional property_id

value_id

DISCHARGE_DESTINATION_CODE Encounter (Inpatient Discharge).containedParameters => IM.DISCHARGE_DEST_CODE encounter_additional property_id

value_id

DISCHARGE_CONSULTANT_CODE Encounter (Inpatient Discharge).participant (reference -> Practitioner resource) encounter_event practitioner_id
DISCHARGE_WARD_CODE Encounter (Inpatient Discharge).containedParameters => JSON_DISCHARGE_WARD_CODE encounter_additional json_value
PRIMARY_DIAGNOSIS Condition.codeableConcept.code.text - -
PRIMARY_DIAGNOSIS_CODE Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup) observation core_concept_id

non_core_concept_id

PRIMARY_PROCEDURE Procedure.codeableConcept.code.text - -
PRIMARY_PROCEDURE_CODE Procedure.codeableConcept.code, Procedure.codeableConcept.code.display (via lookup) observation core_concept_id

non_core_concept_id

REFERRING_CONSULTANT Encounter (Inpatient Admission).containedParameters => JSON_REFERRING_CONSULTANT encounter_additional json_value

Episodes

Publisher DDS Core Compass V2
Field Name FHIR Table Field
EXTERNAL_ID Encounter (Inpatient Episode).id:epi_num:IP:Episode encounter_event id
Condition.Encounter (reference -> Encounter(Inpatient Episode) resource) observation encounter_id
Procedure.Encounter (reference -> Encounter(Inpatient Episode) resource) observation encounter_id
IP_SPELL_EXTERNAL_ID Encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource) encounter_event encounter_id
Encounter (Inpatient Episode).episodeOfCare (reference -> EpisodeOfCare resource) episode_of_care_id
PAS_ID Encounter (Inpatient Episode).patient (reference -> Patient resource) encounter_event patient_id
Condition.patient (reference -> Patient resource) observation
Procedure.patient (reference -> Patient resource) observation
EPI_NUM Encounter (Inpatient Episode).id:epi_num:IP:Episode encounter_event id
Condition.Encounter (reference -> Encounter(Inpatient Episode) resource) observation encounter_id
Procedure.Encounter (reference -> Encounter(Inpatient Episode) resource) observation encounter_id
EPISODE_CONSULTANT_CODE Encounter (Inpatient Episode).participant (reference -> Practitioner resource) encounter practitioner_id
Procedure.performer (reference -> Practitioner resource) observation
Condition.clinician (reference -> Practitioner resource)
EPISODE_SPECIALTY_CODE Encounter (Inpatient Admission).containedParameters => IM.EPISODE_SPECIALTY_CODE encounter_additional property_id

value_id

EPISODE_START_WARD_CODE Encounter (Inpatient Episode).containedParameters => JSON_EPISODE_START_WARD_CODE encounter_additional json_value
EPISODE_END_WARD_CODE Encounter (Inpatient Episode).containedParameters => JSON_EPISODE_END_WARD_CODE encounter_additional json_value
EPISODE_START_DTTM Encounter (Inpatient Admission).period.end   (created during SPELLS) encounter_event end_date
Encounter (Inpatient Episode).period.start encounter_event clinical_effective_date
EPISODE_END_DTTM Encounter (Inpatient Episode).period.end encounter_event end_date
ADMINISTRATIVE_CATEGORY_CODE Encounter (Inpatient Admission).containedParameters => IM.ADMINISTRATIVE_CATEGORY_CODE encounter_additional property_id

value_id

ADMISSION_HOSPITAL_CODE Encounter (Inpatient Episode).serviceProvider (reference -> Organization resource) encounter_event service_provider_organization_id
PRIMARY_DIAGNOSIS_CODE Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = true

observation core_concept_id

non_core_concept_id

PRIMDIAG_DTTM Condition.onset observation clinical_effective_date
DIAG_01 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG1_DTTM Condition.onset observation clinical_effective_date
DIAG_02 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG2_DTTM Condition.onset observation clinical_effective_date
DIAG_03 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG3_DTTM Condition.onset observation clinical_effective_date
DIAG_04 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG4_DTTM Condition.onset observation clinical_effective_date
DIAG_05 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG5_DTTM Condition.onset observation clinical_effective_date
DIAG_06 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG6_DTTM Condition.onset observation clinical_effective_date
DIAG_07 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG7_DTTM Condition.onset observation clinical_effective_date
DIAG_08 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG8_DTTM Condition.onset observation clinical_effective_date
DIAG_09 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG9_DTTM Condition.onset observation clinical_effective_date
DIAG_10 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG10_DTTM Condition.onset observation clinical_effective_date
DIAG_11 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG11_DTTM Condition.onset observation clinical_effective_date
DIAG_12 Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)

Condition.isprimary = false

observation core_concept_id

non_core_concept_id

DIAG12_DTTM Condition.onset observation clinical_effective_date
PRIMARY_PROCEDURE_CODE Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = true

observation core_concept_id

non_core_concept_id

PRIMARY_PROCEDURE_DATE Procedure.performed observation clinical_effective_date
PRIMARY_PROCEDURE Procedure.codeableConcept.code.text - -
PROC_01 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_01_DESC Procedure.codeableConcept.code.text - -
PROC_02 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_02_DESC Procedure.codeableConcept.code.text - -
PROC_03 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_03_DESC Procedure.codeableConcept.code.text - -
PROC_04 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_04_DESC Procedure.codeableConcept.code.text - -
PROC_05 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_05_DESC Procedure.codeableConcept.code.text - -
PROC_06 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_06_DESC Procedure.codeableConcept.code.text - -
PROC_07 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_07_DESC Procedure.codeableConcept.code.text - -
PROC_08 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_08_DESC Procedure.codeableConcept.code.text - -
PROC_09 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_09_DESC Procedure.codeableConcept.code.text - -
PROC_10 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_10_DESC Procedure.codeableConcept.code.text - -
PROC_11 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_11_DESC Procedure.codeableConcept.code.text - -
PROC_12 Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)

Procedure.isprimary = false

observation core_concept_id

non_core_concept_id

PROC_12_DESC Procedure.codeableConcept.code.text - -

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.voror.co.uk/index.php?title=BHRUT_Medway_Extract_FHIR_Mapping&oldid=6779"
Last modified
This page was last modified on 14 November 2024, at 11:56.