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 |
|---|---|---|---|---|
  Composition | I | 0..* | Composition | A set of resources composed into a single coherent clinical statement with clinical attestation 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 |
  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 | Logical identifier of composition (version-independent) ele-1: All FHIR elements must have a @value or children |
| date | Σ I | 1..1 | dateTime | Composition editing time ele-1: All FHIR elements must have a @value or children |
| type | Σ I | 1..1 | CodeableConcept | Kind of composition (LOINC if possible) Binding: http://hl7.org/fhir/ValueSet/doc-typecodes (preferred) 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 |
| coding | Σ I | 0..* | Coding | Code defined by a terminology system 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 |
| system | Σ I | 0..1 | uri | Identity of the terminology system ele-1: All FHIR elements must have a @value or children Fixed Value: http://power2dm.eu |
| version | Σ I | 0..1 | string | Version of the system - if relevant ele-1: All FHIR elements must have a @value or children |
| code | Σ I | 0..1 | code | Symbol in syntax defined by the system ele-1: All FHIR elements must have a @value or children Fixed Value: kadis-baseline |
| display | Σ I | 0..1 | string | Representation defined by the system ele-1: All FHIR elements must have a @value or children |
 userSelected | Σ I | 0..1 | boolean | If this coding was chosen directly by the user ele-1: All FHIR elements must have a @value or children |
| text | Σ I | 0..1 | string | Plain text representation of the concept ele-1: All FHIR elements must have a @value or children |
| class | Σ I | 0..1 | CodeableConcept | Categorization of Composition Binding: http://hl7.org/fhir/ValueSet/doc-classcodes (example) ele-1: All FHIR elements must have a @value or children |
| title | Σ I | 1..1 | string | Human Readable name/title ele-1: All FHIR elements must have a @value or children Fixed Value: POWER2DM KADIS Baseline Dataset |
| status | ?! ΣI | 1..1 | code | preliminary | final | amended | entered-in-error Binding: http://hl7.org/fhir/ValueSet/composition-status (required) ele-1: All FHIR elements must have a @value or children Fixed Value: final |
| confidentiality | ?! ΣI | 0..1 | code | As defined by affinity domain Binding: http://hl7.org/fhir/ValueSet/v3-Confidentiality (required) ele-1: All FHIR elements must have a @value or children |
 subject | Σ I | 1..1 | Reference(POWER2DM-Patient) | Who and/or what the composition 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 |
| author | Σ I | 1..* | Reference(Device) | Who and/or what authored the composition ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
 attester | Σ I | 0..* | BackboneElement | Attests to accuracy of composition 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 |
| mode | Σ I | 1..* | code | personal | professional | legal | official Binding: http://hl7.org/fhir/ValueSet/composition-attestation-mode (required) ele-1: All FHIR elements must have a @value or children |
| time | Σ I | 0..1 | dateTime | When composition attested ele-1: All FHIR elements must have a @value or children |
| party | Σ I | 0..1 | Reference(Patient | Practitioner | Organization) | Who attested the composition ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
| custodian | Σ I | 0..1 | Reference(Organization) | Organization which maintains the composition ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
| event | Σ I | 1..1 | BackboneElement | The clinical service(s) being documented 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 |
| code | Σ I | 0..* | CodeableConcept | Code(s) that apply to the event being documented Binding: http://hl7.org/fhir/ValueSet/v3-ActCode (example) ele-1: All FHIR elements must have a @value or children |
| period | Σ I | 1..1 | Period | The period covered by the documentation ele-1: All FHIR elements must have a @value or children per-1: If present, start SHALL have a lower value than end |
| 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 |
| start | Σ I | 1..1 | dateTime | Starting time with inclusive boundary ele-1: All FHIR elements must have a @value or children |
| end | Σ I | 1..1 | dateTime | End time with inclusive boundary, if not ongoing ele-1: All FHIR elements must have a @value or children |
| detail | Σ I | 0..* | Reference(Resource) | The event(s) being documented 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) | Context of the Composition ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
 section (section) | I | BackboneElement | Composition is broken into sections Slice: Unordered, Open At End, by title ele-1: All FHIR elements must have a @value or children cmp-2: A section can only have an emptyReason if it is empty cmp-1: A section must at least one of text, entries, or sub-sections | |
