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

excitingwonderlakeInternet και Εφαρμογές Web

13 Δεκ 2013 (πριν από 3 χρόνια και 9 μήνες)

77 εμφανίσεις

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

ODaF Europe 2008, 14th
-
15th April 2008

Stefan Bender & Dana Mueller

(Germany)

2

Contents



Administrative data



Metadata



National and international co
-
operations/projects


Administrative Data

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

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

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

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

7

Employment history covered by social security system

Benefit receipt

Job search (2000)

Participation in measures of the Federal Employment Agency (2000)

apprenticeship

pension

since 1975

IAB data are merged data

Administrative Data

8

Notification to Social
Security

Administrative Data of Federal
Employment Agency

Surveys

Employment
Statistics

Employment
History

Benefit Recipient
History

Participants in
measures

Job
-
seekers

Employee and Benefit
Recipient History

Integrated Employment
Biographies

BAP

BHP

IABS

IEBS

LIAB

Data Warehouse and further editing

Source

Research
Data (RDC)

Editing

IAB Data
(ITM)

Administrative Data

9

Data and information flow

Data Warehouse

IT and Information
management (ITM)

FDZ

External Researchers

data

information

Metadata

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

11

Prototype (ITM)

New version

Variable description

DWH information

Detailed description

Scale type

Variable Groups
(Categories)

Synonyms of older
Variable Labels

Name and label

New handbook

Recodes/assign

Value label

Value

Digits

MS Word

Link to variables

Handbooks

Further description in
MS Word

Metadata

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





National and International Projects

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

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


Thanks for your intention!


Contact:

stefan.bender@iab.de

dana.mueller@iab.de


http://fdz.iab.de

Administrative Data

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

Metadata

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

18

Prototype



Sources of applications and libraries

XAMPP

http
:
//www
.
apachefriends
.
org/de/xampp
.
html

Oracle

Instant

Client

http
:
//www
.
oracle
.
com/technology/tech/oci/instantclient/ind
ex
.
html

Zend

Framework

http
:
//framework
.
zend
.
com/

TinyMCE

http
:
//tinymce
.
moxiecode
.
com/

Prototype

http
:
//www
.
prototypejs
.
org/

Scriptaculous

http
:
//script
.
aculo
.
us/

CSS
-
Design

fortables

http
:
//icant
.
co
.
uk/csstablegallery/index
.
php

HTML
-
Tidy

(read
-
in

of

handbooks)

http
:
//tidy
.
sourceforge
.
net/

Microsoft

Word

2002

http
:
//www
.
microsoft
.
com