BHRUT Medway Extract FHIR Mapping: Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
 
(21 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== PMI ==
{{DISPLAYTITLE:BHRUT Medway Extract FHIR Mapping}}
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:50%;"
 
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
To see the latest Compass V2 schema, please see [[Discovery Remote Subscriber Database Familiarisation#Data_Mapping]]
! scope="col" width="25%" |FieldName
 
! scope="col" width="75%" |FHIR Mapping
== Demographics ==
 
=== PMI ===
 
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! 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 ==
 
{| border="1" style="border-collapse:collapse; text-align: left;  vertical-align:top; width:50%;"
===Alerts===
|- style="background-color:#90A4AE; color: white; vertical-align: top;"  
 
! scope="col" width="25%" |FieldName
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! scope="col" width="75%" |FHIR Mapping
! style="color:#90A4AE" |'''Publisher'''
! 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
|-
|-
|EXTERNAL_ID
|Flag.id
|flag
|id
|+
|+
FHIR Resource: Flag
|-
|EXTERNAL_ID
|flag.id
|-
|-
|PAS_ID
|PAS_ID
|flag.patient (reference -> Patient resource)
|Flag.patient (reference -> Patient resource)
|flag
|patient_id
|-
|-
|ALERT_TYPE_DESCRIPTION
|ALERT_TYPE_DESCRIPTION
|flag.category
|Flag.category
|flag
|flag_text
|-
|-
|APPLIED_DTTM
|APPLIED_DTTM
|flag recorded date extension
|Flag.recorded date extension
| -
| -
|-
|-
|START_DTTM
|START_DTTM
|flag.period.start, status = ACTIVE
|Flag.period.start, status = ACTIVE
|flag
|effective_date
|-
|-
|ALERT_DESCRIPTION  
|ALERT_DESCRIPTION  
|flag.code.text
|Flag.code.text
|flag
|flag_text
|-
|-
|ALERT_COMMENTS
|ALERT_COMMENTS
|flag.code.text
|Flag.code.text
|flag
|flag_text
|-
|-
|CLOSED_DTTM
|CLOSED_DTTM
|flag.period.end, status = INACTIVE
|Flag.period.end, status = INACTIVE
|flag
|is_active
|}
|}


== A&E Attendances ==
 
{| class="wikitable"
==Activity==
|+FHIR Resource: EpisodeOfCare
 
!FieldName
===A&E Attendances===
!FHIR Mapping
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! 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
|-
| rowspan="6" |EXTERNAL_ID
|Encounter (Emergency).id
|encounter
| rowspan="6" |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
|+
|-
| rowspan="6" |PAS_ID
|Encounter (Emergency).patient (reference -> Patient resource)
|encounter
| rowspan="6" |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
|-
|-
|EXTERNAL_ID
|Encounter (Emergency Conclusion).patient (reference -> Patient resource)
|episodeofcare.id
|encounter_event
|-
|-
|PAS_ID
|EpisodeOfCare.patient (reference -> Patient resource)
|episodeofcare.patient (reference -> Patient resource)
|episode_of_care
|-
|-
|ARRIVAL_DTTM
| rowspan="5" |HOSPITAL_CODE
|episodeofcare.period.start,.status = ACTIVE
|Encounter (Emergency).serviceProvider (reference -> Organization resource)
|encounter
| rowspan="5" |service_provider_organization_id
|-
|-
|DISCHARGED_DTTM
|Encounter (Emergency Arrival).serviceProvider (reference -> Organization resource)
|episodeofcare.period.end,.status = FINISHED
|encounter_event
|}
{| class="wikitable"
|+FHIR Resource: Encounter
!FieldName
!FHIR Mapping
|-
|-
|EXTERNAL_ID
|Encounter (Emergency Assessment).serviceProvider (reference -> Organization resource)
|encounter (Emergency).id
|encounter_event
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 Treatment).serviceProvider (reference -> Organization resource)
|encounter  (Emergency).patient (reference -> Patient resource)
|encounter_event
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 Conclusion).serviceProvider (reference -> Organization resource)
|encounter  (Emergency).serviceProvider (reference -> Organization resource)
|encounter_event
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
|ATTENDANCE_TYPE
|encounter  (Emergency Arrival).containedParameters => IM.ATTENDANCE_TYPE
|Encounter (Emergency Arrival).containedParameters => IM.ATTENDANCE_TYPE
|encounter_additional
|property_id
value_id
|-
|-
|ARRIVAL_MODE
|ARRIVAL_MODE
|encounter  (Emergency Arrival).containedParameters => IM.ARRIVAL_MODE
|Encounter (Emergency Arrival).containedParameters => IM.ARRIVAL_MODE
|encounter_additional
|property_id
value_id
|-
|-
|REFERRAL_SOURCE
|REFERRAL_SOURCE
|encounter  (Emergency Arrival).containedParameters => IM.REFERRAL_SOURCE
|Encounter (Emergency Arrival).containedParameters => IM.REFERRAL_SOURCE
|encounter_additional
|property_id
value_id
|-
|-
|ARRIVAL_DTTM
| rowspan="3" |ARRIVAL_DTTM
|encounter  (Emergency).period.start, status = INPROGRESS
|Encounter (Emergency).period.start, status = INPROGRESS
encounter (Emergency Arrival).period.start, status = INPROGRESS
|encounter
|clinical_effective_date
|-
|-
|TRIAGE_DTTM
|Encounter (Emergency Arrival).period.start, status = INPROGRESS
|encounter  (Emergency Arrival).period.end, status = FINISHED
|encounter_event
encounter (Emergency Assessment).period.start, status = INPROGRESS
|clinical_effective_date
|-
|-
|SEEN_BY_AE_DOCTOR_DTTM
|EpisodeOfCare.period.start,.status = ACTIVE
|encounter  (Emergency Assessment).period.end, status = FINISHED
|episode_of_care
encounter (Emergency Treatment).period.start, status = INPROGRESS
|date_registered
|-
| rowspan="2" |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
|-
| rowspan="2" |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
|COMPLAINT
|encounter  (Emergency).codeableConcept.code.text
|Encounter (Emergency).codeableConcept.code.text
| -
| -
|-
| rowspan="4" |DISCHARGED_DTTM
|Encounter (Emergency).period.end, status = FINISHED
 
|encounter
 
|end_date
|-
|-
|DISCHARGED_DTTM
|Encounter (Emergency Treatment).period.end, status = FINISHED
|encounter  (Emergency).period.end, status = FINISHED
|encounter_event
encounter (Emergency Treatment).period.end, status = FINISHED
|end_date
encounter (Emergency Conclusion).period.start, status = INPROGRESS
|-
episodeofcare.period.end,.status = FINISHED
|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
|LEFT_DEPARTMENT_DTTM
|encounter  (Emergency Conclusion).period.end, status = FINISHED
|Encounter (Emergency Conclusion).period.end, status = FINISHED
|encounter_event
|end_date
|-
|-
|DISCHARGE_DESTINATION
|DISCHARGE_DESTINATION
|encounter  (Emergency Conclusion).containedParameters => IM.DISCHARGE_DESTINATION
|Encounter (Emergency Conclusion).containedParameters => IM.DISCHARGE_DESTINATION
|encounter_additional
|property_id
value_id
|-
| rowspan="2" |RECORDED_OUTCOME
|Encounter (Emergency).hospitalization.dischargeDisposition
 
| rowspan="2" |encounter_additional
|property_id
|-
|-
|RECORDED_OUTCOME
|Encounter (Emergency Conclusion).containedParameters => IM.RECORDED_OUTCOME
|encounter  (Emergency).hospitalization.dischargeDisposition
|value_id
encounter (Emergency Conclusion).containedParameters => IM.RECORDED_OUTCOME
|}
|}