| 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 |
| title | I | 0..1 | string | Label for section (e.g. for ToC) ele-1: All FHIR elements must have a @value or children |
| code | Σ I | 0..1 | CodeableConcept | Classification of section (recommended) Binding: http://hl7.org/fhir/ValueSet/doc-section-codes (example) ele-1: All FHIR elements must have a @value or children |
| text | I | 0..1 | Narrative | Text summary of the section, for human interpretation ele-1: All FHIR elements must have a @value or children |
| mode | ?! ΣI | 0..1 | code | working | snapshot | changes Binding: http://hl7.org/fhir/ValueSet/list-mode (required) ele-1: All FHIR elements must have a @value or children |
| orderedBy | Σ I | 0..1 | CodeableConcept | Order of section entries Binding: http://hl7.org/fhir/ValueSet/list-order (preferred) ele-1: All FHIR elements must have a @value or children |
| entry | Σ I | 0..* | Reference(Resource) | A reference to data that supports this section ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
| emptyReason | Σ I | 0..1 | CodeableConcept | Why the section is empty Binding: http://hl7.org/fhir/ValueSet/list-empty-reason (preferred) ele-1: All FHIR elements must have a @value or children |
| section | I | 0..* | Nested Section | |
| section (blood-glucose-measurements) | I | 1..1 | BackboneElement | Composition is broken into sections ele-1: All FHIR elements must have a @value or children cmp-2: A section can only have an emptyReason if it is empty cmp-1: A section must at least one of text, entries, or sub-sections |
| 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 |
| title | I | 1..1 | string | Label for section (e.g. for ToC) ele-1: All FHIR elements must have a @value or children Fixed Value: Blood Glucose Measurements |
| code | Σ I | 0..1 | CodeableConcept | Classification of section (recommended) Binding: http://hl7.org/fhir/ValueSet/doc-section-codes (example) ele-1: All FHIR elements must have a @value or children |
| text | I | 0..1 | Narrative | Text summary of the section, for human interpretation ele-1: All FHIR elements must have a @value or children |
| mode | ?! ΣI | 0..1 | code | working | snapshot | changes Binding: http://hl7.org/fhir/ValueSet/list-mode (required) ele-1: All FHIR elements must have a @value or children |
| orderedBy | Σ I | 0..1 | CodeableConcept | Order of section entries Binding: http://hl7.org/fhir/ValueSet/list-order (preferred) ele-1: All FHIR elements must have a @value or children |
| entry | Σ I | 0..* | Reference(POWER2DM-SimpleQuantityObservation | POWER2DM-TimeSeriesObservation) | A reference to data that supports this section ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
| emptyReason | Σ I | 0..1 | CodeableConcept | Why the section is empty Binding: http://hl7.org/fhir/ValueSet/list-empty-reason (preferred) ele-1: All FHIR elements must have a @value or children |
| section | I | 0..* | Nested Section | |
| section (dietary-intakes) | I | 1..1 | BackboneElement | Composition is broken into sections ele-1: All FHIR elements must have a @value or children cmp-2: A section can only have an emptyReason if it is empty cmp-1: A section must at least one of text, entries, or sub-sections |
| 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 |
| title | I | 1..1 | string | Label for section (e.g. for ToC) ele-1: All FHIR elements must have a @value or children Fixed Value: Dietary Intakes |
| code | Σ I | 0..1 | CodeableConcept | Classification of section (recommended) Binding: http://hl7.org/fhir/ValueSet/doc-section-codes (example) ele-1: All FHIR elements must have a @value or children |
| text | I | 0..1 | Narrative | Text summary of the section, for human interpretation ele-1: All FHIR elements must have a @value or children |
| mode | ?! ΣI | 0..1 | code | working | snapshot | changes Binding: http://hl7.org/fhir/ValueSet/list-mode (required) ele-1: All FHIR elements must have a @value or children |
| orderedBy | Σ I | 0..1 | CodeableConcept | Order of section entries Binding: http://hl7.org/fhir/ValueSet/list-order (preferred) ele-1: All FHIR elements must have a @value or children |
| entry | Σ I | 0..* | Reference(POWER2DM-DietaryIntakeLog) | A reference to data that supports this section ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
| emptyReason | Σ I | 0..1 | CodeableConcept | Why the section is empty Binding: http://hl7.org/fhir/ValueSet/list-empty-reason (preferred) ele-1: All FHIR elements must have a @value or children |
| section | I | 0..* | Nested Section | |
| section (medication-intakes) | I | 1..1 | BackboneElement | Composition is broken into sections ele-1: All FHIR elements must have a @value or children cmp-2: A section can only have an emptyReason if it is empty cmp-1: A section must at least one of text, entries, or sub-sections |
| 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 |
| title | I | 1..1 | string | Label for section (e.g. for ToC) ele-1: All FHIR elements must have a @value or children Fixed Value: Medication/Insulin Intakes |
| code | Σ I | 0..1 | CodeableConcept | Classification of section (recommended) Binding: http://hl7.org/fhir/ValueSet/doc-section-codes (example) ele-1: All FHIR elements must have a @value or children |
| text | I | 0..1 | Narrative | Text summary of the section, for human interpretation ele-1: All FHIR elements must have a @value or children |
| mode | ?! ΣI | 0..1 | code | working | snapshot | changes Binding: http://hl7.org/fhir/ValueSet/list-mode (required) ele-1: All FHIR elements must have a @value or children |
| orderedBy | Σ I | 0..1 | CodeableConcept | Order of section entries Binding: http://hl7.org/fhir/ValueSet/list-order (preferred) ele-1: All FHIR elements must have a @value or children |
| entry | Σ I | 0..* | Reference(POWER2DM-MedicationAdministration) | A reference to data that supports this section ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
| emptyReason | Σ I | 0..1 | CodeableConcept | Why the section is empty Binding: http://hl7.org/fhir/ValueSet/list-empty-reason (preferred) ele-1: All FHIR elements must have a @value or children |
| section | I | 0..* | Nested Section | |
| section (exercises) | I | 1..1 | BackboneElement | Composition is broken into sections ele-1: All FHIR elements must have a @value or children cmp-2: A section can only have an emptyReason if it is empty cmp-1: A section must at least one of text, entries, or sub-sections |
 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 |
