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 ShareablePatientDemographics
This view acts on the Patient resource for versions R4 and R5 to produce a table named "patient_demographics".
The table contains the following columns:
| Name | Fhir Type | SQL Type | Collection |
|---|---|---|---|
| id | string | String | |
| gender | string | String | |
| given_name | string | String | |
| family_name | string | String |
Selection Rules:
| Item | Coll | Type | Description |
|---|---|---|---|
  patient_demographics | Patient | ||
  Select | |||
  id | string | getResourceKey() | |
 gender | code | gender | |
| Select | for each name.where(use = 'official').first() | ||
 given_name | string | given.join(' ')A single given name field with all names joined together. | |
| family_name | string | family |