Encounter Flat - SQL on FHIR v3.0.0-ballot

SQL on FHIR
3.0.0-ballot - STU 3 Ballot International flag

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

Example ViewDefinition: Encounter Flat

This view acts on the Encounter resource to produce a table named "encounter_flat".

The table contains the following columns:

Name	Fhir Type	SQL Type
id	string	String
status	string	String
patient_id	string	String
service_org_id	string	String
period_start	dateTime	DateTime
period_end	dateTime	DateTime
type_sys	string	String
type_code	string	String
practitioner_id	string	String
location_id	string	String
episode_of_care_id	string	String

Name

Fhir Type

SQL Type

Collection

id

string

String

status

string

String

patient_id

string

String

service_org_id

string

String

period_start

dateTime

DateTime

period_end

dateTime

DateTime

type_sys

string

String

type_code

string

String

practitioner_id

string

String

location_id

string

String

episode_of_care_id

string

String

Selection Rules:

Item	Type	Description
encounter_flat	Encounter
encounter_flat / Select
encounter_flat / Select / id		`getResourceKey()`
encounter_flat / Select / status		`status`
encounter_flat / Select / patient_id		`subject.getReferenceKey(Patient)`
encounter_flat / Select / service_org_id		`serviceProvider.getReferenceKey(Organization)`
encounter_flat / Select / period_start		`actualPeriod.start`
encounter_flat / Select / period_end		`actualPeriod.end`
encounter_flat / Select		for each `type.coding`, or null
encounter_flat / Select / type_sys		`system`
encounter_flat / Select / type_code		`code`
encounter_flat / Select		for each `participant`, or null
encounter_flat / Select / practitioner_id		`actor.getReferenceKey(Practitioner)`
encounter_flat / Select		for each `location`, or null
encounter_flat / Select / location_id		`location.getReferenceKey(Location)`
encounter_flat / Select		for each `episodeOfCare`, or null
encounter_flat / Select / episode_of_care_id		`getReferenceKey(EpisodeOfCare)`