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 | US Realm DAF laboratory result using CodeableConcept Data Type for non-numeric results 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 |
![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() | ?! SΣ | 1..1 | code | usual | official | temp | secondary (If known) Binding: http://hl7.org/fhir/ValueSet/identifier-use (required) |
![]() ![]() ![]() ![]() | Σ | 0..1 | CodeableConcept | Description of identifier Binding: http://hl7.org/fhir/ValueSet/identifier-type (extensible) |
![]() ![]() ![]() ![]() | S Σ | 1..1 | uri | The namespace for the identifier Example: http://www.acme.com/identifiers/patient or urn:ietf:rfc:3986 if the id itself is a full uri |
![]() ![]() ![]() ![]() | S Σ | 1..1 | string | The value that is unique Example: 123456 |
![]() ![]() ![]() ![]() | Σ | 0..1 | Period | Time period when id is/was valid for use |
![]() ![]() ![]() ![]() | Σ | 0..1 | Reference(Organization) | Organization that issued id (may be just text) |
![]() ![]() ![]() | ?! 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 | US Realm Laboratory Test Name Binding: http://hl7.org/fhir/ValueSet/uslab-obs-codes (extensible) |
![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() | S | 1..* | Coding | Code defined by a terminology system |
![]() ![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() ![]() | S Σ | 1..1 | uri | Identity of the terminology system |
![]() ![]() ![]() ![]() ![]() | Σ | 0..1 | string | Version of the system - if relevant |
![]() ![]() ![]() ![]() ![]() | S Σ | 1..1 | code | Symbol in syntax defined by the system |
![]() ![]() ![]() ![]() ![]() | S Σ | 0..1 | string | Representation defined by the system |
![]() ![]() ![]() ![]() ![]() | Σ | 0..1 | boolean | If this coding was chosen directly by the user |
![]() ![]() ![]() ![]() | S | 0..1 | string | Display text |
![]() ![]() ![]() | 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 ΣI | 0..1 | dateTime, Period | Clinically Relevant time/time-period for observation inv-1: Datetime must be at least to day. |
![]() ![]() ![]() | S Σ | 0..1 | instant | Date/Time this was made available |
![]() ![]() ![]() | Σ | 0..* | Reference(U.S. Data Access Framework (DAF) Practitioner Profile | U.S. DAF Organization Profile | U.S. Data Access Framework (DAF) Patient Profile | U.S. DAF Related Person Profile) | Who is responsible for the observation |
![]() ![]() ![]() | S Σ | 0..1 | Quantity, CodeableConcept, string, Range, Ratio, SampledData, Attachment, time, dateTime, Period | US Realm Coded Test Result Binding: http://hl7.org/fhir/ValueSet/uslab-obs-codedresults (extensible) |
![]() ![]() ![]() | S I | 0..1 | CodeableConcept | Why the result is missing Binding: http://hl7.org/fhir/ValueSet/observation-valueabsentreason (extensible) |
![]() ![]() ![]() | S | 0..1 | CodeableConcept | High, low, normal, etc. Binding: http://hl7.org/fhir/ValueSet/uslab-obs-interpretation (required) |
![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() | S | 1..* | Coding | Code defined by a terminology system |
![]() ![]() ![]() ![]() ![]() | 0..1 | id | xml:id (or equivalent in JSON) | |
![]() ![]() ![]() ![]() ![]() | 0..* | Extension | Additional Content defined by implementations | |
![]() ![]() ![]() ![]() ![]() | S Σ | 1..1 | uri | Identity of the terminology system |
![]() ![]() ![]() ![]() ![]() | Σ | 0..1 | string | Version of the system - if relevant |
![]() ![]() ![]() ![]() ![]() | S Σ | 1..1 | code | Symbol in syntax defined by the system |
![]() ![]() ![]() ![]() ![]() | Σ | 0..1 | string | Representation defined by the system |
![]() ![]() ![]() ![]() ![]() | Σ | 0..1 | boolean | If this coding was chosen directly by the user |
![]() ![]() ![]() ![]() | 0..1 | string | Plain text representation of the concept | |
![]() ![]() ![]() | 0..1 | string | Comments about result | |
![]() ![]() ![]() | 0..0 | CodeableConcept | ||
![]() ![]() ![]() | 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 | |
![]() ![]() ![]() | I | 0..* | 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..1 | SimpleQuantity | Low Range, if relevant |
![]() ![]() ![]() ![]() | I | 0..1 | SimpleQuantity | High Range, if relevant |
![]() ![]() ![]() ![]() | 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 | |
![]() ![]() ![]() ![]() | 0..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 | ||
![]() |