Data Cart

Your data extract

0 variables
0 samples
View Cart
WRKTENURE
Tenure in current job (months)

WRKTENURE is a 3-digit numeric variable.

Codes

480 = 480+ months
998 = Unknown
999 = NIU (not in universe)

Explore how IPUMS created this variable

Download


      class Wrktenure : public Editor {

public:
  Wrktenure(VarPointer varInfo) : Editor(varInfo) {}
  void edit() {

    long a = getRecoded();
    switch (dataSet) {
    case dataset_id::es2005h:
    case dataset_id::es2005i:
    case dataset_id::es2005j:
    case dataset_id::es2005k:
    case dataset_id::es2006h:
    case dataset_id::es2006i:
    case dataset_id::es2006j:
    case dataset_id::es2006k:
    case dataset_id::es2007h:
    case dataset_id::es2007i:
    case dataset_id::es2007j:
    case dataset_id::es2007k:
    case dataset_id::es2008h:
    case dataset_id::es2008i:
    case dataset_id::es2008j:
    case dataset_id::es2008k:
    case dataset_id::es2009h:
    case dataset_id::es2009i:
    case dataset_id::es2009j:
    case dataset_id::es2009k:
    case dataset_id::es2010h:
    case dataset_id::es2010i:
    case dataset_id::es2010j:
    case dataset_id::es2010k:
    case dataset_id::es2011h:
    case dataset_id::es2011i:
    case dataset_id::es2011j:
    case dataset_id::es2011k:
    case dataset_id::es2012h:
    case dataset_id::es2012i:
    case dataset_id::es2012j:
    case dataset_id::es2012k:
    case dataset_id::es2013h:
    case dataset_id::es2013i:
    case dataset_id::es2013j:
    case dataset_id::es2013k:
    case dataset_id::es2014h:
    case dataset_id::es2014i:
    case dataset_id::es2014j:
    case dataset_id::es2014k:
    case dataset_id::es2015h:
    case dataset_id::es2015i:
    case dataset_id::es2015j:
    case dataset_id::es2015k:
    case dataset_id::es2016h:
    case dataset_id::es2016i:
    case dataset_id::es2016j:
    case dataset_id::es2016k:
    case dataset_id::es2017h:
    case dataset_id::es2017i:
    case dataset_id::es2017j:
    case dataset_id::es2017k:
    case dataset_id::es2018h:
    case dataset_id::es2018i:
    case dataset_id::es2018j:
    case dataset_id::es2018k:
    case dataset_id::es2019h:
    case dataset_id::es2019i:
    case dataset_id::es2019j:
    case dataset_id::es2019k:
    case dataset_id::es2020h:
    case dataset_id::es2020i:
    case dataset_id::es2020j:
    case dataset_id::es2020k: {
      long tenure = valueFromFirstAvailable(
          {ES2005H_0440_ref, ES2005I_0440_ref, ES2005J_0440_ref,
           ES2005K_0440_ref, ES2006H_0440_ref, ES2006I_0440_ref,
           ES2006J_0440_ref, ES2006K_0440_ref, ES2007H_0440_ref,
           ES2007I_0440_ref, ES2007J_0440_ref, ES2007K_0440_ref,
           ES2008H_0440_ref, ES2008I_0440_ref, ES2008J_0440_ref,
           ES2008K_0440_ref, ES2009H_0440_ref, ES2009I_0440_ref,
           ES2009J_0440_ref, ES2009K_0440_ref, ES2010H_0440_ref,
           ES2010I_0440_ref, ES2010J_0440_ref, ES2010K_0440_ref,
           ES2011H_0440_ref, ES2011I_0440_ref, ES2011J_0440_ref,
           ES2011K_0440_ref, ES2012H_0440_ref, ES2012I_0440_ref,
           ES2012J_0440_ref, ES2012K_0440_ref, ES2013H_0440_ref,
           ES2013I_0440_ref, ES2013J_0440_ref, ES2013K_0440_ref,
           ES2014H_0440_ref, ES2014I_0440_ref, ES2014J_0440_ref,
           ES2014K_0440_ref, ES2015H_0440_ref, ES2015I_0440_ref,
           ES2015J_0440_ref, ES2015K_0440_ref, ES2016H_0440_ref,
           ES2016I_0440_ref, ES2016J_0440_ref, ES2016K_0440_ref,
           ES2017H_0440_ref, ES2017I_0440_ref, ES2017J_0440_ref,
           ES2017K_0440_ref, ES2018H_0440_ref, ES2018I_0440_ref,
           ES2018J_0440_ref, ES2018K_0440_ref, ES2019H_0440_ref,
           ES2019I_0440_ref, ES2019J_0440_ref, ES2019K_0440_ref,
           ES2020H_0440_ref, ES2020I_0440_ref, ES2020J_0440_ref,
           ES2020K_0440_ref});
      if (tenure > 480 && tenure != 999) {
        a = 480;
      }
    } break;
    case dataset_id::it2011h:
    case dataset_id::it2012h:
    case dataset_id::it2013h:
    case dataset_id::it2014h:
    case dataset_id::it2015h:
    case dataset_id::it2016h:
    case dataset_id::it2017h:
    case dataset_id::it2018h:
    case dataset_id::it2019h:
    case dataset_id::it2020h: {
      long tenure = valueFromFirstAvailable(
          {IT2011H_0687_ref, IT2012H_0687_ref, IT2013H_0687_ref,
           IT2014H_0687_ref, IT2015H_0687_ref, IT2016H_0687_ref,
           IT2017H_0687_ref, IT2018H_0687_ref, IT2019H_0687_ref,
           IT2020H_0687_ref});
      if (tenure > 480 && tenure != 999 && tenure != 998) {
        a = 480;
      }
    } break;
    case dataset_id::uy2006a: {
      a = UY2006A_0564() + (UY2006A_0565() * 12);
      if (UY2006A_0564() == 99 && UY2006A_0565() == 99)
        a = 999;
      if (UY2006A_0564() != 99 && UY2006A_0565() == 99)
        a = UY2006A_0564();
      if (UY2006A_0564() == 99 && UY2006A_0565() != 99)
        a = (UY2006A_0565() * 12);
      if (a > 480 && a != 999)
        a = 480;
    } break;
    case dataset_id::mu1990a: {
      if (MU1990A_0448() > 480 && MU1990A_0448() < 998)
        a = 480;
    } break;
    case dataset_id::mu2000a: {
      if (MU2000A_0458() > 40 && MU2000A_0458() < 98)
        a = 480;
      if (MU2000A_0458() > 0 && MU2000A_0458() <= 40)
        a = (MU2000A_0458() * 12);

    } break;
    case dataset_id::mu2011a: {
      if (MU2011A_0490() > 40 && MU2011A_0490() < 98)
        a = 480;
      if (MU2011A_0490() > 0 && MU2011A_0490() <= 40)
        a = (MU2011A_0490() * 12);

    } break;

    case dataset_id::mx2005h:
    case dataset_id::mx2005i:
    case dataset_id::mx2005j:
    case dataset_id::mx2005k:
    case dataset_id::mx2006h:
    case dataset_id::mx2006i:
    case dataset_id::mx2007i:
    case dataset_id::mx2008i:
    case dataset_id::mx2009h:
    case dataset_id::mx2010h:
    case dataset_id::mx2011h:
    case dataset_id::mx2012h:
    case dataset_id::mx2013h:
    case dataset_id::mx2014h:
    case dataset_id::mx2015h:
    case dataset_id::mx2016h:
    case dataset_id::mx2017h:
    case dataset_id::mx2018h:
    case dataset_id::mx2019h:
    case dataset_id::mx2020h: {
      long strprd = valueFromFirstAvailable(
          {MX2005H_0668_ref, MX2005I_0668_ref, MX2005J_0668_ref,
           MX2005K_0668_ref, MX2006H_0668_ref, MX2006I_0668_ref,
           MX2007I_0668_ref, MX2008I_0668_ref, MX2009H_0668_ref,
           MX2010H_0668_ref, MX2011H_0668_ref, MX2012H_0668_ref,
           MX2013H_0668_ref, MX2014H_0668_ref, MX2015H_0668_ref,
           MX2016H_0668_ref, MX2017H_0668_ref, MX2018H_0668_ref,
           MX2019H_0668_ref, MX2020H_0668_ref});
      long stryear = valueFromFirstAvailable(
          {MX2005H_0669_ref, MX2005I_0669_ref, MX2005J_0669_ref,
           MX2005K_0669_ref, MX2006H_0669_ref, MX2006I_0669_ref,
           MX2007I_0669_ref, MX2008I_0669_ref, MX2009H_0669_ref,
           MX2010H_0669_ref, MX2011H_0669_ref, MX2012H_0669_ref,
           MX2013H_0669_ref, MX2014H_0669_ref, MX2015H_0669_ref,
           MX2016H_0669_ref, MX2017H_0669_ref, MX2018H_0669_ref,
           MX2019H_0669_ref, MX2020H_0669_ref});
      long strmonth = valueFromFirstAvailable(
          {MX2005H_0670_ref, MX2005I_0670_ref, MX2005J_0670_ref,
           MX2005K_0670_ref, MX2006H_0670_ref, MX2006I_0670_ref,
           MX2007I_0670_ref, MX2008I_0670_ref, MX2009H_0670_ref,
           MX2010H_0670_ref, MX2011H_0670_ref, MX2012H_0670_ref,
           MX2013H_0670_ref, MX2014H_0670_ref, MX2015H_0670_ref,
           MX2016H_0670_ref, MX2017H_0670_ref, MX2018H_0670_ref,
           MX2019H_0670_ref, MX2020H_0670_ref});
      long intyear = valueFromFirstAvailable(
          {MX2005H_0027_ref, MX2005I_0027_ref, MX2005J_0027_ref,
           MX2005K_0027_ref, MX2006H_0027_ref, MX2006I_0027_ref,
           MX2007I_0027_ref, MX2008I_0027_ref, MX2009H_0027_ref,
           MX2010H_0027_ref, MX2011H_0027_ref, MX2012H_0027_ref,
           MX2013H_0027_ref, MX2014H_0027_ref, MX2015H_0027_ref,
           MX2016H_0027_ref, MX2017H_0027_ref, MX2018H_0027_ref,
           MX2019H_0027_ref, MX2020H_0027_ref});
      long intmonth = valueFromFirstAvailable(
          {MX2005H_0029_ref, MX2005I_0029_ref, MX2005J_0029_ref,
           MX2005K_0029_ref, MX2006H_0029_ref, MX2006I_0029_ref,
           MX2007I_0029_ref, MX2008I_0029_ref, MX2009H_0029_ref,
           MX2010H_0029_ref, MX2011H_0029_ref, MX2012H_0029_ref,
           MX2013H_0029_ref, MX2014H_0029_ref, MX2015H_0029_ref,
           MX2016H_0029_ref, MX2017H_0029_ref, MX2018H_0029_ref,
           MX2019H_0029_ref, MX2020H_0029_ref});
      // Calculate months for people at current job less than 2 years
      if (strprd >= 1 && strprd <= 2 && strmonth != 99) {
        a = ((intyear - stryear) * 12) + (intmonth - strmonth);
      }
      // Unknown months
      if (strprd >= 1 && strprd <= 2 && strmonth == 99) {
        a = 998;
      }
      // Calculate months for people at current job more than 2 years
      if (strprd == 3 && stryear != 99) {
        a = (intyear - stryear) * 12;
      }
      // Unknown start period or unknown years
      if (strprd == 9 || stryear == 9999) {
        a = 998;
      }
      // Implausible values
      if (a < 0 || a >= 999) {
        a = 998;
      }
      // Top-code (periods longer than 997 months are sent to unknown not
      // top-coded)
      if (a > 480 && a < 998) {
        a = 480;
      }
      if (strprd == 0) {
        a = 999;
      }
    } break;
    }

    setData(a);
  }
};
    

