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 (hspc-stdqty) | I | 0..* | Observation | Measurements and simple assertions obs-6: Shall only be present if Observation.value[x] is not present obs-7: Component code Shall not be same as observation code inv-1: Must have either a value or a dataAbsentReason but not both |
id | Σ | 0..1 | id | Logical id of this artifact |
meta | Σ | 0..1 | Meta | Metadata about the resource |
implicitRules | ?! Σ | 0..1 | uri | A set of rules under which this content was created |
language | 0..1 | code | Language of the resource content Binding: http://tools.ietf.org/html/bcp47 (required) | |
text | I | 0..1 | Narrative | Text summary of the resource, for human interpretation |
contained | 0..* | Resource | Contained, inline Resources | |
extension (reportingPriority) | 0..1 | Extension(code) | Extension URL: http://hl7.org/fhir/StructureDefinition/hspc-reporting-priority | |
extension (deltaFlag) | 0..1 | Extension(code) | Extension URL: http://hl7.org/fhir/StructureDefinition/hspc-delta-flag | |
extension (verified) | 0..1 | Extension(boolean) | Extension URL: http://hl7.org/fhir/StructureDefinition/hspc-verified | |
extension (updated) | 0..1 | Extension(dateTime) | Extension URL: http://hl7.org/fhir/StructureDefinition/hspc-updated | |
focal-subject | 0..1 | Extension | Extension URL: http://hl7.org/fhir/StructureDefinition/observation-focal-subject | |
modifierExtension | ?! | 0..* | Extension | Extensions that cannot be ignored |
identifier | 0..0 | Identifier | ||
status | ?! Σ | 1..1 | code | registered | preliminary | final | amended + Binding: http://hl7.org/fhir/ValueSet/observation-status (required) |
category | 0..1 | CodeableConcept | Classification of type of observation Binding: http://hl7.org/fhir/ValueSet/observation-category (example) | |
code | Σ | 1..1 | CodeableConcept | Type of observation (code / type) Binding: HSPC Quantitative Labs (preferred) Fixed Value: {"coding":[{"system":"http://loinc.org/","code":"2885-2"}]} |
subject | Σ | 1..1 | Reference(Patient | Group | Device | Location) | Who and/or what this is about |
encounter | 0..1 | Reference(Encounter) | Healthcare event during which this observation is made | |
effective[x] | Σ | 0..1 | dateTime, Period | Clinically Relevant time/time-period for observation |
issued | Σ | 0..1 | instant | Date/Time this was made available |
performer | Σ | Reference(Practitioner | Organization | Patient | RelatedPerson) | Who is responsible for the observation Slice: Ordered, Closed, by performer.type | |
performer (person) | Σ | 0..* | Reference(hspc-responsibleobserver) | the individual with the primary responsibility for the procedure or action being taken |
performer (lab) | Σ | 0..1 | Reference(hspc-performinglaboratory) | name and address of the laboratory that performs the test |
valueQuantity | Σ | 0..1 | Quantity | Actual result |
id | 0..1 | id | xml:id (or equivalent in JSON) | |
extension | 0..* | Extension | Additional Content defined by implementations | |
value | 1..1 | decimal | Numerical value (with implicit precision) | |
comparator | ?! | 0..1 | code | < | <= | >= | > - how to understand the value Binding: http://hl7.org/fhir/ValueSet/quantity-comparator (required) |
unit | 1..1 | string | Unit representation | |
system | I | 1..1 | uri | System that defines coded unit form Fixed Value: http://unitsofmeasure.org/ |
code | 1..1 | code | Coded form of the unit | |
dataAbsentReason | I | 0..1 | CodeableConcept | Why the result is missing Binding: http://hl7.org/fhir/ValueSet/observation-valueabsentreason (extensible) |
interpretation | 0..1 | CodeableConcept | High, low, normal, etc. Binding: Abnormal Interpretation Numeric Nom (preferred) | |
comments | 0..1 | string | Comments about result | |
bodySite | 0..0 | CodeableConcept | ||
method | 0..0 | CodeableConcept | ||
specimen | 0..1 | Reference(hspc-specimen) | Specimen used for this observation | |
device | 0..1 | Reference(Device | DeviceMetric) | (Measurement) Device | |
referenceRange | I | 1..1 | BackboneElement | Provides guide for interpretation obs-3: Must have at least a low or a high or text |
id | 0..1 | id | xml:id (or equivalent in JSON) | |
extension | 0..* | Extension | Additional Content defined by implementations | |
modifierExtension | ?! | 0..* | Extension | Extensions that cannot be ignored |
low | I | 0..0 | SimpleQuantity | |
high | I | 0..0 | SimpleQuantity | |
meaning | 0..0 | CodeableConcept | ||
age | 0..0 | Range | ||
text | 1..1 | string | Text based reference range in an observation | |
related | Σ | 0..0 | BackboneElement | |
component | Σ | 0..* | BackboneElement | Component results |
id | 0..1 | id | xml:id (or equivalent in JSON) | |
extension | 0..* | Extension | Additional Content defined by implementations | |
modifierExtension | ?! | 0..* | Extension | Extensions that cannot be ignored |
code | Σ I | 1..1 | CodeableConcept | Type of component observation (code / type) Binding: http://hl7.org/fhir/ValueSet/observation-codes (example) |
value[x] | Σ | 0..1 | Quantity, CodeableConcept, string, Range, Ratio, SampledData, Attachment, time, dateTime, Period | Actual component result |
dataAbsentReason | I | 0..1 | CodeableConcept | Why the component result is missing Binding: http://hl7.org/fhir/ValueSet/observation-valueabsentreason (extensible) |
referenceRange | 0..* | Provides guide for interpretation ofcomponent result | ||
Documentation for this format |