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 inv-1: Must have either a value or a dataAbsentReason but not both |
![]() ![]() ![]() | Σ | 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..1 | Extension(code) | Extension URL: http://hl7.org/fhir/StructureDefinition/hspc-reporting-priority | |
![]() ![]() ![]() | 0..1 | Extension(code) | Extension URL: http://hl7.org/fhir/StructureDefinition/hspc-delta-flag | |
![]() ![]() ![]() | 0..1 | Extension(boolean) | Extension URL: http://hl7.org/fhir/StructureDefinition/hspc-verified | |
![]() ![]() ![]() | 0..1 | Extension(dateTime) | Extension URL: http://hl7.org/fhir/StructureDefinition/hspc-updated | |
![]() ![]() ![]() | 0..1 | Extension | Extension URL: http://hl7.org/fhir/StructureDefinition/observation-focal-subject | |
![]() ![]() ![]() | ?! | 0..* | Extension | Extensions that cannot be ignored |
![]() ![]() ![]() | 0..0 | Identifier | ||
![]() ![]() ![]() | ?! Σ | 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) | |
![]() ![]() ![]() | Σ | 1..1 | CodeableConcept | Type of observation (code / type) Binding: HSPC Quantitative Labs (preferred) Fixed Value: {"coding":[{"system":"http://loinc.org/","code":"2039-6"}]} |
![]() ![]() ![]() | Σ | 1..1 | Reference(Patient | Group | Device | Location) | Who and/or what this is about |
![]() ![]() ![]() | 0..1 | Reference(Encounter) | Healthcare event during which this observation is made | |
![]() ![]() ![]() | Σ | 0..1 | dateTime, Period | Clinically Relevant time/time-period for observation |
![]() ![]() ![]() | Σ | 0..1 | instant | Date/Time this was made available |
![]() ![]() ![]() | Σ | Reference(Practitioner | Organization | Patient | RelatedPerson) | Who is responsible for the observation Slice: Ordered, Closed, by performer.type | |
![]() ![]() ![]() | Σ | 0..* | Reference(hspc-responsibleobserver) | the individual with the primary responsibility for the procedure or action being taken |
![]() ![]() ![]() | Σ | 0..1 | Reference(hspc-performinglaboratory) | name and address of the laboratory that performs the test |
![]() ![]() ![]() | Σ | 0..1 | Quantity | Actual result |
![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() | 1..1 | decimal | Numerical value (with implicit precision) | |
![]() ![]() ![]() ![]() | ?! | 0..1 | code | < | <= | >= | > - how to understand the value Binding: http://hl7.org/fhir/ValueSet/quantity-comparator (required) |
![]() ![]() ![]() ![]() | 1..1 | string | Unit representation | |
![]() ![]() ![]() ![]() | I | 1..1 | uri | System that defines coded unit form Fixed Value: http://unitsofmeasure.org/ |
![]() ![]() ![]() ![]() | 1..1 | code | Coded form of the unit | |
![]() ![]() ![]() | 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: Abnormal Interpretation Numeric Nom (preferred) | |
![]() ![]() ![]() | 0..1 | string | Comments about result | |
![]() ![]() ![]() | 0..0 | CodeableConcept | ||
![]() ![]() ![]() | 0..0 | CodeableConcept | ||
![]() ![]() ![]() | 0..1 | Reference(hspc-specimen) | Specimen used for this observation | |
![]() ![]() ![]() | 0..1 | Reference(Device | DeviceMetric) | (Measurement) Device | |
![]() ![]() ![]() | I | 1..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 |
![]() ![]() ![]() ![]() | I | 0..0 | SimpleQuantity | |
![]() ![]() ![]() ![]() | I | 0..0 | SimpleQuantity | |
![]() ![]() ![]() ![]() | 0..0 | CodeableConcept | ||
![]() ![]() ![]() ![]() | 0..0 | Range | ||
![]() ![]() ![]() ![]() | 1..1 | string | Text based reference range in an observation | |
![]() ![]() ![]() | Σ | 0..0 | BackboneElement | |
![]() ![]() ![]() | Σ | 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 ofcomponent result | ||
![]() |