The Research Data Centre of the Federal Employment Agency at the Institute for Employment Research

1. The Research Data Centre of the Federal Employment Agency at the Institute for Employment Research Stefan Bender & Dana Mueller (Germany) ODaF Europe 2008, 14th-15th April 2008

2. Administrative data Metadata National and international co-operations/projects Contents

3. Administrative Data in the Federal Employment Agency • Two different sources: • notification procedure of the Social Security System (health-, pension-, unemployment- and long-term care insurance) • administrative data of the Federal Employment Agency Administrative Data 3

4. Notification procedure of the Social Security System • Intention of data collection: • calculation of social security contribution and entitlement of benefit • statistics • Procedures: • every employee and marginal worker covered by social security system (notification requirement) • identification: social security number and establishment number • annual, begin or end of employment, employment interruption, change of health insurance • What is notified? Administrative Data 4

5. Notification of Social Security: • Insurance Number • Last Name • First Name • Address • Country • Reason for Notification • Date of Employment • Establishment Number • Nationality • School Education • Professional Education • Type of Employment • Gross Earning • Occupational Status Administrative Data 5

6. Administrative data of the Federal Employment Agency • Receipt of benefit • Job placement • Participation in measures  computer-aided processes • Federal Employment Agency is not allowed to store data for a long time •  data are transmitted to the Institute for Employment Research Administrative Data 6

7. pension apprenticeship since 1975 IAB data are merged data Employment history covered by social security system Benefit receipt Job search (2000) Participation in measures of the Federal Employment Agency (2000) 7 Administrative Data

8. Notification to Social Security Administrative Data of Federal Employment Agency Source Editing Data Warehouse and further editing Employment Statistics Benefit Recipient History Participants in measures Job-seekers Employment History IAB Data (ITM) Employee and Benefit Recipient History Integrated Employment Biographies Research Data (RDC) IABS IEBS LIAB Surveys BAP BHP 8 Administrative Data

9. Data Warehouse data information IT and Information management (ITM) FDZ External Researchers Data and information flow Administrative Data 9

10. Metadata • Standardized handbooks/data-reports in MS-Word • Prototype (ITM): • aim of prototype: optimization of handbook’s preparation and care • focus on variable description • read-in and read-out routines (MS-Word) • enter of changes and new descriptions of variables and values • versioning Metadata 10

11. New version Further description in MS Word Handbooks New handbook Variable description MS Word Name and label Synonyms of older Variable Labels Value Scale type Value label Variable Groups (Categories) Digits Recodes/assign Detailed description DWH information Link to variables Prototype (ITM) Metadata 11

12. Prototype • Further steps: • search for variables, synonyms and variable groups • link to frequencies • input und output DDI3/XML • automatically adjustment to DWH information • web application (intranet) • tests for documentation of surveys Metadata 12

13. National co-operations • Co-operation of Research Data Centres and Data Service Centres in Germany • Task force (AKöffFDZ) • Projects: • translation of questionnaires in English (IdZA) • third-party funds project KombiFID - Combination of Enterprise Data in Germany (with Research Data Centre of the Federal Statistical Office) National and International Projects 13

14. Submitted EU-Project • EURASI – European Access to Statistical Information • Taskforces: • Management • Networking Data access • Integration activities data access • Metadata • European standards of output statistical disclosure control • Research on microdata SDC • Research on tabular data protection on remote access data systems • Exploition, Communication and dissemination • Research on data access and methods • Netherlands, Italy, Germany, Spain, Slovenia, Sweden, Hungary, Austria, Swiss, Denmark, UK, Bulgaria National and International Projects 14

15. Thanks for your intention! Contact: stefan.bender@iab.de dana.mueller@iab.de http://fdz.iab.de

16. Administrative Data – Brief Introduction • are produced to collect data for administrative processes and to complete tasks of public institutions/organisations/establishments • Advantages: • individual information • complete coverage of time • important administrative questions are reliable • to report statistics and longitudinal studies • to create research data • Disadvantages: • depend on the administrative system’s population • changes in administrative systems make comparison difficult • lower quality of less important administrative information Administrative Data 16

17. Prototype • Hardware/Software: • Windows-Server 2003 • XAMPP 1.6.4 • Oracle Instant Client 10.2 • Microsoft Word 2002 • Zend Framwork1.03 • Oracle-server in Version 9i (or 10g) Metadata 17

18. Prototype • Sources of applications and libraries Metadata 18