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.
{ "resourceType": "Bundle", "id": "b2546868-bc6e-4517-943c-14f014979081", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/eReferralBundle|1.0.0" ] }, "type": "message", "timestamp": "01/12/2023 15:21:51", "entry": [ { "fullUrl": "urn:uuid:6cf3735f-c8c5-4c1d-b3a1-01e861611cf8", "resource": { "resourceType": "MessageHeader", "id": "6cf3735f-c8c5-4c1d-b3a1-01e861611cf8", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-MessageHeader|1.0.1" ] }, "eventCoding": { "system": "https://ehealthontario.ca/fhir/CodeSystem/message-event-code", "code": "notify-report-service-request" }, "destination": [ { "name": "RMS Source", "endpoint": "http://rmssource.org/fhir/$process-message" } ], "author": { "reference": "urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8", "display": "April May" }, "source": { "name": "RMS Target", "software": "Software", "version": "1.1.0", "contact": { "system": "email", "value": "tech.support@rmstarget.org", "rank": 1 }, "endpoint": "http://rmstarget.org/fhir/$process-message" }, "reason": { "text": "DEMOGRAPHICS_UPDATED" }, "response": { "identifier": "4783c82c-683e-491d-b834-3d1b8931bdd9", "code": "ok" }, "focus": [ { "reference": "urn:uuid:7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b" } ] } }, { "fullUrl": "urn:uuid:05ed7277-bd41-44ee-b017-9502c3511844", "resource": { "resourceType": "ServiceRequest", "id": "05ed7277-bd41-44ee-b017-9502c3511844", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-ServiceRequest|1.0.1" ], "security": [ { "system": "http://terminology.hl7.org/CodeSystem/v3-ObservationValue", "code": "REDACTED", "display": "redacted" } ] }, "identifier": [ { "system": "http://www.rmssource.org/identifiers/ServiceRequest", "value": "request-for-assessment" } ], "status": "active", "intent": "proposal", "category": [ { "coding": [ { "system": "http://snomed.info/sct", "code": "424008009", "display": "Nursing care surveillance" } ] } ], "priority": "routine", "code": { "coding": [ { "system": "http://snomed.info/sct", "code": "105385000", "display": "Full-time nursing care at home by private nurse" } ] }, "orderDetail": [ { "coding": [ { "system": "http://snomed.info/sct", "code": "243150007", "display": "Assisted controlled mandatory ventilation (procedure)" } ] } ], "subject": { "reference": "urn:uuid:7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b" }, "authoredOn": "2020-10-09", "requester": { "reference": "urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8", "display": "Dr Jack Jones" }, "performer": [ { "reference": "urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8" } ] } }, { "fullUrl": "urn:uuid:4f1d3ed6-0d64-11ed-861d-0242ac120002", "resource": { "resourceType": "Task", "id": "4f1d3ed6-0d64-11ed-861d-0242ac120002", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Task|1.0.1" ] }, "basedOn": [ { "reference": "urn:uuid:05ed7277-bd41-44ee-b017-9502c3511844" } ], "status": "accepted", "businessStatus": { "coding": [ { "system": "https://ehealthontario.ca/fhir/CodeSystem/task-business-status", "code": "BOK", "display": "Booked" } ], "text": "Booked" }, "intent": "proposal", "code": { "coding": [ { "system": "https://ehealthontario.ca/fhir/CodeSystem/task-code", "code": "manage-request" } ], "text": "Process Request" }, "authoredOn": "10/09/2020 18:40:36", "lastModified": "10/09/2020 18:40:36" } }, { "fullUrl": "urn:uuid:7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b", "resource": { "resourceType": "Patient", "id": "7f7ad826-f47b-4c18-9d4a-bd3d0988ad3b", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Patient|1.0.1" ], "security": [ { "system": "http://terminology.hl7.org/CodeSystem/v3-ObservationValue", "code": "REDACTED", "display": "redacted" } ] }, "identifier": [ { "extension": [ { "url": "http://ehealthontario.ca/fhir/StructureDefinition/ext-id-health-card-version-code", "valueString": "EX" } ], "use": "official", "type": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v2-0203", "code": "JHN" } ], "text": "Ontario, Canada Personal Health Number" }, "system": "https://fhir.infoway-inforoute.ca/NamingSystem/ca-on-patient-hcn", "value": "1234567890" }, { "type": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v2-0203", "code": "MR" } ], "text": "The Hospital" }, "system": "http://ehealthontario.ca/fhir/NamingSystem/id-example1-uri", "value": "ABC12345" } ], "active": true, "name": [ { "family": "Doe", "given": [ "Jane" ] } ], "gender": "female", "birthDate": "1951-02-19", "deceasedBoolean": false, "address": [ { "use": "home", "type": "physical", "line": [ "123 Any Street" ], "city": "Waterloo", "state": "ON", "postalCode": "N2L 3G1" } ] } }, { "fullUrl": "urn:uuid:86fa8373-34c8-440d-9e8f-832c1a571da8", "resource": { "resourceType": "PractitionerRole", "id": "86fa8373-34c8-440d-9e8f-832c1a571da8", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-PractitionerRole|1.0.0" ] }, "identifier": [ { "use": "official", "type": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v2-0203", "code": "RRI" } ] }, "system": "http://ehealthontario.ca/fhir/NamingSystem/id-ppr-epid", "value": "56442" } ], "active": true, "practitioner": { "reference": "urn:uuid:8b9f61af-55ce-4ade-9987-f40fe54cc79e", "display": "Dr Jack Jones" }, "organization": { "reference": "urn:uuid:334ec4c8-7932-4620-86fe-d6b33b3fc7e4", "display": "Primary Care Medical Clinics" }, "code": [ { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/practitioner-role", "code": "doctor", "display": "Doctor" } ] } ], "specialty": [ { "coding": [ { "system": "https://fhir.infoway-inforoute.ca/CodeSystem/snomedctcaextension", "code": "394802001", "display": "General medicine" } ] } ], "location": [ { "reference": "urn:uuid:25470f9e-0092-4997-af53-aa3ef0f50879", "display": "279 Yonge St, Barrie, ON L4N 7T9" } ], "telecom": [ { "system": "phone", "value": "(555) 987-1234", "use": "work", "rank": 1 }, { "system": "fax", "value": "(555) 987-1234", "use": "work", "rank": 3 }, { "system": "email", "value": "jack.jones@example.org", "use": "work", "rank": 2 } ] } }, { "fullUrl": "urn:uuid:8b9f61af-55ce-4ade-9987-f40fe54cc79e", "resource": { "resourceType": "Practitioner", "id": "8b9f61af-55ce-4ade-9987-f40fe54cc79e", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Practitioner|1.0.0" ] }, "identifier": [ { "type": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/v2-0203", "code": "LN" } ], "text": "Ontario Medical License Number" }, "system": "http://infoway-inforoute.ca/fhir/NamingSystem/ca-on-license-physician", "value": "111789" } ], "name": [ { "use": "official", "family": "Jones", "given": [ "Jack" ] } ], "telecom": [ { "system": "phone", "value": "(555) 987-1234", "use": "work", "rank": 1 }, { "system": "fax", "value": "(555) 987-1234", "use": "work", "rank": 1 } ], "address": [ { "use": "work", "type": "physical", "line": [ "279 Yonge St" ], "city": "Barrie", "state": "ON", "postalCode": "M5B 1N8", "country": "CAN" } ], "gender": "male", "birthDate": "1979-02-26", "qualification": [ { "code": { "coding": [ { "system": "https://fhir.infoway-inforoute.ca/CodeSystem/scptype", "code": "MD" } ] } } ], "communication": [ { "coding": [ { "system": "urn:ietf:bcp:47", "code": "en", "display": "English" } ], "text": "English" } ] } }, { "fullUrl": "urn:uuid:25470f9e-0092-4997-af53-aa3ef0f50879", "resource": { "resourceType": "Location", "id": "25470f9e-0092-4997-af53-aa3ef0f50879", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Location|1.0.1" ] }, "name": "Yonge Street Medical Office", "address": { "type": "physical", "line": [ "279 Yonge St" ], "city": "Barrie", "state": "ON", "postalCode": "M5B 1N8", "country": "CAN" }, "position": { "longitude": -79.38248, "latitude": 43.6556497 } } }, { "fullUrl": "urn:uuid:334ec4c8-7932-4620-86fe-d6b33b3fc7e4", "resource": { "resourceType": "Organization", "id": "334ec4c8-7932-4620-86fe-d6b33b3fc7e4", "meta": { "profile": [ "http://ehealthontario.ca/fhir/StructureDefinition/ca-on-eReferral-profile-Organization|1.0.0" ] }, "identifier": [ { "use": "official", "system": "https://fhir.infoway-inforoute.ca/NamingSystem/ca-on-health-care-facility-id", "value": "4664" } ], "active": true, "type": [ { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/organization-type", "code": "prov", "display": "Healthcare Provider" } ] } ], "name": "South East LHIN", "telecom": [ { "system": "phone", "value": "(613) 544 7090", "use": "work", "rank": 1 } ], "address": [ { "use": "work", "type": "postal", "line": [ "1471 John Counter Blvd", "Suite 200" ], "city": "Kingston", "state": "ON", "postalCode": "K7M 8S8", "country": "CAN" } ], "contact": [ { "purpose": { "coding": [ { "system": "http://terminology.hl7.org/CodeSystem/contactentity-type", "code": "PATINF", "display": "Patient" } ] }, "name": { "use": "official", "family": "Person", "given": [ "Fake", "Contact" ] }, "telecom": [ { "system": "phone", "value": "(613) 544 7090", "use": "work", "rank": 1 } ], "address": { "use": "work", "type": "postal", "line": [ "120 Yonge St" ], "city": "Barrie", "district": "Rainbow", "state": "ON", "postalCode": "L2W 3R4", "country": "CAN" } } ] } } ] }