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 |
---|---|---|---|---|
Observation | I | 0..* | Observation | Measurements and simple assertions dom-4: If a resource is contained in another resource, it SHALL NOT have a meta.versionId or a meta.lastUpdated dom-3: If the resource is contained in another resource, it SHALL be referred to from elsewhere in the resource dom-2: If the resource is contained in another resource, it SHALL NOT contain nested Resources dom-1: If the resource is contained in another resource, it SHALL NOT contain any narrative obs-6: dataAbsentReason SHALL only be present if Observation.value[x] is not present obs-7: Component code SHALL not be same as observation code |
id | Σ I | 0..1 | id | Logical id of this artifact ele-1: All FHIR elements must have a @value or children |
meta | Σ I | 0..1 | Meta | Metadata about the resource ele-1: All FHIR elements must have a @value or children |
implicitRules | ?! ΣI | 0..1 | uri | A set of rules under which this content was created ele-1: All FHIR elements must have a @value or children |
language | I | 0..1 | code | Language of the resource content Binding: http://tools.ietf.org/html/bcp47 (required) ele-1: All FHIR elements must have a @value or children |
text | I | 0..1 | Narrative | Text summary of the resource, for human interpretation ele-1: All FHIR elements must have a @value or children |
contained | 0..* | Resource | Contained, inline Resources | |
extension | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
modifierExtension | ?! I | 0..* | Extension | Extensions that cannot be ignored ele-1: All FHIR elements must have a @value or children |
identifier | Σ I | 0..1 | Identifier | Unique Id for this particular observation ele-1: All FHIR elements must have a @value or children |
status | ?! ΣI | 1..1 | code | registered | preliminary | final | amended + Binding: http://hl7.org/fhir/ValueSet/observation-status (required) ele-1: All FHIR elements must have a @value or children Fixed Value: final |
category | Σ I | 0..1 | CodeableConcept | Classification of type of observation Binding: http://hl7.org/fhir/ValueSet/observation-category (example) ele-1: All FHIR elements must have a @value or children |
code | Σ I | 1..1 | CodeableConcept | Type of observation (code / type) Binding: http://www.power2dm.eu/pds/ValueSet/pdm-observations (required) ele-1: All FHIR elements must have a @value or children |
subject | Σ I | 1..1 | Reference(POWER2DM-Patient) | Who and/or what this is about ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
encounter | Σ I | 0..1 | Reference(Encounter) | Healthcare event during which this observation is made ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
effectiveDateTime | Σ I | 1..1 | dateTime | Clinically relevant time/time-period for observation ele-1: All FHIR elements must have a @value or children |
issued | Σ I | 0..1 | instant | Date/Time this was made available ele-1: All FHIR elements must have a @value or children |
performer | Σ I | 0..1 | Reference(POWER2DM-Patient | POWER2DM-Practitioner | POWER2DM-Organization) | Who is responsible for the observation ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
valueQuantity | Σ I | 1..1 | Quantity | Actual result ele-1: All FHIR elements must have a @value or children qty-3: If a code for the unit is present, the system SHALL also be present |
dataAbsentReason | Σ I | 0..0 | CodeableConcept | |
interpretation | Σ I | 0..1 | CodeableConcept | High, low, normal, etc. Binding: http://hl7.org/fhir/ValueSet/observation-interpretation (extensible) ele-1: All FHIR elements must have a @value or children |
comments | I | 0..1 | string | Comments about result ele-1: All FHIR elements must have a @value or children |
bodySite | Σ I | 0..0 | CodeableConcept | |
method | Σ I | 0..1 | CodeableConcept | How it was done Binding: http://hl7.org/fhir/ValueSet/observation-methods (example) ele-1: All FHIR elements must have a @value or children |
specimen | Σ I | 0..0 | Reference(Specimen) | |
device | Σ I | 0..1 | Reference(POWER2DM-Device) | (Measurement) Device ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
referenceRange (referenceRange) | I | 0..0 | BackboneElement | |
related | Σ I | 1..1 | BackboneElement | Resource related to this observation ele-1: All FHIR elements must have a @value or children |
id | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
extension | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
modifierExtension | ?! I | 0..* | Extension | Extensions that cannot be ignored ele-1: All FHIR elements must have a @value or children |
type | I | 0..1 | code | has-member | derived-from | sequel-to | replaces | qualified-by | interfered-by Binding: http://hl7.org/fhir/ValueSet/observation-relationshiptypes (required) ele-1: All FHIR elements must have a @value or children |
target | Σ I | 1..1 | Reference(QuestionnaireResponse) | Resource that is related to this one ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
component | Σ I | 0..0 | BackboneElement | |
Documentation for this format |