1 / 16

data warehouse labour market and social protection

CBSS. data warehouse labour market and social protection. Chris Brijs Statistician Crossroads Bank for Social Security Sint-Pieterssteenweg 375 B-1040 Brussels E-mail: chris.brijs@ksz.fgov.be Website: www.bcss.fgov.be. Crossroads Bank for Social Security.

derek-mccormick
Download Presentation

data warehouse labour market and social protection

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. CBSS data warehouse labour market and social protection Chris Brijs Statistician Crossroads Bank for Social Security Sint-Pieterssteenweg 375 B-1040 Brussels E-mail: chris.brijs@ksz.fgov.be Website: www.bcss.fgov.be Crossroads Bank for Social Security

  2. Crossroads Bank for Social Security • parapublic institution • the mission of the CBSS is to be the motor of e-government in the social sector, i.e. • to stimulate and to support the actors in the Belgian social sector to grant more effective and efficient services with a minimum of administrative formalities and costs for all the involved; • based on a common and concerted vision, the actors in the Belgian social sector benefit from the new technologies to improve and re-organize radically their mutual relationships and processes; • to promote the information security and the privacy protection by the actors in the Belgian social sector so that all the involved institutions and people can have justified confidence in the system; • to deliver integrated statistical information to the politicians and the researchers in order to support the social policy. => http://www.bcss.fgov.be/

  3. Need of a data warehouse • operational databases: inadequate tool for the purpose of statistics and scientific research • not efficient • risky • expensive • advantages of a data warehouse • is provided with the adequate hardware and software for its objectives e.g. • calculating statistics • linking data of different sources • taking samples • encrypting data • less expensive

  4. Data sources • Crossroads Bank for Social Security • Federal Public Service Social Security • Health Insurance Funds • National Office for Social Security • National Office for Social Security for Provincial and Local Governments • National Institute for Social Security of the Self- employed • National Employment Office • National Institute for Health Insurance • National Office for Child Allowances for Workers • National Register • National Fund for Industrial Accidents • National Fund for Occupational Diseases

  5. Data sources • National Office for Old Age Pensions • Pension Service for the Public Sector • Regional Employment Services (VDAB/FOREM/Actiris/ADG) • Public Service for Social Integration • CIMIRe/SIGEDIS • Self-defined notions

  6. Contents • labour market information • wages • employer • social security contributions • labour regime (full time / part time) • unemployment • … • information about old age pensions • benefits/fees • kind of pension • starting date • …

  7. Contents • information about sickness/invalidity/incapacity for work/disability • benefits/fees • cause : illness, accident at work, occupational disease • starting date and (potential) final date • … • information about child allowances • information about poverty • personal data • birth date • gender • nationality • …

  8. Management • Crossroads Bank for Social Security • daily coordination and management • coordination between data providers and users • guaranteeing the availibility of the data • daily maintenance • treatment of demands for data • permanent technical support: SmalS • permanent scientific support: • Steunpunt Werk en Sociale Economie (KU Leuven) • Centrum voor Sociologisch Onderzoek (KU Leuven) • Centre METICES (ULB)

  9. Management • user group • composed of • representatives of research institutions • representatives of data providers • scientific discussions and proposals • matching between available data and needs • council of data providers • important principle: data providers keep the ownership of their own data • approval of the proposals made by the user group

  10. Use of the data warehouse • general anonymous statistics • cd-rom / website available for the public • discussed in user group • approved by the Privacy Commission • ad hoc demands for data • only public and scientific organisations can introduce a demand • procedure • approval of the data providers • approval of the Privacy Commission (check on respect of the purpose limitation principle and the proportionality principle) • approval of the Board of Directors of the Crossroads Bank for Social Security

  11. Documentation in the past : user guide + annexes list of variables codebook description of the variable « (nomenclature of) the socioeconomic position » description of the general anonymous statistics summary of the data available in the data warehouse => this documentation was too limited and inadequate : need of a project to reform this documentation

  12. Documentation project 2004 : submission of a project to Belgian Science Policy, in association with Federal Public Service Social Security Project for 4 years (2005-2009) Research teams : Steunpunt Werk en Sociale Economie, Centrum voor Sociologisch Onderzoek, Centre METICES thorough screening and documenting of the data warehouse : the sources, the structure, the variables, the history, … documentation available on the website of the CBSS first : Word-documents that can be downloaded later : consultable via a Content Management System (CMS)

  13. Results first documentation project more exhaustive user guide profound description of the sources, the variables and their possible values (codes) documentation is better structured => Although important improvement has been made, this is not the endpoint. A lot of important aspects are not explained in the current documentation.

  14. New Documentation Project 2008 : submission of a new documentation project to Belgian Science Policy, again in association with Federal Public Service Social Security Project for 4 years (2009-2013) Research teams : Steunpunt Werk en Sociale Economie, Centrum voor Sociologisch Onderzoek, Centre METICES

  15. CMS datawarehouse tool : HIPPO or DRUPAL open source application terms of access read-access for the public write-access for the representatives of the public institutions member of the council of data providers the research teams => team of editors possibility to allow guest editors (i.e. academic experts) workflow change of a part of the documentation + debate translation publication Commissioning : 2011

  16. More info • website Crossroads Bank for Social Security http://www.ksz.fgov.be/nl/bcss/nodepage/content/websites/belgium/statistics/statistics_01.html http://www.ksz.fgov.be/fr/bcss/nodepage/content/websites/belgium/statistics/statistics_01.html

More Related