BHRUT Medway Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
Line 370: Line 370:
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|
|EXTERNAL_ID
|
|Encounter (Inpatient).id
|
Encounter (Inpatient Admission).id:01:IP:Admission
|
Encounter (Inpatient Admission).id:01:IP:Discharge
EpisodeOfCare.id
Condition.Encounter (reference -> Encounter(Inpatient) resource)
Procedure.Encounter (reference -> Encounter(Inpatient) resource)
|encounter
encounter_event
encounter_event
episode_of_care
observation
observation
|id
id
id
id
encounter_id
encounter_id
|-
|-
|
|PAS_ID
|
|Encounter (Inpatient).patient (reference -> Patient resource)
|
Encounter (Inpatient Admission).patient (reference -> Patient resource)
|
Encounter (Inpatient Discharge).patient (reference -> Patient resource)
EpisodeOfCare.patient (reference -> Patient resource)
Condition.patient (reference -> Patient resource)
Procedure.patient (reference -> Patient resource)
|encounter
encounter_event
encounter_event
episode_of_care
observation
observation
|patient_id
|-
|-
|
|ADMISSION_DTTM
|
|Encounter (Inpatient).period.start, status = INPROGRESS
|
Encounter (Inpatient Admission).period.start, status = INPROGRESS
|
EpisodeOfCare.period.start, status = ACTIVE
Condition.onset
Procedure.performed
|encounter
encounter_event
episode_of_care
observation
observation
|clinical_effective_date
clinical_effective_date
date_registered
clinical_effective_date
clinical_effective_date
|-
|-
|
|ADMISSION_CONSULTANT_CODE
|
|Encounter (Inpatient).participant (reference -> Practitioner resource)
|
Encounter (Inpatient Admission).participant (reference -> Practitioner resource)
|
EpisodeOfCare.caremanager (reference -> Practitioner resource)
Condition.clinician (reference -> Practitioner resource)
Procedure.performer (reference -> Practitioner resource)
|encounter
encounter_event
episode_of_care
observation
observation
|practitioner_id
practitioner_id
usual_gp_practitioner_id
practitioner_id
practitioner_id
|-
|-
|
|ADMISSION_HOSPITAL_CODE
|
|Encounter (Inpatient).serviceProvider (reference -> Organization resource)
|
Encounter (Inpatient Admission).serviceProvider (reference -> Organization resource)
|
Encounter (Inpatient Discharge).serviceProvider (reference -> Organization resource)
EpisodeOfCare.managingOrganization (reference -> Organization resource)
|encounter
encounter_event
encounter_event
-
|service_provider_organization_id
|-
|-
|
|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
|
EpisodeOfCare.period.start, status = FINISHED
|
|encounter
episode_of_care
|end_date
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
|}
|}


Line 443: Line 549:
! scope="col" width="15%" |Field
! scope="col" width="15%" |Field
|-
|-
|
|EXTERNAL_ID
|
|Encounter (Inpatient Episode).id:epi_num:IP:Episode
|
Condition.Encounter (reference -> Encounter(Inpatient Episode) resource)
|
Procedure.Encounter (reference -> Encounter(Inpatient Episode) resource)
|encounter_event
observation
observation
|id
encounter_id
encounter_id
|+
|+
|-
|-
|
|IP_SPELL_EXTERNAL_ID
|
|Encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource)
|
Encounter (Inpatient Episode).episodeOfCare (reference -> EpisodeOfCare resource)
|
|encounter_event
|encounter_id
episode_of_care_id
|-
|PAS_ID
|Encounter (Inpatient Episode).patient (reference -> Patient resource)
Condition.patient (reference -> Patient resource)
Procedure.patient (reference -> Patient resource)
|encounter_event
observation
observation
|patient_id
|-
|EPI_NUM
|Encounter (Inpatient Episode).id:epi_num:IP:Episode
Condition.Encounter (reference -> Encounter(Inpatient Episode) resource)
Procedure.Encounter (reference -> Encounter(Inpatient Episode) resource)
|encounter_event
observation
observation
|id
encounter_id
encounter_id
|-
|EPISODE_CONSULTANT_CODE
|Encounter (Inpatient Episode).participant (reference -> Practitioner resource)
Procedure.performer (reference -> Practitioner resource)
Condition.clinician (reference -> Practitioner resource)
|encounter
observation
|practitioner_id
|-
|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 (Inpatient Episode).period.start
|encounter_event
encounter_event
|end_date
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
| -
| -
|}
|}


