Implementation and Management Approach
AVIA started at the beginning of 2005. In September 2007 over 200,000 dossiers were exchanged electronically. The realisation of this complex project which had to be built from the bottom up took a short time.The background: In October schools send digital lists of all enrolled pupils and students to the Department of Education.
The Department therefore knows perfectly who is still studying. Even when someone deregisters during the school or academic year, this is automatically entered in the database.The needed electronic chain involves 225.000 certificates each year. In terms of technical data, it is one of the longest electronic chains in Belgium.
It starts with the educational institutions and runs via the educational administration through the Flemish MAGDA platform for data exchange to the Federal KSZ, the Federal child benefit funds and the payment offices.Fine-tuning all these links to one another is not just a technical tour de force. We also had to steer the communication between the partners in the right direction and have each party commit to paying part of the costs. Moreover, we had to build in guarantees so as to avoid double payments or citizens not receiving any child benefit at all.
Technology solution
As said, the automatic attestation system is one of the longest electronic chains in Belgium, and various tools, software, services and databases are used. In short: if a child is subscribed in a secondary school or is a student in a high school or a university, the proof of his inscription is sent to the Department of Education. This was an already existing data transfer mechanism, based on HTTPS file uploads (for the secondary schools) or through webservice calls (SOAP-XML) using security certificates for protection of the privacy.
The last part of the chain is the transfer of the attestations between the Crossroads Bank for Social Security and the Child Benefit Funds RKW and RSVZ, which transmit the attestations to the different Child Benefit Payment Agencies. This system, consisting of the transfer of the XML-messages over secure FTP, was also based on an existing data transfer mechanism.
Â
The main challenge of the project was to set up a connection between the Department of Education and the Crossroads Bank for Social Security and to make sure that the attestations of inscription are transmitted in a format suitable to the other partners, by reusing the existing systems and architecture.
The connection between the Department of Education and the Magda-platform was built upon the existing network that interconnects all the departments and ministries of the Flemish government. Transfer of the XML-messages is done by FTP from the Department of Education to the Magda-platform. On the Magda-platform the necessary data format transformation is carried out to make the attestation compatible with the format expected by the Crossroads Bank, by using the messaging services and transformation services provided by the platform. The Magda-platform is a Service Oriented Architecture – platform or SOA, based on Solaris as operating system with Oracle databases. The engine is written in Java. The attestations are then transmitted through a secure VPN-tunnel using webservice calls (SOAP-XML). This last connection is a type of communication with the CBSS in which CORVE had already some experience. Since CORVE is a trusted third party for the CBSS, it was much easier for the Department of Education to use CORVE’s Magda-platform and talk and negotiate with a single technological partner rather than have to talk with numerous new partners.
It was a crucial success factor for this project to re-use as much existing data transfer mechanisms and authentic data sources: the schools and universities were already connected to Department of Education and the CBSS had already a working connection with the Child Benefit Funds, which in turn were already connected to the Child Benefit Payment Agencies. This project is therefore a very good example of the re-use of existing data exchange mechanisms rather than to re-build a data exchange chain from scratch; this way the partners saved a lot of time and money.
In this project all partners used as much as possible open standards and existing open source technologies, such as Java, XML and the SOAP-protocol, and focused on the re-use of existing data exchange flows and processes.