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: ConditionFlat

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

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

Selection Rules:

ItemCollTypeDescription
.. 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
.... clinical_status code
... Select for each verificationStatus.coding, or null
.... verification_status code