Transcript Achieving integrated e-government in a federal state: the

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
Co-ordination Cell Flemish
e-Government
1 of 75
September 14, 2007
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
Belgium
 Flemish data-sharing platform : MAGDA
Flanders
 MAGDA - Cases
 MAGDA - Lessons Learned
Co-ordination Cell Flemish
e-Government
2 of 75
September 14, 2007
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)
Co-ordination Cell Flemish
e-Government
3 of 75
September 14, 2007
First experience : front versus back-office…
Co-ordination Cell Flemish
e-Government
4 of 75
September 14, 2007
Second experience : back-office !!
Co-ordination Cell Flemish
e-Government
5 of 75
September 14, 2007
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
Co-ordination Cell Flemish
e-Government
6 of 75
September 14, 2007
Major ‘authentic sources’ (3) in Belgium
1. 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
?
primary key
foreign key…
both A.S.’s, but fundamentally different,
always to be discerned
Co-ordination Cell Flemish
e-Government
7 of 75
September 14, 2007
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, householdremoval…) on-line by Municipalities into RR
Municipalities
Municipalities
RR
Co-ordination Cell Flemish
e-Government
8 of 75
September 14, 2007
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…
Co-ordination Cell Flemish
e-Government
9 of 75
September 14, 2007
2. Legal Entities & Enterprises
Unique
ID
WHO
1 db !!!
From 2003 onwards :
• 1 reference-database, merging the 5 databases, unique ID
• fed & updated ONLY via :
- Enterprise-counters
- clerks court’s office, public notaries…
Co-ordination Cell Flemish
e-Government
ROLES / AUTHORISATIONS
1-n
Legal Entity
VAT
Commerce
Employer
Public Employer
WHAT
10 of 75
September 14, 2007
3. CrossRoads Bank for Social Security
employment
Public employment
Health-insurance employee
unemployment
Health-insurance entrepreneurship
WHAT
Use of RR
as A.S. WHO
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
Co-ordination Cell Flemish
e-Government
11 of 75
September 14, 2007
KSZ : United Nations Public Service Award
Co-ordination Cell Flemish
e-Government
12 of 75
September 14, 2007
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/
Co-ordination Cell Flemish
e-Government
13 of 75
September 14, 2007
Protecting privacy – Belgian approach
 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
KBO
KSZ
3 Sectoral Committees, deciding who can access which data, for what purpose…
 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, …)
Co-ordination Cell Flemish
e-Government
14 of 75
September 14, 2007
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 legitimate
purpose
– 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 theirs
is processed, for what purposes and by whom
Co-ordination Cell Flemish
e-Government
15 of 75
September 14, 2007
This was the Belgian/federal level…
 How does a region (Flanders) cooperate with such Federal
model ?
Co-ordination Cell Flemish
e-Government
16 of 75
September 14, 2007
Flemish Situation in 2004
KBO
backoffice
backoffice
backoffice
frontoffice
frontoffice
frontoffice
backoffice
backoffice
backoffice
backoffice
backoffice
services
frontoffice
information
frontoffice
services
frontoffice
information
own
website
services
own
website
information
own
website
services
own
website
information
own
website
services
services
frontoffice
information
services
frontoffice
information
RR
services
KSZ
frontoffice
information
U
M
E
LOCAL
GOVERNMENT
own
website
information
Flemish
government portal
FLEMISH GOVERNMENT
AGENCIES
services
MINISTRY OF THE
FLEMISH COMMUNITY
information
FEDERAL
GOVERNMENT
backoffice
 Only ad-hoc and point-to-point data exchange and application integration
Co-ordination Cell Flemish
e-Government
17 of 75
September 14, 2007
Situation Now with MAGDA-PLATFORM
FEDERAL
GOVERNMENT
FLEMISH
MINISTRIES
INDEPENDENT FLEMISH
GOVERNMENT AGENCIES
LOCAL
GOVERNMENT
PKI
KBO
backoffice
backoffice
backoffice
frontoffice
backoffice
backoffice
backoffice
backoffice
backoffice
services
frontoffice
information
frontoffice
services
frontoffice
information
frontoffice
services
frontoffice
information
own
website
services
own
website
information
own
website
services
own
website
information
own
website
services
services
frontoffice
information
services
frontoffice
information
RR
services
KSZ
frontoffice
information
U
M
E
own
website
information
Flemish
portal
backoffice
Magda (Flemish Integration Platform)
VKBO
VKBP
Geo-data
 Extending the service-oriented architecture to facilitate local E-government :
already the case for VKBO.
Co-ordination Cell Flemish
e-Government
18 of 75
September 14, 2007
With ACM
FEDERAL
GOVERNMENT
MINISTRIES
OF FLANDERS
ordinary
citizens
INDEPENDENT FLEMISH
GOVERNMENT AGENCIES
civil
servants
LOCAL
GOVERNMENT
special
groups
ACM (Access Control Management)
KBO
backoffice
backoffice
backoffice
frontoffice
backoffice
backoffice
backoffice
backoffice
backoffice
services
frontoffice
information
frontoffice
services
frontoffice
information
frontoffice
services
frontoffice
information
own
website
services
own
website
information
own
website
services
own
website
information
own
website
services
services
frontoffice
information
services
frontoffice
information
RR
services
KSZ
frontoffice
information
U
M
E
own
website
information
Flemish
portal
backoffice
Magda (Flemish Integration Platform)
VKBO
VKBP
VKBGeo
 A secure service-oriented architecture using the Belgian eID card to access
