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.
<Bundle xmlns="http://hl7.org/fhir"> <id value="b063045d-8a25-43f0-aa9f-b10eb13b3e76" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-Bundle|1.0.0" /> <security> <system value="http://terminology.hl7.org/CodeSystem/v3-ActReason" /> <code value="HTEST" /> </security> <tag> <system value="https://fhir.infoway-inforoute.ca/NamingSystem/ca-on-health-care-facility-id" /> <code value="4999" /> </tag> </meta> <identifier> <system value="http://my.facility.ca/case-identifier" /> <value value="4999.case-001" /> </identifier> <type value="message" /> <timestamp value="2023-03-11T14:30:00+01:00" /> <entry> <fullUrl value="urn:uuid:efff2a5e-88ef-4545-8b58-57551ebf53f5" /> <resource> <MessageHeader> <id value="efff2a5e-88ef-4545-8b58-57551ebf53f5" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-MessageHeader|1.0.0" /> </meta> <eventCoding> <system value="http://ontariohealth.ca/fhir/CodeSystem/message-event-code" /> <code value="case-scheduled" /> <display value="An EventCode used by SERIS to submit Elective Surgery case information when a surgery is Booked" /> </eventCoding> <source> <endpoint value="http://ohdomain.com/ehr/fhir" /> </source> </MessageHeader> </resource> </entry> <entry> <fullUrl value="urn:uuid:f9ec36d6-67f0-11ee-8c99-0242ac120002" /> <resource> <Task> <id value="f9ec36d6-67f0-11ee-8c99-0242ac120002" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-Task|1.0.0" /> </meta> <basedOn> <reference value="urn:uuid:29bdbf9d-2417-4604-b8ca-930dfacd32be" /> </basedOn> <basedOn> <reference value="urn:uuid:25fc7cad-b076-4090-a803-d53b2039e28d" /> </basedOn> <status value="accepted" /> <businessStatus> <coding> <system value="http://ontariohealth.ca/fhir/CodeSystem/business-status" /> <code value="booked" /> <display value="Booked" /> </coding> </businessStatus> <intent value="order" /> </Task> </resource> </entry> <entry> <fullUrl value="urn:uuid:29bdbf9d-2417-4604-b8ca-930dfacd32be" /> <resource> <Appointment> <id value="29bdbf9d-2417-4604-b8ca-930dfacd32be" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-Appointment|1.0.0" /> </meta> <identifier> <system value="http://healthcare-clinic.xyz.com/appointment" /> <value value="2-23-FJDFR-3E445789" /> </identifier> <status value="booked" /> <serviceCategory> <coding> <system value="http://snomed.info/sct" /> <code value="310156009" /> <display value="General surgical service" /> </coding> </serviceCategory> <reasonReference> <reference value="urn:uuid:58a07d6e-ffca-46d7-9e5f-846058ef344c" /> </reasonReference> <start value="2023-04-15T10:00:00Z" /> <end value="2023-04-15T12:00:00Z" /> <minutesDuration value="120" /> <created value="2023-01-01" /> <comment value="Notes (when this is initial scheduling of case)" /> <participant> <actor> <reference value="urn:uuid:5350a3c4-109b-44db-a0b6-a59a28e0a19c" /> </actor> <status value="accepted" /> </participant> <participant> <actor> <identifier> <system value="https://enterprisehealth.com/location-identifiers" /> <value value="4999" /> </identifier> </actor> <status value="accepted" /> </participant> </Appointment> </resource> </entry> <entry> <fullUrl value="urn:uuid:58a07d6e-ffca-46d7-9e5f-846058ef344c" /> <resource> <Procedure> <id value="58a07d6e-ffca-46d7-9e5f-846058ef344c" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-Procedure|1.0.0" /> </meta> <status value="preparation" /> <category> <coding> <system value="http://snomed.info/sct" /> <code value="310156009" /> <display value="General surgical service" /> </coding> </category> <code> <coding> <system value="http://ontariohealth.ca/fhir/CodeSystem/WTIS-procedure-code" /> <code value="W.GS.DCL" /> <display value="General Surgery - Digestive System – Colorectal" /> </coding> <text value="Procedure Description" /> </code> <subject> <reference value="urn:uuid:5350a3c4-109b-44db-a0b6-a59a28e0a19c" /> </subject> <performer> <actor> <reference value="urn:uuid:b0147d44-21cb-4d03-92d7-698844b8238e" /> </actor> </performer> <location> <identifier> <system value="https://enterprisehealth.com/location-identifiers" /> <value value="4999" /> </identifier> </location> </Procedure> </resource> </entry> <entry> <fullUrl value="urn:uuid:5350a3c4-109b-44db-a0b6-a59a28e0a19c" /> <resource> <Patient> <id value="5350a3c4-109b-44db-a0b6-a59a28e0a19c" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-Patient|1.0.0" /> </meta> <extension url="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-ext-race"> <valueCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <code value="413581001" /> </coding> </valueCodeableConcept> </extension> <extension url="http://hl7.org/fhir/StructureDefinition/patient-genderIdentity"> <valueCodeableConcept> <coding> <system value="http://snomed.info/sct" /> <code value="33791000087105" /> <display value="Identifies as nonbinary gender" /> </coding> <text value="Non-Binary" /> </valueCodeableConcept> </extension> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="JHN" /> </coding> </type> <system value="https://fhir.infoway-inforoute.ca/NamingSystem/ca-on-patient-hcn" /> <value value="1234567890" /> </identifier> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="MR" /> </coding> </type> <system value="http://ontariohealth.ca/fhir/NamingSystem/id-example1-uri" /> <value value="ABC12345" /> </identifier> <name> <family value="Alcantara" /> <given value="Xero" /> <given value="D" /> </name> <gender value="male" /> <birthDate value="1972-11-12" /> <address> <use value="home" /> <type value="postal" /> <line value="4 Privet Drive" /> <city value="Surrey" /> <state value="ON" /> <postalCode value="M9W7B8" /> </address> </Patient> </resource> </entry> <entry> <fullUrl value="urn:uuid:b0147d44-21cb-4d03-92d7-698844b8238e" /> <resource> <PractitionerRole> <id value="b0147d44-21cb-4d03-92d7-698844b8238e" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-practitionerrole|1.0.0" /> </meta> <practitioner> <reference value="urn:uuid:c71f25a2-1dde-4191-a335-7a71105fada6" /> </practitioner> <specialty> <coding> <system value="http://snomed.info/sct" /> <code value="310161006" /> <display value="Orthopedic service" /> </coding> </specialty> </PractitionerRole> </resource> </entry> <entry> <fullUrl value="urn:uuid:25fc7cad-b076-4090-a803-d53b2039e28d" /> <resource> <Encounter> <id value="25fc7cad-b076-4090-a803-d53b2039e28d" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-Encounter|1.0.0" /> </meta> <status value="planned" /> <class> <system value="http://ontariohealth.ca/fhir/CodeSystem/encounter-class" /> <code value="sd" /> <display value="Same Day Admit" /> </class> <type> <coding> <system value="http://cihi.ca/fhir/CodeSystem/aac-admit-category" /> <code value="U" /> <display value="Urgent" /> </coding> </type> <priority> <coding> <system value="http://ontariohealth.ca/fhir/CodeSystem/surgical-priority-classification" /> <code value="P1A" /> <display value="Access within 0-2 hours" /> </coding> </priority> <subject> <reference value="urn:uuid:5350a3c4-109b-44db-a0b6-a59a28e0a19c" /> </subject> <appointment> <reference value="urn:uuid:29bdbf9d-2417-4604-b8ca-930dfacd32be" /> </appointment> <period> <start value="2023-04-15T10:00:00Z" /> </period> <reasonReference> <reference value="urn:uuid:58a07d6e-ffca-46d7-9e5f-846058ef344c" /> </reasonReference> </Encounter> </resource> </entry> <entry> <fullUrl value="urn:uuid:c71f25a2-1dde-4191-a335-7a71105fada6" /> <resource> <Practitioner> <id value="c71f25a2-1dde-4191-a335-7a71105fada6" /> <meta> <profile value="http://ontariohealth.ca/fhir/StructureDefinition/ca-on-seris-profile-Practitioner|1.0.0" /> </meta> <identifier> <system value="http://infoway-inforoute.ca/fhir/NamingSystem/ca-on-license-physician" /> <value value="111789" /> </identifier> <name> <text value="Akuada Kisu" /> <family value="Kisu" /> <given value="Akuada" /> </name> </Practitioner> </resource> </entry> </Bundle>