== Spells ==
=== Spells ===
{| class="wikitable"
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
|+FHIR Resource: Encounter
! style="color:#90A4AE" |'''Publisher'''
!FieldName
! style="color:#90A4AE" |DDS Core
!FHIR Mapping
! colspan="2" style="color:#90A4AE" |Compass V2
|-
|- style="background-color:#90A4AE; color: white; vertical-align: top;"
|EXTERNAL_ID
! scope="col" width="15%" |Field Name
|encounter (Inpatient).id
! scope="col" width="25%" |FHIR
! scope="col" width="15%" |Table
! scope="col" width="15%" |Field
|-
|-
|PAS_ID
| rowspan="6" |EXTERNAL_ID
|encounter (Inpatient).patient (reference -> Patient resource)
|Encounter (Inpatient).id


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


encounter (Inpatient Discharge).patient (reference -> Patient resource)
|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
|-
|-
|ADMISSION_DTTM
|Procedure.Encounter (reference -> Encounter(Inpatient) resource)
|encounter (Inpatient).period.start, status = INPROGRESS
|observation
|encounter_id
|-
| rowspan="6" |PAS_ID
|Encounter (Inpatient).patient (reference -> Patient resource)
|encounter


encounter (Inpatient Admission).period.start, status = INPROGRESS
| rowspan="6" |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
|-
|-
|ADMISSION_CONSULTANT_CODE
|Procedure.patient (reference -> Patient resource)
|encounter (Inpatient).participant (reference -> Practitioner resource)
|observation
 
|-
encounter (Inpatient Admission).participant (reference -> Practitioner resource)
| rowspan="5" |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
|-
| rowspan="5" |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
|-
| rowspan="4" |ADMISSION_HOSPITAL_CODE
|Encounter (Inpatient).serviceProvider (reference -> Organization resource)
|encounter
| rowspan="4" |service_provider_organization_id
|-
|Encounter (Inpatient Admission).serviceProvider (reference -> Organization resource)
|encounter_event
|-
|Encounter (Inpatient Discharge).serviceProvider (reference -> Organization resource)
|encounter_event
|-
|-
|ADMISSION_HOSPITAL_CODE
|EpisodeOfCare.managingOrganization (reference -> Organization resource)
|encounter (Inpatient).serviceProvider (reference -> Organization resource)
| -
 
encounter (Inpatient Admission).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
|encounter_additional
|property_id
value_id
|-
|-
|ADMISSION_SOURCE_CODE
|ADMISSION_SOURCE_CODE
|encounter (Inpatient Admission).containedParameters => IM.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
|ADMISSION_WARD_CODE
|encounter (Inpatient Admission).containedParameters => JSON_ADMISSION_WARD_CODE
|Encounter (Inpatient Admission).containedParameters => JSON_ADMISSION_WARD_CODE
|encounter_additional
|json_value
|-
|-
|PATIENT_CLASS_CODE
|PATIENT_CLASS_CODE
|encounter (Inpatient Admission).containedParameters => IM.PATIENT_CLASS
|Encounter (Inpatient Admission).containedParameters => IM.PATIENT_CLASS
|encounter_additional
|property_id
value_id
|-
| rowspan="2" |DISCHARGE_DTTM
|Encounter (Inpatient).period.end, status = FINISHED
|encounter
|end_date
|-
|-
|DISCHARGE_DTTM
|EpisodeOfCare.period.start, status = FINISHED
|encounter (Inpatient).period.end, status = FINISHED
|episode_of_care
 
|date_registered_end
NOTE: encounter (Inpatient Admission).period.end, status = FINISHED when linked Inpatient Episode encounter starts (See EPISODES)
|+
|-
|-
|DISCHARGE_METHOD_CODE
|DISCHARGE_METHOD_CODE
|encounter (Inpatient Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE
|Encounter (Inpatient Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE
|encounter_additional
|property_id
value_id
|-
|-
|DISCHARGE_DESTINATION_CODE
|DISCHARGE_DESTINATION_CODE
|encounter  (Inpatient Discharge).containedParameters => IM.DISCHARGE_DEST_CODE
|Encounter (Inpatient Discharge).containedParameters => IM.DISCHARGE_DEST_CODE
|encounter_additional
|property_id
value_id
|-
|-
|DISCHARGE_CONSULTANT_CODE
|DISCHARGE_CONSULTANT_CODE
|encounter  (Inpatient Discharge).participant (reference -> Practitioner resource)
|Encounter (Inpatient Discharge).participant (reference -> Practitioner resource)
|encounter_event
|practitioner_id
|-
|-
|DISCHARGE_WARD_CODE
|DISCHARGE_WARD_CODE
|encounter (Inpatient Discharge).containedParameters => JSON_DISCHARGE_WARD_CODE
|Encounter (Inpatient Discharge).containedParameters => JSON_DISCHARGE_WARD_CODE
|}
|encounter_additional
{| class="wikitable"
|json_value
|+FHIR Resource: EpisodeOfCare
!FieldName
!FHIR Mapping
|-
|-
|EXTERNAL_ID
|PRIMARY_DIAGNOSIS
|episodeofcare.id
|Condition.codeableConcept.code.text
| -
| -
|-
|-
|PAS_ID
|PRIMARY_DIAGNOSIS_CODE
|episodeofcare.patient (reference -> Patient resource)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
|observation
|core_concept_id
non_core_concept_id
|-
|-
|ADMISSION_DTTM
|PRIMARY_PROCEDURE
|episodeofcare.period.start, status = ACTIVE
|Procedure.codeableConcept.code.text
| -
| -
|-
|-
|ADMISSION_CONSULTANT_CODE
|PRIMARY_PROCEDURE_CODE
|episodeofcare.caremanager (reference -> Practitioner resource)
|Procedure.codeableConcept.code, Procedure.codeableConcept.code.display (via lookup)
|observation
|core_concept_id
non_core_concept_id
|-
|-
|ADMISSION_HOSPITAL_CODE
|REFERRING_CONSULTANT
|episodeofcare.managingOrganization (reference -> Organization resource)
|Encounter (Inpatient Admission).containedParameters => JSON_REFERRING_CONSULTANT
|-
|encounter_additional
|DISCHARGE_DTTM
|json_value
|episodeofcare.period.start, status = FINISHED
|}
|}
{| class="wikitable"
 
|+FHIR Resource: Condition
=== Episodes ===
!FieldName
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
!FHIR Mapping
! style="color:#90A4AE" |'''Publisher'''
! 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
|-
|-
|EXTERNAL_ID
| rowspan="3" |EXTERNAL_ID
|condition.encounter (reference -> encounter(Inpatient) resource)
|Encounter (Inpatient Episode).id:epi_num:IP:Episode
|encounter_event
|id
|-
|-
|PAS_ID
|Condition.Encounter (reference -> Encounter(Inpatient Episode) resource)
|condition.patient (reference -> Patient resource)  
|observation
|encounter_id
|-
|-
|ADMISSION_DTTM
|Procedure.Encounter (reference -> Encounter(Inpatient Episode) resource)
|condition.onset
|observation
|encounter_id
|+
|-
|-
|ADMISSION_CONSULTANT_CODE
| rowspan="2" |IP_SPELL_EXTERNAL_ID
|condition.clinician (reference -> Practitioner resource)
|Encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource)
| rowspan="2" |encounter_event
|encounter_id
|-
|-
|PRIMARY_DIAGNOSIS
|Encounter (Inpatient Episode).episodeOfCare (reference -> EpisodeOfCare resource)
|condition.codeableConcept.code.text
|episode_of_care_id
|-
|-
|PRIMARY_DIAGNOSIS_CODE
| rowspan="3" |PAS_ID
|condition.codeableConcept.code,  condition.codeableConcept.code.display (via lookup)
|Encounter (Inpatient Episode).patient (reference -> Patient resource)  
|}<br />
|encounter_event
{| class="wikitable"
| rowspan="3" |patient_id
|+FHIR Resource: Procedure
!FieldName
!FHIR Mapping
|-
|EXTERNAL_ID
|procedure.encounter (reference -> encounter(Inpatient) resource)
|-
|PAS_ID
|procedure.patient (reference -> Patient resource)
|-
|-
|ADMISSION_DTTM
|Condition.patient (reference -> Patient resource)
|procedure.performed
|observation
|-
|-
|ADMISSION_CONSULTANT_CODE
|Procedure.patient (reference -> Patient resource)
|procedure.performer (reference -> Practitioner resource)
|observation
|-
|-
|PRIMARY_PROCEDURE
| rowspan="3" |EPI_NUM
|procedure.codeableConcept.code.text
|Encounter (Inpatient Episode).id:epi_num:IP:Episode
|encounter_event
|id
|-
|-
|PRIMARY_PROCEDURE_CODE
|Condition.Encounter (reference -> Encounter(Inpatient Episode) resource)
|procedure.codeableConcept.code,  procedure.codeableConcept.code.display (via lookup)
|observation
|}
|encounter_id
 
