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