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 |