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
This content is an example of the View Definition Logical Model and is not a FHIR Resource
This view acts on the Encounter resource for version R4 to produce a table named "encounter_flat".
Selection Rules:
| Item | Coll | Type | Description |
|---|---|---|---|
  encounter_flat |
Encounter | ||
  Select |
|||
   id |
getResourceKey() | ||
| status |
status | ||
| patient_id |
subject.getReferenceKey(Patient) | ||
| service_org_id |
serviceProvider.getReferenceKey(Organization) | ||
| period_start |
period.start | ||
| period_end |
period.end | ||
 EpisodeOfCareId |
episodeOfCare.getReferenceKey(EpisodeOfCare) | ||
| Select |
for each type.coding, or null | ||
| type_sys |
system | ||
| type_code |
code | ||
| Select |
for each participant, or null | ||
| practitioner_id |
individual.getReferenceKey(Practitioner) | ||
 Select |
for each location, or null | ||
 location_id |
location.getReferenceKey(Location) |