Revision as of 09:19, 3 August 2023


Demographics

PMI

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

Patient.identifier

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

value_id

CAUSEOFDEATH_1B Patient.containedParameters => IM.CAUSEOFDEATH_1B patient_additional property_id

value_id

CAUSEOFDEATH_1C Patient.containedParameters => IM.CAUSEOFDEATH_1C patient_additional property_id

value_id

CAUSEOFDEATH_2 Patient.containedParameters => IM.CAUSEOFDEATH_2 patient_additional property_id

value_id

INFECTION_STATUS Patient.containedParameters => IM.INFECTION_STATUS patient_additional property_id

value_id

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


Alerts

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


Activity

A&E Attendances

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

value_id

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

value_id

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

value_id

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

value_id

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

Spells

Publisher DDS Core Compass V2
Field Name FHIR Table Field
EXTERNAL_ID Encounter (Inpatient).id

Encounter (Inpatient Admission).id:01:IP:Admission Encounter (Inpatient Admission).id:01:IP:Discharge EpisodeOfCare.id Condition.Encounter (reference -> Encounter(Inpatient) resource) Procedure.Encounter (reference -> Encounter(Inpatient) resource)

encounter

encounter_event encounter_event episode_of_care observation observation

id

id id id encounter_id encounter_id

PAS_ID Encounter (Inpatient).patient (reference -> Patient resource)

Encounter (Inpatient Admission).patient (reference -> Patient resource) Encounter (Inpatient Discharge).patient (reference -> Patient resource) EpisodeOfCare.patient (reference -> Patient resource) Condition.patient (reference -> Patient resource) Procedure.patient (reference -> Patient resource)

encounter

encounter_event encounter_event episode_of_care observation observation

patient_id
ADMISSION_DTTM Encounter (Inpatient).period.start, status = INPROGRESS

Encounter (Inpatient Admission).period.start, status = INPROGRESS EpisodeOfCare.period.start, status = ACTIVE Condition.onset Procedure.performed

encounter

encounter_event episode_of_care observation observation

clinical_effective_date

clinical_effective_date date_registered clinical_effective_date clinical_effective_date

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

Encounter (Inpatient Admission).participant (reference -> Practitioner resource) EpisodeOfCare.caremanager (reference -> Practitioner resource) Condition.clinician (reference -> Practitioner resource) Procedure.performer (reference -> Practitioner resource)

encounter

encounter_event episode_of_care observation observation

practitioner_id

practitioner_id usual_gp_practitioner_id practitioner_id practitioner_id

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

Encounter (Inpatient Admission).serviceProvider (reference -> Organization resource) Encounter (Inpatient Discharge).serviceProvider (reference -> Organization resource) EpisodeOfCare.managingOrganization (reference -> Organization resource)

encounter

encounter_event encounter_event -

service_provider_organization_id
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

EpisodeOfCare.period.start, status = FINISHED

encounter

episode_of_care

end_date

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

Condition.Encounter (reference -> Encounter(Inpatient Episode) resource) Procedure.Encounter (reference -> Encounter(Inpatient Episode) resource)

encounter_event

observation observation

id

encounter_id encounter_id

IP_SPELL_EXTERNAL_ID Encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource)

Encounter (Inpatient Episode).episodeOfCare (reference -> EpisodeOfCare resource)

encounter_event encounter_id

episode_of_care_id

PAS_ID Encounter (Inpatient Episode).patient (reference -> Patient resource)

Condition.patient (reference -> Patient resource) Procedure.patient (reference -> Patient resource)

encounter_event

observation observation

patient_id
EPI_NUM Encounter (Inpatient Episode).id:epi_num:IP:Episode

Condition.Encounter (reference -> Encounter(Inpatient Episode) resource) Procedure.Encounter (reference -> Encounter(Inpatient Episode) resource)

encounter_event

observation observation

id

encounter_id encounter_id

EPISODE_CONSULTANT_CODE Encounter (Inpatient Episode).participant (reference -> Practitioner resource)

Procedure.performer (reference -> Practitioner resource) Condition.clinician (reference -> Practitioner resource)

encounter

observation

practitioner_id
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 (Inpatient Episode).period.start

encounter_event

encounter_event

end_date

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