1b. Verdeelsleutel gedeclareerd bedrag per langdurige zorg sector

SPARQL query

Code gekopieerd
...
Kopieer naar klembord
1# Verdeelsleutel: 1b
2# Parameters: -
3# Ontologie: versie 2.0.0
4
5PREFIX onz-g: <http://purl.org/ozo/onz-g#>
6PREFIX onz-org: <http://purl.org/ozo/onz-org#>
7PREFIX onz-zorg: <http://purl.org/ozo/onz-zorg#>
8PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
9PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
10PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
11
12SELECT
13    (SUM(?ggzbAmount) / SUM(?amount) *100 as ?GGZB)
14    (SUM(?lgAmount) / SUM(?amount) *100 as ?LG)
15    (SUM(?lvgAmount) / SUM(?amount) *100 as ?LVG)
16    (SUM(?vgAmount) / SUM(?amount) *100 as ?VG)
17    (SUM(?zgaudAmount) / SUM(?amount) *100 as ?ZGAUD)
18    (SUM(?zgvisAmount) / SUM(?amount) *100 as ?ZGVIS)
19    (SUM(?vvAmount) / SUM(?amount) *100 as ?VV)
20    
21WHERE {
22    BIND("2022-01-01"^^xsd:date AS ?start_periode)
23    BIND("2022-12-01"^^xsd:date AS ?eind_periode)
24    ?declaratie
25        a onz-g:CareInvoice ;
26        onz-g:hasDate ?date ;
27        onz-g:isAbout [
28            a onz-g:FinancialEntity ;
29            onz-g:hasQuality [onz-g:hasQualityValue [onz-g:hasDataValue ?amount]]
30        ] ;
31    onz-g:isAbout ?zorgproces .
32    FILTER(?start_periode <= ?date && ?date <= ?eind_periode)
33    
34    ?zorgproces
35        a onz-zorg:NursingProcess ;
36        onz-g:definedBy ?indicatie .
37    ?indicatie
38        a onz-zorg:WlzIndicatie ;
39        onz-g:hasPart/onz-g:isAbout ?sector .
40
41    #Per financieringsstroom
42    BIND(IF(?sector = onz-zorg:GGZ-B, ?amount, 0) AS ?ggzbAmount)
43    BIND(IF(?sector = onz-zorg:LG, ?amount, 0) AS ?lgAmount)
44    BIND(IF(?sector = onz-zorg:LVG, ?amount, 0) AS ?lvgAmount)
45    BIND(IF(?sector = onz-zorg:VG, ?amount, 0) AS ?vgAmount)
46    BIND(IF(?sector = onz-zorg:ZGAUD, ?amount, 0) AS ?zgaudAmount)
47    BIND(IF(?sector = onz-zorg:ZGVIS, ?amount, 0) AS ?zgvisAmount)
48    BIND(IF(?sector = onz-zorg:VV, ?amount, 0) AS ?vvAmount)
49  
50} GROUP BY ?sector