{description: 'Uses labels to disambiguate patient views from different sources and joins\npatient diagnoses for downstream analytics.\n\n```sql\nSELECT\n  omop_person.person_id AS omop_person_id,\n  fhir_patient.id AS fhir_patient_id,\n  fhir_patient.name,\n  diagnoses_view.code AS diagnosis_code,\n  diagnoses_view.display AS diagnosis_display\nFROM omop_person\nJOIN fhir_patient\n  ON omop_person.person_id = fhir_patient.mrn\nJOIN diagnoses_view\n  ON diagnoses_view.patient_id = fhir_patient.id\nWHERE omop_person.source_system = :source_system\n```', package_name: hl7.fhir.uv.sql-on-fhir, name: OmopFhirPatientJoin, type: '{:coding [{:system \"http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/LibraryTypesCodes\", :code \"sql-query\"}]}', package_version: 3.0.0-ballot, class: unknown, kind: null, url: 'http://hl7.org/fhir/uv/sql-on-fhir/Library/OmopFhirPatientJoin', version: 3.0.0-ballot}