Uitwisselprofiel Zorgkantoren Inkoopondersteuning en beleidsontwikkeling
21.1 - Rentabiliteit, Winstratio
Concepten
Relaties
Eigenschappen
SPARQL query
Code gekopieerd
...Kopieer naar klembord
1# Indicator: Zorgkantoren 21.1.0 2# Parameters: $(start_periode), $(eind_periode) 3# Ontologie: 4 5PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> 6PREFIX onz-fin: <http://purl.org/ozo/onz-fin#> 7PREFIX onz-g: <http://purl.org/ozo/onz-g#> 8 9SELECT 10 ("Winstratio" AS ?Kental) 11 ((SUM(?bedrag_S1_sum) + SUM(?bedrag_P_sum) - SUM(?bedrag_S2_sum)) / SUM(?bedrag_P_sum) AS ?Waarde) 12WHERE { 13 ?grootboek_post 14 a onz-fin:Grootboekpost ; 15 onz-g:partOf ?rubriek ; 16 onz-g:hasDate ?datum ; 17 onz-g:isAbout [ 18 a onz-g:FinancialEntity ; 19 onz-g:hasQuality / onz-g:hasQualityValue / onz-g:hasDataValue ?geld_bedrag 20 ] . 21 BIND($(start_periode) AS ?start_periode) 22 BIND($(eind_periode) AS ?eind_periode) 23 FILTER (?datum >= ?start_periode) 24 FILTER (?datum <= ?eind_periode) 25 # Winstratio = "S Resultaat na belastingen" / "P Som der bedrijfsopbrengsten" 26 BIND(IF(?rubriek in ( 27 # "P Som der bedrijfsopbrengsten" 28 # P.I Netto omzet 29 onz-fin:811000, 30 31 # P.II, P.II leeg 32 # P.IV Overige bedrijfsopbrengsten 33 onz-fin:821000, onz-fin:822000, onz-fin:825000, onz-fin:826000, onz-fin:827000, onz-fin:828000, onz-fin:829000, 34 onz-fin:831000, onz-fin:832000, onz-fin:833000, onz-fin:835000, 35 onz-fin:891000, onz-fin:919000, onz-fin:920000, onz-fin:930000 36 ), ?geld_bedrag, 0) AS ?bedrag_P_sum) 37 38 # S = (P + R.I + R.II + S.II) - (Q + R.III + R.IV + S.I) 39 # S = S1 - S2 where 40 # S1 = (P + R.I + R.II + S.II) and 41 # S2 = (Q + R.III + R.IV + S.I) 42 BIND(IF(?rubriek in ( 43 # S1 = P + R.I + R.II + S.II 44 # R.I 45 onz-fin:904000, 46 # R.II 47 onz-fin:900000, 48 # S.II 49 onz-fin:902000 50 ), ?geld_bedrag, 0) AS ?bedrag_S1_sum) # add P to this sum 51 52 BIND(IF(?rubriek in ( 53 # S2 = Q + R.III + R.IV + S.I, S.I always 0 54 # Q Som der bedrijfslasten" 55 # Q.I leeg 56 # Q.II 57 onz-fin:417000, 58 onz-fin:418000, onz-fin:418100, onz-fin:418200, 59 60 # Q.III 61 onz-fin:411000, onz-fin:411100, onz-fin:411200, onz-fin:411300, onz-fin:411400, onz-fin:411500, onz-fin:411600, onz-fin:411700, 62 onz-fin:412000, onz-fin:412100, onz-fin:412200, onz-fin:412300, onz-fin:412400, onz-fin:412500, 63 onz-fin:413000, onz-fin:413100, onz-fin:413200, onz-fin:413300, onz-fin:413400, onz-fin:413500, onz-fin:413600, onz-fin:413610, 64 onz-fin:413620, onz-fin:413700, onz-fin:414000, onz-fin:414100, onz-fin:414101, onz-fin:414102, onz-fin:414103, onz-fin:414104, 65 onz-fin:414110, onz-fin:414111, onz-fin:414112, onz-fin:414113, onz-fin:414114, onz-fin:414200, onz-fin:414202, onz-fin:414203, 66 onz-fin:414204, onz-fin:414300, onz-fin:414500, onz-fin:414503, onz-fin:414504, onz-fin:414700, onz-fin:414800, 67 onz-fin:415000, onz-fin:416000, 68 onz-fin:419000, onz-fin:419100, onz-fin:419101, onz-fin:419200, onz-fin:419500, 69 70 # Q.IV 71 onz-fin:420000, onz-fin:420100, onz-fin:422100, onz-fin:422300, onz-fin:422400, onz-fin:422410, onz-fin:422500, onz-fin:422900, 72 73 # Q.V 74 onz-fin:422600, 75 76 # Q.VI 77 onz-fin:480012, onz-fin:480022, onz-fin:480032, onz-fin:480112, onz-fin:480122, onz-fin:480132, onz-fin:480532, onz-fin:480632, 78 onz-fin:480932, 79 onz-fin:481212, onz-fin:481222, onz-fin:481232, onz-fin:481242, onz-fin:481252, 80 onz-fin:482112, onz-fin:482122, onz-fin:482132, onz-fin:482142, onz-fin:482152, onz-fin:482212, onz-fin:482222, onz-fin:482232, 81 onz-fin:482242, onz-fin:482252, onz-fin:482312, onz-fin:482322, onz-fin:482332, onz-fin:482342, onz-fin:482352, onz-fin:482412, 82 onz-fin:482422, onz-fin:482432, onz-fin:482442, onz-fin:482452, 83 onz-fin:483112, onz-fin:483122, onz-fin:483132, onz-fin:483142, onz-fin:483152, 84 onz-fin:484112, onz-fin:484122, onz-fin:484132, onz-fin:484222, onz-fin:484232, onz-fin:484322, onz-fin:484332, 85 86 # Q.VII, Q.VIII leeg 87 # Q.IX 88 onz-fin:423100, onz-fin:423110, onz-fin:423120, onz-fin:423140, onz-fin:423190, onz-fin:423200, onz-fin:423210, onz-fin:423220, 89 onz-fin:423300, onz-fin:423400, onz-fin:423410, onz-fin:423420, onz-fin:423500, onz-fin:423510, onz-fin:423520, onz-fin:423600, 90 onz-fin:423700, onz-fin:423900, onz-fin:423910, onz-fin:423920, 91 onz-fin:431000, onz-fin:431100, onz-fin:431200, onz-fin:431300, onz-fin:432000, onz-fin:433000, 92 onz-fin:441000, onz-fin:441100, onz-fin:441200, onz-fin:441300, onz-fin:441400, onz-fin:441900, onz-fin:442000, onz-fin:442100, 93 onz-fin:442200, onz-fin:443000, onz-fin:443100, onz-fin:443200, onz-fin:443300, onz-fin:444000, onz-fin:444100, onz-fin:445000, 94 onz-fin:445100, onz-fin:445200, onz-fin:449000, 95 onz-fin:451000, onz-fin:451100, onz-fin:451200, onz-fin:451300, onz-fin:451400, onz-fin:451500, onz-fin:451600, onz-fin:452000, 96 onz-fin:452100, onz-fin:452200, onz-fin:452900, onz-fin:453000, onz-fin:453100, onz-fin:453200, onz-fin:453300, onz-fin:453900, 97 onz-fin:453910, onz-fin:453920, onz-fin:453930, onz-fin:453990, onz-fin:454000, onz-fin:454100, onz-fin:454200, onz-fin:454210, 98 onz-fin:454220, onz-fin:454290, onz-fin:455000, onz-fin:455100, onz-fin:459000, onz-fin:459100, onz-fin:459300, onz-fin:459900, 99 onz-fin:461000, onz-fin:461100, onz-fin:461200, onz-fin:462000, onz-fin:462100, onz-fin:462200, onz-fin:462300, onz-fin:462400, 100 onz-fin:462500, onz-fin:462600, onz-fin:462700, onz-fin:462800, onz-fin:462900, onz-fin:463000, onz-fin:463100, onz-fin:463200, 101 onz-fin:463900, onz-fin:464000, onz-fin:464100, onz-fin:464200, onz-fin:464300, onz-fin:464900, onz-fin:465000, onz-fin:465100, 102 onz-fin:465200, onz-fin:465300, onz-fin:465400, onz-fin:465900, onz-fin:466000, onz-fin:467100, onz-fin:467110, onz-fin:467120, 103 onz-fin:467200, onz-fin:468000, 104 onz-fin:471100, onz-fin:471200, onz-fin:471300, onz-fin:471400, onz-fin:472000, onz-fin:473000, onz-fin:473100, onz-fin:473200, 105 onz-fin:473300, onz-fin:473400, onz-fin:473500, onz-fin:473600, onz-fin:473900, 106 onz-fin:486115, onz-fin:486125, onz-fin:486135, onz-fin:486215, onz-fin:486225, onz-fin:486235, onz-fin:486315, onz-fin:486325, 107 onz-fin:486335, onz-fin:486415, onz-fin:486425, onz-fin:486435, onz-fin:486515, onz-fin:486525, onz-fin:486535, onz-fin:486615, 108 onz-fin:486625, onz-fin:486635, onz-fin:486725, onz-fin:486735, onz-fin:486825, onz-fin:486835, 109 onz-fin:489150, onz-fin:489211, onz-fin:489212, onz-fin:489221, onz-fin:489222, onz-fin:489230, 110 onz-fin:905000, 111 onz-fin:911000, onz-fin:912000, onz-fin:913000, onz-fin:914000, onz-fin:915000, 112 onz-fin:921000, onz-fin:931000, 113 114 # "R.III Waardeverandering van vorderingen die tot de vaste activa behoren en van effecten 115 onz-fin:903000, 116 117 # R.IV Rentelasten en soortgelijke kosten 118 onz-fin:485000, onz-fin:485100, onz-fin:485190, onz-fin:485205, onz-fin:485211, onz-fin:485300, onz-fin:485311, 119 onz-fin:485412, onz-fin:485900, 120 onz-fin:901000 121 ), ?geld_bedrag, 0) AS ?bedrag_S2_sum) 122} 123
Heb je feedback?
Loopt u tegen een issue of vraag aan bij het KIK-V product? Neem dan contact met ons op!