| title | I | 1..1 | string | Label for section (e.g. for ToC) ele-1: All FHIR elements must have a @value or children Fixed Value: Exercises |
| code | Σ I | 0..1 | CodeableConcept | Classification of section (recommended) Binding: http://hl7.org/fhir/ValueSet/doc-section-codes (example) ele-1: All FHIR elements must have a @value or children |
| text | I | 0..1 | Narrative | Text summary of the section, for human interpretation ele-1: All FHIR elements must have a @value or children |
| mode | ?! ΣI | 0..1 | code | working | snapshot | changes Binding: http://hl7.org/fhir/ValueSet/list-mode (required) ele-1: All FHIR elements must have a @value or children |
| orderedBy | Σ I | 0..1 | CodeableConcept | Order of section entries Binding: http://hl7.org/fhir/ValueSet/list-order (preferred) ele-1: All FHIR elements must have a @value or children |
| entry | Σ I | 0..* | Reference(POWER2DM-PhysicalActivityLog) | A reference to data that supports this section ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
| emptyReason | Σ I | 0..1 | CodeableConcept | Why the section is empty Binding: http://hl7.org/fhir/ValueSet/list-empty-reason (preferred) ele-1: All FHIR elements must have a @value or children |
| section | I | 0..* | Nested Section | |
| Documentation for this format | ||||