1 / 35

Building a regional (=Flemish) datasharing-platform in a federal (=Belgian) state

Seminar LONDON, 11-12 sept 2007. Building a regional (=Flemish) datasharing-platform in a federal (=Belgian) state. Co-ordination Cell Flemish e-Government (CORVE) Boudewijngebouw 4B, Boudewijnlaan 30 bus 46, B-1000 Brussels, Belgium Web: http://www.corve.be. Agenda (45 ‘).

cisco
Download Presentation

Building a regional (=Flemish) datasharing-platform in a federal (=Belgian) state

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Seminar LONDON, 11-12 sept 2007 Building a regional (=Flemish) datasharing-platform in a federal (=Belgian) state Co-ordination Cell Flemish e-Government (CORVE) Boudewijngebouw 4B, Boudewijnlaan 30 bus 46, B-1000 Brussels, Belgium Web: http://www.corve.be

  2. Agenda (45 ‘) • (The Belgian federal state) • Principle of “Authentic Sources + SOA” • Major ‘authentic sources’ (3) in Belgium • Physical persons • Legal Entities & Enterprises • CrossRoads Bank of Social Security • Protecting Privacy : the Belgian Approach • Flemish data-sharing platform : MAGDA • MAGDA - Cases • MAGDA - Lessons Learned Belgium Flanders

  3. The Belgian federal state • Six consecutive state reforms: from a unitary to a federal state • 1970, 1980, 1988, 1993, 2001, 2004 • and another one planned after the federal elections in June 2007 … • Resulting in a very complicated federal system: • 1 federal state (10.4 million inhabitants) • 3 regions (territory-related) • Flanders (6 million inhabitants) • Wallonia (3.4 million inhabitants) • Brussels Capital Region • 3 communities (person-related) • Flemish Community • French-speaking Community • German-speaking Community • 10 provinces (5 in Flanders) • 589 municipalities (308 in Flanders) - COMPLICATED - 2 EUROPEAN CULTURES

  4. First experience : front versus back-office…

  5. Second experience : back-office !!

  6. PRINCIPLE of “Authentic source + SOA” • Authentic source(A.S.) = ‘authoritative’ database ;A piece of information (data-element) should be kept in 1 and only 1 place !! • Update-processes ! Always to and from the A.S. !! • No unnecessary duplication of A.S. : get the data – even in the midst of the business-proces- from the A.S., if possible ; • Copies (of A.S.’s) are allowed, but there should be no confusion as to which source is leading or ‘dominant’ ; • A.S.’s are to be distributed via SOA-principle Goal = to provide access (for external clients) to A.S.’s through basic services&composite services

  7. Major ‘authentic sources’ (3) in Belgium • Physical persons : RR, National Register for Physical Persons 2. Legal Entities & Enterprises : KBO, Crossroads Bank for Enterprises, a Reference Database “WHO’s WHO” (IDENTIFICATION) 3. Crossroads Bank for Social Security : KSZ, a repository, pointing to authentic data sources within the different institutions of the social security sector (child allowances, employment, pensions…) “WHAT” ((major) ATTRIBUTES) WHO ? - WHAT ? both A.S.’s, but fundamentally different, always to be discerned primary key foreign key…

  8. 1. Physical Persons (RR) • Grown out of the Population Registers held in the different Municipalities… • 1968 : one Register containing the name & adress of all Belgian citizens • 1983 : legal framework ! RR with Unique ID per citizen, 14 legal Attributes (name/adress/date&place of birth/matrim.status/…), fed & updated (birtht/decease, matrimonial status, household-removal…) on-line by Municipalities into RR Municipalities Municipalities RR

  9. 2. Legal Entities & Enterprises VAT LEGAL ENTITY EMPLOYER PUBLIC EMPLOYER COMMERCE • Up to year 2003 in Belgium : • 5 major reference-databases • huge overlap • different business-processes, different ID’s, contradicting contenance…

  10. 2. Legal Entities & Enterprises UniqueID WHO 1 db !!! ROLES / AUTHORISATIONS Legal EntityVAT Commerce Employer Public Employer 1 - n • From 2003 onwards : • 1 reference-database, merging the 5 databases, unique ID • fed & updated ONLY via : • - Enterprise-counters- clerks court’s office, public notaries… WHAT

  11. 3. CrossRoads Bank for Social Security employment Public employment Health-insurance employee unemployment Use of RR as A.S. WHAT WHO Health-insurance entrepreneurship BIS_Register(Phys Pers), additional A.S. ‘WHO’ !! Child allowance … invalidity pensions CrossRoads Bank is not a database as such, it is a Repository, starting from A.S. (Who) & pointing to A.S.’s (What) within Soc.security

  12. KSZ : United Nations Public Service Award

  13. Protecting privacy – Belgian approach • Single legal framework for protecting privacy • When using these authentic data sources and exchanging data,how do Belgian governments avoid becoming “big brothers”? • Government has to respect: • European Convention on Human Rights, article 8: • Everyone has the right to respect for his private and family life • Interference is only allowed when in accordance with the law,and if it is necessary in a democratic society • Belgian Constitution, article 22: • Everyone has the right to respect for his private and family life • Except such as is in accordance with, and within the conditions of the law • European Directives: • Directive on Personal Data Protection 1995/46/EC • Directive on Privacy and Electronic Communications 2002/58/EC both transposed into Belgian law (in 1998 and 2005) • specific laws on National Register for Natural Persons (1983), Crossroads Bank for Social Security (1990) and Crossroads Bank for Enterprises (2003) http://www.privacycommission.be/

  14. Protecting privacy – Belgian approach • Privacy Commission keeps a register of permitted exchanges of personal data • Additional security measures asked from data-users (independent security consultants, security plan, logging and auditing, …) • Privacy layer around each of the 3 A.S.’s • The exchange of personal data is allowed only with prior permission from the Commission for the Protection of Personal Privacy, via 3 Sectoral Committees RR KSZ KBO 3 Sectoral Committees, deciding who can access which data, for what purpose…

  15. Protecting privacy – Belgian approach • What do you need to obtain authorisation to access data ? • 4 Guiding principles of Belgian law on privacy, guarded by Privacy Commission & Sectoral Committees : • Principle of Legitimacy • Law or decree as a legal basis for the processing of personal data • Principle of Finality • Personal data can only be processed for a well-defined and legitimatepurpose • Principle of Proportionality • Only relevant (pertinent, necessary and not excessive) data needed to achieve the purpose can be processed + Data can be kept no longer than needed for the purpose • Principle of Transparency • Citizens have an insight which personal data of theirsis processed, for what purposes and by whom

  16. This was the Belgian/federal level… • How does a region (Flanders) cooperate with such Federal model ?

  17. Flemish Situation in 2004 FEDERALGOVERNMENT MINISTRY OF THEFLEMISH COMMUNITY FLEMISH GOVERNMENTAGENCIES LOCAL GOVERNMENT Flemish government portal own website own website own website own website own website own website UME front- office front- office front- office front- office front- office front- office front- office front- office front- office information services information services information services information services information services information services information services information services information services KSZ RR back- office back- office back- office back- office back- office back- office back- office back- office back- office KBO • Only ad-hoc and point-to-point data exchange and application integration

  18. Situation Now with MAGDA-PLATFORM FEDERALGOVERNMENT FLEMISH MINISTRIES INDEPENDENT FLEMISHGOVERNMENT AGENCIES LOCAL GOVERNMENT PKI Flemish portal own website own website own website own website own website own website UME front- office front- office front- office front- office front- office front- office front- office front- office front- office information services information services information services information services information services information services information services information services information services KSZ RR back- office back- office back- office back- office back- office back- office back- office back- office back- office KBO Magda (Flemish Integration Platform) Geo-data VKBO VKBP • Extending the service-oriented architecture to facilitate local E-government : already the case for VKBO.

  19. With ACM VKBGeo VKBP FEDERALGOVERNMENT MINISTRIESOF FLANDERS INDEPENDENT FLEMISHGOVERNMENT AGENCIES LOCAL GOVERNMENT ordinarycitizens civilservants specialgroups ACM (Access Control Management) Flemish portal own website own website own website own website own website own website UME front- office front- office front- office front- office front- office front- office front- office front- office front- office information services information services information services information services information services information services information services information services information services KSZ RR back- office back- office back- office back- office back- office back- office back- office back- office back- office KBO Magda (Flemish Integration Platform) VKBO • A secure service-oriented architecture using the Belgian eID card to access and use authentic data sources in federal, regional and local government

  20. Electronic identity card • = Basis for Authentication, Authorisation, Roles… • Not fully implemented yet • other (intermediate) solutions : user/password, token…

  21. Token for citizens or for civil servants

  22. Shared government authentication services 6. If authentication OK, receive identity data: rijksregisternummer (RRN) 5. Send authentication data username+ password 2. Authenticate user at security level X 7. Have authenticated user, here are his/her identity data federal token 1. Log in on website to gain access to Information or service 3. Choose authentication method and identify yourself federal eID 8. Please come in 4. Give authentication data federal eID + biometry federal authentication and identity data Flemish government website ACM

  23. Flemish datasharing platform : MAGDA • MAGDA = MAximale GegevensDeling tussen Administraties/applicatiesor ‘MAximal DataSharing amongst Administrations/applications’ • PLATFORM that makes data exchange and application integration possible within the Flemish administration and with the outside world • Service-oriented architecture : (a)synchronous data-exchange (webservices, ftp, web-application, ETL-message transformation, routing, archiving, logging & auditing, …) • Re-usability of data-components : benefits to e-government entities, to (business) partners & clients • Gov-Entity : ‘generic’ services available, lower cost, better data • Citizen/enterprise : “I will say it only once”

  24. MAGDA : Accessing & combining A.S.’s KBO RR KSZ Federal Level authentic data sources (federal social security) basic/identification (WHO) Essential “WHAT” authentic data sources (regional policy domainEconomy) authentic data sources (regional policy domain Persons) VKBO VKBP “enriched data”eg. GEO, annual accounts, employment-indication… “enriched data” eg. … MAGDA-platform Flemishgovernment entities

  25. Magda platform: Releases 1-2-3 In Productie In Test In Ontwerp Federale Gegevensbronnen Magda Dienstenaanbod Vlaamse Organisaties VKBO-GO VO (VLAO, ORAFIN, …) KBO Kruispunt Bank Onder nemingen VKBO KBO cache + Repertoria GeefOnderneming, Vestigingen … ZoekOnderneming … RegistreerDossier … Europees Sociaal Fonds, ESF Eur Fonds Region Ondersteuning, EFRO VDAB (AB21) Innovatie, Wetensch & Technologie, IWT PubliceerMutatie, StatusNietNormaal Inspectie Werkgelegenheid, AIW KSZ Kruispunt Bank Sociale Zekerheid File Transfer WVG Zorg & Gezondheid (Vaccinet) VKBP-GUI Medisch Verantwoord Sporten, MVS RR (Rijksregister) GeefPersoon, Gezinssamenstelling … ZoekPersoon … RegistreerDossier … CreeerBIS Onderwijs (Lerende Mens) JongerenWelzijn (DOMINO) Studietoelagen(Dig Aanvraag Form) De Lijn (eLoket) Zorg&Gezondheid (ZorgFonds, Vaccinet) PubliceerMutatie Kinder Bijslag Fondsen RKW Publiceer Attest Inschrijving Onderwijs (Lerende Mens) RSVZ CRAB Adressen / Geografie / Ligging Ag Geografische Informatie Vl (AGIV) Lokale Besturen Gemeentes BouwVergunning EPB (Energie Prestatie & Binnenklimaat)

  26. Magda platform: Release 4-5 In Productie In Test In Ontwerp SERVICE-LAYER FEDERAL A.S. MAGDA Services Flemish Applications VKBO-GO VO (VLAO, ORAFIN, …) KBO Kruispunt Bank Onder nemingen VKBO KBO cache + Repertoria + “Vlaamse Gegevens Bronnen” GeefOnderneming, Vestigingen … ZoekOnderneming … RegistreerDossier … Jaarrekening, RSZ Tewerkstelling Europees Sociaal Fonds, ESF Eur Fonds Region Ondersteuning, EFRO ENTERPRISES VDAB (AB21) NBB Innovatie, Wetensch & Technologie, IWT PubliceerMutatie, StatusNietNormaal, OvernameOpslorping, … Events, Rapporten Inspectie Werkgelegenheid, AIW Successierechten RSZ Gemeentes Arbeidsvergunningen (MIA) File Transfer: LIMOSA Db-CACHE KSZ Kruispunt Bank Sociale Zekerheid File Transfer WVG Zorg & Gezondheid (Vaccinnet) VKBP RR + KSZ cache + Repertoria + “Vlaamse Gegevens Bronnen” VKBP-GUI Medisch Verantwoord Sporten, MVS RR (Rijksregister) GeefPersoon, Gezinssamenstelling … ZoekPersoon … RegistreerDossier … CreeerBIS Handicap Werkend Landbouw & Visserij, ALV (EPR) PHYSICAL PERSONS Onderwijs (Lerende Mens) JongerenWelzijn (DOMINO) Studietoelagen(Dig Aanvraag Form) De Lijn (eLoket) Zorg&Gezondheid (ZorgFonds, Vaccinnet) PubliceerMutatie Events, Rapporten Dienstencheques Kinder Opvang Kinder Bijslag Fondsen RKW Publiceer Attest Inschrijving Onderwijs (Lerende Mens) RSVZ CRAB Adressen / Geografie / Ligging Ag Geografische Informatie Vl (AGIV) Lokale Besturen Gemeentes BouwVergunning EPB (Energie Prestatie & Binnenklimaat)

  27. MAGDA-Protocols en formaten HTTP S Federale Diensten MAGDA Dienstenaanbod Vlaamse Organisaties VKBO-GO Economie, Werkgelegenheid KBO Kruispunt Bank Onder nemingen F T P T X T VKBO KBO cache + “Vlaamse” Gegevens Onderneming T X T 1 Mutaties Ondernemingen 2 Events Ondernemingen VDAB FTP XML 1 GeefOnderneming 2 GeefVestigingen 3 GeefTewerkstelling 4 GeefActiviteiten 5 GeefHoedanigheden 6 ZoekOnderneming 7 RegistreerDossier Onderneming SOAP HTTP AIW (Inspectie Werkgelegenheid) IWT (Innovatie Wetenschap & Technologie) ESF (Europees Sociaal Fonds) VPN Web-applicationsWeb-servicesFTP-publish/subscribe KSZ Kruispunt Bank Sociale Zekerheid DIMONA F T P Onderwijs FTP XML Web-servicesFiles over FTP RKW Kinder Bijslag Fondsen HTTP S SOAP 1 Events Inschrijvingen Lerenden in Scholen Onderwijs (Lerende Mens) RSVZ VKBP RR + KSZ Register cache + “Vlaamse” Gegevens Personen WVG Kind & Gezin 1 Mutaties Personen 2 Events Personen Netwerk Sociale Zekerheid FTP Onderwijs (Lerende Mens) 1 GeefPersoon 2 ZoekPersoonOpNaam 3 ZoekPersoonOpAdres 4 RegistreerDossier Persoon 5 GeefGezinssamenstellling 6 CreeerBIS Digitaal Aanvraag Formulier Studietoelagen HTTPS SOAP HTTP S SOAP JeugdZorg (DOMINO) RR (Rijksregister) ALV (Landbouw & Visserij) voor EPR (Eenmalige PerceelsRegistratie) MVS (Medisch Verantwoord Sporten) VKBP-GUI SOAP XML HTTPS XML Lokale Besturen VKBA/G Adressen / Geografie / Ligging AGIV (Geografische Informatie) EPB (Energie Prestatie & Binnenklimaat) 1 BouwVergunning 2 Aangiftes EPB Gemeentes

  28. MAGDA – CASES CORE = Generic data-components (especially for Identification ! WHO) for Flemish applications • FindPerson, GetPerson, GetFamilyComposition.. • FindEnterprise, GetEnteprise, GetEmployment… = Data from federal A.S.’s, enriched with other A.S.’s (WHAT) CASES • Study-grant request : family-composition (online) + Income (batch) • Digiflow : retrieval (by Civil Servant) from A.S. (in stead of from Enterprise) 3 attestations (VAT, annual account, employer-duties) for a public tender • E-conomy grant-request : existence, activity, turnover, employment (online) • To Municipalities : exhaustive listing of enterprise & branches on the territory of a Community (+ updates) • http://vipvkbo.vlaanderen.be/vkbo/ • http://www.waregem.be

  29. Request for study-grant => family-composition • https://daf.vlaanderen.be/daf/index.jsp !

  30. VKBO : Enterprise-listing for Municipalities

  31. VKBO : Enterprise-listing for Municipalities • Measure the impact of public works on local economy

  32. Size and importance of the e-government units • Federal : • Annual budget: 30 million Euro • Personnel: 54 ( 83) + Crossroads Bank for Social Security: • Annual budget: 14.2 million Euro • Personnel: 70 + National Register, Crossroads Bank for Enterprises, … • Flanders : CORVE (Co-ordination Cell Flemish e-Government): • Annual budget: 3.8 million Euro • Personnel: 12 + 10 (semi-permanent) Consultants/IT • Wallony : EASY-WAL (E-Administration and SImplification - Wallonia): • Annual budget: 2.7 million Euro • Personnel: 21

  33. MAGDA – lessons learned • Communication & « Education » when starting with S.O.A. • Short-term IT-solution (eg Matching) versus thorough Business Proces Analysis / structural re-thinking (cf. Henry Ford-anecdote) • Orthodoxy within the service-layer ! SOA is easy ; consequent & maintained SOA isn’t ; • Quality of the A.S. = crucial ; • New Belgian privacy-approach ? Need for data-integrators, « trusted parties » (eg CORVE) to help build service-‘intelligence’ ; S.A. cannot cope with all the applicative requests => intermediate brokers with special Privacy-status • Local government is the first point of contact of the citizens,but they have the least people and resources available ; Quid ? • Budget : S.O.A.-platform charges are the same, whether you serve 10 or 100 clients/applications (cf. airplane-costs) • => Return on Investment !! => comfortable Time-horizon ( 3 to 5 years )

  34. MAGDA – lessons learned political commitment financial commitment organisational commitment above all personal commitment! E-government success is the result of TO KEEP GOING START

  35. Thank you for your attention Any questions? More information about Flemish e-governmentand the Co-ordination Cell Flemish e-Government: http://www.vlaanderen.be/e-government/

More Related