== Episodes ==
{| class="wikitable"
|+FHIR Resource: Encounter
!FieldName
!FHIR Mapping
|-
|-
|EXTERNAL_ID
|Procedure.Encounter (reference -> Encounter(Inpatient Episode) resource)
|encounter (Inpatient Episode).id:epi_num:IP:Episode
|observation
|encounter_id
|-
|-
|IP_SPELL_EXTERNAL_ID
| rowspan="3" |EPISODE_CONSULTANT_CODE
|encounter (Inpatient Episode).partOf (reference -> Encounter (Inpatient) resource)
|Encounter (Inpatient Episode).participant (reference -> Practitioner resource)
 
|encounter
encounter (Inpatient Episode).episodeOfCare (reference -> EpisodOfCare resource)
| rowspan="3" |practitioner_id
|-
|-
|PAS_ID
|Procedure.performer (reference -> Practitioner resource)
|encounter (Inpatient Episode).patient (reference -> Patient resource)  
| rowspan="2" |observation
|-
|-
|EPI_NUM
|Condition.clinician (reference -> Practitioner resource)
|encounter (Inpatient Episode).id:epi_num:IP:Episode
|-
|-
|EPISODE_CONSULTANT_CODE
|EPISODE_SPECIALTY_CODE
|encounter (Inpatient Episode).participant (reference -> Practitioner resource)
|Encounter (Inpatient Admission).containedParameters => IM.EPISODE_SPECIALTY_CODE
|encounter_additional
|property_id
value_id
|-
|-
|EPISODE_START_WARD_CODE
|EPISODE_START_WARD_CODE
|encounter  (Inpatient Episode).containedParameters => JSON_EPISODE_START_WARD_CODE
|Encounter (Inpatient Episode).containedParameters => JSON_EPISODE_START_WARD_CODE
|encounter_additional
|json_value
|-
|-
|EPISODE_END_WARD_CODE
|EPISODE_END_WARD_CODE
|encounter  (Inpatient Episode).containedParameters => JSON_EPISODE_END_WARD_CODE
|Encounter (Inpatient Episode).containedParameters => JSON_EPISODE_END_WARD_CODE
|encounter_additional
|json_value
|-
| rowspan="2" |EPISODE_START_DTTM
|Encounter (Inpatient Admission).period.end   (created during SPELLS)
|encounter_event
|end_date
|-
|-
|EPISODE_START_DTTM
|Encounter (Inpatient Episode).period.start
|encounter  (Inpatient Admission).period.end    (created during SPELLS)
|encounter_event
encounter (Inpatient Episode).period.start
|clinical_effective_date
|-
|-
|EPISODE_END_DTTM
|EPISODE_END_DTTM
|encounter  (Inpatient Episode).period.end
|Encounter (Inpatient Episode).period.end
|encounter_event
|end_date
|-
|-
|ADMINISTRATIVE_CATEGORY_CODE
|ADMINISTRATIVE_CATEGORY_CODE
|encounter  (Inpatient Admission).containedParameters => IM.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
|-
|-
|ADMISSION_METHOD_CODE
|PRIMARY_DIAGNOSIS_CODE
|encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_METHOD_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
|-
|-
|ADMISSION_SOURCE_CODE
|DIAG5_DTTM
|encounter (Inpatient  Admission).containedParameters => IM.ADMISSION_SOURCE_CODE
|Condition.onset
|observation
|clinical_effective_date
|-
|-
|PATIENT_CLASS_CODE
|DIAG_06
|encounter (Inpatient  Admission).containedParameters => IM.PATIENT_CLASS
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
Condition.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|DISCHARGE_METHOD_CODE
|DIAG6_DTTM
|encounter (Inpatient  Discharge).containedParameters => IM.DISCHARGE_METHOD_CODE
|Condition.onset
|observation
|clinical_effective_date
|-
|-
|DISCHARGE_DESTINATION_CODE
|DIAG_07
|encounter  (Inpatient Discharge).containedParameters => IM.DISCHARGE_DEST_CODE
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
Condition.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|ADMISSION_HOSPITAL_CODE
|DIAG7_DTTM
|encounter  (Inpatient Episode).serviceProvider (reference -> Organization resource)
|Condition.onset
|}
|observation
{| class="wikitable"
|clinical_effective_date
|+FHIR Resource: Condition
!FieldName
!FHIR Mapping
|-
|-
|EXTERNAL_ID
|DIAG_08
|condition.encounter (reference -> encounter(Inpatient Episode) resource)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
Condition.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|PAS_ID
|DIAG8_DTTM
|condition.patient (reference -> Patient resource)
|Condition.onset
|observation
|clinical_effective_date
|-
|-
|EPISODE_CONSULTANT_CODE
|DIAG_09
|condition.clinician (reference -> Practitioner resource)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
Condition.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|PRIMARY_DIAGNOSIS_CODE
|DIAG9_DTTM
|condition.codeableConcept.code,  condition.codeableConcept.code.display (via lookup)
|Condition.onset
condition.isprimary = true
|observation
|clinical_effective_date
|-
|-
|PRIMDIAG_DTTM
|DIAG_10
|condition.onset
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
Condition.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|DIAG_01 - DIAG_12
|DIAG10_DTTM
|condition.codeableConcept.code,  condition.codeableConcept.code.display (via lookup)
|Condition.onset
condition.isprimary = false
|observation
|clinical_effective_date
|-
|-
|DIAG1_DTTM - DIAG12_DTTM
|DIAG_11
|condition.onset
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
|}
Condition.isprimary = false
{| class="wikitable"
|observation
|+FHIR Resource: Procedure
|core_concept_id
!FieldName
non_core_concept_id
!FHIR Mapping
|-
|-
|EXTERNAL_ID
|DIAG11_DTTM
|procedure.encounter (reference -> encounter(Inpatient Episode) resource)
|Condition.onset
|observation
|clinical_effective_date
|-
|-
|PAS_ID
|DIAG_12
|procedure.patient (reference -> Patient resource)  
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
Condition.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|EPISODE_CONSULTANT_CODE
|DIAG12_DTTM
|procedure.performer (reference -> Practitioner resource)
|Condition.onset
|observation
|clinical_effective_date
|-
|-
|PRIMARY_PROCEDURE_CODE
|PRIMARY_PROCEDURE_CODE
|procedure.codeableConcept.code,procedure.codeableConcept.code.display (via lookup)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
procedure.isprimary = true
Procedure.isprimary = true
|observation
|core_concept_id
non_core_concept_id
|-
|-
|PRIMARY_PROCEDURE_DATE
|PRIMARY_PROCEDURE_DATE
|procedure.performed
|Procedure.performed
|observation
|clinical_effective_date
|-
|-
|PRIMARY_PROCEDURE
|PRIMARY_PROCEDURE
|procedure.codeableConcept.code.text
|Procedure.codeableConcept.code.text
| -
| -
|-
|-
|PROC_01 - PROC_12
|PROC_01
|procedure.codeableConcept.code,procedure.codeableConcept.code.display (via lookup)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
procedure.isprimary = false
Procedure.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|PROC_01_DESC - PROC_12_DESC
|PROC_01_DESC
|procedure.codeableConcept.code.text
|Procedure.codeableConcept.code.text
|}
| -
 
