Uitwisselprofiel IGJ Contextinformatie t.b.v. onaangekondigd inspectiebezoek
1.1.3 Wat is het aantal cliënten met een Zvw-indicatie met ELV, GRZ en overig?
Concepten
Relaties
Eigenschappen
SPARQL query
Code gekopieerd
...Kopieer naar klembord
1# Indicator: IGJ 1.1.3 2# Parameters: ?vestigingsnummer, ?peildatum 3# Ontologie: versie 3.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 onz-fin: <http://purl.org/ozo/onz-fin#> 9PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> 10PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 11 12 13SELECT 14 (SUM(?max_elv) AS ?Aantal_clienten_ELV) 15 (SUM(?max_grz) AS ?Aantal_clienten_GRZ) 16 (SUM(?max_overig) AS ?Aantal_clienten_met_een_Zvw_indicatie_overig) 17 (COUNT(DISTINCT ?client) AS ?Totaal_aantal_unieke_clienten) 18 19{ 20 { 21 SELECT 22 ?client 23 (MAX(?is_elv) AS ?max_elv) 24 (MAX(?is_grz) AS ?max_grz) 25 (MAX(?is_zvw_overig) AS ?max_overig) 26 { 27# BIND($(vestigingsnummer) AS ?vestigingsnummer) 28# BIND($(peildatum) AS ?peildatum) 29 BIND(?peildatum AS ?peildatum_argument) 30 31 # Nieuwe vestigingsnummer triple 32 ?vestiging 33 a onz-org:Vestiging ; 34 onz-g:identifiedBy ?vestigingsnummer_object . 35 ?vestigingsnummer_object 36 a onz-org:Vestigingsnummer ; 37 onz-g:hasDataValue ?vestigingsnummer . 38 39 ?zorgproces 40 a onz-g:CureAndCareProcess ; 41 onz-g:startDatum ?start_zorgproces ; 42 onz-g:hasPerdurantLocation/onz-g:partOf* ?vestiging ; 43 . 44 OPTIONAL {?zorgproces onz-g:eindDatum ?eind_zorgproces} 45 FILTER(?peildatum_argument >= ?start_zorgproces && (?peildatum_argument <= ?eind_zorgproces || !BOUND(?eind_zorgproces))) 46 #FILTER(?peildatum >= ?start_zorgproces && (?peildatum <= ?eind_zorgproces || !BOUND(?eind_zorgproces))) 47 48 ?client 49 a onz-g:Human . 50 ?indicatie 51 a onz-zorg:ZvwIndicatie ; 52 onz-g:startDatum ?start_indicatie ; 53 onz-g:isAbout ?client ; 54 onz-g:isAbout ?zorgproces ; 55 . 56 OPTIONAL {?indicatie onz-g:eindDatum ?eind_indicatie} 57 FILTER(?peildatum_argument >= ?start_indicatie && (?peildatum_argument <= ?eind_indicatie || !BOUND(?eind_indicatie))) 58 #FILTER(?peildatum >= ?start_indicatie && (?peildatum <= ?eind_indicatie || !BOUND(?eind_indicatie))) 59 60 OPTIONAL { 61 ?declaratie 62 a onz-g:CareInvoice ; 63 onz-g:goedgekeurd "true"^^xsd:boolean ; 64 onz-fin:heeftZorgPrestatieCode|onz-fin:heeftZorgProductCode ?zorg_id_code ; 65 onz-g:isAbout ?zorgproces ; 66 . 67 } 68 69 70 BIND(IF(!BOUND(?declaratie) || !BOUND(?zorg_id_code), 0, 71 IF(?zorg_id_code in # ELV prestatiecodes 72 ( 73 "1001", 74 "1002", 75 "1003", 76 "A0001", 77 "A0002", 78 "A0003", 79 "A0004", 80 "A0005", 81 "A0006", 82 "A0007", 83 "A0008", 84 "A0009", 85 "A0010", 86 "A0011", 87 "A0012", 88 "A0013", 89 "A0014", 90 "A0015", 91 "A0016", 92 "A0017", 93 "A0018", 94 "A0019", 95 "A0020", 96 "A0021", 97 "A0022", 98 "A0023", 99 "A0024" 100 ), 101 1, 0) 102 ) 103 AS ?is_elv) 104 105 BIND(IF(!BOUND(?declaratie) || !BOUND(?zorg_id_code), 0, 106 IF(?zorg_id_code in # GRZ productcodes 107 ( 108 "972800066", 109 "972800067", 110 "972800068", 111 "972800069", 112 "972802071", 113 "972802076", 114 "972802077", 115 "972802078", 116 "972802079", 117 "972802081", 118 "972802082", 119 "972802083", 120 "972802084", 121 "972802085", 122 "972802086", 123 "972802088", 124 "972802089", 125 "972802090", 126 "972802091", 127 "972802092", 128 "972802093", 129 "972802094", 130 "972802095", 131 "972802097", 132 "972802098", 133 "972802099", 134 "972802100", 135 "972802101", 136 "972802102", 137 "972802103", 138 "972802104", 139 "972802106", 140 "972802107", 141 "972802108", 142 "972802109", 143 "972802110", 144 "972802111", 145 "972802112", 146 "972802113", 147 "972802115", 148 "972802116", 149 "972802117", 150 "972802118", 151 "972802119", 152 "972802121", 153 "972802123", 154 "972802124", 155 "972802125", 156 "972802126", 157 "972802127", 158 "972802128", 159 "972804004", 160 "972804005", 161 "972804006", 162 "972804007", 163 "972804008", 164 "972804009", 165 "972804010", 166 "972804011", 167 "972804015", 168 "972804016", 169 "972804018", 170 "972804020", 171 "972804021", 172 "972804022", 173 "972804023", 174 "972804024", 175 "972804025", 176 "972804026", 177 "972804029", 178 "972804030", 179 "972804031", 180 "972804032", 181 "972804034", 182 "972804035", 183 "972804036", 184 "972804038", 185 "972804039", 186 "972804040", 187 "972804041", 188 "979001127", 189 "979001128", 190 "979001129", 191 "979001130", 192 "979001132", 193 "979001133", 194 "979001134", 195 "979001135", 196 "979001136", 197 "979001138", 198 "979001139", 199 "979001140", 200 "979001141", 201 "979001142", 202 "979001144", 203 "979001145", 204 "979001146", 205 "979001147", 206 "979001148", 207 "979001150", 208 "979001151", 209 "979001152", 210 "979001153", 211 "979001154", 212 "979001157", 213 "979001158", 214 "979001159", 215 "979001160", 216 "979001161", 217 "979001163", 218 "979001164", 219 "979001165", 220 "979001166", 221 "979001167", 222 "979001169", 223 "979001170", 224 "979001171", 225 "979001172", 226 "979001173", 227 "979001179", 228 "979001181", 229 "979001182", 230 "979001184", 231 "979001185", 232 "979001186", 233 "979001188", 234 "979001189", 235 "979001190", 236 "979001191", 237 "979001192", 238 "979001193", 239 "979001195", 240 "979001196", 241 "979001197", 242 "979001199", 243 "979001200", 244 "979001201", 245 "979001203", 246 "979001205", 247 "979001206", 248 "979001208", 249 "979001210", 250 "979001211", 251 "979001212", 252 "979001213", 253 "979001214", 254 "979001215", 255 "979001217", 256 "979001218", 257 "979001219", 258 "979001220", 259 "979001221", 260 "979001222", 261 "979001223", 262 "979001224", 263 "979001225", 264 "979001226", 265 "979001228", 266 "979001229", 267 "979001230", 268 "979001231", 269 "979001233", 270 "979001234", 271 "979001235", 272 "979001236", 273 "979001237", 274 "979001238", 275 "979001239", 276 "979001240", 277 "979001242", 278 "979001243", 279 "979001244", 280 "979001245", 281 "979001246", 282 "979001249", 283 "979001250", 284 "979001251", 285 "979001252", 286 "979001253", 287 "979001256", 288 "979001257", 289 "979001258", 290 "979001259", 291 "979001260", 292 "979002216", 293 "979002217", 294 "979002218", 295 "979002219", 296 "979002221", 297 "979002222", 298 "979002223", 299 "979002224", 300 "979002226", 301 "979002227", 302 "979002228", 303 "979002229", 304 "979002232", 305 "979002233", 306 "979002235", 307 "979002236", 308 "979002238", 309 "979002239", 310 "979002241", 311 "979002242", 312 "979002243", 313 "979002244", 314 "979002246", 315 "979002249", 316 "979002251", 317 "979002255", 318 "979002256", 319 "979002257", 320 "979002258", 321 "979002260", 322 "979002261", 323 "979002262", 324 "979002263", 325 "979002265", 326 "979002266", 327 "979002268", 328 "979002269", 329 "979002270", 330 "979002271", 331 "979002274", 332 "979002275", 333 "979002276", 334 "979002278", 335 "979002279", 336 "979002280", 337 "979002282", 338 "979002283", 339 "979002285", 340 "979002286", 341 "979002287", 342 "979002288", 343 "979002290", 344 "979002291", 345 "979002292", 346 "979002294", 347 "979002295", 348 "979002297", 349 "979002298", 350 "979002299", 351 "979002300", 352 "979002302", 353 "979002303", 354 "979002305", 355 "979002306", 356 "979002308", 357 "979002309", 358 "979002311", 359 "979002313", 360 "979002314", 361 "979002316", 362 "979002319", 363 "979002321", 364 "979002325", 365 "979002326", 366 "979002328", 367 "979002330", 368 "979002333", 369 "979002334", 370 "979002335", 371 "979002337", 372 "979002338", 373 "979002341", 374 "979002346", 375 "979002347", 376 "979002348", 377 "979002349", 378 "979002350", 379 "979002352", 380 "979002353", 381 "979002354", 382 "979002356", 383 "979002357", 384 "979002358", 385 "979002360", 386 "979002361", 387 "979002362", 388 "979003011", 389 "979003016", 390 "979003021", 391 "979003022", 392 "979003026", 393 "979003033", 394 "979003035", 395 "979003040", 396 "979003043", 397 "979003044", 398 "979003045", 399 "979003046", 400 "979003047", 401 "979003049", 402 "979003050", 403 "979003052", 404 "979003053", 405 "979003054", 406 "979003056", 407 "979003058", 408 "979003059", 409 "979003060", 410 "979003061", 411 "979003073", 412 "979003074", 413 "979003075", 414 "979003076", 415 "979003077", 416 "979003078", 417 "979003079", 418 "979003080", 419 "979003081", 420 "979003082", 421 "979003083", 422 "979003084", 423 "979003085", 424 "979003086", 425 "979003087", 426 "979003088", 427 "979003089", 428 "979003090", 429 "979003091", 430 "979003092", 431 "979003101", 432 "979003102", 433 "979003103", 434 "979003104", 435 "979003105", 436 "979003107", 437 "979003108", 438 "979003109", 439 "979004002", 440 "979004003", 441 "979004004", 442 "979004005", 443 "979004006", 444 "979004008", 445 "979004009", 446 "979004010", 447 "979004011", 448 "979004012", 449 "979004013", 450 "979004017", 451 "982017013", 452 "982017014", 453 "982017015", 454 "990011002", 455 "990011003", 456 "990011005", 457 "990011006", 458 "990011008", 459 "990011009", 460 "990011011", 461 "990011013", 462 "990011015", 463 "990017018", 464 "990017039", 465 "990017040", 466 "990017041", 467 "990017042", 468 "990017043", 469 "990017044", 470 "990017045", 471 "990017046", 472 "990017047", 473 "990017048", 474 "990017049", 475 "990022036", 476 "990022037", 477 "990022038", 478 "990022090", 479 "990022092", 480 "990022093", 481 "990022096", 482 "990022097", 483 "990022098", 484 "990022100", 485 "990022101", 486 "990022103", 487 "990022104", 488 "990022107", 489 "990022108", 490 "990022110", 491 "990022111", 492 "990022113", 493 "990022114", 494 "990027131", 495 "990027134", 496 "990027135", 497 "990027136", 498 "990027137", 499 "990027138", 500 "990027140", 501 "990027141", 502 "990027142", 503 "990027143", 504 "990027144", 505 "990027145", 506 "990027146", 507 "990027147", 508 "990027149", 509 "990027150", 510 "990027151", 511 "990027152", 512 "990027153", 513 "990027154", 514 "990027155", 515 "990027156", 516 "990027157", 517 "990027158", 518 "990027159", 519 "990027160", 520 "990027161", 521 "990027162", 522 "990027163", 523 "990027164", 524 "990027165", 525 "990027166", 526 "990027167", 527 "990027168", 528 "990027175", 529 "990027176", 530 "990027177", 531 "990027178", 532 "990027179", 533 "990027180", 534 "990027181", 535 "990027182", 536 "990027184", 537 "990027185", 538 "990027186", 539 "990027187", 540 "990027188", 541 "990027189", 542 "990027190", 543 "990027191", 544 "990027193", 545 "990027194", 546 "990027195", 547 "990027198", 548 "990027199", 549 "990027200", 550 "990027201", 551 "990027202", 552 "990027203", 553 "990027204", 554 "990027205", 555 "990027206", 556 "990027207", 557 "990027208", 558 "990027209", 559 "990029002", 560 "990029010", 561 "990029011", 562 "990029012", 563 "990040003", 564 "990040004", 565 "990040005", 566 "990040006", 567 "990040007", 568 "990040009", 569 "990040010", 570 "990040012", 571 "990040013", 572 "990040014", 573 "990040015", 574 "990061074", 575 "990061075", 576 "990061076", 577 "990061077", 578 "990061078", 579 "990061080", 580 "990061082", 581 "990116003", 582 "990116004", 583 "990116006", 584 "990116007", 585 "990116008", 586 "990116011", 587 "990116018", 588 "990116022", 589 "990116025", 590 "990116027", 591 "990116029", 592 "990116030", 593 "990116031", 594 "990116033", 595 "990116034", 596 "990116036", 597 "990116037", 598 "990116039", 599 "990116040", 600 "990116042", 601 "990116043", 602 "990116045", 603 "990116046", 604 "990116048", 605 "990116049", 606 "990116051", 607 "990116052", 608 "990116054", 609 "990116055", 610 "990216003", 611 "990216005", 612 "990216006", 613 "990216007", 614 "990216008", 615 "990216010", 616 "990216011", 617 "990216012", 618 "990216013", 619 "990216014", 620 "990216015", 621 "990216016", 622 "990216018", 623 "990216020", 624 "990216021", 625 "990216022", 626 "990216023", 627 "990216024", 628 "990216025", 629 "990216026", 630 "990216027", 631 "990216029", 632 "990216030", 633 "990216031", 634 "990216032", 635 "990216033", 636 "990216034", 637 "990216035", 638 "990216036", 639 "990216037", 640 "990216038", 641 "990216040", 642 "990216041", 643 "990216042", 644 "990216044", 645 "990216046", 646 "990216047", 647 "990216048", 648 "990216050", 649 "990216052", 650 "990216054", 651 "990216055", 652 "990216056", 653 "990216057", 654 "990216058", 655 "990216059", 656 "990216061", 657 "990216063", 658 "990216064", 659 "990216065", 660 "990216066", 661 "990216067", 662 "990216069", 663 "990216070", 664 "990216071", 665 "990216072", 666 "990216073", 667 "990216074", 668 "990216075", 669 "990216076", 670 "990316008", 671 "990316009", 672 "990316014", 673 "990316016", 674 "990316017", 675 "990316018", 676 "990316019", 677 "990316020", 678 "990316022", 679 "990316023", 680 "990316025", 681 "990316026", 682 "990316028", 683 "990316029", 684 "990316030", 685 "990316031", 686 "990316032", 687 "990316034", 688 "990316035", 689 "990316036", 690 "990316037", 691 "990316039", 692 "990316041", 693 "990316042", 694 "990316043", 695 "990316044", 696 "990316045", 697 "990316047", 698 "990316050", 699 "990316051", 700 "990316052", 701 "990316053", 702 "990316054", 703 "990316056", 704 "990316057", 705 "990316058", 706 "990316060", 707 "990316061", 708 "990316062", 709 "990316063", 710 "990316064", 711 "990316065", 712 "990316066", 713 "990316068", 714 "990316070", 715 "990316071", 716 "990316072", 717 "990316074", 718 "990316089", 719 "990316091", 720 "990316095", 721 "990316097", 722 "990316098", 723 "990316099", 724 "990316100", 725 "990316101", 726 "990416003", 727 "990416004", 728 "990416005", 729 "990416006", 730 "990416007", 731 "990416008", 732 "990416010", 733 "990416011", 734 "990416013", 735 "990416014", 736 "990416015", 737 "990416016", 738 "990416017", 739 "990416019", 740 "990416021", 741 "990416022", 742 "990416024", 743 "990416025", 744 "990416026", 745 "990416027", 746 "990416028", 747 "990416029", 748 "990416030", 749 "990416031", 750 "990416032", 751 "990416033", 752 "990416035", 753 "990416036", 754 "990416037", 755 "990416038", 756 "990416039", 757 "990416040", 758 "990416041", 759 "990416042", 760 "990416043", 761 "990416044", 762 "990416045", 763 "990416046", 764 "990416047", 765 "990416048", 766 "990416050", 767 "990416051", 768 "990416052", 769 "990416053", 770 "990416054", 771 "990416056", 772 "990416057", 773 "990416058", 774 "990416060", 775 "990416061", 776 "990416062", 777 "990416063", 778 "990416064", 779 "990516005", 780 "990516008", 781 "990516011", 782 "990516014", 783 "990516015", 784 "990516020", 785 "990516021", 786 "990516027", 787 "990516031", 788 "990516035", 789 "990516036", 790 "990516040", 791 "990516041", 792 "990516042", 793 "990516043", 794 "990516044", 795 "990516045", 796 "990516046", 797 "990516047", 798 "990516048", 799 "990516049", 800 "990516050", 801 "990516051", 802 "990516052", 803 "990516053", 804 "990516054", 805 "990516055", 806 "990516056", 807 "990516057", 808 "990516058", 809 "990516059", 810 "990516060", 811 "990616003", 812 "990616004", 813 "990616005", 814 "990616006", 815 "990616007", 816 "990616009", 817 "990616010", 818 "990616011", 819 "990616012", 820 "990616013", 821 "990616015", 822 "990616016", 823 "990616017", 824 "990616018", 825 "990616019", 826 "990616020", 827 "990616021", 828 "990616022", 829 "990616023", 830 "990616024", 831 "990616026", 832 "990616027", 833 "990616028", 834 "990616029", 835 "990616030", 836 "990616031", 837 "990616032", 838 "990616033", 839 "990616034", 840 "990616035", 841 "990616037", 842 "990616038", 843 "990616039", 844 "990616040", 845 "990616041", 846 "990616043", 847 "990616044", 848 "990616045", 849 "990616046", 850 "990616047", 851 "990616048", 852 "990616049", 853 "990616051", 854 "990616052", 855 "990616053", 856 "990616054", 857 "990616055", 858 "990616056", 859 "990616057", 860 "990616059", 861 "990616060", 862 "990616061", 863 "990616062", 864 "990616063", 865 "990616065", 866 "990616066", 867 "990616067", 868 "990616068", 869 "990616069", 870 "990716003", 871 "990716004", 872 "990716005", 873 "990716006", 874 "990716007", 875 "990716008", 876 "990716009", 877 "990716010", 878 "990716011", 879 "990716013", 880 "990716014", 881 "990716015", 882 "990816004", 883 "990816005", 884 "990816006", 885 "990816007", 886 "990816008", 887 "990816009", 888 "990816010", 889 "990816011", 890 "990816013", 891 "990816014", 892 "990816015", 893 "990816016", 894 "990816017", 895 "990816018", 896 "990816019", 897 "990816021", 898 "990816022", 899 "990816023", 900 "990816024", 901 "990816025", 902 "990816027", 903 "990816028", 904 "990816029", 905 "990816031", 906 "990816032", 907 "990816033", 908 "991016004", 909 "991016005", 910 "991016007", 911 "991016008", 912 "991016009", 913 "991016011", 914 "991016012", 915 "991016013", 916 "991016014", 917 "991016015", 918 "991016016", 919 "991016017", 920 "991016018", 921 "991016020", 922 "991016021", 923 "991016022", 924 "991016023", 925 "991016024", 926 "991016026", 927 "991016027", 928 "991016028", 929 "991116004", 930 "991116005", 931 "991116006", 932 "991116007", 933 "991116008", 934 "991116009", 935 "991116010", 936 "991116011", 937 "991116012", 938 "991116013", 939 "991116014", 940 "991116016", 941 "991116017", 942 "991116018", 943 "991116019", 944 "991116020", 945 "991116021", 946 "991116022", 947 "991116023", 948 "991116024", 949 "991116025", 950 "991116026", 951 "991116028", 952 "991116029", 953 "991116030", 954 "991116031", 955 "991116033", 956 "991216004", 957 "991216005", 958 "991216006", 959 "991216009", 960 "991216013", 961 "991216019", 962 "991216020", 963 "991216024", 964 "991216025", 965 "991216026", 966 "991216027", 967 "991216028", 968 "991216029", 969 "991216030", 970 "991216031", 971 "991216032", 972 "991216033", 973 "991216034", 974 "991316004", 975 "991316005", 976 "991316006", 977 "991316007", 978 "991316008", 979 "991316009", 980 "991316010", 981 "991316012", 982 "991316014", 983 "991316015", 984 "991316016", 985 "991316017", 986 "991316018", 987 "991316019", 988 "991316021", 989 "991316022", 990 "991316023", 991 "991316025", 992 "991316026", 993 "991316027", 994 "991316028", 995 "991316029", 996 "991316030", 997 "991316031", 998 "991416004", 999 "991416005", 1000 "991416006", 1001 "991416007", 1002 "991416008", 1003 "991416009", 1004 "991416010", 1005 "991416011", 1006 "991416012", 1007 "991416013", 1008 "991416014", 1009 "991416015", 1010 "991416016", 1011 "991416017", 1012 "991416018", 1013 "991416020", 1014 "991416021", 1015 "991416022", 1016 "991416024", 1017 "991416025", 1018 "991416026", 1019 "991516003", 1020 "991516004", 1021 "991516005", 1022 "991516006", 1023 "991516007", 1024 "991516008", 1025 "991516009", 1026 "991516010", 1027 "991516012", 1028 "991516014", 1029 "991516016", 1030 "991516017", 1031 "991516018", 1032 "991516020", 1033 "991516021", 1034 "991516022", 1035 "991516023", 1036 "991516024", 1037 "991516025", 1038 "991516027", 1039 "991516028", 1040 "991516030", 1041 "991516031", 1042 "991516032", 1043 "991516033", 1044 "991516038", 1045 "991516040", 1046 "991516042", 1047 "991516043", 1048 "991516044", 1049 "991516046", 1050 "991516051", 1051 "991516058", 1052 "991516059", 1053 "991630002", 1054 "991630003", 1055 "991630004", 1056 "991630005", 1057 "991630006", 1058 "991630007", 1059 "991630009", 1060 "991630010", 1061 "991630011", 1062 "991630012", 1063 "991630013", 1064 "991630014", 1065 "991630015", 1066 "991630016", 1067 "991630017", 1068 "991630018", 1069 "991630019", 1070 "991630021", 1071 "991630022", 1072 "991630023", 1073 "991630024", 1074 "991630025", 1075 "991630026", 1076 "991630027", 1077 "991630028", 1078 "991630029", 1079 "991630030", 1080 "991630032", 1081 "991630033", 1082 "991630034", 1083 "991630035", 1084 "991630036", 1085 "991630037", 1086 "991630038", 1087 "991630039", 1088 "991630040", 1089 "991630041", 1090 "991630042", 1091 "991630044", 1092 "991630045", 1093 "991630046", 1094 "991630047", 1095 "991630048", 1096 "991630051", 1097 "991630052", 1098 "991630053", 1099 "991630055", 1100 "991630056", 1101 "991630057", 1102 "991630058", 1103 "991630059", 1104 "991630060", 1105 "991630061", 1106 "991630062", 1107 "991630063", 1108 "991630064", 1109 "991630065", 1110 "991630069", 1111 "991630070", 1112 "998418022", 1113 "998418026", 1114 "998418029", 1115 "998418032", 1116 "998418034", 1117 "998418036", 1118 "998418043", 1119 "998418045", 1120 "998418046", 1121 "998418047", 1122 "998418048", 1123 "998418049", 1124 "998418050", 1125 "998418051", 1126 "998418052", 1127 "998418053", 1128 "998418060", 1129 "998418062", 1130 "998418063", 1131 "998418064", 1132 "998418065", 1133 "998418066", 1134 "998418067", 1135 "998418068", 1136 "998418069", 1137 "998418070", 1138 "998418071", 1139 "998418072", 1140 "998418073", 1141 "998418074", 1142 "998418075", 1143 "998418076", 1144 "998418077", 1145 "998418079", 1146 "998418080", 1147 "998418081" 1148 ), 1149 1, 0) 1150 ) 1151 AS ?is_grz) 1152 1153 # Clienten met een ZVW indicatie maar geen (declaratie met een) ELV of GRZ code op peildatum zijn "overig" 1154 BIND(IF(?is_grz + ?is_elv > 0, 0, 1) AS ?is_zvw_overig) 1155 1156 } 1157 GROUP BY ?client 1158 } 1159} 1160
Heb je feedback?
Loopt u tegen een issue aan bij het KIK-V product? Neem dan contact met ons op!