A project team was formed to oversee the project as it spanned several council departments.
To ensure that Social Work clients were easily identifiable the quality of the SWIS data was paramount and work undertaken to clean legacy data was done in tandem with the implementation of the One Scotland Gazetteer acting as the definitive source of address data for the Social Work system.
At the same time ICT were involved with setting up a secure server to host highly confidential data and implementing security & backup protocols thereby ensuring that the data would be both secure and accessible in all scenarios including loss of electrical power.
A data extract routine was implemented to allow Social Work data to be routinely exported on a daily basis where the data is then imported into a GIS solution.
Once the database was up and running it was demoed to the local NHS board who agreed to export their own data to the Falkirk system, this development was viewed as a ringing endorsement of the Falkirk solution.
The Council legal team greatly assisted with the Governance arrangements in developing our Information Sharing Protocol between Falkirk Council and the NHS and in progressing the project.