| -
== Outpatients ==
|-
{| class="wikitable"
|PROC_02
|+FHIR Resource: Encounter
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
!FieldName
Procedure.isprimary = false
!FHIR Mapping
|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
|-
|-
|EXTERNAL_ID
|PROC_08_DESC
|encounter (Outpatient).id
|Procedure.codeableConcept.code.text
 
| -
encounter (Outpatient).setAppointment (reference -> appointment resource)
| -
|-
|-
|PAS_ID
|PROC_09
|encounter.patient (reference -> Patient resource)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|ADMIN_CATEGORY_CODE
|PROC_09_DESC
|encounter (Outpatient).containedParameters => IM.ADMIN_CATEGORY_CODE
|Procedure.codeableConcept.code.text
| -
| -
|-
|-
|APPOINTMENT_STATUS_CODE
|PROC_10
|encounter (Outpatient).containedParameters => IM.APPOINTMENT_STATUS_CODE
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|APPOINTMENT_DTTM
|PROC_10_DESC
|encounter (Outpatient).period.start (if APPT_SEEN_DTM blank)
|Procedure.codeableConcept.code.text
| -
| -
|-
|-
|APPT_SEEN_DTTM
|PROC_11
|encounter (Outpatient).period.start
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|APPT_DEPARTURE_DTTM
|PROC_11_DESC
|encounter (Outpatient).period.end
|Procedure.codeableConcept.code.text
| -
| -
|-
|-
|HOSPITAL_CODE
|PROC_12
|encounter (Outpatient).serviceProvider (reference -> Organization resource)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|core_concept_id
non_core_concept_id
|-
|-
|CONSULTANT_CODE
|PROC_12_DESC
|encounter (Outpatient).participant (reference -> Practitioner resource)
|Procedure.codeableConcept.code.text
| -
| -
|}
|}
{| class="wikitable"
 
|+FHIR Resource: EpisodeOfCare
=== Outpatients===
!FieldName
 
!FHIR Mapping
{| class="mw-collapsible" border="1" style="border-collapse:collapse; text-align: center;  vertical-align:top; width:70%;"
! style="color:#90A4AE" |'''Publisher'''
! 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
|-
| rowspan="6" |EXTERNAL_ID
|Encounter (Outpatient).id
|encounter
|id
|-
|EpisodeOfCare.id
|episode_of_care
|id
|-
|-
|EXTERNAL_ID
|Appointment.id:Appointment
|episodeofcare.id
|appointment
|id
|-
|Condition.Encounter (reference -> Encounter(Outpatient) resource)
|observation
|encounter_id
|-
|-
|PAS_ID
|Procedure.Encounter (reference -> Encounter(Outpatient) resource)
|episodeofcare.patient (reference -> Patient resource)
|observation
|encounter_id
|-
|-
|APPOINTMENT_PRIORITY
|Encounter (Outpatient).setAppointment (reference -> appointment resource)
|episodeofcare.priority  extension
|encounter
|appointment_id
|+
|-
|-
|APPOINTMENT_DTTM
| rowspan="5" |PAS_ID
|episodeofcare.period.start (if APPT_SEEN_DTM blank)
|Encounter.patient (reference -> Patient resource)
|encounter
| rowspan="5" |patient_id
|-
|-
|APPT_SEEN_DTTM
|EpisodeOfCare.patient (reference -> Patient resource)
|episodeofcare.period.start
|episode_of_care
|-
|-
|APPT_DEPARTURE_DTTM
|Condition.patient (reference -> Patient resource)
|episodeofcare.period.end
|observation
|-
|-
|HOSPITAL_CODE
|Procedure.patient (reference -> Patient resource)
|episodeofcare.managingOrganization (reference -> Organization resource)
|observation
|-
|-
|CONSULTANT_CODE
|Appointment.participant (reference -> Patient resource)
|episodeofcare.careManager (reference -> Practitioner resource)
|appointment
|}
{| class="wikitable"
|+FHIR Resource: Appointment
!FieldName
!FHIR Mapping
|-
|-
|EXTERNAL_ID
|ADMIN_CATEGORY_CODE
|appointment.id:Appointment
|Encounter (Outpatient).containedParameters => IM.ADMIN_CATEGORY_CODE
|encounter_additional
|property_id
value_id
|-
|-
|PAS_ID
|APPOINTMENT_PRIORITY
|appointment.participant (reference -> Patient resource)
|EpisodeOfCare.priority extension
| -
| -
|-
|-
|APPT_TYPE
|APPT_TYPE
|appointment.type.text
|Appointment.type.text
|appointment_additional
|property_id
text_value
|-
|-
|APPOINTMENT_OUTCOME
|APPOINTMENT_OUTCOME
|appointment.comments
|Appointment.comments
| -
| -
|-
|-
|APPOINTMENT_STATUS
|APPOINTMENT_STATUS_CODE
|appointment.status
|Encounter (Outpatient).containedParameters => IM.APPOINTMENT_STATUS_CODE
|encounter_additional
appointment
|property_id
value_id
appointment_status_concept_id
|-
| rowspan="4" |APPOINTMENT_DTTM
|Appointment.start
|appointment
|start_date
|-
|Encounter (Outpatient).period.start (if APPT_SEEN_DTM blank)
|encounter
|clinical_effective_date
|-
|Appointment.minutesDuration
| -
| -
|-
|-
|APPOINTMENT_DTTM
|EpisodeOfCare.period.start (if APPT_SEEN_DTM blank)
|appointment.start
|episode_of_care
|date_registered
|-
|-
|APPT_ARRIVAL_DTTM
|APPT_ARRIVAL_DTTM
|appointment.minutesDuration
|Appointment.extension.APPOINTMENT_PATIENT_WAIT
|appointment
|patient_wait
|-
|-
|APPT_CALL_DTTM
|APPT_CALL_DTTM
|appointment.minutesDuration
|Appointment.minutesDuration
| -
| -
|-
| rowspan="3" |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
|-
| rowspan="3" |APPT_DEPARTURE_DTTM
|Appointment.end
|appointment
|date_time_left
|-
|Encounter (Outpatient).period.end
|encounter
|end_date
|-
|-
|APPT_SEEN_DTTM
|EpisodeOfCare.period.end
|appointment.end
|episode_of_care
|date_registered_end
|-
|-
|BOOKED_DTTM
|BOOKED_DTTM
|appointment  booking date extension
|Appointment.bookingdateextension
| -
| -
|-
|-
|CANCEL_DTTM
|CANCEL_DTTM
|appointment cancellation date extension
|Appointment.cancellationdateextension
|appointment
|cancelled_date
|-
| rowspan="2" |HOSPITAL_CODE
|Encounter (Outpatient).serviceProvider (reference -> Organization resource)
|encounter
|service_provider_organization_id
|-
|EpisodeOfCare.managingOrganization (reference -> Organization resource)
| -
| -
|-
| rowspan="3" |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
|-
|-
|CONSULTANT_CODE
|PRIMARY_PROCEDURE_CODE
|appointment.participant (reference -> Practitioner resource)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
|}
Procedure.isprimary = true
{| class="wikitable"
|observation
|+FHIR Resource: Condition
|non_core_concept_id
!FieldName
is_primary
!FHIR Mapping
|-
|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
|-
|-
|EXTERNAL_ID
|SECONDARY_PROCEDURE_CODE_5
|condition.encounter (reference -> encounter(Outpatient) resource)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|PAS_ID
|SECONDARY_PROCEDURE_CODE_6
|condition.patient (reference -> Patient resource)  
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|PRIMARY_DIAGNOSIS_CODE
|SECONDARY_PROCEDURE_CODE_7
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
condition.isprimary = true
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|SECONDARY_DIAGNOSIS_CODE_1
|SECONDARY_PROCEDURE_CODE_8
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
condition.isprimary = false
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|SECONDARY_DIAGNOSIS_CODE_2
|SECONDARY_PROCEDURE_CODE_9
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
condition.isprimary = false
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|SECONDARY_DIAGNOSIS_CODE_3
|SECONDARY_PROCEDURE_CODE_10
|condition.codeableConcept.code, condition.codeableConcept.code.display (via lookup)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
condition.isprimary = false
Procedure.isprimary = false
|}
|observation
{| class="wikitable"
|non_core_concept_id
|+FHIR Resource: Procedure
is_primary
!FieldName
!FHIR Mapping
|-
|-
|EXTERNAL_ID
|SECONDARY_PROCEDURE_CODE_11
|procedure.encounter (reference -> encounter(Outpatient) resource)
|Procedure.codeableConcept.code,Procedure.codeableConcept.code.display (via lookup)
Procedure.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|PAS_ID
|PRIMARY_DIAGNOSIS_CODE
|procedure.patient (reference -> Patient resource)  
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
Condition.isprimary = true
|observation
|non_core_concept_id
is_primary
|-
|-
|PRIMARY_PROCEDURE_CODE
|SECONDARY_DIAGNOSIS_CODE_1
|procedure.codeableConcept.code,procedure.codeableConcept.code.display (via lookup)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
procedure.isprimary = true
Condition.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|SECONDARY_PROCEDURE_CODE_1
|SECONDARY_DIAGNOSIS_CODE_2
|procedure.codeableConcept.code,procedure.codeableConcept.code.display (via lookup)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
procedure.isprimary = false
Condition.isprimary = false
|observation
|non_core_concept_id
is_primary
|-
|-
|SECONDARY_PROCEDURE_CODE_2 - 11
|SECONDARY_DIAGNOSIS_CODE_3
|procedure.codeableConcept.code,procedure.codeableConcept.code.display (via lookup)
|Condition.codeableConcept.code, Condition.codeableConcept.code.display (via lookup)
procedure.isprimary = false
Condition.isprimary = false
|observation
|non_core_concept_id
is_primary
|}
|}

Latest revision as of 10:56, 3 August 2023


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