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="0022F68B-F981-4D7F-8446-4BD754B824EA" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/eReferralBundle|1.0.0" /> </meta> <type value="message" /> <timestamp value="2020-10-09T15:21:51.2112Z" /> <entry> <fullUrl value="urn:uuid:2329ebe3-747c-4cf8-8549-31b2d45d4f3d" /> <resource> <MessageHeader> <id value="6cf3735f-c8c5-4c1d-b3a1-01e861611cf8" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-MessageHeader|1.0.1" /> </meta> <eventCoding> <system value="https://ehealthontario.ca/fhir/CodeSystem/message-event-code" /> <code value="notify-add-process-request" /> </eventCoding> <destination> <name value="RMS Source" /> <endpoint value="http://rmssource.org/fhir/$process-message" /> </destination> <author> <reference value="urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8" /> <display value="April May" /> </author> <source> <name value="RMS Target" /> <software value="Software" /> <version value="1.1.0" /> <contact> <system value="email" /> <value value="tech.support@rmstarget.org" /> <rank value="1" /> </contact> <endpoint value="http://rmstarget.org/fhir/$process-message" /> </source> <reason> <text value="Referral request accepted and is in progress" /> </reason> <response> <identifier value="4783C82C-683E-491D-B834-3D1B8931BDD9" /> <code value="ok" /> </response> <focus> <reference value="urn:uuid:4f1d3ed6-0d64-11ed-861d-0242ac120002" /> </focus> </MessageHeader> </resource> </entry> <entry> <fullUrl value="urn:uuid:4f1d3ed6-0d64-11ed-861d-0242ac120002" /> <resource> <Task> <id value="4f1d3ed6-0d64-11ed-861d-0242ac120002" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Task|1.0.1" /> </meta> <basedOn> <reference value="urn:uuid:05ed7277-bd41-44ee-b017-9502c3511844" /> </basedOn> <status value="ready" /> <businessStatus> <coding> <system value="https://ehealthontario.ca/fhir/CodeSystem/task-business-status" /> <code value="NW" /> <display value="New" /> </coding> <text value="New" /> </businessStatus> <intent value="proposal" /> <code> <coding> <system value="https://ehealthontario.ca/fhir/CodeSystem/task-code" /> <code value="process-request" /> </coding> <text value="Process Request" /> </code> <authoredOn value="2020-10-09T18:40:36Z" /> <lastModified value="2020-10-09T18:40:36Z" /> </Task> </resource> </entry> <entry> <fullUrl value="urn:uuid:ea5ec3dc-5c09-41f7-aaa6-d3c8f71c0792" /> <resource> <ServiceRequest> <id value="05ed7277-bd41-44ee-b017-9502c3511844" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-ServiceRequest|1.0.1" /> </meta> <extension url="http://ehealthontario.ca/fhir/StructureDefinition/ext-routing-options"> <valueCodeableConcept> <coding> <system value="http://ehealthontario.ca/fhir/CodeSystem/ereferral-source-types" /> <code value="DR" /> <display value="Referral Source Type - Primary Care Provider" /> </coding> </valueCodeableConcept> </extension> <identifier> <system value="http://www.rmssource.org/identifiers/ServiceRequest" /> <value value="request-for-assessment" /> </identifier> <status value="active" /> <intent value="proposal" /> <category> <coding> <system value="http://snomed.info/sct" /> <code value="424008009" /> <display value="Nursing care surveillance" /> </coding> </category> <priority value="routine" /> <code> <coding> <system value="http://snomed.info/sct" /> <code value="105385000" /> <display value="Full-time nursing care at home by private nurse" /> </coding> </code> <subject> <reference value="urn:uuid:7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b" /> </subject> <authoredOn value="2020-10-09" /> <requester> <reference value="urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8" /> <display value="Dr Jack Jones" /> </requester> <performer> <reference value="http://rmstarget.org/fhir/HealthcareService/16770" /> </performer> <supportingInfo> <reference value="urn:uuid:9cea3cb8-d24f-4be2-acbf-dbc6c3801493" /> <display value="Referral Form" /> </supportingInfo> </ServiceRequest> </resource> </entry> <entry> <fullUrl value="urn:uuid:77837fc9-6dab-4d6c-84cd-d4bfb97dc811" /> <resource> <Patient> <id value="7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Patient|1.0.1" /> </meta> <identifier> <extension url="http://ehealthontario.ca/fhir/StructureDefinition/ext-id-health-card-version-code"> <valueString value="EX" /> </extension> <use value="official" /> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="JHN" /> </coding> <text value="Ontario, Canada Personal Health Number" /> </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> <text value="The Hospital" /> </type> <system value="http://ehealthontario.ca/fhir/NamingSystem/id-example1-uri" /> <value value="ABC12345" /> </identifier> <active value="true" /> <name> <family value="Doe" /> <given value="Jane" /> </name> <telecom> <system value="phone" /> <value value="1 (555) 867 5309" /> <rank value="1" /> </telecom> <telecom> <system value="email" /> <value value="janedoe@example.com" /> <rank value="2" /> </telecom> <gender value="female" /> <birthDate value="1951-02-19" /> <deceasedBoolean value="false" /> <address> <use value="home" /> <type value="physical" /> <line value="123 Any Street" /> <city value="Waterloo" /> <state value="ON" /> <postalCode value="N2L 3G1" /> </address> <contact> <relationship> <coding> <system value="http://ehealthontario.ca/fhir/CodeSystem/patient-contact-relationship" /> <code value="EC" /> <display value="Emergency Contact" /> </coding> <text value="Emergency Contact" /> </relationship> <name> <family value="McContact" /> <given value="David" /> </name> <telecom> <system value="phone" /> <value value="(555) 555 1212" /> <rank value="1" /> </telecom> <address> <line value="50 Another St." /> <line value="Unit 2" /> <city value="Waterloo" /> <state value="ON" /> <postalCode value="N2L 3G2" /> </address> </contact> <communication> <language> <coding> <system value="urn:ietf:bcp:47" /> <code value="en" /> <display value="English" /> </coding> <text value="english" /> </language> </communication> <generalPractitioner> <reference value="urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8" /> </generalPractitioner> </Patient> </resource> </entry> <entry> <fullUrl value="urn:uuid:c708db26-16b1-4470-9e23-2a6bcd2e7be6" /> <resource> <PractitionerRole> <id value="86fa8373-34c8-440d-9e8f-832c1a571da8" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-PractitionerRole|1.0.0" /> </meta> <identifier> <use value="official" /> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="RRI" /> </coding> </type> <system value="http://ehealthontario.ca/fhir/NamingSystem/id-ppr-epid" /> <value value="56442" /> </identifier> <active value="true" /> <practitioner> <reference value="urn:uuid:8b9f61af-55ce-4ade-9987-f40fe54cc79e" /> <display value="Dr Jack Jones" /> </practitioner> <organization> <reference value="urn:uuid:334ec4c8-7932-4620-86fe-d6b33b3fc7e4" /> <display value="Primary Care Medical Clinics" /> </organization> <code> <coding> <system value="http://terminology.hl7.org/CodeSystem/practitioner-role" /> <code value="doctor" /> <display value="Doctor" /> </coding> </code> <specialty> <coding> <system value="https://fhir.infoway-inforoute.ca/CodeSystem/snomedctcaextension" /> <code value="394802001" /> <display value="General medicine" /> </coding> </specialty> <location> <reference value="urn:uuid:25470f9e-0092-4997-af53-aa3ef0f50879" /> <display value="279 Yonge St, Barrie, ON L4N 7T9" /> </location> <telecom> <system value="phone" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="1" /> </telecom> <telecom> <system value="fax" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="3" /> </telecom> <telecom> <system value="email" /> <value value="jack.jones@example.org" /> <use value="work" /> <rank value="2" /> </telecom> </PractitionerRole> </resource> </entry> <entry> <fullUrl value="urn:uuid:3832fed2-c181-4cb4-af46-f4a71e78487b" /> <resource> <Practitioner> <id value="8b9f61af-55ce-4ade-9987-f40fe54cc79e" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Practitioner|1.0.0" /> </meta> <identifier> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/v2-0203" /> <code value="LN" /> </coding> <text value="Ontario Medical License Number" /> </type> <system value="http://infoway-inforoute.ca/fhir/NamingSystem/ca-on-license-physician" /> <value value="111789" /> </identifier> <name> <use value="official" /> <family value="Jones" /> <given value="Jack" /> </name> <telecom> <system value="phone" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="1" /> </telecom> <telecom> <system value="fax" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="1" /> </telecom> <address> <use value="work" /> <type value="physical" /> <line value="279 Yonge St" /> <city value="Barrie" /> <state value="ON" /> <postalCode value="M5B 1N8" /> <country value="CAN" /> </address> <gender value="male" /> <birthDate value="1979-02-26" /> <qualification> <code> <coding> <system value="https://fhir.infoway-inforoute.ca/CodeSystem/scptype" /> <code value="MD" /> </coding> </code> </qualification> <communication> <coding> <system value="urn:ietf:bcp:47" /> <code value="en" /> <display value="English" /> </coding> <text value="English" /> </communication> </Practitioner> </resource> </entry> <entry> <fullUrl value="urn:uuid:8b3b08f0-9252-4108-be4c-a48b9f4ab3fe" /> <resource> <Organization> <id value="334ec4c8-7932-4620-86fe-d6b33b3fc7e4" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Organization|1.0.0" /> </meta> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/organization-type" /> <code value="prov" /> <display value="Healthcare Provider" /> </coding> </type> <name value="Primary Care Medical Clinics" /> <telecom> <system value="phone" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="1" /> </telecom> <telecom> <system value="fax" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="1" /> </telecom> <address> <use value="work" /> <type value="physical" /> <line value="279 Yonge St" /> <city value="Barrie" /> <state value="ON" /> <postalCode value="M5B 1N8" /> <country value="CAN" /> </address> </Organization> </resource> </entry> <entry> <fullUrl value="urn:uuid:ed530846-ea05-48d3-b005-070de7ae8a6f" /> <resource> <Location> <id value="25470f9e-0092-4997-af53-aa3ef0f50879" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Location|1.0.1" /> </meta> <name value="Yonge Street Medical Office" /> <address> <type value="physical" /> <line value="279 Yonge St" /> <city value="Barrie" /> <state value="ON" /> <postalCode value="M5B 1N8" /> <country value="CAN" /> </address> <position> <longitude value="-79.38248" /> <latitude value="43.6556497" /> </position> </Location> </resource> </entry> <entry> <fullUrl value="urn:uuid:c670c15f-c55c-41fd-9682-c467915576f6" /> <resource> <PractitionerRole> <id value="86fa8373-34c8-440d-9e8f-832c1a571da8" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-PractitionerRole|1.0.0" /> </meta> <active value="true" /> <practitioner> <reference value="urn:uuid:8b9f61af-55ce-4ade-9987-f40fe54cc79e" /> <display value="April May" /> </practitioner> <organization> <reference value="urn:uuid:334ec4c8-7932-4620-86fe-d6b33b3fc7e4" /> <display value="South East LHIN" /> </organization> <telecom> <system value="phone" /> <value value="(555) 987-1234" /> <use value="work" /> <rank value="1" /> </telecom> <telecom> <system value="email" /> <value value="april.may@example.org" /> <use value="work" /> <rank value="2" /> </telecom> </PractitionerRole> </resource> </entry> <entry> <fullUrl value="urn:uuid:e602a738-b17e-4f11-8686-2b12c01988f2" /> <resource> <Practitioner> <id value="8b9f61af-55ce-4ade-9987-f40fe54cc79e" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Practitioner|1.0.0" /> </meta> <name> <use value="official" /> <family value="May" /> <given value="April" /> </name> </Practitioner> </resource> </entry> <entry> <fullUrl value="urn:uuid:c6187618-b90a-45ec-855a-399db10b52bd" /> <resource> <Organization> <id value="334ec4c8-7932-4620-86fe-d6b33b3fc7e4" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Organization|1.0.0" /> </meta> <identifier> <use value="official" /> <system value="https://fhir.infoway-inforoute.ca/NamingSystem/ca-on-health-care-facility-id" /> <value value="4664" /> </identifier> <active value="true" /> <type> <coding> <system value="http://terminology.hl7.org/CodeSystem/organization-type" /> <code value="prov" /> <display value="Healthcare Provider" /> </coding> </type> <name value="South East LHIN" /> <telecom> <system value="phone" /> <value value="(613) 544 7090" /> <use value="work" /> <rank value="1" /> </telecom> <address> <use value="work" /> <type value="postal" /> <line value="1471 John Counter Blvd" /> <line value="Suite 200" /> <city value="Kingston" /> <state value="ON" /> <postalCode value="K7M 8S8" /> <country value="CAN" /> </address> <contact> <purpose> <coding> <system value="http://terminology.hl7.org/CodeSystem/contactentity-type" /> <code value="PATINF" /> <display value="Patient" /> </coding> </purpose> <name> <use value="official" /> <family value="Person" /> <given value="Fake" /> <given value="Contact" /> </name> <telecom> <system value="phone" /> <value value="(613) 544 7090" /> <use value="work" /> <rank value="1" /> </telecom> <address> <use value="work" /> <type value="postal" /> <line value="120 Yonge St" /> <city value="Barrie" /> <district value="Rainbow" /> <state value="ON" /> <postalCode value="L2W 3R4" /> <country value="CAN" /> </address> </contact> </Organization> </resource> </entry> <entry> <fullUrl value="urn:uuid:9cea3cb8-d24f-4be2-acbf-dbc6c3801493" /> <resource> <QuestionnaireResponse> <id value="9cea3cb8-d24f-4be2-acbf-dbc6c3801493" /> <meta> <profile value="http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-QuestionnaireResponse|1.0.0" /> </meta> <identifier> <system value="http://www.rmssource.org/identifiers/questionnaire-ids" /> <value value="9cea3cb8-d24f-4be2-acbf-dbc6c3801493" /> </identifier> <status value="completed" /> <subject> <reference value="urn:uuid:7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b" /> </subject> <authored value="2020-10-09" /> <author> <reference value="urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8" /> </author> <item> <linkId value="1" /> <text value="Section 1 Header" /> <item> <linkId value="1.1" /> <text value="String Question in Section 1" /> <answer> <valueString value="String Answer" /> </answer> </item> <item> <linkId value="1.2" /> <text value="Boolean Question in Section 1" /> <answer> <valueBoolean value="true" /> </answer> </item> <item> <linkId value="1.3" /> <text value="Number Question in Section 1" /> <answer> <valueInteger value="365" /> </answer> </item> <item> <linkId value="1.4" /> <text value="Decimal question in Section 1" /> <answer> <valueDecimal value="364.9" /> </answer> </item> <item> <linkId value="1.5" /> <text value="DateTime Question in Section 2" /> <answer> <valueDateTime value="2021-05-07T13:28:17Z" /> </answer> </item> </item> <item> <linkId value="2" /> <text value="Section 2 Header" /> <item> <linkId value="2.1" /> <text value="Integer Question in Section 2" /> <answer> <valueInteger value="365" /> </answer> </item> <item> <linkId value="2.2" /> <text value="Multi-Select Question in Section 2" /> <answer> <valueString value="tag1" /> </answer> <answer> <valueString value="tag2" /> </answer> <answer> <valueString value="tag3" /> </answer> </item> <item> <linkId value="2.3" /> <text value="Date Question in Section 2" /> <answer> <valueDate value="2019-09-05" /> </answer> </item> <item> <linkId value="2.4" /> <text value="Time Question in Section 2" /> <answer> <valueTime value="12:34:56" /> </answer> </item> </item> <item> <linkId value="3" /> <text value="CONDITIONAL Section 3 with Question" /> <answer> <valueBoolean value="true" /> <item> <linkId value="3.1" /> <text value="Conditional Question 1:" /> <answer> <valueString value="ConditionalAnswer1" /> </answer> </item> <item> <linkId value="3.2" /> <text value="Conditional Question 2:" /> <answer> <valueString value="ConditionalAnswer2" /> </answer> </item> </answer> </item> </QuestionnaireResponse> </resource> </entry> </Bundle>