job churn 4th administrative data seminar 20 apr 2015outline job creation, job destruction, hirings...

Job ChurnJob Churn

4th Administrative Data Seminar20 Apr 2015

OutlineOutline•Job Creation, Job Destruction, Hirings & Job Creation, Job Destruction, Hirings & SeparationsSeparations•MotivationMotivation•The SourcesThe Sources•MethodologyMethodology•Snapshot of CSO StatbankSnapshot of CSO Statbank•Examples of R codeExamples of R code mervyn.oluing@cso.ie

Motivation behind Job Churn

• In the back drop of a global downturn and economic recession in Ireland

• Increased demand for information on jobs & the labour market

• Less financial resources available• New opportunities to exploit administrative data• A methodology already outlined in research

literature

The Sources – the analysis file

CSOBusiness Register

EMR IDCBR ID

Legal formActivity

Revenue Employer Employee Tax returns

EMR IDPPSNClass

WeeksPay

DSPClient record System

PPSNDOB

GenderNationality

SPP35 Analysis file for each reference yearCSOPPSN

CBR IDMonth of birth, Sex, Nationality

Activity (NACE Rev 2), Legal formWeeks, Reckonable pay

Integrated and depersonalised for multi-purpose analysis

A firm has 10 paid employees on books in 2008The same firm has 12 paid employees on books in 2009

Job Creation (JC) = 2Job Destruction (JD) = 0

This firm has 4 paid workers on books in 2009 that didn’t exist in 2008 (Hirings) and it has 2 paid workers on books in 2008 that don’t exist in 2009 (Separations)

Hirings (H) = 4Separations (S) = 2

The Methodology – illustrating by simple example

Easy to Access & Query

Copy Link Locationn

R code used to prepare data

• The data is easy to prepare for analysis• Example of R code used to download the data

and covert it in to a pliable data frame

Thank you

Mervyn.Oluing@cso.ie