SQL on FHIR
2.1.0-pre - release
SQL on FHIR
2.1.0-pre - release
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
| draft |
Generated Narrative: ViewDefinition PatientAddresses
This view acts on the Patient resource to produce a table named "patient_addresses".
The table contains the following columns:
| Name | Fhir Type | SQL Type | Collection | Notes |
|---|---|---|---|---|
| patient_id | string | String | ||
| street | string | String | ||
| use | string | String | This column is not defined as a collection, but the path statement 'use' might return multiple values for the column 'use' for some inputs | |
| city | string | String | This column is not defined as a collection, but the path statement 'city' might return multiple values for the column 'city' for some inputs | |
| zip | string | String | This column is not defined as a collection, but the path statement 'postalCode' might return multiple values for the column 'zip' for some inputs |
Selection Rules:
| Item | Coll | Type | Description |
|---|---|---|---|
  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 |