SQL on FHIR
2.1.0-pre - release International flag

SQL on FHIR - Local Development build (v2.1.0-pre) built by the FHIR (HL7® FHIR® Standard) Build Tools. See the Directory of published versions

Example Binary: PatientAddresses

This content is an example of the View Definition Logical Model and is not a FHIR Resource

This view acts on the Patient resource to produce a table named "patient_addresses".

Selection Rules:

ItemCollTypeDescription
.. patient_addresses Patient
... Select
.... patient_id getResourceKey()
... Select for each address
.... street line.join(' ')
The full street address, including newlines if present.
.... use use
.... city city
.... zip postalCode

Notes:

This will result in a “patient_addresses” table that looks like this:

patient_id street use city zip
1 123 Main St\nApt 1 home San Diego 92101
1 456 Maplewood Dve\nApt 2 work New York 10001
2 789 Brookside Ave\nApt 3 home Los Angeles 90001
3 987 Pinehurst Rd\nApt 4 home Chicago 60601
3 654 Evergreen Tce\nApt 5 work Houston 77001