SQL on FHIR
2.1.0-pre - release International flag

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

Example Binary: UsCoreBloodPressures

This content is an example of the View Definition Logical Model and is not a FHIR Resource

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).

Constants:

NameValue
systolic_bp 8480-6
diastolic_bp 8462-4
bp_code 85354-9

Selection Rules:

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

Notes:

This will result in a “us_core_blood_pressures” table that looks like this:

id patient_id effective_date_time sbp_quantity_system sbp_quantity_code sbp_quantity_unit sbp_quantity_value dbp_quantity_system dbp_quantity_code dbp_quantity_unit dbp_quantity_value
1 1 2020-01-01T00:00:00 http://unitsofmeasure.org mmHg mm[Hg] 120 http://unitsofmeasure.org mmHg mm[Hg] 80
2 1 2020-01-02T00:00:00 http://unitsofmeasure.org mmHg mm[Hg] 130 http://unitsofmeasure.org mmHg mm[Hg] 90
3 2 2020-01-03T00:00:00 http://unitsofmeasure.org mmHg mm[Hg] 140 http://unitsofmeasure.org mmHg mm[Hg] 100
4 3 2020-01-04T00:00:00 http://unitsofmeasure.org mmHg mm[Hg] 150 http://unitsofmeasure.org mmHg mm[Hg] 110
5 3 2020-01-05T00:00:00 http://unitsofmeasure.org mmHg mm[Hg] 160 http://unitsofmeasure.org mmHg mm[Hg] 120