Condition 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: Condition Flat

This view acts on the Condition resource to produce a table named "condition_flat".

The table contains the following columns:

Name	Fhir Type	SQL Type
id	string	String
patient_id	string	String
encounter_id	string	String
onset_datetime	dateTime	DateTime
system	string	String
code	string	String
category	string	String
clinical_status	string	String
verification_status	string	String

Name

Fhir Type

SQL Type

Collection

id

string

String

patient_id

string

String

encounter_id

string

String

onset_datetime

dateTime

DateTime

system

string

String

code

string

String

category

string

String

clinical_status

string

String

verification_status

string

String

Selection Rules:

Item	Type	Description
condition_flat	Condition
condition_flat / Select
condition_flat / Select / id		`getResourceKey()`
condition_flat / Select / patient_id		`subject.getReferenceKey(Patient)`
condition_flat / Select / encounter_id		`encounter.getReferenceKey(Encounter)`
condition_flat / Select / onset_datetime	dateTime	`onset.ofType(dateTime)`
condition_flat / Select		for each `code.coding`, or null
condition_flat / Select / system	uri	`system`
condition_flat / Select / code		`code`
condition_flat / Select		for each `category.coding`, or null
condition_flat / Select / category		`code`
condition_flat / Select		for each `clinicalStatus.coding`, or null
condition_flat / Select / clinical_status		`code`
condition_flat / Select		for each `verificationStatus.coding`, or null
condition_flat / Select / verification_status		`code`

Notes:

This will result in a "condition_flat" table that looks like this:

id

patient_id

encounter_id

onset_datetime

system

code