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

• Narrative Content
• XML
• JSON

: Active Patient Addresses

Raw xml | Download

<Library xmlns="http://hl7.org/fhir">
  <id value="ActivePatientAddressesQuery"/>
  <meta>
    <profile
             value="http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/SQLQuery"/>
  </meta>
  <language value="en"/>
  <text>
    <status value="extensions"/>
    <div xmlns="http://www.w3.org/1999/xhtml">
  <table class="narrative-table">
    <tbody>
<tr>


<th colspan="2" scope="row" class="row-header">Metadata</th>


</tr>

<tr>


<th scope="row" class="row-header">Title</th>



<td class="content-container">Active Patient Addresses</td>


</tr>



<tr>


<th scope="row" class="row-header">Version</th>



<td class="content-container">3.0.0-ballot</td>


</tr>







  
<tr>


<th scope="row" class="row-header">Identifier</th>



<td class="content-container">urn:oid:2.16.840.1.113883.4.642.40.77.28.1</td>


</tr>










<tr>


<th scope="row" class="row-header">Jurisdiction</th>



<td class="content-container">
    World


</td>


</tr>








<tr>


<th scope="row" class="row-header">Steward (Publisher)</th>



<td class="content-container">HL7 International / FHIR Infrastructure</td>


</tr>



<tr>


<th scope="row" class="row-header">Steward Contact</th>



<td class="content-container">HL7 International / FHIR Infrastructure</td>


</tr>







<tr>


<th scope="row" class="row-header">Description</th>



<td class="content-container"><div><p>Joins the <a href="Library-ActivePatientsView.html">Active Patients</a> view to patient
addresses. The <code>active_patients</code> label resolves to the referenced SQLView, which
the executing engine may materialize or inline.</p>
<pre><code class="language-sql">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
</code></pre>
</div></td>


</tr>






<tr>


<th scope="row" class="row-header">Type</th>



<td class="content-container">
    sql-query from <a href="CodeSystem-LibraryTypesCodes.html">http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/LibraryTypesCodes</a> 


</td>


</tr>



<tr>
  
  
  
  
  

<th scope="row" class="row-header">Dependency</th>


  
  
  <td class="content-container">
    
    <em>Description</em>: Active Patients view
    
    <br/>
    
    
    
    
    
    
    <em>Resource</em>: <a href="Library-ActivePatientsView.html">Active Patients</a>
    <br/>
    <em>Canonical URL</em>: <tt>http://hl7.org/fhir/uv/sql-on-fhir/Library/ActivePatientsView</tt>
    
    
    
  </td>
</tr>

<tr>
  
  
  
  
  

<th scope="row" class="row-header">Dependency</th>


  
  
  <td class="content-container">
    
    <em>Description</em>: Patient address view
    
    <br/>
    
    
    
    
    
    
    <em>Resource</em>: <code>https://example.org/ViewDefinition/patient_address_view</code>
    <br/>
    <em>Canonical URL</em>: <tt>https://example.org/ViewDefinition/patient_address_view</tt>
    
    
    
  </td>
</tr>








<tr>


<th colspan="2" scope="row" class="row-header"><a name="parameters"> </a>Parameters</th>


</tr>


<tr>


<th scope="row" class="row-header">Parameter</th>



<td class="content-container">None</td>


</tr>







  <tr>


<th colspan="2" scope="row" class="row-header">Library Content</th>


</tr>
  
    
    <tr>
      <th scope="row" class="row-header">application/sqlContent</th>
      <td>
        <pre style="border: none;" class="content-container highlight language-cql"><code>Encoded data </code></pre>
      </td>
    </tr>
    
  

<tr>
  <th colspan="2" scope="row" class="row-header">Generated using version 0.5.4 of the sample-content-ig Liquid templates</th>
</tr>

    </tbody>
  </table>
</div>
  </text>
  <url
       value="http://hl7.org/fhir/uv/sql-on-fhir/Library/ActivePatientAddressesQuery"/>
  <identifier>
    <system value="urn:ietf:rfc:3986"/>
    <value value="urn:oid:2.16.840.1.113883.4.642.40.77.28.1"/>
  </identifier>
  <version value="3.0.0-ballot"/>
  <name value="ActivePatientAddressesQuery"/>
  <title value="Active Patient Addresses"/>
  <status value="active"/>
  <type>
    <coding>
      <system
              value="http://hl7.org/fhir/uv/sql-on-fhir/CodeSystem/LibraryTypesCodes"/>
      <code value="sql-query"/>
    </coding>
  </type>
  <date value="2026-08-13T15:42:34+00:00"/>
  <publisher value="HL7 International / FHIR Infrastructure"/>
  <contact>
    <name value="HL7 International / FHIR Infrastructure"/>
    <telecom>
      <system value="url"/>
      <value value="http://www.hl7.org/Special/committees/fiwg"/>
    </telecom>
  </contact>
  <description
               value="Joins the [Active Patients](Library-ActivePatientsView.html) view to patient
addresses. The `active_patients` label resolves to the referenced SQLView, which
the executing engine may materialize or inline.

```sql
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
```"/>
  <jurisdiction>
    <coding>
      <system value="http://unstats.un.org/unsd/methods/m49/m49.htm"/>
      <code value="001"/>
      <display value="World"/>
    </coding>
  </jurisdiction>
  <relatedArtifact>
    <type value="depends-on"/>
    <label value="active_patients"/>
    <display value="Active Patients view"/>
    <resource
              value="http://hl7.org/fhir/uv/sql-on-fhir/Library/ActivePatientsView"/>
  </relatedArtifact>
  <relatedArtifact>
    <type value="depends-on"/>
    <label value="patient_address_view"/>
    <display value="Patient address view"/>
    <resource
              value="https://example.org/ViewDefinition/patient_address_view"/>
  </relatedArtifact>
  <content>
    <extension
               url="http://hl7.org/fhir/uv/sql-on-fhir/StructureDefinition/sql-text">
      <valueString
                   value="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"/>
    </extension>
    <contentType value="application/sql"/>
    <data
          value="U0VMRUNUCiAgYWN0aXZlX3BhdGllbnRzLnBhdGllbnRfaWQsCiAgYWN0aXZlX3BhdGllbnRzLnBhdGllbnRfbmFtZSwKICBwYXRpZW50X2FkZHJlc3Nfdmlldy5jaXR5LAogIHBhdGllbnRfYWRkcmVzc192aWV3LnN0YXRlCkZST00gYWN0aXZlX3BhdGllbnRzCkpPSU4gcGF0aWVudF9hZGRyZXNzX3ZpZXcKICBPTiBhY3RpdmVfcGF0aWVudHMucGF0aWVudF9pZCA9IHBhdGllbnRfYWRkcmVzc192aWV3LnBhdGllbnRfaWQ="/>
  </content>
</Library>