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