FQL is a query language that allows you to retrieve, filter and project data from any data source containing FHIR Resources. It brings the power of three existing languages together: SQL, JSON and FhirPath. It allows you to create tables and is useful for gaining insight and perform quality control.
Name | Flags | Card. | Type | Description & Constraints![]() |
---|---|---|---|---|
![]() ![]() | I | 0..* | Observation | Measurements and simple assertions obs-6: SHALL only be present if Observation.value[x] is not present obs-7: Component code SHALL not be same as observation code |
![]() ![]() ![]() | Σ | 0..1 | id | Logical id of this artifact |
![]() ![]() ![]() | Σ | 0..1 | Meta | Metadata about the resource |
![]() ![]() ![]() | ?! Σ | 0..1 | uri | A set of rules under which this content was created |
![]() ![]() ![]() | 0..1 | code | Language of the resource content Binding: http://tools.ietf.org/html/bcp47 (required) | |
![]() ![]() ![]() | I | 0..1 | Narrative | Text summary of the resource, for human interpretation |
![]() ![]() ![]() | 0..* | Resource | Contained, inline Resources | |
![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() | ?! | 0..* | Extension | Extensions that cannot be ignored |
![]() ![]() ![]() | S | 1..* | Identifier | Unique Id for this particular observation |
![]() ![]() ![]() | ?! SΣ | 1..1 | code | registered | preliminary | final | amended + Binding: http://hl7.org/fhir/ValueSet/observation-status (required) |
![]() ![]() ![]() | 0..1 | CodeableConcept | Classification of type of observation Binding: http://hl7.org/fhir/ValueSet/observation-category (example) | |
![]() ![]() ![]() | S Σ | 1..1 | CodeableConcept | Coded Responses from C-CDA Vital Sign Results Binding: C-CDA Vital Sign Result (extensible) |
![]() ![]() ![]() | S Σ | 1..1 | Reference(U.S. Data Access Framework (DAF) Patient Profile) | Who and/or what this is about |
![]() ![]() ![]() | S | 0..1 | Reference(U.S. Data Access Framework (DAF) Encounter profile) | Healthcare event during which this observation is made |
![]() ![]() ![]() | S Σ | 1..1 | dateTime, Period | Often just a dateTime for Vital Signs |
![]() ![]() ![]() | Σ | 0..1 | instant | Date/Time this was made available |
![]() ![]() ![]() | S Σ | 0..1 | Reference(U.S. Data Access Framework (DAF) Practitioner Profile | U.S. Data Access Framework (DAF) Patient Profile | U.S. DAF Related Person Profile | U.S. DAF Organization Profile) | Who is responsible for the observation |
![]() ![]() ![]() | S Σ | 0..1 | Quantity | Vital Sign Value recorded with UCUM Binding: Common UCUM units (required) |
![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() | S Σ | 0..1 | decimal | Numerical value (with implicit precision) |
![]() ![]() ![]() ![]() | ?! Σ | 0..1 | code | < | <= | >= | > - how to understand the value Binding: http://hl7.org/fhir/ValueSet/quantity-comparator (required) |
![]() ![]() ![]() ![]() | S Σ | 0..1 | string | Unit representation |
![]() ![]() ![]() ![]() | S ΣI | 0..1 | uri | System that defines coded unit form Fixed Value: http://unitsofmeasure.org/ |
![]() ![]() ![]() ![]() | S Σ | 0..1 | code | Coded responses from the common UCUM units for vital signs value set. |
![]() ![]() ![]() | S I | 0..1 | CodeableConcept | Why the result is missing Binding: http://hl7.org/fhir/ValueSet/observation-valueabsentreason (extensible) |
![]() ![]() ![]() | 0..1 | CodeableConcept | High, low, normal, etc. Binding: http://hl7.org/fhir/ValueSet/observation-interpretation (extensible) | |
![]() ![]() ![]() | 0..1 | string | Comments about result | |
![]() ![]() ![]() | 0..1 | CodeableConcept | Observed body part Binding: http://hl7.org/fhir/ValueSet/body-site (example) | |
![]() ![]() ![]() | 0..1 | CodeableConcept | How it was done Binding: http://hl7.org/fhir/ValueSet/observation-methods (example) | |
![]() ![]() ![]() | 0..1 | Reference(Specimen) | Specimen used for this observation | |
![]() ![]() ![]() | 0..1 | Reference(Device | DeviceMetric) | (Measurement) Device | |
![]() ![]() ![]() | S I | 0..1 | BackboneElement | Provides guide for interpretation obs-3: Must have at least a low or a high or text |
![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() | ?! | 0..* | Extension | Extensions that cannot be ignored |
![]() ![]() ![]() ![]() | S I | 0..1 | SimpleQuantity | Low Range, if relevant Binding: Common UCUM units (required) |
![]() ![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() ![]() | S Σ | 0..1 | decimal | Numerical value (with implicit precision) |
![]() ![]() ![]() ![]() ![]() | ?! Σ | 0..0 | code | |
![]() ![]() ![]() ![]() ![]() | S Σ | 0..1 | string | Unit representation |
![]() ![]() ![]() ![]() ![]() | S ΣI | 0..1 | uri | System that defines coded unit form Fixed Value: http://unitsofmeasure.org/ |
![]() ![]() ![]() ![]() ![]() | S Σ | 0..1 | code | Coded form of the unit |
![]() ![]() ![]() ![]() | S I | 0..1 | SimpleQuantity | High Range, if relevant Binding: Common UCUM units (required) |
![]() ![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() ![]() | S Σ | 0..1 | decimal | Numerical value (with implicit precision) |
![]() ![]() ![]() ![]() ![]() | ?! Σ | 0..0 | code | |
![]() ![]() ![]() ![]() ![]() | S Σ | 0..1 | string | Unit representation |
![]() ![]() ![]() ![]() ![]() | S ΣI | 0..1 | uri | System that defines coded unit form Fixed Value: http://unitsofmeasure.org/ |
![]() ![]() ![]() ![]() ![]() | S Σ | 0..1 | code | Coded form of the unit |
![]() ![]() ![]() ![]() | S | 0..1 | CodeableConcept | Indicates the meaning/use of this range of this range Binding: http://hl7.org/fhir/ValueSet/referencerange-meaning (example) |
![]() ![]() ![]() ![]() | 0..1 | Range | Applicable age range, if relevant | |
![]() ![]() ![]() ![]() | S | 0..1 | string | Text based reference range in an observation |
![]() ![]() ![]() | S Σ | 0..1 | BackboneElement | Used when reporting systolic and diastolic blood pressure. |
![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() | ?! | 0..* | Extension | Extensions that cannot be ignored |
![]() ![]() ![]() ![]() | S | 1..1 | code | has-member | derived-from | sequel-to | replaces | qualified-by | interfered-by Binding: http://hl7.org/fhir/ValueSet/observation-relationshiptypes (required) Fixed Value: has-component |
![]() ![]() ![]() ![]() | S | 1..1 | Reference(U.S. Data Access Framework (DAF) Vital Signs Profile) | Resource that is related to this one |
![]() ![]() ![]() | Σ | 0..* | BackboneElement | Component results |
![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() | ?! | 0..* | Extension | Extensions that cannot be ignored |
![]() ![]() ![]() ![]() | Σ I | 1..1 | CodeableConcept | Type of component observation (code / type) Binding: http://hl7.org/fhir/ValueSet/observation-codes (example) |
![]() ![]() ![]() ![]() | Σ | 0..1 | Quantity, CodeableConcept, string, Range, Ratio, SampledData, Attachment, time, dateTime, Period | Actual component result |
![]() ![]() ![]() ![]() | I | 0..1 | CodeableConcept | Why the component result is missing Binding: http://hl7.org/fhir/ValueSet/observation-valueabsentreason (extensible) |
![]() ![]() ![]() ![]() | 0..* | Provides guide for interpretation of component result | ||
![]() |