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..* | Condition | Problem identified in POWER2DM 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 | 0..* | Extension(Reference(POWER2DM-Condition)) | Reference to related POWER2DM condition URL: http://www.power2dm.eu/pds/StructureDefinition/POWER2DM-relatedCondition ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | I | 0..* | Extension(Reference(POWER2DM-Problem)) | Extension to indicate related POWER2DM problem URL: http://www.power2dm.eu/pds/StructureDefinition/POWER2DM-relatedProblem 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..1 | Identifier | External Ids for this condition ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | Reference(POWER2DM-Patient) | Who has the condition? 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 | Reference(Encounter) | Encounter when condition first asserted 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 | Reference(POWER2DM-Practitioner) | Person who asserts this condition 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 | date | When first entered ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | CodeableConcept | Identification of the condition, problem or diagnosis Binding: http://power2dm.eu/pds/ValueSet/pdm-problems (required) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | CodeableConcept | complaint | barrier | problem | diagnosis Binding: http://power2dm.eu/pds/ValueSet/pdm-condition-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 Fixed Value: http://power2dm.eu |
![]() ![]() ![]() ![]() ![]() | Σ 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 Fixed Value: problem |
![]() ![]() ![]() ![]() ![]() | Σ 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 | code | active | relapse | remission | resolved Binding: (unbound) (required) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | ?! ΣI | 1..1 | code | provisional | confirmed | refuted Binding: http://power2dm.eu/pds/ValueSet/pdm-cond-verification-status (required) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..1 | CodeableConcept | Subjective severity of condition Binding: http://hl7.org/fhir/ValueSet/condition-severity (preferred) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 1..1 | dateTime | Estimated or actual date, date-time, or age ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..1 | dateTime | If/when in resolution/remission ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() | Σ I | 0..1 | BackboneElement | Stage/grade, usually assessed formally ele-1: All FHIR elements must have a @value or children con-1: Stage SHALL have summary or assessment |
![]() ![]() ![]() ![]() | 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..* | Extension | Extensions that cannot be ignored ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | CodeableConcept | Simple summary (disease specific) Binding: http://hl7.org/fhir/ValueSet/condition-stage (example) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..* | Reference(ClinicalImpression | DiagnosticReport | Observation) | Formal record of assessment 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 | BackboneElement | Supporting evidence ele-1: All FHIR elements must have a @value or children con-2: evidence SHALL have code or details |
![]() ![]() ![]() ![]() | 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..* | Extension | Extensions that cannot be ignored ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..1 | CodeableConcept | Manifestation/symptom Binding: http://hl7.org/fhir/ValueSet/manifestation-or-symptom (example) ele-1: All FHIR elements must have a @value or children |
![]() ![]() ![]() ![]() | Σ I | 0..* | Reference(Resource) | Supporting information found elsewhere 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 | CodeableConcept | |
![]() ![]() ![]() | Σ I | 0..1 | string | Additional information about the Condition ele-1: All FHIR elements must have a @value or children |
![]() |