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	Notes
id	string	String
patient_id	string	String
encounter_id	string	String
onset_datetime	dateTime	DateTime
system	uri	String	This column is not defined as a collection, but the path statement 'system' might return multiple values for the column 'system' for some inputs
code	string	String	This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'code' for some inputs
category	string	String	This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'category' for some inputs
clinical_status	string	String	This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'clinical_status' for some inputs
verification_status	string	String	This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'verification_status' for some inputs

Name

Fhir Type

SQL Type

Collection

Notes

id

string

String

patient_id

string

String

encounter_id

string

String

onset_datetime

dateTime

DateTime

system

uri

String

This column is not defined as a collection, but the path statement 'system' might return multiple values for the column 'system' for some inputs

code

string

String

This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'code' for some inputs

category

string

String

This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'category' for some inputs

clinical_status

string

String

This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'clinical_status' for some inputs

verification_status

string

String

This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'verification_status' for some inputs

Selection Rules:

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

IG © 2023+ HL7 International / FHIR Infrastructure. Package hl7.fhir.uv.sql-on-fhir#3.0.0-ballot based on FHIR 6.0.0-ballot5. Generated 2026-08-13
Links: Table of Contents | QA Report | Version History | | Propose a change