SQL on FHIR
3.0.0-ballot - STU 3 Ballot International flag

SQL on FHIR, published by HL7 International / FHIR Infrastructure. This guide is not an authorized publication; it is the continuous build for version 3.0.0-ballot built by the FHIR (HL7® FHIR® Standard) CI Build. This version is based on the current content of https://github.com/HL7/sql-on-fhir/ and changes regularly. See the Directory of published versions

Library: Active Patient Addresses

Official URL: http://hl7.org/fhir/uv/sql-on-fhir/Library/ActivePatientAddressesQuery Version: 3.0.0-ballot
Standards status: Informative Computable Name: ActivePatientAddressesQuery
Other Identifiers: OID:2.16.840.1.113883.4.642.40.77.28.1

Joins the Active Patients view to patient addresses. The active_patients label resolves to the referenced SQLView, which the executing engine may materialize or inline.

SELECT
  active_patients.patient_id,
  active_patients.patient_name,
  patient_address_view.city,
  patient_address_view.state
FROM active_patients
JOIN patient_address_view
  ON active_patients.patient_id = patient_address_view.patient_id

Metadata
Title Active Patient Addresses
Version 3.0.0-ballot
Identifier urn:oid:2.16.840.1.113883.4.642.40.77.28.1
Jurisdiction World
Steward (Publisher) HL7 International / FHIR Infrastructure
Steward Contact HL7 International / FHIR Infrastructure
Description

Joins the Active Patients view to patient addresses. The active_patients label resolves to the referenced SQLView, which the executing engine may materialize or inline.

SELECT
  active_patients.patient_id,
  active_patients.patient_name,
  patient_address_view.city,
  patient_address_view.state
FROM active_patients
JOIN patient_address_view
  ON active_patients.patient_id = patient_address_view.patient_id
Type sql-query from http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/LibraryTypesCodes
Dependency Description: Active Patients view
Resource: Active Patients
Canonical URL: http://hl7.org/fhir/uv/sql-on-fhir/Library/ActivePatientsView
Dependency Description: Patient address view
Resource: https://example.org/ViewDefinition/patient_address_view
Canonical URL: https://example.org/ViewDefinition/patient_address_view
Parameters
Parameter None
Library Content
application/sqlContent 
Encoded data
Generated using version 0.5.4 of the sample-content-ig Liquid templates