US Core Blood Pressures - 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: US Core Blood Pressures

This view acts on the Observation resource to produce a table named "us_core_blood_pressures" where code.coding.exists(system='http://loinc.org' and code=%bp_code).

The table contains the following columns:

Name	Fhir Type	SQL Type
id	string	String
patient_id	string	String
effective_date_time	dateTime	DateTime
sbp_quantity_system	string	String
sbp_quantity_code	string	String
sbp_quantity_unit	string	String
sbp_quantity_value	decimal	Decimal
dbp_quantity_system	string	String
dbp_quantity_code	string	String
dbp_quantity_unit	string	String
dbp_quantity_value	decimal	Decimal

Name

Fhir Type

SQL Type

Collection

id

string

String

patient_id

string

String

effective_date_time

dateTime

DateTime

sbp_quantity_system

string

String

sbp_quantity_code

string

String

sbp_quantity_unit

string

String

sbp_quantity_value

decimal

Decimal

dbp_quantity_system

string

String

dbp_quantity_code

string

String

dbp_quantity_unit

string

String

dbp_quantity_value

decimal

Decimal

Constants:

Name	Value
systolic_bp	8480-6
diastolic_bp	8462-4
bp_code	85354-9

Selection Rules:

Item	Type	Description
us_core_blood_pressures	Observation
us_core_blood_pressures / Select
us_core_blood_pressures / Select / id		`getResourceKey()`
us_core_blood_pressures / Select / patient_id		`subject.getReferenceKey(Patient)` Can be used to join to patient tables created by other views.
us_core_blood_pressures / Select / effective_date_time		`effective.ofType(dateTime)`
us_core_blood_pressures / Select		for each `component.where(code.coding.exists(system='http://loinc.org' and code=%systolic_bp)).first()`
us_core_blood_pressures / Select / sbp_quantity_system		`value.ofType(Quantity).system`
us_core_blood_pressures / Select / sbp_quantity_code		`value.ofType(Quantity).code`
us_core_blood_pressures / Select / sbp_quantity_unit		`value.ofType(Quantity).unit`
us_core_blood_pressures / Select / sbp_quantity_value		`value.ofType(Quantity).value`
us_core_blood_pressures / Select		for each `component.where(code.coding.exists(system='http://loinc.org' and code=%diastolic_bp)).first()`
us_core_blood_pressures / Select / dbp_quantity_system		`value.ofType(Quantity).system`
us_core_blood_pressures / Select / dbp_quantity_code		`value.ofType(Quantity).code`
us_core_blood_pressures / Select / dbp_quantity_unit		`value.ofType(Quantity).unit`
us_core_blood_pressures / Select / dbp_quantity_value		`value.ofType(Quantity).value`