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..* | DomainResource | A request for information to be sent to a receiver 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 |
![]() ![]() ![]() | Σ I | 0..1 | id | Logical id of this artifact ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..1 | Meta | Metadata about the resource ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | ?! Σ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 |
![]() ![]() ![]() | 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 |
![]() ![]() ![]() | I | 0..1 | Narrative | Text summary of the resource, for human interpretation ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | 0..* | Resource | Contained, inline Resources | |
![]() ![]() ![]() | I | 1..1 | Extension(Reference(POWER2DM-ActionPlan | POWER2DM-Goal | POWER2DM-MedicationOrder | POWER2DM-Appointment)) | Extension of Addressed Gıal or action URL: http://www.power2dm.eu/pds/StructureDefinition/POWER2DM-CommunicationPreference-addresses ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | ?! I | 0..* | Extension | Extensions that cannot be ignored ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..* | Identifier | Unique identifier ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | ?! ΣI | 0..1 | code | usual | official | temp | secondary (If known) Binding: http://hl7.org/fhir/ValueSet/identifier-use (required) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | CodeableConcept | Description of identifier Binding: http://hl7.org/fhir/ValueSet/identifier-type (extensible) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..* | Coding | Code defined by a terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | uri | Identity of the terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Version of the system - if relevant ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | code | Symbol in syntax defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Representation defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | boolean | If this coding was chosen directly by the user ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Plain text representation of the concept ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | uri | The namespace for the identifier ele-1: All FHIR elements must have a @value or children Example: http://www.acme.com/identifiers/patient or urn:ietf:rfc:3986 if the Identifier.value itself is a full uri |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | The value that is unique ele-1: All FHIR elements must have a @value or children Example: 123456 |
![]() ![]() ![]() ![]() | Σ I | 0..1 | Period | Time period when id is/was valid for use ele-1: All FHIR elements must have a @value or children per-1: If present, start SHALL have a lower value than end |
![]() ![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | dateTime | Starting time with inclusive boundary ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | dateTime | End time with inclusive boundary, if not ongoing ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | Reference(Organization) | Organization that issued id (may be just text) ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
![]() ![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Relative, internal or absolute URL reference ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Text alternative for the resource ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | CodeableConcept | Message category Binding: http://power2dm.eu/pds/ValueSet/pdm-communication-categories (required) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..* | Coding | Code defined by a terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | uri | Identity of the terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Version of the system - if relevant ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | code | Symbol in syntax defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Representation defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | boolean | If this coding was chosen directly by the user ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Plain text representation of the concept ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..1 | Reference(Device | Organization | Patient | Practitioner | RelatedPerson) | Message sender ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
![]() ![]() ![]() | Σ I | 1..1 | Reference(Patient | Practitioner | RelatedPerson) | Message recipient ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
![]() ![]() ![]() | Σ I | 0..0 | BackboneElement | |
![]() ![]() ![]() | Σ I | 0..* | CodeableConcept | A channel of communication Binding: http://hl7.org/fhir/ValueSet/v3-ParticipationMode (example) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..* | Coding | Code defined by a terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | uri | Identity of the terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Version of the system - if relevant ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | code | Symbol in syntax defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Representation defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | boolean | If this coding was chosen directly by the user ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Plain text representation of the concept ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | Reference(Practitioner | Patient | RelatedPerson) | An individual who requested a communication ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
![]() ![]() ![]() | ?! ΣI | 1..1 | code | proposed | planned | requested | received | accepted | in-progress | completed | suspended | rejected | failed Binding: http://hl7.org/fhir/ValueSet/communication-request-status (required) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..1 | Reference(Encounter) | Encounter leading to message ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Relative, internal or absolute URL reference ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Text alternative for the resource ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | Period | When scheduled ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..* | CodeableConcept | Indication for message Binding: (unbound) (example) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..* | Coding | Code defined by a terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | uri | Identity of the terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Version of the system - if relevant ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | code | Symbol in syntax defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Representation defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | boolean | If this coding was chosen directly by the user ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Plain text representation of the concept ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..1 | dateTime | When ordered or proposed ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | Reference(Patient) | Focus of message ele-1: All FHIR elements must have a @value or children ref-1: SHALL have a local reference if the resource is provided inline |
![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Relative, internal or absolute URL reference ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Text alternative for the resource ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | CodeableConcept | Preference for this type of communication Binding: http://power2dm.eu/pds/ValueSet/pdm-communication-preferences (required) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..* | Coding | Code defined by a terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..1 | id | xml:id (or equivalent in JSON) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | I | 0..* | Extension | Additional Content defined by implementations ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | uri | Identity of the terminology system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Version of the system - if relevant ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | code | Symbol in syntax defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Representation defined by the system ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() ![]() | Σ I | 0..1 | boolean | If this coding was chosen directly by the user ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | string | Plain text representation of the concept ele-1: All FHIR elements must have a @value or children |
![]() |