Description

WRKTENURE indicates the length of time (in months) workers have been in their current job or with their current employer.

Comparability — Index

GENERAL
Mauritius
Uruguay

Comparability — General

The samples are generally comparable apart from small age differences in universes.

The variable is top-coded at 480 months (i.e. 40 years).

Comparability — Mauritius [top]

The 1990-2011 samples ask persons age 12+ who ever worked about their length of service. The enumeration instructions in 1990-2011 indicate that persons who had no job in the reference week should provide the length of service with their more recent employer.

The 1990 census collected the information in months for persons who worked less than a year and in years otherwise; while the length of service is represented only in years in 2000 and 2011. The data are converted to their equivalent in months in WRKTENURE.

Comparability — Uruguay [top]

The question in 2006 asked about the duration of employment in months or years of employment, which are all converted to their month equivalent in WRKTENURE.

Universe

  • Mauritius 1990: Persons age 12+ who ever worked
  • Mauritius 2000: Persons age 12+ who ever worked
  • Mauritius 2011: Persons age 12+ who ever worked
  • Uruguay 2006: Persons age 14+ who were employed

Availability

  • Italy: 2011Q1, 2012Q1, 2013Q1, 2014Q1, 2015Q1, 2016Q1, 2017Q1, 2018Q1, 2019Q1, 2020Q1
  • Mauritius: 1990, 2000, 2011
  • Mexico: 2005Q1, 2005Q2, 2005Q3, 2005Q4, 2006Q1, 2006Q2, 2007Q2, 2008Q2, 2009Q1, 2010Q1, 2011Q1, 2012Q1, 2013Q1, 2014Q1, 2015Q1, 2016Q1, 2017Q1, 2018Q1, 2019Q1, 2020Q1
  • Spain: 2005Q1, 2005Q2, 2005Q3, 2005Q4, 2006Q1, 2006Q2, 2006Q3, 2006Q4, 2007Q1, 2007Q2, 2007Q3, 2007Q4, 2008Q1, 2008Q2, 2008Q3, 2008Q4, 2009Q1, 2009Q2, 2009Q3, 2009Q4, 2010Q1, 2010Q2, 2010Q3, 2010Q4, 2011Q1, 2011Q2, 2011Q3, 2011Q4, 2012Q1, 2012Q2, 2012Q3, 2012Q4, 2013Q1, 2013Q2, 2013Q3, 2013Q4, 2014Q1, 2014Q2, 2014Q3, 2014Q4, 2015Q1, 2015Q2, 2015Q3, 2015Q4, 2016Q1, 2016Q2, 2016Q3, 2016Q4, 2017Q1, 2017Q2, 2017Q3, 2017Q4, 2018Q1, 2018Q2, 2018Q3, 2018Q4, 2019Q1, 2019Q2, 2019Q3, 2019Q4, 2020Q1, 2020Q2, 2020Q3, 2020Q4
  • Uruguay: 2006