and use authentic data sources in federal, regional and local government
Co-ordination Cell Flemish
e-Government
19 of 75
September 14, 2007
Electronic identity card
• = Basis for Authentication, Authorisation, Roles…
• Not fully implemented yet
• other (intermediate) solutions : user/password, token…
Co-ordination Cell Flemish
e-Government
20 of 75
September 14, 2007
Token for citizens or for civil servants
Co-ordination Cell Flemish
e-Government
21 of 75
September 14, 2007
Shared government authentication services
federal authentication
and identity data
6. If authentication OK,
receive identity data:
rijksregisternummer (RRN)
Flemish
government website
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
ACM
federal eID
federal eID
+ biometry
Co-ordination Cell Flemish
e-Government
22 of 75
September 14, 2007
Flemish datasharing platform : MAGDA
 MAGDA = MAximale GegevensDeling tussen Administraties/applicaties
or ‘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”
Co-ordination Cell Flemish
e-Government
23 of 75
September 14, 2007
MAGDA : Accessing & combining A.S.’s
KBO
Federal
Level
RR
KSZ
authentic data sources
(federal social security)
basic/identification (WHO)
Essential “WHAT”
authentic data sources
(regional policy domain Economy)
“enriched data”
eg. GEO, annual
accounts,
employmentindication…
VKBO
VKBP
MAGDA-platform
authentic data sources
(regional policy domain Persons)
“enriched data”
eg. …
Flemish
government entities
Co-ordination Cell Flemish
e-Government
24 of 75
September 14, 2007
Magda platform: Releases 1-2-3
Federale Gegevensbronnen
In Productie
In Test
In Ontwerp
Magda Dienstenaanbod
Vlaamse Organisaties
VO (VLAO, ORAFIN, …)
VKBO-GO
Europees Sociaal Fonds, ESF
KBO
Kruispunt
Bank
Onder
nemingen
VKBO
KBO cache
+
Repertoria
GeefOnderneming,
Vestigingen …
ZoekOnderneming …
RegistreerDossier …
Eur Fonds Region Ondersteuning, EFRO
VDAB (AB21)
Innovatie, Wetensch & Technologie, IWT
Inspectie Werkgelegenheid, AIW
PubliceerMutatie,
StatusNietNormaal
File Transfer
VKBP-GUI
RR
(Rijksregister)
KSZ
Kruispunt
Bank
Sociale
Zekerheid
GeefPersoon,
Gezinssamenstelling …
ZoekPersoon …
RegistreerDossier …
CreeerBIS
WVG
Zorg & Gezondheid (Vaccinet)
Medisch Verantwoord Sporten, MVS
Onderwijs (Lerende Mens)
JongerenWelzijn (DOMINO)
Studietoelagen (Dig Aanvraag Form)
De Lijn (eLoket)
Zorg&Gezondheid (ZorgFonds, Vaccinet)
PubliceerMutatie
Kinder
Bijslag
Fondsen
RKW
RSVZ
Lokale Besturen
Gemeentes
Co-ordination Cell Flemish
e-Government
Publiceer Attest Inschrijving
CRAB Adressen / Geografie / Ligging
BouwVergunning
Onderwijs (Lerende Mens)
Ag Geografische Informatie Vl (AGIV)
EPB (Energie Prestatie & Binnenklimaat)
25 of 75
September 14, 2007
Magda platform: Release 4-5
FEDERAL A.S.
In Productie
In Test
In Ontwerp
MAGDA Services
Flemish Applications
VO (VLAO, ORAFIN, …)
VKBO-GO
VKBO
KBO
Kruispunt
Bank
Onder
nemingen
NBB
Db-CACHE
KBO cache
+
Repertoria
+
“Vlaamse
Gegevens
Bronnen”
RSZ
GeefOnderneming,
Vestigingen …
ZoekOnderneming …
RegistreerDossier …
Jaarrekening,
RSZ Tewerkstelling
Europees Sociaal Fonds, ESF
Eur Fonds Region Ondersteuning, EFRO
VDAB (AB21)
Innovatie, Wetensch & Technologie, IWT
PubliceerMutatie,
StatusNietNormaal,
OvernameOpslorping, …
Events, Rapporten
Inspectie Werkgelegenheid, AIW
File Transfer: LIMOSA
Arbeidsvergunningen (MIA)
File Transfer
VKBP-GUI
Successierechten
Gemeentes
WVG
Zorg & Gezondheid (Vaccinnet)
Medisch Verantwoord Sporten, MVS
VKBP
RR
(Rijksregister)
KSZ
Kruispunt
Bank
Sociale
Zekerheid
Kinder
Bijslag
Fondsen
RKW
RSVZ
Lokale Besturen
Gemeentes
Co-ordination Cell Flemish
e-Government
RR + KSZ
cache
+
Repertoria
+
“Vlaamse
Gegevens
Bronnen”
GeefPersoon,
Gezinssamenstelling …
ZoekPersoon …
RegistreerDossier …
CreeerBIS
Handicap
Werkend
SERVICELAYER
Landbouw & Visserij, ALV (EPR)
Onderwijs (Lerende Mens)
JongerenWelzijn (DOMINO)
Studietoelagen (Dig Aanvraag Form)
De Lijn (eLoket)
Zorg&Gezondheid (ZorgFonds, Vaccinnet)
PubliceerMutatie
Events, Rapporten
Dienstencheques Kinder Opvang
Publiceer Attest Inschrijving
Onderwijs (Lerende Mens)
CRAB Adressen / Geografie / Ligging
BouwVergunning
Ag Geografische Informatie Vl (AGIV)
EPB (Energie Prestatie & Binnenklimaat)
26 of 75
September 14, 2007
MAGDA-Protocols en formaten
Federale Diensten
MAGDA Dienstenaanbod
VKBO-GO
VKBO
KBO
Kruispunt
Bank
Onder
nemingen
Kinder
Bijslag
Fondsen
RKW
RSVZ
Netwerk
Sociale
Zekerheid
F
T
P
T
X
T
KBO cache
+
“Vlaamse”
Gegevens
Onderneming
VPN
FTP
H
S
T
O
T
A
VKBP
P
P
S
RR +
X
FTP
M KSZ Register
cache
L
+
“Vlaamse”
H
S
Gegevens
T
O
Personen
T
A
P
P
S
Web-services
KSZ
Files
over FTP
Kruispunt
Bank
Sociale
Zekerheid
RR
(Rijksregister)
1 Mutaties Ondernemingen
2 Events Ondernemingen
1 GeefOnderneming
2 GeefVestigingen
3 GeefTewerkstelling
4 GeefActiviteiten
5 GeefHoedanigheden
6 ZoekOnderneming
7 RegistreerDossier
Onderneming
T
X
T
H
T
T
P
S
FTP
S
O
A
P
Gemeentes
Co-ordination Cell Flemish
e-Government
H
T
T
P
S
X
M
L
Economie, Werkgelegenheid
VDAB
AIW (Inspectie Werkgelegenheid)
IWT (Innovatie
Wetenschap & Technologie)
ESF (Europees Sociaal Fonds)
Onderwijs
Web-applications
X
1 Events Inschrijvingen
M
Onderwijs (Lerende Mens)
Web-services
F
Lerenden in Scholen
L
T
WVG
Kind & Gezin
FTP-publish/subscribe
1 Mutaties Personen
P
DIMONA
2 Events Personen
1 GeefPersoon
2 ZoekPersoonOpNaam
3 ZoekPersoonOpAdres
4 RegistreerDossier
Persoon
5 GeefGezinssamenstellling
6 CreeerBIS
Onderwijs (Lerende Mens)
S
O
A
P
VKBP-GUI
Lokale Besturen
H
T
T
P
Vlaamse Organisaties
VKBA/G Adressen / Geografie / Ligging
1 BouwVergunning
2 Aangiftes EPB
S
X
O
M
A
L
P
Digitaal Aanvraag Formulier
Studietoelagen
JeugdZorg (DOMINO)
H
T
T
P
S
ALV (Landbouw & Visserij) voor
EPR (Eenmalige PerceelsRegistratie)
MVS (Medisch Verantwoord Sporten)
AGIV (Geografische Informatie)
EPB (Energie Prestatie
& Binnenklimaat)
27 of 75
September 14, 2007
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
Co-ordination Cell Flemish
e-Government
28 of 75
September 14, 2007
Request for study-grant => family-composition
 https://daf.vlaanderen.be/daf/index.jsp !
Co-ordination Cell Flemish
e-Government
29 of 75
September 14, 2007
VKBO : Enterprise-listing for Municipalities
Co-ordination Cell Flemish
e-Government
30 of 75
September 14, 2007
VKBO : Enterprise-listing for Municipalities
 Measure the impact of public works on local economy
Co-ordination Cell Flemish
e-Government
31 of 75
September 14, 2007
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
Co-ordination Cell Flemish
e-Government
32 of 75
September 14, 2007
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 Privacystatus
 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 )
Co-ordination Cell Flemish
e-Government
33 of 75
September 14, 2007
MAGDA – lessons learned
E-government success is the result of
political commitment
organisational commitment
TO KEEP GOING
START
financial commitment
above all personal commitment!
Co-ordination Cell Flemish
e-Government
34 of 75
September 14, 2007
Thank you for your attention
Any questions?
More information about Flemish e-government
and the Co-ordination Cell Flemish e-Government:
http://www.vlaanderen.be/e-government/
Co-ordination Cell Flemish
e-Government
35 of 75
September 14, 2007