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": "Provenance", "meta": { "profile": [ "https://pta.kanta.fi/fhir/StructureDefinition/AppointmentProvenance" ] }, "contained": [ { "resourceType": "Patient", "id": "PAT1", "meta": { "profile": [ "https://pta.kanta.fi/fhir/StructureDefinition/AppointmentPatient" ] }, "identifier": [ { "use": "official", "system": "urn:oid:1.2.246.21", "value": "300111A9001" }, { "use": "old", "system": "urn:oid:1.2.246.10.12345678.22.2023", "value": "1122" } ], "name": [ { "use": "official", "family": "Koski", "given": [ "Iida", "Maria" ] } ], "birthDate": "2011-01-30" }, { "id": "PRACTITIONER1", "resourceType": "Practitioner", "meta": { "profile": [ "https://pta.kanta.fi/fhir/StructureDefinition/AppointmentPractitioner" ] }, "identifier": [ { "system": "urn:oid:1.2.246.537.26", "value": "032763" } ], "name": [ { "use": "official", "family": "Seppä", "given": [ "Aili", "Sini" ] } ] }, { "resourceType": "Device", "id": "DEVICE1", "meta": { "profile": [ "https://gen.kanta.fi/fhir/StructureDefinition/KantaDevice" ] }, "identifier": [ { "system": "urn:oid:1.2.246.537.6.12.999.2003.34", "value": "345675" } ], "deviceName": [ { "name": "Tietojärjestelmän nimi Valviran tietojärjestelmärekisterin sosiaali- ja terveydenhuollon tietojärjestelmistä mukaan", "type": "other" } ], "version": [ { "value": "Versio xyz" } ] } ], "language": "fi", "target": [ { "reference": "urn:uuid:ce5ea340-adfd-40f2-87d4-a25e4f8bf143", "display": "Ajanvaraus" } ], "recorded": "05/10/2023 09:02:00", "agent": [ { "role": [ { "coding": [ { "system": "http://gen.kanta.fi/figen-cs-provenancerolecategory", "code": "3", "display": "Asiakas tai potilas, jota resurssi koskee" } ] } ], "who": { "reference": "#PAT1" } }, { "role": [ { "coding": [ { "system": "http://gen.kanta.fi/figen-cs-provenancerolecategory", "code": "2", "display": "Resurssin tallentanut ammattihenkilö" } ] } ], "who": { "reference": "#PRACTITIONER1" } }, { "role": [ { "coding": [ { "system": "http://gen.kanta.fi/figen-cs-provenancerolecategory", "code": "7", "display": "Resurssin tallentaneen ammattihenkilön palveluyksikkö" } ] } ], "who": { "identifier": { "system": "urn:ietf:rfc:3986", "value": "urn:oid:1.2.246.10.99999773.10.20.1014" }, "display": "Asiakaspalvelu, Kirkonkylän sosiaali- ja terveystoimi" } }, { "role": [ { "coding": [ { "system": "http://gen.kanta.fi/figen-cs-provenancerolecategory", "code": "1", "display": "Resurssin rekisterinpitäjä" } ] } ], "who": { "identifier": { "system": "urn:ietf:rfc:3986", "value": "urn:oid:1.2.246.10.99999773.19.0" }, "display": "Hämeen hyvinvointialueen rekisterinpitäjä" } }, { "role": [ { "coding": [ { "system": "http://gen.kanta.fi/figen-cs-provenancerolecategory", "code": "13", "display": "Resurssin tuottanut palveluntuottaja" } ] } ], "who": { "identifier": { "system": "urn:ietf:rfc:3986", "value": "urn:oid:1.2.246.10.99999773.10.0" }, "display": "Hämeen hyvinvointialue" } }, { "role": [ { "coding": [ { "system": "http://gen.kanta.fi/figen-cs-provenancerolecategory", "code": "10", "display": "Palvelunjärjestäjä" } ] } ], "who": { "identifier": { "system": "urn:ietf:rfc:3986", "value": "urn:oid:1.2.246.10.99999773.10.0" }, "display": "Hämeen hyvinvointialue" } }, { "role": [ { "coding": [ { "system": "http://gen.kanta.fi/figen-cs-provenancerolecategory", "code": "4", "display": "Resurssin tuottanut tietojärjestelmä" } ] } ], "who": { "reference": "#DEVICE1" } } ], "extension": [ { "url": "https://pta.kanta.fi/fhir/StructureDefinition/extension/ReleaseDateForPatientViewing", "valueDate": "2023-06-30" }, { "url": "https://gen.kanta.fi/fhir/StructureDefinition/extension/serviceEvent", "valueIdentifier": { "system": "urn:ietf:rfc:3986", "value": "urn:oid:1.2.246.10.99999773.14.2024.123" } }, { "url": "https://gen.kanta.fi/fhir/StructureDefinition/extension/Status", "valueCoding": { "system": "urn:oid:1.2.246.537.5.40154.2008", "code": "3", "display": "Arkistointivalmis" } }, { "url": "https://pta.kanta.fi/fhir/StructureDefinition/extension/TableOfContents", "valueCoding": { "system": "urn:oid:1.2.246.537.6.12.2002", "code": "70", "display": "Psykiatria" } }, { "url": "https://gen.kanta.fi/fhir/StructureDefinition/extension/RegisterType", "valueCoding": { "system": "urn:oid:1.2.246.537.5.40150.2009", "code": "2", "display": "Julkinen terveydenhuolto" } } ] }